27th October 2010, 06:39
|
|
Senior Member
|
|
Join Date: Dec 2006
Location: Oklahoma, USA
Posts: 429
Thanks: 3
Thanked 13 Times in 5 Posts
|
|
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!
|
27th October 2010, 14:52
|
|
Senior Member
|
|
Join Date: Dec 2006
Location: Oklahoma, USA
Posts: 429
Thanks: 3
Thanked 13 Times in 5 Posts
|
|
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 20:22.
|
27th October 2010, 20:25
|
|
Senior Member
|
|
Join Date: Jun 2008
Posts: 169
Thanks: 15
Thanked 9 Times in 9 Posts
|
|
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...
|
27th October 2010, 20:30
|
|
Senior Member
|
|
Join Date: Jun 2008
Posts: 169
Thanks: 15
Thanked 9 Times in 9 Posts
|
|
hve you checked your webalizer or awstats for traffic during those spike times? Maybe you're getting attacked...or maybe it's just googlebot!
|
27th October 2010, 20:34
|
|
Senior Member
|
|
Join Date: Dec 2006
Location: Oklahoma, USA
Posts: 429
Thanks: 3
Thanked 13 Times in 5 Posts
|
|
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 20:41.
|
27th October 2010, 20:39
|
|
Senior Member
|
|
Join Date: Jun 2008
Posts: 169
Thanks: 15
Thanked 9 Times in 9 Posts
|
|
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.
|
27th October 2010, 20:49
|
|
Senior Member
|
|
Join Date: Dec 2006
Location: Oklahoma, USA
Posts: 429
Thanks: 3
Thanked 13 Times in 5 Posts
|
|
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!
|
27th October 2010, 21:22
|
|
Senior Member
|
|
Join Date: Jun 2008
Posts: 169
Thanks: 15
Thanked 9 Times in 9 Posts
|
|
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.
|
27th October 2010, 21:55
|
|
Senior Member
|
|
Join Date: Dec 2006
Location: Oklahoma, USA
Posts: 429
Thanks: 3
Thanked 13 Times in 5 Posts
|
|
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 21:58.
|
27th October 2010, 22:52
|
|
Senior Member
|
|
Join Date: Jun 2008
Posts: 169
Thanks: 15
Thanked 9 Times in 9 Posts
|
|
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.
|
| Thread Tools |
|
|
| Display Modes |
 Linear Mode
|
Posting Rules
|
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
HTML code is Off
|
|
|
All times are GMT +2. The time now is 07:56.
|
|
English | 
Deutsch
Recent comments
1 day 8 hours ago
1 day 8 hours ago
1 day 13 hours ago
1 day 19 hours ago
1 day 20 hours ago
1 day 21 hours ago
2 days 2 hours ago
2 days 8 hours ago
2 days 12 hours ago
2 days 14 hours ago