Obsolete Releases > SME 8.x Contribs

puzzling server slowdown

<< < (2/2)

janet:
wdepot

Also try using
top -i
to see only the active processes (rather than just top whihc will display everything, similar to htop)

I'd be looking at email virus scanning & spamassassin filtering, disable them both (temporarily) & see if you stop having system slowdown.

compdoc:

--- Quote from: wdepot on May 29, 2013, 08:59:21 PM ---We are running into some puzzling server slowdowns ever since we upgraded to a new server and were wondering if it might be due to a couple of contribs we tried and then rejected. When we built the new server, along with the contributions we had been using previously (Sysmon, AWStats, phpMyAdmin, Diskusage, Hardware Info, and DAR2)
--- End quote ---

When you say 'full backup' and 'disaster recovery restore' using DAR2, do you mean all directories are restored? I think you're having the same problem I did recently.

wdepot:
The full backup saves the following folders with any subfolders inside:

etc/e-smith/templates-custom
etc/e-smith/templates-user-custom
etc/group
etc/gshadow
etc/passwd
etc/samba/secrets.tdb
etc/samba/smbpasswd
etc/shadow
etc/smbpasswd
etc/ssh
etc/sudoers
home/e-smith
root

The disaster recovery restore restores all of these same folders. Any other folders would just have stock SMEServer files which you would be resintalling anyway.

wdepot:
I finally managed to catch the server during one of its big slowdowns using htop. The odd thing is that the thing that was showing like 530 CPU% was /usr/libexec/mysqld. At the same time there were about four other instances of mysqld running at the same time that were showing something like 85 to 95 CPU%. The one that was showing 530% was the one highlighted in blue at the very top of the process list. So I guess the question now would be what might make one single MySQL query take such a large amount of CPU power?

I have the following settings added to the default SMEServer values in the my.cnf file:

--- Code: ---[mysqld]
character-set-server=utf8
collation-server=utf8_general_ci
key_buffer_size=2048M
preload_buffer_size=512M
query_cache_limit=16M
query_cache_size=128M
query_cache_type=1
query_prealloc_size=256M
read_buffer_size=2M
read_rnd_buffer_size=4M
sort_buffer_size=2M
thread_cache_size=100


--- End code ---
The idea is to try and buffer as much as possible to make the MySQL server faster in responding. However we were noticing some slowdowns before I ever added these to the templates-custom for my.cnf.

The other thing I'm wondering if if might somehow be related to the apparent MySQL problem is the following that I found in the messages log file for today after I applied the latest SME updates this morning:

