Go Back   HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials > ISPConfig 3 > General

Do you like HowtoForge? Please consider supporting us by becoming a subscriber.
Reply
 
Thread Tools Display Modes
  #41  
Old 27th October 2010, 07:39
crypted crypted is offline
Senior Member
 
Join Date: Dec 2006
Location: Oklahoma, USA
Posts: 429
Thanks: 3
Thanked 14 Times in 6 Posts
Default

Most queries to SQL come from packaged scripts like that of Wordpress and other web packages.

What do you suggest for the SQL long query wait to be instead of 10 seconds? I agree there's a good bit being written to the harddrive. Below is my.cnf, let me know what your suggested changes are.

Code:
user            = mysql
pid-file        = /var/run/mysqld/mysqld.pid
socket          = /var/run/mysqld/mysqld.sock
port            = 3306
basedir         = /usr
datadir         = /var/lib/mysql
tmpdir          = /tmp
language        = /usr/share/mysql/english
skip-external-locking
#
# Instead of skip-networking the default is now to listen only on
# localhost which is more compatible and is not less secure.
#bind-address           = 127.0.0.1
#
# * Fine Tuning
#
key_buffer              = 16M
max_allowed_packet      = 16M
thread_stack            = 128K
thread_cache_size       = 8
# This replaces the startup script and checks MyISAM tables if needed
# the first time they are touched
myisam-recover          = BACKUP
max_connections        = 200
table_cache            = 650
#thread_concurrency     = 10
#
# * Query Cache Configuration
#
query_cache_limit       = 24M
query_cache_size        = 128M
#
# * Logging and Replication
#
# Both location gets rotated by the cronjob.
# Be aware that this log type is a performance killer.
#log            = /var/log/mysql/mysql.log
#
# Error logging goes to syslog. This is a Debian improvement :)
#
# Here you can see queries with especially long duration
log_slow_queries=/var/log/mysql/mysql-slow.log
#long_query_time = 2
log-queries-not-using-indexes
#
# The following can be used as easy to replay backup logs or for replication.
# note: if you are setting up a replication slave, see README.Debian about
#       other settings you may need to change.
#server-id              = 1
#log_bin                        = /var/log/mysql/mysql-bin.log
expire_logs_days        = 10
max_binlog_size         = 100M
#binlog_do_db           = include_database_name
#binlog_ignore_db       = include_database_name
#
# * BerkeleyDB
#
# Using BerkeleyDB is now discouraged as its support will cease in 5.1.12.
skip-bdb
#
# * InnoDB
#
# InnoDB is enabled by default with a 10MB datafile in /var/lib/mysql/.
# Read the manual for more InnoDB related options. There are many!
# You might want to disable InnoDB to shrink the mysqld process by circa 100MB.
#skip-innodb
#
# * Security Features
#
# Read the manual, too, if you want chroot!
# chroot = /var/lib/mysql/
#
# For generating SSL certificates I recommend the OpenSSL GUI "tinyca".
#
# ssl-ca=/etc/mysql/cacert.pem
# ssl-cert=/etc/mysql/server-cert.pem
# ssl-key=/etc/mysql/server-key.pem
join_buffer_size=3M
max_heap_table_size=375M
tmp_table_size=375M
low_priority_updates=1
concurrent_insert=2

innodb_buffer_pool_size=64M



[mysqldump]
quick
quote-names
max_allowed_packet      = 16M

[mysql]
#no-auto-rehash # faster start of mysql but no tab completition

[isamchk]
key_buffer              = 64M

#
# * NDB Cluster
#
# See /usr/share/doc/mysql-server-*/README.Debian for more information.
#
# The following configuration is read by the NDB Data Nodes (ndbd processes)
# not from the NDB Management Nodes (ndb_mgmd processes).
#
# [MYSQL_CLUSTER]
# ndb-connectstring=127.0.0.1


#
# * IMPORTANT: Additional settings that can override those from this file!
#   The files must end with '.cnf', otherwise they'll be ignored.
#
!includedir /etc/mysql/conf.d/

#join_buffer_size=2M
#max_heap_table_size=80M
#tmp_table_size=80M

#low_priority_updates=1

#concurrent_insert=2
As far as errors, I'm getting the following in web8's error log:
Code:
[Mon Oct 25 06:59:57 2010] [warn] (103)Software caused connection abort: mod_fcgid: ap_pass_brigade failed in handle_request functi$
[Mon Oct 25 07:14:39 2010] [warn] (103)Software caused connection abort: mod_fcgid: ap_pass_brigade failed in handle_request functi$
[Mon Oct 25 07:18:19 2010] [warn] (103)Software caused connection abort: mod_fcgid: ap_pass_brigade failed in handle_request functi$
[Mon Oct 25 07:24:16 2010] [warn] mod_fcgid: read data timeout in 360 seconds
[Mon Oct 25 07:24:16 2010] [error] [client 66.118.142.211] Premature end of script headers: wp-cron.php
[Mon Oct 25 07:29:19 2010] [warn] (103)Software caused connection abort: mod_fcgid: ap_pass_brigade failed in handle_request functi$
[Mon Oct 25 07:55:06 2010] [warn] (103)Software caused connection abort: mod_fcgid: ap_pass_brigade failed in handle_request functi$
[Mon Oct 25 08:02:16 2010] [warn] (103)Software caused connection abort: mod_fcgid: ap_pass_brigade failed in handle_request functi$
[Mon Oct 25 08:24:02 2010] [warn] (104)Connection reset by peer: mod_fcgid: read data from fastcgi server error.
[Mon Oct 25 08:24:02 2010] [error] [client 66.118.142.211] Premature end of script headers: wp-cron.php
[Mon Oct 25 09:14:35 2010] [warn] (103)Software caused connection abort: mod_fcgid: ap_pass_brigade failed in handle_request functi$
[Mon Oct 25 09:24:31 2010] [warn] mod_fcgid: read data timeout in 360 seconds
[Mon Oct 25 09:24:31 2010] [error] [client 66.118.142.211] Premature end of script headers: wp-cron.php
[Mon Oct 25 09:44:25 2010] [warn] (103)Software caused connection abort: mod_fcgid: ap_pass_brigade failed in handle_request functi$
[Mon Oct 25 10:13:35 2010] [warn] (103)Software caused connection abort: mod_fcgid: ap_pass_brigade failed in handle_request functi$
[Mon Oct 25 10:24:37 2010] [warn] mod_fcgid: read data timeout in 360 seconds
[Mon Oct 25 10:24:37 2010] [error] [client 66.118.142.211] Premature end of script headers: wp-cron.php
[Mon Oct 25 10:28:31 2010] [warn] (103)Software caused connection abort: mod_fcgid: ap_pass_brigade failed in handle_request functi$
[Mon Oct 25 10:37:36 2010] [warn] (103)Software caused connection abort: mod_fcgid: ap_pass_brigade failed in handle_request functi$
[Mon Oct 25 10:51:02 2010] [warn] (103)Software caused connection abort: mod_fcgid: ap_pass_brigade failed in handle_request functi$
[Mon Oct 25 10:52:24 2010] [error] [client 72.198.65.173] File does not exist: /var/www/inter5.org/web/wp-content/plugins/statpress$
[Mon Oct 25 10:59:24 2010] [warn] (103)Software caused connection abort: mod_fcgid: ap_pass_brigade failed in handle_request functi$
[Mon Oct 25 11:09:18 2010] [warn] (103)Software caused connection abort: mod_fcgid: ap_pass_brigade failed in handle_request functi$
[Mon Oct 25 11:23:57 2010] [warn] (104)Connection reset by peer: mod_fcgid: read data from fastcgi server error.
[Mon Oct 25 11:23:57 2010] [error] [client 66.118.142.211] Premature end of script headers: wp-cron.php
[Mon Oct 25 11:48:25 2010] [warn] (103)Software caused connection abort: mod_fcgid: ap_pass_brigade failed in handle_request functi$
Web5 (the other big site that has a lot of spawns of php-cgi) has the following:
Code:
[Mon Oct 25 05:41:13 2010] [warn] (103)Software caused connection abort: mod_fcgid: ap_pass_brigade failed in handle_request functi$
[Mon Oct 25 05:41:14 2010] [warn] (103)Software caused connection abort: mod_fcgid: ap_pass_brigade failed in handle_request functi$
[Mon Oct 25 05:41:16 2010] [warn] (103)Software caused connection abort: mod_fcgid: ap_pass_brigade failed in handle_request functi$
[Mon Oct 25 05:41:17 2010] [warn] (103)Software caused connection abort: mod_fcgid: ap_pass_brigade failed in handle_request functi$
[Mon Oct 25 05:41:19 2010] [warn] (103)Software caused connection abort: mod_fcgid: ap_pass_brigade failed in handle_request functi$
[Mon Oct 25 05:41:21 2010] [warn] (103)Software caused connection abort: mod_fcgid: ap_pass_brigade failed in handle_request functi$
[Mon Oct 25 05:41:22 2010] [warn] (103)Software caused connection abort: mod_fcgid: ap_pass_brigade failed in handle_request functi$
[Mon Oct 25 05:41:24 2010] [warn] (103)Software caused connection abort: mod_fcgid: ap_pass_brigade failed in handle_request functi$
[Mon Oct 25 05:41:25 2010] [warn] (103)Software caused connection abort: mod_fcgid: ap_pass_brigade failed in handle_request functi$
[Mon Oct 25 05:41:27 2010] [warn] (103)Software caused connection abort: mod_fcgid: ap_pass_brigade failed in handle_request functi$
[Mon Oct 25 05:41:28 2010] [warn] (103)Software caused connection abort: mod_fcgid: ap_pass_brigade failed in handle_request functi$
[Mon Oct 25 05:41:30 2010] [warn] (103)Software caused connection abort: mod_fcgid: ap_pass_brigade failed in handle_request functi$
[Mon Oct 25 05:41:32 2010] [warn] (103)Software caused connection abort: mod_fcgid: ap_pass_brigade failed in handle_request functi$
[Mon Oct 25 05:41:33 2010] [warn] (103)Software caused connection abort: mod_fcgid: ap_pass_brigade failed in handle_request functi$
[Mon Oct 25 05:41:35 2010] [warn] (103)Software caused connection abort: mod_fcgid: ap_pass_brigade failed in handle_request functi$
[Mon Oct 25 05:41:36 2010] [warn] (103)Software caused connection abort: mod_fcgid: ap_pass_brigade failed in handle_request functi$
[Mon Oct 25 05:41:38 2010] [warn] (103)Software caused connection abort: mod_fcgid: ap_pass_brigade failed in handle_request functi$
[Mon Oct 25 05:41:39 2010] [warn] (103)Software caused connection abort: mod_fcgid: ap_pass_brigade failed in handle_request functi$
[Mon Oct 25 05:41:41 2010] [warn] (103)Software caused connection abort: mod_fcgid: ap_pass_brigade failed in handle_request functi$
[Mon Oct 25 05:41:43 2010] [warn] (103)Software caused connection abort: mod_fcgid: ap_pass_brigade failed in handle_request functi$
[Mon Oct 25 05:41:44 2010] [warn] (103)Software caused connection abort: mod_fcgid: ap_pass_brigade failed in handle_request functi$
[Mon Oct 25 05:41:46 2010] [warn] (103)Software caused connection abort: mod_fcgid: ap_pass_brigade failed in handle_request functi$
[Mon Oct 25 05:41:47 2010] [warn] (103)Software caused connection abort: mod_fcgid: ap_pass_brigade failed in handle_request functi$
[Mon Oct 25 05:41:49 2010] [warn] (103)Software caused connection abort: mod_fcgid: ap_pass_brigade failed in handle_request functi$
Repeats quite often for both sites, just warns really though.
__________________
ISPC3 on Debian! It's great!
Reply With Quote
Sponsored Links
  #42  
Old 27th October 2010, 15:52
crypted crypted is offline
Senior Member
 
Join Date: Dec 2006
Location: Oklahoma, USA
Posts: 429
Thanks: 3
Thanked 14 Times in 6 Posts
Default

Since I can't add more to my previous post found above, here's the output from my load monitoring script. It emails me information when the load gets >10.

Code:
USER       PID %CPU %MEM    VSZ   RSS TTY      STAT START   TIME COMMAND
root         2  0.0  0.0      0     0 ?        S<   Oct12   0:00 [kthreadd]
root         3  0.0  0.0      0     0 ?        S<   Oct12   0:02  \_ [migration/0]
root         4  0.0  0.0      0     0 ?        S<   Oct12   0:02  \_ [ksoftirqd/0]
root         5  0.0  0.0      0     0 ?        S<   Oct12   0:12  \_ [watchdog/0]
root         6  0.0  0.0      0     0 ?        S<   Oct12   0:02  \_ [migration/1]
root         7  0.0  0.0      0     0 ?        S<   Oct12   0:01  \_ [ksoftirqd/1]
root         8  0.0  0.0      0     0 ?        S<   Oct12   0:00  \_ [watchdog/1]
root         9  0.0  0.0      0     0 ?        S<   Oct12   0:53  \_ [events/0]
root        10  0.0  0.0      0     0 ?        S<   Oct12   0:52  \_ [events/1]
root        11  0.0  0.0      0     0 ?        S<   Oct12   0:00  \_ [khelper]
root        46  0.0  0.0      0     0 ?        S<   Oct12   0:42  \_ [kblockd/0]
root        47  0.0  0.0      0     0 ?        S<   Oct12   0:01  \_ [kblockd/1]
root        49  0.0  0.0      0     0 ?        S<   Oct12   0:00  \_ [kacpid]
root        50  0.0  0.0      0     0 ?        S<   Oct12   0:00  \_ [kacpi_notify]
root       120  0.0  0.0      0     0 ?        S<   Oct12   0:00  \_ [ksuspend_usbd]
root       126  0.0  0.0      0     0 ?        S<   Oct12   0:00  \_ [khubd]
root       129  0.0  0.0      0     0 ?        S<   Oct12   0:00  \_ [kseriod]
root       175  0.0  0.0      0     0 ?        S<   Oct12   0:46  \_ [kswapd0]
root       176  0.0  0.0      0     0 ?        S<   Oct12   0:00  \_ [aio/0]
root       177  0.0  0.0      0     0 ?        S<   Oct12   0:00  \_ [aio/1]
root       673  0.0  0.0      0     0 ?        S<   Oct12   0:00  \_ [ata/0]
root       674  0.0  0.0      0     0 ?        S<   Oct12   0:00  \_ [ata/1]
root       675  0.0  0.0      0     0 ?        S<   Oct12   0:00  \_ [ata_aux]
root       788  0.0  0.0      0     0 ?        S<   Oct12   0:00  \_ [scsi_eh_0]
root       789  0.0  0.0      0     0 ?        S<   Oct12   0:00  \_ [scsi_eh_1]
root       890  0.0  0.0      0     0 ?        S<   Oct12   8:07  \_ [kjournald]
root      1311  0.0  0.0      0     0 ?        S<   Oct12   0:14  \_ [edac-poller]
root      1461  0.0  0.0      0     0 ?        S<   Oct12   0:00  \_ [kpsmoused]
root      1684  0.0  0.0      0     0 ?        S<   Oct12   0:11  \_ [kjournald]
root      3862  0.0  0.0      0     0 ?        S<   Oct12   0:00  \_ [rpciod/0]
root      3863  0.0  0.0      0     0 ?        S<   Oct12   0:00  \_ [rpciod/1]
root      3887  0.0  0.0      0     0 ?        S<   Oct12   0:00  \_ [lockd]
root      3888  0.0  0.0      0     0 ?        S<   Oct12   0:00  \_ [nfsd4]
root      3889  0.0  0.0      0     0 ?        S    Oct12   0:00  \_ [nfsd]
root      3890  0.0  0.0      0     0 ?        S    Oct12   0:00  \_ [nfsd]
root      3891  0.0  0.0      0     0 ?        S    Oct12   0:00  \_ [nfsd]
root      3892  0.0  0.0      0     0 ?        S    Oct12   0:00  \_ [nfsd]
root      3893  0.0  0.0      0     0 ?        S    Oct12   0:00  \_ [nfsd]
root      3894  0.0  0.0      0     0 ?        S    Oct12   0:00  \_ [nfsd]
root      3895  0.0  0.0      0     0 ?        S    Oct12   0:00  \_ [nfsd]
root      3896  0.0  0.0      0     0 ?        S    Oct12   0:00  \_ [nfsd]
root     13511  0.0  0.0      0     0 ?        S    Oct21   0:11  \_ [pdflush]
root     22363  0.0  0.0      0     0 ?        S    Oct25   0:09  \_ [pdflush]
root         1  0.0  0.0  10316    84 ?        Ss   Oct12   0:11 init [2]        
root       966  0.0  0.0  16836     4 ?        S<s  Oct12   0:00 udevd --daemon
daemon    2622  0.0  0.0   8024   132 ?        Ss   Oct12   0:00 /sbin/portmap
statd     2634  0.0  0.0  10140     8 ?        Ss   Oct12   0:00 /sbin/rpc.statd
root      2822  0.0  0.0 253048  1472 ?        Sl   Oct12   1:00 /usr/sbin/rsyslogd -c3
root      2833  0.0  0.0   3800     4 ?        Ss   Oct12   0:00 /usr/sbin/acpid
root      2846  0.0  0.0  48868   348 ?        Ss   Oct12   0:00 /usr/sbin/sshd
amavis    2873  0.0  0.0 191280  1512 ?        Ss   Oct12   0:13 amavisd (master)
amavis   20106  0.0  1.2 195540 52256 ?        S    Oct26   0:01  \_ amavisd (ch8-avail)
amavis   21362  0.0  1.4 199544 57364 ?        S    Oct26   0:06  \_ amavisd (ch8-avail)
postgrey  2994  0.0  0.1  57244  5060 ?        Ss   Oct12   0:10 /usr/sbin/postgrey --pidfile=/var/run/postgrey.pid --daemonize --inet=127.0.0.1:60000 --delay=300
root      2998  0.0  0.0 106100  1792 ?        Ss   Oct12   2:37 /usr/sbin/spamd --create-prefs --max-children 5 --helper-home-dir -d --pidfile=/var/run/spamd.pid
root      3938  0.0  0.0 106100  1124 ?        S    Oct12   0:01  \_ spamd child
root      3939  0.0  0.0 106100  1136 ?        S    Oct12   0:00  \_ spamd child
clamav    3631  0.0  3.4 271236 140452 ?       Ssl  Oct12  17:15 /usr/sbin/clamd
clamav    3739  0.0  0.1  56344  6972 ?        Ss   Oct12   1:59 /usr/bin/freshclam -d --quiet
root      3781  0.5  0.2  57612  8364 ?        Ss   Oct12 104:38 /usr/bin/perl -w /usr/bin/collectl -D
root      3786  0.0  0.0   6064     4 ?        S    Oct12   0:00 /usr/sbin/courierlogger -pid=/var/run/courier/authdaemon/pid -start /usr/lib/courier/courier-authlib/authdaemond
root      3787  0.0  0.0  29600    40 ?        S    Oct12   0:02  \_ /usr/lib/courier/courier-authlib/authdaemond
root      3794  0.0  0.0  31696   492 ?        S    Oct12   0:01      \_ /usr/lib/courier/courier-authlib/authdaemond
root      3795  0.0  0.0  31696   488 ?        S    Oct12   0:02      \_ /usr/lib/courier/courier-authlib/authdaemond
root      3796  0.0  0.0  31696   488 ?        S    Oct12   0:00      \_ /usr/lib/courier/courier-authlib/authdaemond
root      3797  0.0  0.0  31696   488 ?        S    Oct12   0:00      \_ /usr/lib/courier/courier-authlib/authdaemond
root      3798  0.0  0.0  31696   488 ?        S    Oct12   0:00      \_ /usr/lib/courier/courier-authlib/authdaemond
root      3802  0.0  0.0   6064   252 ?        S    Oct12   0:00 /usr/sbin/courierlogger -pid=/var/run/courier/imapd.pid -start -name=imapd /usr/sbin/couriertcpd -address=0 -maxprocs=40 -maxperip=20 -nodnslookup -noidentlookup 143 /usr/lib/courier/courier/imaplogin /usr/bin/imapd Maildir
root      3803  0.0  0.0   9236   124 ?        S    Oct12   0:01  \_ /usr/sbin/couriertcpd -address=0 -maxprocs=40 -maxperip=20 -nodnslookup -noidentlookup 143 /usr/lib/courier/courier/imaplogin /usr/bin/imapd Maildir
root      3814  0.0  0.0   6064   252 ?        S    Oct12   0:00 /usr/sbin/courierlogger -pid=/var/run/courier/imapd-ssl.pid -start -name=imapd-ssl /usr/sbin/couriertcpd -address=0 -maxprocs=40 -maxperip=20 -nodnslookup -noidentlookup 993 /usr/bin/couriertls -server -tcpd /usr/lib/courier/courier/imaplogin /usr/bin/imapd Maildir
root      3815  0.0  0.0   9236   128 ?        S    Oct12   0:01  \_ /usr/sbin/couriertcpd -address=0 -maxprocs=40 -maxperip=20 -nodnslookup -noidentlookup 993 /usr/bin/couriertls -server -tcpd /usr/lib/courier/courier/imaplogin /usr/bin/imapd Maildir
root      3820  0.0  0.0   6064   248 ?        S    Oct12   0:00 /usr/sbin/courierlogger -pid=/var/run/courier/pop3d.pid -start -name=pop3d /usr/sbin/couriertcpd -maxprocs=40 -maxperip=4 -nodnslookup -noidentlookup -address=0 110 /usr/lib/courier/courier/courierpop3login /usr/lib/courier/courier/courierpop3d Maildir
root      3821  0.0  0.0   9236   128 ?        S    Oct12   0:01  \_ /usr/sbin/couriertcpd -maxprocs=40 -maxperip=4 -nodnslookup -noidentlookup -address=0 110 /usr/lib/courier/courier/courierpop3login /usr/lib/courier/courier/courierpop3d Maildir
root      3832  0.0  0.0   6064     4 ?        S    Oct12   0:00 /usr/sbin/courierlogger -pid=/var/run/courier/pop3d-ssl.pid -start -name=pop3d-ssl /usr/sbin/couriertcpd -address=0 -maxprocs=40 -maxperip=4 -nodnslookup -noidentlookup 995 /usr/bin/couriertls -server -tcpd /usr/lib/courier/courier/courierpop3login /usr/lib/courier/courier/courierpop3d Maildir
root      3833  0.0  0.0   9236     8 ?        S    Oct12   0:00  \_ /usr/sbin/couriertcpd -address=0 -maxprocs=40 -maxperip=4 -nodnslookup -noidentlookup 995 /usr/bin/couriertls -server -tcpd /usr/lib/courier/courier/courierpop3login /usr/lib/courier/courier/courierpop3d Maildir
nobody    3843  0.0  0.0  26072   508 ?        Ss   Oct12   0:02 /usr/local/sbin/mydns -b
nobody   20954  0.0  0.0  28220  2708 ?        S    Oct25   1:37  \_ /usr/local/sbin/mydns -b
root      3900  0.0  0.0  14360     4 ?        Ss   Oct12   0:00 /usr/sbin/rpc.mountd
root      3907  0.0  0.0  95176  2496 ?        Ss   Oct12   0:51 /usr/bin/perl -w /usr/sbin/mailgraph -l /var/log/mail.log -d --daemon_rrd=/var/lib/mailgraph
root      3912  0.0  0.0  10132     8 ?        Ss   Oct12   0:00 /usr/sbin/inetd
root      3983  0.0  0.0  36844   304 ?        Ss   Oct12   0:37 /usr/lib/postfix/master
postfix   3991  0.0  0.0  52160   720 ?        S    Oct12   0:03  \_ qmgr -l -t fifo -u
postfix   4120  0.0  0.0  41672   856 ?        S    Oct12   0:04  \_ tlsmgr -l -t unix -u -c
postfix   8690  0.0  0.0  38900  2216 ?        S    01:45   0:00  \_ pickup -l -t fifo -u -c
root      4004  0.0  0.0  55540   720 ?        Ss   Oct12   0:18 /usr/sbin/nmbd -D
root      4006  0.0  0.0  81776  1112 ?        Ss   Oct12   6:37 /usr/sbin/smbd -D
root      4032  0.0  0.0  79916    24 ?        S    Oct12   0:00  \_ /usr/sbin/smbd -D
root     28265  0.0  0.0  81296  1208 ?        S    Oct22   0:01  \_ /usr/sbin/smbd -D
root     28266  0.0  0.0  81296  1200 ?        S    Oct22   0:01  \_ /usr/sbin/smbd -D
root     28270  0.0  0.0  81296  1196 ?        S    Oct22   0:01  \_ /usr/sbin/smbd -D
root     28271  0.0  0.0  81296  1180 ?        S    Oct22   0:01  \_ /usr/sbin/smbd -D
root     28273  0.0  0.0  81296  1196 ?        S    Oct22   0:02  \_ /usr/sbin/smbd -D
root     28274  0.0  0.0  81296  1192 ?        S    Oct22   0:02  \_ /usr/sbin/smbd -D
root     28275  0.0  0.0  81296  1184 ?        S    Oct22   0:01  \_ /usr/sbin/smbd -D
root     28276  0.0  0.0  81296  1176 ?        S    Oct22   0:01  \_ /usr/sbin/smbd -D
root     28277  0.0  0.0  81296  1180 ?        S    Oct22   0:01  \_ /usr/sbin/smbd -D
root     28278  0.0  0.0  81296  1176 ?        S    Oct22   0:01  \_ /usr/sbin/smbd -D
root      4031  0.0  0.0  56936     8 ?        Ss   Oct12   0:00 /usr/sbin/saslauthd -a pam -c -m /var/spool/postfix/var/run/saslauthd -r -n 5
root      4033  0.0  0.0  56576     8 ?        S    Oct12   0:00  \_ /usr/sbin/saslauthd -a pam -c -m /var/spool/postfix/var/run/saslauthd -r -n 5
root      4034  0.0  0.0  56456  1056 ?        S    Oct12   0:00  \_ /usr/sbin/saslauthd -a pam -c -m /var/spool/postfix/var/run/saslauthd -r -n 5
root      4035  0.0  0.0  56456     8 ?        S    Oct12   0:00  \_ /usr/sbin/saslauthd -a pam -c -m /var/spool/postfix/var/run/saslauthd -r -n 5
root      4036  0.0  0.0  56576   976 ?        S    Oct12   0:00  \_ /usr/sbin/saslauthd -a pam -c -m /var/spool/postfix/var/run/saslauthd -r -n 5
root      4054  0.0  0.0  59732   720 ?        Ss   Oct12   0:12 /usr/sbin/winbindd
root      4061  0.0  0.0  59644   516 ?        S    Oct12   0:01  \_ /usr/sbin/winbindd
root     28192  0.0  0.0  59644   472 ?        S    Oct12   0:00  \_ /usr/sbin/winbindd
root     28193  0.0  0.0  59728   856 ?        S    Oct12   0:03  \_ /usr/sbin/winbindd
root      4064  0.0  0.0  24464   516 ?        Ss   Oct12   0:01 /usr/sbin/famd -T 0
ntp       4081  0.0  0.0  22384   616 ?        Ss   Oct12   0:25 /usr/sbin/ntpd -p /var/run/ntpd.pid -u 104:108 -g
root      4097  0.0  0.0  23868     4 ?        Ss   Oct12   0:00 /usr/sbin/squid -D -YC
proxy     4099  0.0  0.3  39932 14152 ?        S    Oct12   2:31  \_ (squid) -D -YC
proxy     4106  0.0  0.0   3644    80 ?        Ss   Oct12   0:00      \_ (unlinkd)
root      4117  0.0  0.0   5988    60 ?        S    Oct12   0:02 /usr/sbin/atalkd
root      4275  0.0  0.0  22304     8 ?        S    Oct12   0:00 /usr/sbin/afpd -U uams_clrtxt.so,uams_randnum.so -g nobody -c 50 -n my
root      4277  0.0  0.0  41308     4 ?        S    Oct12   0:00 /usr/sbin/papd
daemon    4280  0.0  0.0  16360    52 ?        Ss   Oct12   0:00 /usr/sbin/atd
root      4300  0.0  0.0  19836   644 ?        Ss   Oct12   0:22 /usr/sbin/cron
root     11247  0.0  0.0  28380   964 ?        S    02:15   0:00  \_ /USR/SBIN/CRON
munin    11255  0.0  0.0   8832  1140 ?        Ss   02:15   0:00  |   \_ /bin/sh -c if [ -x /usr/bin/munin-cron ]; then /usr/bin/munin-cron; fi
munin    11256  0.0  0.0   8840  1152 ?        S    02:15   0:00  |       \_ /bin/sh /usr/bin/munin-cron
munin    11261 12.0  0.2 100404  8424 ?        R    02:15   0:00  |           \_ /usr/bin/perl -w /usr/share/munin/munin-update
root     11269  0.0  0.0  28380   964 ?        S    02:15   0:00  \_ /USR/SBIN/CRON
root     11272  0.0  0.0   8832  1140 ?        Ss   02:15   0:00  |   \_ /bin/sh -c /backup/loadchecker.sh >/dev/null 2>&1 #load check and report
root     11281  0.0  0.0   8848  1172 ?        S    02:15   0:00  |       \_ /bin/bash /backup/loadchecker.sh
root     11302  0.0  0.0  15044  1208 ?        R    02:15   0:00  |           \_ ps auxfww
root     11275  0.0  0.0  28380   964 ?        S    02:15   0:00  \_ /USR/SBIN/CRON
root     11276  0.0  0.0   8832  1136 ?        Ss   02:15   0:00      \_ /bin/sh -c /usr/local/ispconfig/server/server.sh > /dev/null 2>> /var/log/ispconfig/cron.log
root     11277  0.0  0.0   8844  1180 ?        S    02:15   0:00          \_ /bin/sh /usr/local/ispconfig/server/server.sh
root     11288  6.0  0.3 247124 14780 ?        S    02:15   0:00              \_ /usr/bin/php -q /usr/local/ispconfig/server/server.php
root     11303  0.0  0.0   4124   676 ?        D    02:15   0:00                  \_ repquota -asu
root      4372  0.0  0.0  40368  2260 ?        Ss   Oct12   1:01 /usr/sbin/munin-node
root      4460  0.0  0.0  73488  3212 ?        Sl   Oct12   5:33 /usr/bin/python /usr/bin/fail2ban-server -b -s /var/run/fail2ban/fail2ban.sock
root      4504  0.0  0.0  17476     8 tty8     Ss+  Oct12   0:00 -/bin/bash
root      4527  0.0  0.0  74900  2428 ?        Ss   Oct12   0:40 /usr/bin/perl /usr/share/webmin/miniserv.pl /etc/webmin/miniserv.conf
root      4529  0.0  0.0   3800     8 tty1     Ss+  Oct12   0:00 /sbin/getty 38400 tty1
root      4530  0.0  0.0   3800     8 tty2     Ss+  Oct12   0:00 /sbin/getty 38400 tty2
root      4531  0.0  0.0   3800     8 tty3     Ss+  Oct12   0:00 /sbin/getty 38400 tty3
root      4532  0.0  0.0   3800     8 tty4     Ss+  Oct12   0:00 /sbin/getty 38400 tty4
root      4533  0.0  0.0   3800     8 tty5     Ss+  Oct12   0:00 /sbin/getty 38400 tty5
root      4534  0.0  0.0   3800     8 tty6     Ss+  Oct12   0:00 /sbin/getty 38400 tty6
nobody   28439  0.0  0.0  21284    96 ?        S    Oct13   0:31 /usr/bin/memcached -m 64 -p 11211 -u nobody -l 127.0.0.1
root     31502  0.0  0.0  31984   192 ?        Ss   Oct24   0:00 pure-ftpd (SERVER)                                                                                                                                                                      
root     15342  0.0  0.0  10192  1404 ?        S    Oct26   0:00 /bin/sh /usr/bin/mysqld_safe
mysql    15381  5.1  3.8 421328 156400 ?       Sl   Oct26  17:18  \_ /usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --user=mysql --pid-file=/var/run/mysqld/mysqld.pid --skip-external-locking --port=3306 --socket=/var/run/mysqld/mysqld.sock
root     15382  0.0  0.0   5040   668 ?        S    Oct26   0:00  \_ logger -p daemon.err -t mysqld_safe -i -t mysqld
root      2297  0.0  0.4 330864 17200 ?        Ss   00:46   0:00 /usr/sbin/apache2 -k start
root      2299  0.0  0.1  39188  6924 ?        S    00:46   0:01  \_ vlogger (access log)
www-data  2300  0.0  0.1 170188  5404 ?        S    00:46   0:00  \_ /usr/sbin/apache2 -k start
web1      2326  0.5  2.5 284144 105240 ?       S    00:46   0:30  |   \_ /usr/bin/php-cgi -d open_basedir=/var/www/clients/client1/web1/web:/var/www/clients/client1/web1/tmp:/var/www/masonicwiki.info/web:/srv/www/masonicwiki.info/web:/usr/share/php5:/tmp:/usr/share/phpmyadmin -d upload_tmp_dir=/var/www/clients/client1/web1/tmp -d session.save_path=/var/www/clients/client1/web1/tmp
web7      2419  0.0  1.3 263660 55880 ?        S    00:48   0:02  |   \_ /usr/bin/php-cgi -d open_basedir=/var/www/clients/client1/web7/web:/var/www/clients/client1/web7/tmp:/var/www/sebastianlodge.com/web:/srv/www/sebastianlodge.com/web:/usr/share/php5:/tmp:/usr/share/phpmyadmin -d upload_tmp_dir=/var/www/clients/client1/web7/tmp -d session.save_path=/var/www/clients/client1/web7/tmp
web11     2431  0.0  1.3 266240 56204 ?        S    00:48   0:03  |   \_ /usr/bin/php-cgi -d open_basedir=/var/www/clients/client1/web11/web:/var/www/clients/client1/web11/tmp:/var/www/derekgordon.com/web:/srv/www/derekgordon.com/web:/usr/share/php5:/tmp:/usr/share/phpmyadmin -d upload_tmp_dir=/var/www/clients/client1/web11/tmp -d session.save_path=/var/www/clients/client1/web11/tmp
web11     3001  0.0  1.3 265456 55056 ?        S    00:53   0:02  |   \_ /usr/bin/php-cgi -d open_basedir=/var/www/clients/client1/web11/web:/var/www/clients/client1/web11/tmp:/var/www/derekgordon.com/web:/srv/www/derekgordon.com/web:/usr/share/php5:/tmp:/usr/share/phpmyadmin -d upload_tmp_dir=/var/www/clients/client1/web11/tmp -d session.save_path=/var/www/clients/client1/web11/tmp
web29     4199  0.0  1.3 264152 55728 ?        S    01:03   0:00  |   \_ /usr/bin/php-cgi -d open_basedir=/var/www/clients/client1/web29/web:/var/www/clients/client1/web29/tmp:/var/www/derekandgaby.com/web:/srv/www/derekandgaby.com/web:/usr/share/php5:/tmp:/usr/share/phpmyadmin -d upload_tmp_dir=/var/www/clients/client1/web29/tmp -d session.save_path=/var/www/clients/client1/web29/tmp
web5      8283  4.5  1.9 277696 78128 ?        S    01:42   1:28  |   \_ /usr/bin/php-cgi -d open_basedir=/var/www/clients/client1/web5/web:/var/www/clients/client1/web5/tmp:/var/www/areyouliberal.com/web:/srv/www/areyouliberal.com/web:/usr/share/php5:/tmp:/usr/share/phpmyadmin -d upload_tmp_dir=/var/www/clients/client1/web5/tmp -d session.save_path=/var/www/clients/client1/web5/tmp
web5      8330  4.5  1.9 277700 78092 ?        R    01:44   1:23  |   \_ /usr/bin/php-cgi -d open_basedir=/var/www/clients/client1/web5/web:/var/www/clients/client1/web5/tmp:/var/www/areyouliberal.com/web:/srv/www/areyouliberal.com/web:/usr/share/php5:/tmp:/usr/share/phpmyadmin -d upload_tmp_dir=/var/www/clients/client1/web5/tmp -d session.save_path=/var/www/clients/client1/web5/tmp
web8      9690 26.1  1.5 262628 63336 ?        S    01:58   4:17  |   \_ /usr/bin/php-cgi -d open_basedir=/var/www/clients/client1/web8/web:/var/www/clients/client1/web8/tmp:/var/www/inter5.org/web:/srv/www/inter5.org/web:/usr/share/php5:/tmp:/usr/share/phpmyadmin -d upload_tmp_dir=/var/www/clients/client1/web8/tmp -d session.save_path=/var/www/clients/client1/web8/tmp
web5      9695  6.2  1.9 277704 78056 ?        S    01:58   1:00  |   \_ /usr/bin/php-cgi -d open_basedir=/var/www/clients/client1/web5/web:/var/www/clients/client1/web5/tmp:/var/www/areyouliberal.com/web:/srv/www/areyouliberal.com/web:/usr/share/php5:/tmp:/usr/share/phpmyadmin -d upload_tmp_dir=/var/www/clients/client1/web5/tmp -d session.save_path=/var/www/clients/client1/web5/tmp
web8      9721 21.5  1.7 272068 72972 ?        R    01:59   3:26  |   \_ /usr/bin/php-cgi -d open_basedir=/var/www/clients/client1/web8/web:/var/www/clients/client1/web8/tmp:/var/www/inter5.org/web:/srv/www/inter5.org/web:/usr/share/php5:/tmp:/usr/share/phpmyadmin -d upload_tmp_dir=/var/www/clients/client1/web8/tmp -d session.save_path=/var/www/clients/client1/web8/tmp
web9     10189  0.0  1.1 258148 46292 ?        S    02:04   0:00  |   \_ /usr/bin/php-cgi -d open_basedir=/var/www/clients/client1/web9/web:/var/www/clients/client1/web9/tmp:/var/www/Peruvianprincess.org/web:/srv/www/Peruvianprincess.org/web:/usr/share/php5:/tmp:/usr/share/phpmyadmin -d upload_tmp_dir=/var/www/clients/client1/web9/tmp -d session.save_path=/var/www/clients/client1/web9/tmp
web8     11094  2.7  1.7 271788 72720 ?        S    02:12   0:04  |   \_ /usr/bin/php-cgi -d open_basedir=/var/www/clients/client1/web8/web:/var/www/clients/client1/web8/tmp:/var/www/inter5.org/web:/srv/www/inter5.org/web:/usr/share/php5:/tmp:/usr/share/phpmyadmin -d upload_tmp_dir=/var/www/clients/client1/web8/tmp -d session.save_path=/var/www/clients/client1/web8/tmp
web8     11095  7.2  1.7 271808 72880 ?        R    02:12   0:12  |   \_ /usr/bin/php-cgi -d open_basedir=/var/www/clients/client1/web8/web:/var/www/clients/client1/web8/tmp:/var/www/inter5.org/web:/srv/www/inter5.org/web:/usr/share/php5:/tmp:/usr/share/phpmyadmin -d upload_tmp_dir=/var/www/clients/client1/web8/tmp -d session.save_path=/var/www/clients/client1/web8/tmp
web8     11096  6.7  1.7 270788 71856 ?        R    02:12   0:12  |   \_ /usr/bin/php-cgi -d open_basedir=/var/www/clients/client1/web8/web:/var/www/clients/client1/web8/tmp:/var/www/inter5.org/web:/srv/www/inter5.org/web:/usr/share/php5:/tmp:/usr/share/phpmyadmin -d upload_tmp_dir=/var/www/clients/client1/web8/tmp -d session.save_path=/var/www/clients/client1/web8/tmp
web8     11097  2.7  1.7 270768 71700 ?        S    02:12   0:04  |   \_ /usr/bin/php-cgi -d open_basedir=/var/www/clients/client1/web8/web:/var/www/clients/client1/web8/tmp:/var/www/inter5.org/web:/srv/www/inter5.org/web:/usr/share/php5:/tmp:/usr/share/phpmyadmin -d upload_tmp_dir=/var/www/clients/client1/web8/tmp -d session.save_path=/var/www/clients/client1/web8/tmp
web8     11100  2.7  1.7 270768 71700 ?        S    02:12   0:04  |   \_ /usr/bin/php-cgi -d open_basedir=/var/www/clients/client1/web8/web:/var/www/clients/client1/web8/tmp:/var/www/inter5.org/web:/srv/www/inter5.org/web:/usr/share/php5:/tmp:/usr/share/phpmyadmin -d upload_tmp_dir=/var/www/clients/client1/web8/tmp -d session.save_path=/var/www/clients/client1/web8/tmp
web8     11101  7.3  1.7 270768 71704 ?        S    02:12   0:13  |   \_ /usr/bin/php-cgi -d open_basedir=/var/www/clients/client1/web8/web:/var/www/clients/client1/web8/tmp:/var/www/inter5.org/web:/srv/www/inter5.org/web:/usr/share/php5:/tmp:/usr/share/phpmyadmin -d upload_tmp_dir=/var/www/clients/client1/web8/tmp -d session.save_path=/var/www/clients/client1/web8/tmp
web8     11102  9.4  1.7 270784 71856 ?        R    02:12   0:16  |   \_ /usr/bin/php-cgi -d open_basedir=/var/www/clients/client1/web8/web:/var/www/clients/client1/web8/tmp:/var/www/inter5.org/web:/srv/www/inter5.org/web:/usr/share/php5:/tmp:/usr/share/phpmyadmin -d upload_tmp_dir=/var/www/clients/client1/web8/tmp -d session.save_path=/var/www/clients/client1/web8/tmp
web8     11104  2.7  1.7 270768 71700 ?        S    02:12   0:04  |   \_ /usr/bin/php-cgi -d open_basedir=/var/www/clients/client1/web8/web:/var/www/clients/client1/web8/tmp:/var/www/inter5.org/web:/srv/www/inter5.org/web:/usr/share/php5:/tmp:/usr/share/phpmyadmin -d upload_tmp_dir=/var/www/clients/client1/web8/tmp -d session.save_path=/var/www/clients/client1/web8/tmp
web8     11107  2.7  1.7 270508 71440 ?        S    02:12   0:04  |   \_ /usr/bin/php-cgi -d open_basedir=/var/www/clients/client1/web8/web:/var/www/clients/client1/web8/tmp:/var/www/inter5.org/web:/srv/www/inter5.org/web:/usr/share/php5:/tmp:/usr/share/phpmyadmin -d upload_tmp_dir=/var/www/clients/client1/web8/tmp -d session.save_path=/var/www/clients/client1/web8/tmp
web8     11113  7.0  1.7 270784 71856 ?        R    02:12   0:12  |   \_ /usr/bin/php-cgi -d open_basedir=/var/www/clients/client1/web8/web:/var/www/clients/client1/web8/tmp:/var/www/inter5.org/web:/srv/www/inter5.org/web:/usr/share/php5:/tmp:/usr/share/phpmyadmin -d upload_tmp_dir=/var/www/clients/client1/web8/tmp -d session.save_path=/var/www/clients/client1/web8/tmp
web8     11114  2.7  1.7 270768 71704 ?        S    02:12   0:04  |   \_ /usr/bin/php-cgi -d open_basedir=/var/www/clients/client1/web8/web:/var/www/clients/client1/web8/tmp:/var/www/inter5.org/web:/srv/www/inter5.org/web:/usr/share/php5:/tmp:/usr/share/phpmyadmin -d upload_tmp_dir=/var/www/clients/client1/web8/tmp -d session.save_path=/var/www/clients/client1/web8/tmp
web8     11115  7.0  1.7 270788 71860 ?        R    02:12   0:12  |   \_ /usr/bin/php-cgi -d open_basedir=/var/www/clients/client1/web8/web:/var/www/clients/client1/web8/tmp:/var/www/inter5.org/web:/srv/www/inter5.org/web:/usr/share/php5:/tmp:/usr/share/phpmyadmin -d upload_tmp_dir=/var/www/clients/client1/web8/tmp -d session.save_path=/var/www/clients/client1/web8/tmp
web8     11117  2.7  1.7 270768 71704 ?        S    02:12   0:04  |   \_ /usr/bin/php-cgi -d open_basedir=/var/www/clients/client1/web8/web:/var/www/clients/client1/web8/tmp:/var/www/inter5.org/web:/srv/www/inter5.org/web:/usr/share/php5:/tmp:/usr/share/phpmyadmin -d upload_tmp_dir=/var/www/clients/client1/web8/tmp -d session.save_path=/var/www/clients/client1/web8/tmp
web8     11127  2.7  1.7 271788 72724 ?        S    02:12   0:04  |   \_ /usr/bin/php-cgi -d open_basedir=/var/www/clients/client1/web8/web:/var/www/clients/client1/web8/tmp:/var/www/inter5.org/web:/srv/www/inter5.org/web:/usr/share/php5:/tmp:/usr/share/phpmyadmin -d upload_tmp_dir=/var/www/clients/client1/web8/tmp -d session.save_path=/var/www/clients/client1/web8/tmp
web8     11131  9.5  1.7 271812 72872 ?        R    02:12   0:16  |   \_ /usr/bin/php-cgi -d open_basedir=/var/www/clients/client1/web8/web:/var/www/clients/client1/web8/tmp:/var/www/inter5.org/web:/srv/www/inter5.org/web:/usr/share/php5:/tmp:/usr/share/phpmyadmin -d upload_tmp_dir=/var/www/clients/client1/web8/tmp -d session.save_path=/var/www/clients/client1/web8/tmp
web8     11135  9.7  1.7 270784 71856 ?        R    02:12   0:16  |   \_ /usr/bin/php-cgi -d open_basedir=/var/www/clients/client1/web8/web:/var/www/clients/client1/web8/tmp:/var/www/inter5.org/web:/srv/www/inter5.org/web:/usr/share/php5:/tmp:/usr/share/phpmyadmin -d upload_tmp_dir=/var/www/clients/client1/web8/tmp -d session.save_path=/var/www/clients/client1/web8/tmp
web8     11136  2.8  1.7 271788 72720 ?        S    02:12   0:04  |   \_ /usr/bin/php-cgi -d open_basedir=/var/www/clients/client1/web8/web:/var/www/clients/client1/web8/tmp:/var/www/inter5.org/web:/srv/www/inter5.org/web:/usr/share/php5:/tmp:/usr/share/phpmyadmin -d upload_tmp_dir=/var/www/clients/client1/web8/tmp -d session.save_path=/var/www/clients/client1/web8/tmp
web8     11140 16.7  1.7 272052 72744 ?        R    02:12   0:27  |   \_ /usr/bin/php-cgi -d open_basedir=/var/www/clients/client1/web8/web:/var/www/clients/client1/web8/tmp:/var/www/inter5.org/web:/srv/www/inter5.org/web:/usr/share/php5:/tmp:/usr/share/phpmyadmin -d upload_tmp_dir=/var/www/clients/client1/web8/tmp -d session.save_path=/var/www/clients/client1/web8/tmp
web8     11196 11.8  2.0 278700 81592 ?        R    02:13   0:07  |   \_ /usr/bin/php-cgi -d open_basedir=/var/www/clients/client1/web8/web:/var/www/clients/client1/web8/tmp:/var/www/inter5.org/web:/srv/www/inter5.org/web:/usr/share/php5:/tmp:/usr/share/phpmyadmin -d upload_tmp_dir=/var/www/clients/client1/web8/tmp -d session.save_path=/var/www/clients/client1/web8/tmp
web8     11197  7.6  1.9 277536 80000 ?        S    02:13   0:04  |   \_ /usr/bin/php-cgi -d open_basedir=/var/www/clients/client1/web8/web:/var/www/clients/client1/web8/tmp:/var/www/inter5.org/web:/srv/www/inter5.org/web:/usr/share/php5:/tmp:/usr/share/phpmyadmin -d upload_tmp_dir=/var/www/clients/client1/web8/tmp -d session.save_path=/var/www/clients/client1/web8/tmp
web8     11229  8.5  1.7 268700 71488 ?        S    02:14   0:04  |   \_ /usr/bin/php-cgi -d open_basedir=/var/www/clients/client1/web8/web:/var/www/clients/client1/web8/tmp:/var/www/inter5.org/web:/srv/www/inter5.org/web:/usr/share/php5:/tmp:/usr/share/phpmyadmin -d upload_tmp_dir=/var/www/clients/client1/web8/tmp -d session.save_path=/var/www/clients/client1/web8/tmp
web8     11230  6.9  1.9 277536 79992 ?        S    02:14   0:03  |   \_ /usr/bin/php-cgi -d open_basedir=/var/www/clients/client1/web8/web:/var/www/clients/client1/web8/tmp:/var/www/inter5.org/web:/srv/www/inter5.org/web:/usr/share/php5:/tmp:/usr/share/phpmyadmin -d upload_tmp_dir=/var/www/clients/client1/web8/tmp -d session.save_path=/var/www/clients/client1/web8/tmp
web8     11233 10.3  1.9 277536 79992 ?        S    02:14   0:03  |   \_ /usr/bin/php-cgi -d open_basedir=/var/www/clients/client1/web8/web:/var/www/clients/client1/web8/tmp:/var/www/inter5.org/web:/srv/www/inter5.org/web:/usr/share/php5:/tmp:/usr/share/phpmyadmin -d upload_tmp_dir=/var/www/clients/client1/web8/tmp -d session.save_path=/var/www/clients/client1/web8/tmp
web8     11235 10.1  2.2 291396 93392 ?        R    02:14   0:03  |   \_ /usr/bin/php-cgi -d open_basedir=/var/www/clients/client1/web8/web:/var/www/clients/client1/web8/tmp:/var/www/inter5.org/web:/srv/www/inter5.org/web:/usr/share/php5:/tmp:/usr/share/phpmyadmin -d upload_tmp_dir=/var/www/clients/client1/web8/tmp -d session.save_path=/var/www/clients/client1/web8/tmp
web8     11238 10.2  2.2 291136 93236 ?        R    02:14   0:03  |   \_ /usr/bin/php-cgi -d open_basedir=/var/www/clients/client1/web8/web:/var/www/clients/client1/web8/tmp:/var/www/inter5.org/web:/srv/www/inter5.org/web:/usr/share/php5:/tmp:/usr/share/phpmyadmin -d upload_tmp_dir=/var/www/clients/client1/web8/tmp -d session.save_path=/var/www/clients/client1/web8/tmp
web8     11239 10.2  2.2 291396 93404 ?        R    02:14   0:03  |   \_ /usr/bin/php-cgi -d open_basedir=/var/www/clients/client1/web8/web:/var/www/clients/client1/web8/tmp:/var/www/inter5.org/web:/srv/www/inter5.org/web:/usr/share/php5:/tmp:/usr/share/phpmyadmin -d upload_tmp_dir=/var/www/clients/client1/web8/tmp -d session.save_path=/var/www/clients/client1/web8/tmp
web8     11245 10.3  2.2 290116 92072 ?        R    02:14   0:02  |   \_ /usr/bin/php-cgi -d open_basedir=/var/www/clients/client1/web8/web:/var/www/clients/client1/web8/tmp:/var/www/inter5.org/web:/srv/www/inter5.org/web:/usr/share/php5:/tmp:/usr/share/phpmyadmin -d upload_tmp_dir=/var/www/clients/client1/web8/tmp -d session.save_path=/var/www/clients/client1/web8/tmp
www-data  4720  0.0  0.3 332504 12616 ?        S    01:07   0:02  \_ /usr/sbin/apache2 -k start
www-data  4819  0.0  0.3 332124 12364 ?        S    01:09   0:00  \_ /usr/sbin/apache2 -k start
www-data  8331  0.0  0.3 332124 12356 ?        S    01:44   0:01  \_ /usr/sbin/apache2 -k start
www-data  9698  0.0  0.3 332504 12508 ?        S    01:58   0:00  \_ /usr/sbin/apache2 -k start
www-data  9699  0.0  0.3 332116 12288 ?        S    01:58   0:00  \_ /usr/sbin/apache2 -k start
www-data  9700  0.0  0.3 332508 12524 ?        S    01:58   0:00  \_ /usr/sbin/apache2 -k start
www-data 10166  0.0  0.3 332368 12552 ?        S    02:03   0:00  \_ /usr/sbin/apache2 -k start
www-data 10568  0.0  0.3 332116 12280 ?        S    02:06   0:00  \_ /usr/sbin/apache2 -k start
www-data 11093  0.0  0.2 332060 11992 ?        S    02:12   0:00  \_ /usr/sbin/apache2 -k start
www-data 11108  0.0  0.3 332116 12280 ?        S    02:12   0:00  \_ /usr/sbin/apache2 -k start
www-data 11122  0.0  0.2 331788 11780 ?        S    02:12   0:00  \_ /usr/sbin/apache2 -k start
www-data 11123  0.0  0.3 332368 12504 ?        S    02:12   0:00  \_ /usr/sbin/apache2 -k start
www-data 11169  0.0  0.3 332104 12252 ?        S    02:13   0:00  \_ /usr/sbin/apache2 -k start
www-data 11170  0.0  0.2 331788 11656 ?        S    02:13   0:00  \_ /usr/sbin/apache2 -k start
www-data 11171  0.0  0.3 332388 12504 ?        S    02:13   0:00  \_ /usr/sbin/apache2 -k start
www-data 11174  0.0  0.2 332056 12000 ?        S    02:13   0:00  \_ /usr/sbin/apache2 -k start
www-data 11175  0.0  0.2 332056 12000 ?        S    02:13   0:00  \_ /usr/sbin/apache2 -k start
www-data 11176  0.0  0.2 332064 11992 ?        S    02:13   0:00  \_ /usr/sbin/apache2 -k start
www-data 11177  0.0  0.2 331788 11656 ?        S    02:13   0:00  \_ /usr/sbin/apache2 -k start
www-data 11184  0.0  0.2 331788 11656 ?        S    02:13   0:00  \_ /usr/sbin/apache2 -k start
www-data 11187  0.0  0.2 332056 12016 ?        S    02:13   0:00  \_ /usr/sbin/apache2 -k start
www-data 11188  0.0  0.2 332060 12012 ?        S    02:13   0:00  \_ /usr/sbin/apache2 -k start
www-data 11190  0.0  0.2 332056 11984 ?        S    02:13   0:00  \_ /usr/sbin/apache2 -k start
www-data 11191  0.0  0.2 332056 11992 ?        S    02:13   0:00  \_ /usr/sbin/apache2 -k start
www-data 11193  0.0  0.2 332056 11988 ?        S    02:13   0:00  \_ /usr/sbin/apache2 -k start
www-data 11194  0.0  0.3 332104 12252 ?        S    02:13   0:00  \_ /usr/sbin/apache2 -k start
www-data 11198  0.0  0.2 332064 11992 ?        S    02:13   0:00  \_ /usr/sbin/apache2 -k start
www-data 11200  0.0  0.3 332104 12256 ?        S    02:13   0:00  \_ /usr/sbin/apache2 -k start
www-data 11201  0.0  0.2 331920 11788 ?        S    02:13   0:00  \_ /usr/sbin/apache2 -k start
www-data 11202  0.0  0.3 332104 12256 ?        S    02:13   0:00  \_ /usr/sbin/apache2 -k start
www-data 11203  0.0  0.2 332056 11976 ?        S    02:13   0:00  \_ /usr/sbin/apache2 -k start
www-data 11204  0.0  0.2 331788 11820 ?        S    02:13   0:00  \_ /usr/sbin/apache2 -k start
www-data 11205  0.0  0.2 331924 11756 ?        S    02:13   0:00  \_ /usr/sbin/apache2 -k start
www-data 11234  0.0  0.2 332064 11964 ?        S    02:14   0:00  \_ /usr/sbin/apache2 -k start
www-data 11236  0.0  0.2 332064 11972 ?        S    02:14   0:00  \_ /usr/sbin/apache2 -k start
www-data 11237  0.0  0.2 331788 11664 ?        S    02:14   0:00  \_ /usr/sbin/apache2 -k start
www-data 11243  0.0  0.2 332056 11980 ?        S    02:14   0:00  \_ /usr/sbin/apache2 -k start
server has high load right now.
Time: Wed Oct 27 02:15:03 EDT 2010
Web8 is a Wordpress site and it gets 5000+ views a day...no clue on spidering, though I made a robots.txt a few weeks ago to rate limit.