--- Code: ---Jun 11 10:25:45 www mysql.init: ERROR 1060 (42S21) at line 108: Duplicate column name 'File_priv'
Jun 11 10:25:45 www mysql.init: ERROR 1060 (42S21) at line 114: Duplicate column name 'Grant_priv'
Jun 11 10:25:45 www mysql.init: ERROR 1060 (42S21) at line 115: Duplicate column name 'Grant_priv'
Jun 11 10:25:45 www mysql.init: ERROR 1060 (42S21) at line 116: Duplicate column name 'Grant_priv'
Jun 11 10:25:45 www mysql.init: ERROR 1060 (42S21) at line 127: Duplicate column name 'ssl_type'
Jun 11 10:25:45 www mysql.init: ERROR 1061 (42000) at line 138: Duplicate key name 'Grantor'
Jun 11 10:25:45 www mysql.init: ERROR 1054 (42S22) at line 164: Unknown column 'Type' in 'columns_priv'
Jun 11 10:25:45 www mysql.init: ERROR 1060 (42S21) at line 186: Duplicate column name 'type'
Jun 11 10:25:45 www mysql.init: ERROR 1060 (42S21) at line 196: Duplicate column name 'Show_db_priv'
Jun 11 10:25:45 www mysql.init: ERROR 1060 (42S21) at line 213: Duplicate column name 'max_questions'
Jun 11 10:25:45 www mysql.init: ERROR 1060 (42S21) at line 223: Duplicate column name 'Create_tmp_table_priv'
Jun 11 10:25:45 www mysql.init: ERROR 1060 (42S21) at line 226: Duplicate column name 'Create_tmp_table_priv'
Jun 11 10:25:45 www mysql.init: ERROR 1060 (42S21) at line 320: Duplicate column name 'Create_view_priv'
Jun 11 10:25:45 www mysql.init: ERROR 1060 (42S21) at line 323: Duplicate column name 'Create_view_priv'
Jun 11 10:25:45 www mysql.init: ERROR 1060 (42S21) at line 326: Duplicate column name 'Create_view_priv'
Jun 11 10:25:45 www mysql.init: ERROR 1060 (42S21) at line 332: Duplicate column name 'Show_view_priv'
Jun 11 10:25:45 www mysql.init: ERROR 1060 (42S21) at line 335: Duplicate column name 'Show_view_priv'
Jun 11 10:25:45 www mysql.init: ERROR 1060 (42S21) at line 338: Duplicate column name 'Show_view_priv'
Jun 11 10:25:45 www mysql.init: ERROR 1060 (42S21) at line 355: Duplicate column name 'Create_routine_priv'
Jun 11 10:25:45 www mysql.init: ERROR 1060 (42S21) at line 358: Duplicate column name 'Create_routine_priv'
Jun 11 10:25:45 www mysql.init: ERROR 1060 (42S21) at line 361: Duplicate column name 'Create_routine_priv'
Jun 11 10:25:45 www mysql.init: ERROR 1060 (42S21) at line 367: Duplicate column name 'Alter_routine_priv'
Jun 11 10:25:45 www mysql.init: ERROR 1060 (42S21) at line 370: Duplicate column name 'Alter_routine_priv'
Jun 11 10:25:45 www mysql.init: ERROR 1060 (42S21) at line 373: Duplicate column name 'Alter_routine_priv'
Jun 11 10:25:46 www mysql.init: ERROR 1060 (42S21) at line 376: Duplicate column name 'Execute_priv'
Jun 11 10:25:46 www mysql.init: ERROR 1060 (42S21) at line 379: Duplicate column name 'Execute_priv'
Jun 11 10:25:46 www mysql.init: ERROR 1060 (42S21) at line 392: Duplicate column name 'max_user_connections'
Jun 11 10:25:46 www mysql.init: ERROR 1060 (42S21) at line 401: Duplicate column name 'Create_user_priv'
Jun 11 10:25:46 www mysql.init: ERROR 1060 (42S21) at line 423: Duplicate column name 'Routine_type'
Jun 11 10:25:46 www mysql.init: @hadGrantPriv:=1
Jun 11 10:25:46 www mysql.init: 1
Jun 11 10:25:46 www last message repeated 4 times
Jun 11 10:25:46 www mysql.init: @hadShowDbPriv:=1
Jun 11 10:25:46 www mysql.init: 1
Jun 11 10:25:46 www last message repeated 4 times
Jun 11 10:25:46 www mysql.init: @hadCreateViewPriv:=1
Jun 11 10:25:46 www mysql.init: 1
Jun 11 10:25:46 www last message repeated 4 times
Jun 11 10:25:46 www mysql.init: @hadCreateRoutinePriv:=1
Jun 11 10:25:46 www mysql.init: 1
Jun 11 10:25:46 www last message repeated 4 times
Jun 11 10:25:46 www mysql.init: @hadCreateUserPriv:=1
Jun 11 10:25:46 www mysql.init: 1
Jun 11 10:25:46 www last message repeated 4 times
Jun 11 10:25:46 www mysql.init: waiting for mysqld to restart

--- End code ---
Is there any possibility that this might somehow be related to the slowdown?

Navigation

[0] Message Index

[*] Previous page