I did edit the FastCgi settings on ISPC3 to have 1 max children.

All sites have the following custom PHP directive:
Code:
memory_limit = 84M
max_execution_time = 280
max_input_time = 30
upload_max_filesize = 5M
post_max_size = 20M
date.timezone = America/New_York
Everything was fine for about a week without any modifications to files. This spiking just now started happening again.


EDDDDDIT:
Load spiked again at 11:21am.

And, I changed the SQL settings around some.
max_connections = 200
table_cache = 650
long_query_time=5
query_cache_limit = 24M
query_cache_size = 150M
join_buffer_size=3M
max_heap_table_size=400M
tmp_table_size=400M
low_priority_updates=1
concurrent_insert=2
innodb_buffer_pool_size=64M
__________________
ISPC3 on Debian! It's great!

Last edited by crypted; 27th October 2010 at 21:22.
Reply With Quote
  #43  
Old 27th October 2010, 21:25
Turbanator Turbanator is offline
Senior Member
 
Join Date: Jun 2008
Posts: 220
Thanks: 23
Thanked 16 Times in 16 Posts
Default

I would leave it at 10 sec for now, but open up your slowquery log and look at those queries. Run them from mysql command line using the EXPLAIN command. It will provide you the output of some of those queries telling you how well the joins are and which subquery (if any) is causing the major delay. Again, this is still an assumption that disk tables are part of your issue.

key_buffer = 128M
max_connections = 500
max_user_connections = 500


are you using the innodb engine for anything?


wordpress and the php settings are beyond me...
Reply With Quote
  #44  
Old 27th October 2010, 21:30
Turbanator Turbanator is offline
Senior Member
 
Join Date: Jun 2008
Posts: 220
Thanks: 23
Thanked 16 Times in 16 Posts
Default

hve you checked your webalizer or awstats for traffic during those spike times? Maybe you're getting attacked...or maybe it's just googlebot!
Reply With Quote
  #45  
Old 27th October 2010, 21:34
crypted crypted is offline
Senior Member
 
Join Date: Dec 2006
Location: Oklahoma, USA
Posts: 429
Thanks: 3
Thanked 14 Times in 6 Posts
Default

No innodb to my knowledge. WP uses MYISAM. You can switch it over, but I'm fearful of that killing off DBs.

Made the switches you suggested. Originally, when log_query was down to 5 i was running constant >10 on the load. Went back to 10 and I'm at 2-3 load.

Well, originally Googlebot and others were hitting the site at 30x times a second. I created a robots.txt a few weeks ago and now it's down to about every 3 seconds there will be a hit or two from a spider. Googlebot is specifically limited to every 7 seconds.

So, nothing in the way of attacks.
__________________
ISPC3 on Debian! It's great!

Last edited by crypted; 27th October 2010 at 21:41.
Reply With Quote
  #46  
Old 27th October 2010, 21:39
Turbanator Turbanator is offline
Senior Member
 
Join Date: Jun 2008
Posts: 220
Thanks: 23
Thanked 16 Times in 16 Posts
Default

the log_slow_query is just telling mysql what querys to write to the log...only the ones that run over 5 sec (or 10 in your case). So if your load went up by doing that change, then it means you have a lot of slow querys and mysql is slowing down the system due to having to write to the log constantly.
Reply With Quote
  #47  
Old 27th October 2010, 21:49
crypted crypted is offline
Senior Member
 
Join Date: Dec 2006
Location: Oklahoma, USA
Posts: 429
Thanks: 3
Thanked 14 Times in 6 Posts
Default

Yeah the log isn't growing though, so odd enough I know.

Code:
top - 14:46:14 up 14 days, 16:23,  5 users,  load average: 6.63, 2.91, 2.28
Tasks: 223 total,  13 running, 209 sleeping,   0 stopped,   1 zombie
Cpu(s): 93.2%us,  6.6%sy,  0.0%ni,  0.0%id,  0.0%wa,  0.0%hi,  0.2%si,  0.0%st
Mem:   4063804k total,  3090744k used,   973060k free,    83660k buffers
Swap:  1951856k total,   239788k used,  1712068k free,  1339448k cached

  PID USER      PR  NI  VIRT  RES  SHR S %CPU %MEM    TIME+  COMMAND                                                                
18971 web8      20   0  245m  88m  39m R   17  2.2   0:03.14 php-cgi                                                                
14991 web8      20   0  237m  78m  39m R   17  2.0   2:51.51 php-cgi                                                                
18961 web8      20   0  247m  89m  39m R   17  2.3   0:04.26 php-cgi                                                                
18968 web8      20   0  247m  89m  39m R   17  2.3   0:03.80 php-cgi                                                                
14977 web8      20   0  234m  75m  39m R   16  1.9   1:22.30 php-cgi                                                                
17130 web8      20   0  236m  78m  40m R   16  2.0   1:01.92 php-cgi                                                                
17045 web8      20   0  236m  78m  40m R   15  2.0   1:14.84 php-cgi                                                                
17046 web8      20   0  240m  78m  40m R   15  2.0   1:53.43 php-cgi                                                                
18954 web8      20   0  247m  90m  39m R   15  2.3   0:04.60 php-cgi                                                                
18964 web8      20   0  246m  89m  39m R   15  2.2   0:03.76 php-cgi                                                                
17136 web8      20   0  236m  78m  40m S   14  2.0   0:49.89 php-cgi                                                                
16479 mysql     20   0  541m  95m 5772 S   10  2.4   1:50.68 mysqld                                                                 
 9414 web5      20   0  230m  72m  39m R   10  1.8   0:32.24 php-cgi                                                                
 3781 root      20   0 57612 8212 1076 S    3  0.2 108:24.30 collectl                                                               
18950 www-data  20   0     0    0    0 Z    1  0.0   0:00.02 apache2 <defunct>                                                      
18972 www-data  20   0  290m  12m 2244 S    1  0.3   0:00.02 apache2                                                                
    1 root      20   0 10316   84   56 S    0  0.0   0:11.66 init                                                                   
    2 root      15  -5     0    0    0 S    0  0.0   0:00.00 kthreadd                                                               
    3 root      RT  -5     0    0    0 S    0  0.0   0:02.44 migration/0
__________________
ISPC3 on Debian! It's great!
Reply With Quote
  #48  
Old 27th October 2010, 22:22
Turbanator Turbanator is offline
Senior Member
 
Join Date: Jun 2008
Posts: 220
Thanks: 23
Thanked 16 Times in 16 Posts
Default

I'm sory I'm not much more help. My thought process is saying mysql is your issue with php-cgi using a lot of cpu power waiting on mysql to return data.

After you've made the changes I suggested including key_buffer = 128M and max_connections= 500, what has your mydns log show?

Are you still having mysql connect issue in mydns and mail error?

for your mysqllogs, create the files yourself and give permissions it should then be writing to the logs correctly.

and lastly, after restarting mysql, I would wait for the next spike and then analyze your access logs to see if it's a traffic spike or resource issue...or something.

Is it a single 500G HD running the whole system. I would think that it would be a constant hit if it were a disk write issue vs spikes though.
Reply With Quote
  #49  
Old 27th October 2010, 22:55
crypted crypted is offline
Senior Member
 
Join Date: Dec 2006
Location: Oklahoma, USA
Posts: 429
Thanks: 3
Thanked 14 Times in 6 Posts
Default

Just for the heck of it, today's mysql-slow.log is around 2MB. A clear majority of the log is full of ISPCONFIG related SQL queries. But, here's a snippet from the bottom:

Code:
# User@Host: ispconfig[ispconfig] @ localhost []
# Query_time: 0  Lock_time: 0  Rows_sent: 0  Rows_examined: 0
DELETE FROM monitor_data WHERE type ='server_load' AND created < 1288208162;
# User@Host: ispconfig[ispconfig] @ localhost []
# Query_time: 0  Lock_time: 0  Rows_sent: 0  Rows_examined: 0
DELETE FROM monitor_data WHERE type ='os_info' AND created < 1288208162;
# User@Host: ispconfig[ispconfig] @ localhost []
# Query_time: 0  Lock_time: 0  Rows_sent: 0  Rows_examined: 0
DELETE FROM monitor_data WHERE type ='ispc_info' AND created < 1288208162;
# User@Host: ispconfig[ispconfig] @ localhost []
# Query_time: 0  Lock_time: 0  Rows_sent: 0  Rows_examined: 0
DELETE FROM monitor_data WHERE type ='disk_usage' AND created < 1288208162;
# User@Host: ispconfig[ispconfig] @ localhost []
# Query_time: 0  Lock_time: 0  Rows_sent: 0  Rows_examined: 0
DELETE FROM monitor_data WHERE type ='mem_usage' AND created < 1288208162;
# User@Host: ispconfig[ispconfig] @ localhost []
# Query_time: 0  Lock_time: 0  Rows_sent: 0  Rows_examined: 0
DELETE FROM monitor_data WHERE type ='cpu_info' AND created < 1288208162;
# User@Host: ispconfig[ispconfig] @ localhost []
# Query_time: 0  Lock_time: 0  Rows_sent: 0  Rows_examined: 0
DELETE FROM monitor_data WHERE type ='services' AND created < 1288208162;
# User@Host: ispconfig[ispconfig] @ localhost []
# Query_time: 0  Lock_time: 0  Rows_sent: 0  Rows_examined: 0
DELETE FROM monitor_data WHERE type ='openvz_veinfo' AND created < 1288208162;
# User@Host: ispconfig[ispconfig] @ localhost []
# Query_time: 0  Lock_time: 0  Rows_sent: 0  Rows_examined: 0
DELETE FROM monitor_data WHERE type ='openvz_beancounter' AND created < 1288208162;
# User@Host: ispconfig[ispconfig] @ localhost []
# Query_time: 0  Lock_time: 0  Rows_sent: 0  Rows_examined: 0
DELETE FROM monitor_data WHERE type ='log_mail' AND created < 1288208162;
# User@Host: ispconfig[ispconfig] @ localhost []
# Query_time: 0  Lock_time: 0  Rows_sent: 0  Rows_examined: 0
DELETE FROM monitor_data WHERE type ='log_mail_warn' AND created < 1288208162;
# User@Host: ispconfig[ispconfig] @ localhost []
# Query_time: 0  Lock_time: 0  Rows_sent: 0  Rows_examined: 0
DELETE FROM monitor_data WHERE type ='log_mail_err' AND created < 1288208162;
# User@Host: ispconfig[ispconfig] @ localhost []
# Query_time: 0  Lock_time: 0  Rows_sent: 0  Rows_examined: 0
DELETE FROM monitor_data WHERE type ='log_messages' AND created < 1288208162;
# User@Host: ispconfig[ispconfig] @ localhost []
# Query_time: 0  Lock_time: 0  Rows_sent: 0  Rows_examined: 0
DELETE FROM monitor_data WHERE type ='log_ispc_cron' AND created < 1288208162;
# User@Host: ispconfig[ispconfig] @ localhost []
# Query_time: 0  Lock_time: 0  Rows_sent: 0  Rows_examined: 0
DELETE FROM monitor_data WHERE type ='log_freshclam' AND created < 1288208162;
# User@Host: ispconfig[ispconfig] @ localhost []
# Query_time: 0  Lock_time: 0  Rows_sent: 0  Rows_examined: 0
DELETE FROM monitor_data WHERE type ='log_clamav' AND created < 1288208162;
# User@Host: ispconfig[ispconfig] @ localhost []
# Query_time: 0  Lock_time: 0  Rows_sent: 0  Rows_examined: 0
DELETE FROM monitor_data WHERE type ='log_ispconfig' AND created < 1288208162;
# User@Host: ispconfig[ispconfig] @ localhost []
# Query_time: 0  Lock_time: 0  Rows_sent: 0  Rows_examined: 0
DELETE FROM monitor_data WHERE type ='mailq' AND created < 1288208162;
# User@Host: ispconfig[ispconfig] @ localhost []
# Query_time: 0  Lock_time: 0  Rows_sent: 0  Rows_examined: 0
DELETE FROM monitor_data WHERE type ='raid_state' AND created < 1288208162;
# User@Host: ispconfig[ispconfig] @ localhost []
# Query_time: 0  Lock_time: 0  Rows_sent: 0  Rows_examined: 0
DELETE FROM monitor_data WHERE type ='log_fail2ban' AND created < 1288208162;
# User@Host: ispconfig[ispconfig] @ localhost []
# Query_time: 0  Lock_time: 0  Rows_sent: 0  Rows_examined: 0
DELETE FROM monitor_data WHERE type ='sys_log' AND created < 1288208162;
# Time: 101027 15:42:05
# User@Host: c1areyouliberal[c1areyouliberal] @ localhost []
# Query_time: 0  Lock_time: 0  Rows_sent: 422  Rows_examined: 632
use c1areyouliberal;
SELECT option_name, option_value FROM wp_options WHERE autoload = 'yes';
# Time: 101027 15:42:56
# User@Host: ispconfig[ispconfig] @ localhost [127.0.0.1]
# Query_time: 0  Lock_time: 0  Rows_sent: 0  Rows_examined: 38
use dbispconfig;
SELECT access FROM mail_access WHERE source='125.166.191.119' and type = 'client' and active = 'y';
# User@Host: ispconfig[ispconfig] @ localhost [127.0.0.1]
# Query_time: 0  Lock_time: 0  Rows_sent: 0  Rows_examined: 38
SELECT access FROM mail_access WHERE source='125.166.191' and type = 'client' and active = 'y';
# User@Host: ispconfig[ispconfig] @ localhost [127.0.0.1]
# Query_time: 0  Lock_time: 0  Rows_sent: 0  Rows_examined: 38
SELECT access FROM mail_access WHERE source='125.166' and type = 'client' and active = 'y';
# User@Host: ispconfig[ispconfig] @ localhost [127.0.0.1]
# Query_time: 0  Lock_time: 0  Rows_sent: 0  Rows_examined: 38
SELECT access FROM mail_access WHERE source='125' and type = 'client' and active = 'y';
# Time: 101027 15:43:19
# User@Host: c1areyouliberal[c1areyouliberal] @ localhost []
# Query_time: 0  Lock_time: 0  Rows_sent: 422  Rows_examined: 632
use c1areyouliberal;
SELECT option_name, option_value FROM wp_options WHERE autoload = 'yes';
# Time: 101027 15:43:30
# User@Host: c1inter5[c1inter5] @ localhost []
# Query_time: 0  Lock_time: 0  Rows_sent: 339  Rows_examined: 513
use c1inter5;
SELECT option_name, option_value FROM wp_options WHERE autoload = 'yes';
# Time: 101027 15:43:38
# User@Host: c1areyouliberal[c1areyouliberal] @ localhost []
# Query_time: 0  Lock_time: 0  Rows_sent: 422  Rows_examined: 632
use c1areyouliberal;
SELECT option_name, option_value FROM wp_options WHERE autoload = 'yes';
# Time: 101027 15:44:45
# User@Host: c1inter5[c1inter5] @ localhost []
# Query_time: 0  Lock_time: 0  Rows_sent: 339  Rows_examined: 513
use c1inter5;
SELECT option_name, option_value FROM wp_options WHERE autoload = 'yes';
# Time: 101027 15:45:02
# User@Host: ispconfig[ispconfig] @ localhost []
# Query_time: 0  Lock_time: 0  Rows_sent: 0  Rows_examined: 0
use dbispconfig;
DELETE FROM monitor_data WHERE type ='harddisk_quota' AND created < 1288208462;
# User@Host: ispconfig[ispconfig] @ localhost []
# Query_time: 0  Lock_time: 0  Rows_sent: 0  Rows_examined: 0
DELETE FROM monitor_data WHERE type ='server_load' AND created < 1288208462;
# User@Host: ispconfig[ispconfig] @ localhost []
# Query_time: 0  Lock_time: 0  Rows_sent: 0  Rows_examined: 0
DELETE FROM monitor_data WHERE type ='os_info' AND created < 1288208462;
# User@Host: ispconfig[ispconfig] @ localhost []
# Query_time: 0  Lock_time: 0  Rows_sent: 0  Rows_examined: 0
DELETE FROM monitor_data WHERE type ='ispc_info' AND created < 1288208462;
# User@Host: ispconfig[ispconfig] @ localhost []
# Query_time: 0  Lock_time: 0  Rows_sent: 0  Rows_examined: 0
DELETE FROM monitor_data WHERE type ='disk_usage' AND created < 1288208462;
# User@Host: ispconfig[ispconfig] @ localhost []
# Query_time: 0  Lock_time: 0  Rows_sent: 0  Rows_examined: 0
DELETE FROM monitor_data WHERE type ='mem_usage' AND created < 1288208462;
# User@Host: ispconfig[ispconfig] @ localhost []
# Query_time: 0  Lock_time: 0  Rows_sent: 0  Rows_examined: 0
DELETE FROM monitor_data WHERE type ='cpu_info' AND created < 1288208462;
# User@Host: ispconfig[ispconfig] @ localhost []
# Query_time: 0  Lock_time: 0  Rows_sent: 0  Rows_examined: 0
DELETE FROM monitor_data WHERE type ='services' AND created < 1288208462;
# User@Host: ispconfig[ispconfig] @ localhost []
# Query_time: 0  Lock_time: 0  Rows_sent: 0  Rows_examined: 0
DELETE FROM monitor_data WHERE type ='openvz_veinfo' AND created < 1288208462;
# User@Host: ispconfig[ispconfig] @ localhost []
# Query_time: 0  Lock_time: 0  Rows_sent: 0  Rows_examined: 0
DELETE FROM monitor_data WHERE type ='openvz_beancounter' AND created < 1288208462;
# User@Host: ispconfig[ispconfig] @ localhost []
# Query_time: 0  Lock_time: 0  Rows_sent: 0  Rows_examined: 0
DELETE FROM monitor_data WHERE type ='log_mail' AND created < 1288208462;
# User@Host: ispconfig[ispconfig] @ localhost []
# Query_time: 0  Lock_time: 0  Rows_sent: 0  Rows_examined: 0
DELETE FROM monitor_data WHERE type ='log_mail_warn' AND created < 1288208462;
# User@Host: ispconfig[ispconfig] @ localhost []
# Query_time: 0  Lock_time: 0  Rows_sent: 0  Rows_examined: 0
DELETE FROM monitor_data WHERE type ='log_mail_err' AND created < 1288208462;
# User@Host: ispconfig[ispconfig] @ localhost []
# Query_time: 0  Lock_time: 0  Rows_sent: 0  Rows_examined: 0
DELETE FROM monitor_data WHERE type ='log_messages' AND created < 1288208462;
# User@Host: ispconfig[ispconfig] @ localhost []
# Query_time: 0  Lock_time: 0  Rows_sent: 0  Rows_examined: 0
DELETE FROM monitor_data WHERE type ='log_ispc_cron' AND created < 1288208462;
# User@Host: ispconfig[ispconfig] @ localhost []
# Query_time: 0  Lock_time: 0  Rows_sent: 0  Rows_examined: 0
DELETE FROM monitor_data WHERE type ='log_freshclam' AND created < 1288208462;
# User@Host: ispconfig[ispconfig] @ localhost []
# Query_time: 0  Lock_time: 0  Rows_sent: 0  Rows_examined: 0
DELETE FROM monitor_data WHERE type ='log_clamav' AND created < 1288208462;
# User@Host: ispconfig[ispconfig] @ localhost []
# Query_time: 0  Lock_time: 0  Rows_sent: 0  Rows_examined: 0
DELETE FROM monitor_data WHERE type ='log_ispconfig' AND created < 1288208462;
# User@Host: ispconfig[ispconfig] @ localhost []
# Query_time: 0  Lock_time: 0  Rows_sent: 0  Rows_examined: 0
DELETE FROM monitor_data WHERE type ='mailq' AND created < 1288208462;
# User@Host: ispconfig[ispconfig] @ localhost []
# Query_time: 0  Lock_time: 0  Rows_sent: 0  Rows_examined: 0
DELETE FROM monitor_data WHERE type ='raid_state' AND created < 1288208462;
# User@Host: ispconfig[ispconfig] @ localhost []
# Query_time: 0  Lock_time: 0  Rows_sent: 0  Rows_examined: 0
DELETE FROM monitor_data WHERE type ='log_fail2ban' AND created < 1288208462;
# User@Host: ispconfig[ispconfig] @ localhost []
# Query_time: 0  Lock_time: 0  Rows_sent: 0  Rows_examined: 0
DELETE FROM monitor_data WHERE type ='sys_log' AND created < 1288208462;
# Time: 101027 15:45:08
# User@Host: ispconfig[ispconfig] @ localhost [127.0.0.1]
# Query_time: 0  Lock_time: 0  Rows_sent: 0  Rows_examined: 38
SELECT access FROM mail_access WHERE source='77.126.177.9' and type = 'client' and active = 'y';
# User@Host: ispconfig[ispconfig] @ localhost [127.0.0.1]
# Query_time: 0  Lock_time: 0  Rows_sent: 0  Rows_examined: 38
SELECT access FROM mail_access WHERE source='77.126.177' and type = 'client' and active = 'y';
# User@Host: ispconfig[ispconfig] @ localhost [127.0.0.1]
# Query_time: 0  Lock_time: 0  Rows_sent: 0  Rows_examined: 38
SELECT access FROM mail_access WHERE source='77.126' and type = 'client' and active = 'y';
# User@Host: ispconfig[ispconfig] @ localhost [127.0.0.1]
# Query_time: 0  Lock_time: 0  Rows_sent: 0  Rows_examined: 38
SELECT access FROM mail_access WHERE source='77' and type = 'client' and active = 'y';
# Time: 101027 15:45:16
# User@Host: ispconfig[ispconfig] @ localhost [127.0.0.1]
# Query_time: 0  Lock_time: 0  Rows_sent: 0  Rows_examined: 38
SELECT access FROM mail_access WHERE source='athedsl-362929.home.otenet.gr' and type = 'client' and active = 'y';
# User@Host: ispconfig[ispconfig] @ localhost [127.0.0.1]
# Query_time: 0  Lock_time: 0  Rows_sent: 0  Rows_examined: 38
SELECT access FROM mail_access WHERE source='87.202.145.114' and type = 'client' and active = 'y';
# User@Host: ispconfig[ispconfig] @ localhost [127.0.0.1]
# Query_time: 0  Lock_time: 0  Rows_sent: 0  Rows_examined: 38
SELECT access FROM mail_access WHERE source='87.202.145' and type = 'client' and active = 'y';
# User@Host: ispconfig[ispconfig] @ localhost [127.0.0.1]
# Query_time: 0  Lock_time: 0  Rows_sent: 0  Rows_examined: 38
SELECT access FROM mail_access WHERE source='87.202' and type = 'client' and active = 'y';
# Time: 101027 15:45:22
# User@Host: c1inter5[c1inter5] @ localhost []
# Query_time: 0  Lock_time: 0  Rows_sent: 339  Rows_examined: 513
use c1inter5;
SELECT option_name, option_value FROM wp_options WHERE autoload = 'yes';
# Time: 101027 15:45:51
# User@Host: c1dgcom[c1dgcom] @ localhost []
# Query_time: 0  Lock_time: 0  Rows_sent: 0  Rows_examined: 0
use c1dgcom;
DELETE FROM wp_statpress WHERE date < '20100427';
# Time: 101027 15:45:52
# User@Host: c1dgcom[c1dgcom] @ localhost []
# Query_time: 0  Lock_time: 0  Rows_sent: 286  Rows_examined: 327
SELECT option_name, option_value FROM wp_options WHERE autoload = 'yes';
# Time: 101027 15:45:53
# User@Host: c1dgcom[c1dgcom] @ localhost []
# Query_time: 1  Lock_time: 0  Rows_sent: 0  Rows_examined: 0
DELETE FROM wp_statpress WHERE date < '20100427';
# Time: 101027 15:45:54
# User@Host: c1dgcom[c1dgcom] @ localhost []
# Query_time: 1  Lock_time: 0  Rows_sent: 0  Rows_examined: 0
DELETE FROM wp_statpress WHERE date < '20100427';
# Time: 101027 15:46:14
# User@Host: c1sebastianlodgu[c1sebastianlodgu] @ localhost []
# Query_time: 0  Lock_time: 0  Rows_sent: 0  Rows_examined: 0
use c1sebastianlodge;
DELETE FROM wp_statpress WHERE date < '20100727';
# Time: 101027 15:46:56
# User@Host: c1areyouliberal[c1areyouliberal] @ localhost []
# Query_time: 0  Lock_time: 0  Rows_sent: 422  Rows_examined: 632
use c1areyouliberal;
SELECT option_name, option_value FROM wp_options WHERE autoload = 'yes';
# Time: 101027 15:47:30
# User@Host: root[root] @ localhost []
# Query_time: 0  Lock_time: 0  Rows_sent: 1  Rows_examined: 403
/*!50000 SELECT IFNULL(SUM(INDEX_LENGTH),0) from information_schema.TABLES where ENGINE='InnoDB' */;
# User@Host: root[root] @ localhost []
# Query_time: 0  Lock_time: 0  Rows_sent: 1  Rows_examined: 403
/*!50000 SELECT IFNULL(SUM(DATA_LENGTH),0) from information_schema.TABLES where ENGINE='InnoDB' */;
# Time: 101027 15:47:31
# User@Host: root[root] @ localhost []
# Query_time: 0  Lock_time: 0  Rows_sent: 1  Rows_examined: 403
/*!50000 SELECT IFNULL(SUM(INDEX_LENGTH),0) from information_schema.TABLES where ENGINE='MyISAM' */;
# Time: 101027 15:47:32
# User@Host: root[root] @ localhost []
# Query_time: 0  Lock_time: 0  Rows_sent: 1  Rows_examined: 403
/*!50000 SELECT COUNT(*) FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_TYPE='BASE TABLE' */;
# Time: 101027 15:47:37
# User@Host: root[root] @ localhost []
# Query_time: 0  Lock_time: 0  Rows_sent: 3  Rows_examined: 375
SELECT ENGINE,SUM(DATA_LENGTH),COUNT(ENGINE) FROM information_schema.TABLES WHERE TABLE_SCHEMA NOT IN ('information_schema','mysql') AND ENGINE IS NOT NULL GROUP BY ENGINE ORDER BY ENGINE ASC;
# User@Host: root[root] @ localhost []
# Query_time: 0  Lock_time: 0  Rows_sent: 1  Rows_examined: 369
SELECT COUNT(TABLE_NAME) FROM information_schema.TABLES WHERE TABLE_SCHEMA NOT IN ('information_schema','mysql') AND Data_free > 0 AND NOT ENGINE='MEMORY';
# User@Host: root[root] @ localhost []
# Query_time: 0  Lock_time: 0  Rows_sent: 1  Rows_examined: 386
SELECT IFNULL(SUM(INDEX_LENGTH),0) FROM information_schema.TABLES WHERE TABLE_SCHEMA NOT IN ('information_schema') AND ENGINE = 'MyISAM';
# Time: 101027 15:47:50
# User@Host: c1mediawiki[c1mediawiki] @ localhost []
# Query_time: 0  Lock_time: 0  Rows_sent: 0  Rows_examined: 0
use c1mediawiki;
UPDATE /* SiteStatsUpdate::doUpdate 67.195.111.161 */ `site_stats` SET ss_total_views=ss_total_views+1;
# Time: 101027 15:48:01
# User@Host: ispconfig[ispconfig] @ localhost [127.0.0.1]
# Query_time: 0  Lock_time: 0  Rows_sent: 0  Rows_examined: 38
use dbispconfig;
SELECT access FROM mail_access WHERE source='athedsl-229737.home.otenet.gr' and type = 'client' and active = 'y';
# User@Host: ispconfig[ispconfig] @ localhost [127.0.0.1]
# Query_time: 0  Lock_time: 0  Rows_sent: 0  Rows_examined: 38
SELECT access FROM mail_access WHERE source='85.74.217.7' and type = 'client' and active = 'y';
# User@Host: ispconfig[ispconfig] @ localhost [127.0.0.1]
# Query_time: 0  Lock_time: 0  Rows_sent: 0  Rows_examined: 38
SELECT access FROM mail_access WHERE source='85.74.217' and type = 'client' and active = 'y';
# User@Host: ispconfig[ispconfig] @ localhost [127.0.0.1]
# Query_time: 0  Lock_time: 0  Rows_sent: 0  Rows_examined: 38
SELECT access FROM mail_access WHERE source='85.74' and type = 'client' and active = 'y';
# User@Host: ispconfig[ispconfig] @ localhost [127.0.0.1]
# Query_time: 0  Lock_time: 0  Rows_sent: 0  Rows_examined: 38
SELECT access FROM mail_access WHERE source='85' and type = 'client' and active = 'y';
# Time: 101027 15:48:55
# User@Host: c1inter5[c1inter5] @ localhost []
# Query_time: 0  Lock_time: 0  Rows_sent: 339  Rows_examined: 513
use c1inter5;
SELECT option_name, option_value FROM wp_options WHERE autoload = 'yes';
# Time: 101027 15:49:33
# User@Host: c1dgcom[c1dgcom] @ localhost []
# Query_time: 1  Lock_time: 0  Rows_sent: 0  Rows_examined: 0
use c1dgcom;
DELETE FROM wp_statpress WHERE date < '20100427';
# Time: 101027 15:50:02
# User@Host: ispconfig[ispconfig] @ localhost []
# Query_time: 0  Lock_time: 0  Rows_sent: 0  Rows_examined: 0
use dbispconfig;
DELETE FROM monitor_data WHERE type ='harddisk_quota' AND created < 1288208762;
# User@Host: ispconfig[ispconfig] @ localhost []
# Query_time: 0  Lock_time: 0  Rows_sent: 0  Rows_examined: 0
DELETE FROM monitor_data WHERE type ='server_load' AND created < 1288208762;
# User@Host: ispconfig[ispconfig] @ localhost []
# Query_time: 0  Lock_time: 0  Rows_sent: 0  Rows_examined: 0
DELETE FROM monitor_data WHERE type ='os_info' AND created < 1288208762;
# User@Host: ispconfig[ispconfig] @ localhost []
# Query_time: 0  Lock_time: 0  Rows_sent: 0  Rows_examined: 0
DELETE FROM monitor_data WHERE type ='ispc_info' AND created < 1288208762;
# User@Host: ispconfig[ispconfig] @ localhost []
# Query_time: 0  Lock_time: 0  Rows_sent: 0  Rows_examined: 0
DELETE FROM monitor_data WHERE type ='disk_usage' AND created < 1288208762;
# User@Host: ispconfig[ispconfig] @ localhost []
# Query_time: 0  Lock_time: 0  Rows_sent: 0  Rows_examined: 0
DELETE FROM monitor_data WHERE type ='mem_usage' AND created < 1288208762;
# User@Host: ispconfig[ispconfig] @ localhost []
# Query_time: 0  Lock_time: 0  Rows_sent: 0  Rows_examined: 0
DELETE FROM monitor_data WHERE type ='cpu_info' AND created < 1288208762;
# User@Host: ispconfig[ispconfig] @ localhost []
# Query_time: 0  Lock_time: 0  Rows_sent: 0  Rows_examined: 0
DELETE FROM monitor_data WHERE type ='services' AND created < 1288208762;
# User@Host: ispconfig[ispconfig] @ localhost []
# Query_time: 0  Lock_time: 0  Rows_sent: 0  Rows_examined: 0
DELETE FROM monitor_data WHERE type ='openvz_veinfo' AND created < 1288208762;
# User@Host: ispconfig[ispconfig] @ localhost []
# Query_time: 0  Lock_time: 0  Rows_sent: 0  Rows_examined: 0
DELETE FROM monitor_data WHERE type ='openvz_beancounter' AND created < 1288208762;
# User@Host: ispconfig[ispconfig] @ localhost []
# Query_time: 0  Lock_time: 0  Rows_sent: 0  Rows_examined: 0
DELETE FROM monitor_data WHERE type ='log_mail' AND created < 1288208762;
# User@Host: ispconfig[ispconfig] @ localhost []
# Query_time: 0  Lock_time: 0  Rows_sent: 0  Rows_examined: 0
DELETE FROM monitor_data WHERE type ='log_mail_warn' AND created < 1288208762;
# User@Host: ispconfig[ispconfig] @ localhost []
# Query_time: 0  Lock_time: 0  Rows_sent: 0  Rows_examined: 0
DELETE FROM monitor_data WHERE type ='log_mail_err' AND created < 1288208762;
# User@Host: ispconfig[ispconfig] @ localhost []
# Query_time: 0  Lock_time: 0  Rows_sent: 0  Rows_examined: 0
DELETE FROM monitor_data WHERE type ='log_messages' AND created < 1288208762;
# User@Host: ispconfig[ispconfig] @ localhost []
# Query_time: 0  Lock_time: 0  Rows_sent: 0  Rows_examined: 0
DELETE FROM monitor_data WHERE type ='log_ispc_cron' AND created < 1288208762;
# User@Host: ispconfig[ispconfig] @ localhost []
# Query_time: 0  Lock_time: 0  Rows_sent: 0  Rows_examined: 0
DELETE FROM monitor_data WHERE type ='log_freshclam' AND created < 1288208762;
# User@Host: ispconfig[ispconfig] @ localhost []
# Query_time: 0  Lock_time: 0  Rows_sent: 0  Rows_examined: 0
DELETE FROM monitor_data WHERE type ='log_clamav' AND created < 1288208762;
# User@Host: ispconfig[ispconfig] @ localhost []
# Query_time: 0  Lock_time: 0  Rows_sent: 0  Rows_examined: 0
DELETE FROM monitor_data WHERE type ='log_ispconfig' AND created < 1288208762;
# User@Host: ispconfig[ispconfig] @ localhost []
# Query_time: 0  Lock_time: 0  Rows_sent: 0  Rows_examined: 0
DELETE FROM monitor_data WHERE type ='mailq' AND created < 1288208762;
# Time: 101027 15:50:03
# User@Host: ispconfig[ispconfig] @ localhost []
# Query_time: 0  Lock_time: 0  Rows_sent: 0  Rows_examined: 0
DELETE FROM monitor_data WHERE type ='raid_state' AND created < 1288208763;
# User@Host: ispconfig[ispconfig] @ localhost []
# Query_time: 0  Lock_time: 0  Rows_sent: 0  Rows_examined: 0
DELETE FROM monitor_data WHERE type ='log_fail2ban' AND created < 1288208763;
# User@Host: ispconfig[ispconfig] @ localhost []
# Query_time: 0  Lock_time: 0  Rows_sent: 0  Rows_examined: 0
DELETE FROM monitor_data WHERE type ='sys_log' AND created < 1288208763;
# Time: 101027 15:50:27
# User@Host: c1dgcom[c1dgcom] @ localhost []
# Query_time: 1  Lock_time: 0  Rows_sent: 0  Rows_examined: 0
use c1dgcom;
DELETE FROM wp_statpress WHERE date < '20100427';
Yeah it's a single HDD running the server with a slave HDD for backups.

I don't seem to be getting any errors from other daemons UNLESS the whole server goes ape from load/wait issues.
__________________
ISPC3 on Debian! It's great!

Last edited by crypted; 27th October 2010 at 22:58.
Reply With Quote
  #50  
Old 27th October 2010, 23:52
Turbanator Turbanator is offline
Senior Member
 
Join Date: Jun 2008
Posts: 220
Thanks: 23
Thanked 16 Times in 16 Posts
 
Default

these should be in your slow log though. these look like they would be in your normal query log....or maybe these are querys without indexes.
Reply With Quote
Reply

Bookmarks

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
problems with suexec gobokster Installation/Configuration 7 7th May 2009 14:33
Question about the hardware requirement for mysql cluster with load balancing??? johN5Five^ HOWTO-Related Questions 3 12th April 2007 18:06
Mandriva 10.2 Perfect Setup Install Problems... ctroyp Installation/Configuration 12 30th December 2005 17:04
Apache with MYSQL trouble mandarin14 Installation/Configuration 4 4th December 2005 21:18
MySQL 5.0 and Apache 2.0.xx Lil'Brudder General 2 11th November 2005 02:08


All times are GMT +2. The time now is 03:04.


Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2014, vBulletin Solutions, Inc.