PDA

View Full Version : Server Optimization Request

staticrebelle
Sun 29th Jun '08, 9:56pm
1. Dedicated Server

2. Processor: Dual Opteron 246
Memory: 4GB DDR Registered ECC
Hd1: 120GB 7200RPM SATA / 8MB Cache
Hd2: 120GB 7200RPM SATA / 8MB Cache
RemoteBackup: 50GB Remote Backup
OS: Linux - CentOS 4
ControlPanel: cPanel / Web Host Manager
(+Fantastico/XController)
Apache 2.2.9 (Unix)
PHP 5.2.6
MySQL 4.1.22-standard Planning to upgrade to latest 5.x.x branch via WHM

3. 3.6.10 PL2 Planning to upgrade to 3.7.2 at one AM tonight (low site usage hours)

4. I do not know

5. MySQL (to my knowledge) was compiled and installed via WHM/cPanel but it could have been via the yum package manager

6. top - 20:29:29 up 4 days, 14:53, 1 user, load average: 0.71, 0.65, 0.63
Tasks: 133 total, 3 running, 130 sleeping, 0 stopped, 0 zombie
Cpu(s): 22.0% us, 4.5% sy, 0.0% ni, 71.7% id, 1.5% wa, 0.0% hi, 0.3% si
Mem: 3703608k total, 3635612k used, 67996k free, 165692k buffers
Swap: 2040244k total, 108520k used, 1931724k free, 2671444k cached

PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND
20113 mysql 15 0 319m 190m 3872 S 20 5.3 956:18.49 mysqld
32631 nobody 15 0 134m 24m 18m S 10 0.7 0:08.58 httpd
32710 nobody 17 0 137m 28m 18m S 6 0.8 0:06.48 httpd
709 nobody 17 0 134m 23m 17m S 4 0.7 0:01.89 httpd
1497 nobody 15 0 133m 17m 11m S 2 0.5 0:00.21 httpd
1456 nobody 15 0 136m 17m 9700 S 1 0.5 0:00.07 httpd
338 nobody 16 0 134m 24m 18m S 1 0.7 0:04.52 httpd
708 nobody 15 0 133m 19m 14m S 1 0.6 0:02.10 httpd
32624 nobody 15 0 134m 25m 19m S 0 0.7 0:08.15 httpd
32634 nobody 15 0 134m 25m 19m S 0 0.7 0:07.13 httpd
32707 nobody 15 0 134m 26m 19m S 0 0.7 0:08.65 httpd
1 root 16 0 4756 456 424 S 0 0.0 0:04.38 init
2 root RT 0 0 0 0 S 0 0.0 0:00.58 migration/0
3 root 34 19 0 0 0 S 0 0.0 0:00.27 ksoftirqd/0
4 root RT 0 0 0 0 S 0 0.0 0:00.65 migration/1
5 root 34 19 0 0 0 S 0 0.0 0:00.41 ksoftirqd/1
6 root 5 -10 0 0 0 S 0 0.0 0:00.20 events/0
7 root 5 -10 0 0 0 S 0 0.0 0:00.04 events/1
8 root 5 -10 0 0 0 S 0 0.0 0:00.00 khelper
9 root 15 -10 0 0 0 S 0 0.0 0:00.00 kacpid
32 root 5 -10 0 0 0 S 0 0.0 0:00.01 kblockd/0
33 root 5 -10 0 0 0 S 0 0.0 0:00.00 kblockd/1
34 root 25 0 0 0 0 S 0 0.0 0:00.00 khubd
61 root 15 0 0 0 0 S 0 0.0 7:25.16 kswapd0
62 root 13 -10 0 0 0 S 0 0.0 0:00.00 aio/0
63 root 5 -10 0 0 0 S 0 0.0 0:00.00 aio/1
207 root 23 0 0 0 0 S 0 0.0 0:00.00 kseriod
324 nobody 16 0 134m 23m 17m S 0 0.6 0:06.80 httpd
336 nobody 15 0 134m 24m 18m S 0 0.7 0:05.49 httpd
337 nobody 15 0 134m 23m 17m S 0 0.7 0:05.33 httpd
339 nobody 15 0 134m 21m 15m S 0 0.6 0:04.09 httpd
439 root 5 -10 0 0 0 S 0 0.0 0:00.00 ata/0
440 root 5 -10 0 0 0 S 0 0.0 0:00.00 ata/1
441 root 8 -10 0 0 0 S 0 0.0 0:00.00 ata_aux
445 root 15 0 0 0 0 S 0 0.0 0:00.00 scsi_eh_0
446 root 15 0 0 0 0 S 0 0.0 0:00.00 scsi_eh_1
447 root 15 0 0 0 0 S 0 0.0 0:00.00 scsi_eh_2
448 root 15 0 0 0 0 S 0 0.0 0:00.00 scsi_eh_3
454 nobody 16 0 134m 21m 15m S 0 0.6 0:03.67 httpd
475 root 15 0 0 0 0 S 0 0.0 0:08.64 kjournald
507 nobody 15 0 134m 21m 15m S 0 0.6 0:04.38 httpd
551 nobody 16 0 133m 20m 14m S 0 0.6 0:01.78 httpd
552 nobody 15 0 134m 22m 16m S 0 0.6 0:02.97 httpd
631 nobody 15 0 133m 19m 13m S 0 0.5 0:01.18 httpd
646 nobody 15 0 133m 19m 13m S 0 0.5 0:03.36 httpd
650 nobody 15 0 133m 20m 14m S 0 0.6 0:03.02 httpd
731 root 16 0 30788 4020 2172 S 0 0.1 0:00.02 exim

7. mysqld]
# max_connections = 75
max_connections = 250
safe-show-database
skip-locking
key_buffer = 64M
max_allowed_packet = 1M
table_cache = 128
sort_buffer_size = 2M
read_buffer_size = 2M
read_rnd_buffer_size = 2M
myisam_sort_buffer_size = 64M
thread_cache_size = 8
query_cache_size= 64M
thread_concurrency = 8
wait_timeout = 10
interactive_timeout = 30

[mysqldump]
quick
max_allowed_packet = 8M

[mysql]
no-auto-rehash

[isamchk]
key_buffer = 64M
sort_buffer_size = 64M
read_buffer = 2M
write_buffer = 2M

[myisamchk]
key_buffer = 64M
sort_buffer_size = 64M
read_buffer = 2M
write_buffer = 2M

8. +---------------------------------+---------------------------------------------+
| Variable_name | Value |
+---------------------------------+---------------------------------------------+
| back_log | 50 |
| basedir | / |
| binlog_cache_size | 32768 |
| bulk_insert_buffer_size | 8388608 |
| character_set_client | latin1 |
| character_set_connection | latin1 |
| character_set_database | latin1 |
| character_set_results | latin1 |
| character_set_server | latin1 |
| character_set_system | utf8 |
| character_sets_dir | /usr/share/mysql/charsets/ |
| collation_connection | latin1_swedish_ci |
| collation_database | latin1_swedish_ci |
| collation_server | latin1_swedish_ci |
| concurrent_insert | ON |
| connect_timeout | 5 |
| datadir | /var/lib/mysql/ |
| date_format | %Y-%m-%d |
| datetime_format | %Y-%m-%d %H:%i:%s |
| default_week_format | 0 |
| delay_key_write | ON |
| delayed_insert_limit | 100 |
| delayed_insert_timeout | 300 |
| delayed_queue_size | 1000 |
| expire_logs_days | 0 |
| flush | OFF |
| flush_time | 0 |
| ft_boolean_syntax | + -><()~*:""&| |
| ft_max_word_len | 84 |
| ft_min_word_len | 4 |
| ft_query_expansion_limit | 20 |
| ft_stopword_file | (built-in) |
| group_concat_max_len | 1024 |
| have_archive | NO |
| have_bdb | NO |
| have_blackhole_engine | NO |
| have_compress | YES |
| have_crypt | YES |
| have_csv | NO |
| have_example_engine | NO |
| have_geometry | YES |
| have_innodb | YES |
| have_isam | NO |
| have_merge_engine | YES |
| have_ndbcluster | NO |
| have_openssl | NO |
| have_query_cache | YES |
| have_raid | NO |
| have_rtree_keys | YES |
| have_symlink | YES |
| init_connect | |
| init_file | |
| init_slave | |
| innodb_additional_mem_pool_size | 1048576 |
| innodb_autoextend_increment | 8 |
| innodb_buffer_pool_awe_mem_mb | 0 |
| innodb_buffer_pool_size | 8388608 |
| innodb_data_file_path | ibdata1:10M:autoextend |
| innodb_data_home_dir | |
| innodb_fast_shutdown | ON |
| innodb_file_io_threads | 4 |
| innodb_file_per_table | OFF |
| innodb_flush_log_at_trx_commit | 1 |
| innodb_flush_method | |
| innodb_force_recovery | 0 |
| innodb_lock_wait_timeout | 50 |
| innodb_locks_unsafe_for_binlog | OFF |
| innodb_log_arch_dir | |
| innodb_log_archive | OFF |
| innodb_log_buffer_size | 1048576 |
| innodb_log_file_size | 5242880 |
| innodb_log_files_in_group | 2 |
| innodb_log_group_home_dir | ./ |
| innodb_max_dirty_pages_pct | 90 |
| innodb_max_purge_lag | 0 |
| innodb_mirrored_log_groups | 1 |
| innodb_open_files | 300 |
| innodb_table_locks | ON |
| innodb_thread_concurrency | 8 |
| interactive_timeout | 30 |
| join_buffer_size | 131072 |
| key_buffer_size | 67108864 |
| key_cache_age_threshold | 300 |
| key_cache_block_size | 1024 |
| key_cache_division_limit | 100 |
| language | /usr/share/mysql/english/ |
| large_files_support | ON |
| lc_time_names | en_US |
| license | GPL |
| local_infile | ON |
| locked_in_memory | OFF |
| log | OFF |
| log_bin | OFF |
| log_error | |
| log_slave_updates | OFF |
| log_slow_queries | OFF |
| log_update | OFF |
| log_warnings | 1 |
| long_query_time | 10 |
| low_priority_updates | OFF |
| lower_case_file_system | OFF |
| lower_case_table_names | 0 |
| max_allowed_packet | 1047552 |
| max_binlog_cache_size | 18446744073709551615 |
| max_binlog_size | 1073741824 |
| max_connect_errors | 10 |
| max_connections | 250 |
| max_delayed_threads | 20 |
| max_error_count | 64 |
| max_heap_table_size | 16777216 |
| max_insert_delayed_threads | 20 |
| max_join_size | 18446744073709551615 |
| max_length_for_sort_data | 1024 |
| max_prepared_stmt_count | 16382 |
| max_relay_log_size | 0 |
| max_seeks_for_key | 18446744073709551615 |
| max_sort_length | 1024 |
| max_tmp_tables | 32 |
| max_user_connections | 0 |
| max_write_lock_count | 18446744073709551615 |
| myisam_data_pointer_size | 4 |
| myisam_max_extra_sort_file_size | 2147483648 |
| myisam_max_sort_file_size | 9223372036854775807 |
| myisam_recover_options | OFF |
| myisam_repair_threads | 1 |
| myisam_sort_buffer_size | 67108864 |
| myisam_stats_method | nulls_unequal |
| net_buffer_length | 16384 |
| net_read_timeout | 30 |
| net_retry_count | 10 |
| net_write_timeout | 60 |
| new | OFF |
| old_passwords | OFF |
| open_files_limit | 1250 |
| pid_file | /var/lib/mysql/apollo.avrilbandaids.com.pid |
| port | 3306 |
| preload_buffer_size | 32768 |
| prepared_stmt_count | 0 |
| protocol_version | 10 |
| query_alloc_block_size | 8192 |
| query_cache_limit | 1048576 |
| query_cache_min_res_unit | 4096 |
| query_cache_size | 67108864 |
| query_cache_type | ON |
| query_cache_wlock_invalidate | OFF |
| query_prealloc_size | 8192 |
| range_alloc_block_size | 2048 |
| read_buffer_size | 2093056 |
| read_only | OFF |
| read_rnd_buffer_size | 2093056 |
| relay_log_purge | ON |
| relay_log_space_limit | 0 |
| rpl_recovery_rank | 0 |
| secure_auth | OFF |
| server_id | 0 |
| skip_external_locking | ON |
| skip_networking | OFF |
| skip_show_database | OFF |
| slave_net_timeout | 3600 |
| slave_transaction_retries | 0 |
| slow_launch_time | 2 |
| socket | /var/lib/mysql/mysql.sock |
| sort_buffer_size | 2097144 |
| sql_mode | |
| sql_notes | ON |
| sql_warnings | ON |
| storage_engine | MyISAM |
| sync_binlog | 0 |
| sync_frm | ON |
| sync_replication | 0 |
| sync_replication_slave_id | 0 |
| sync_replication_timeout | 0 |
| system_time_zone | EDT |
| table_cache | 128 |
| table_type | MyISAM |
| thread_cache_size | 8 |
| thread_stack | 196608 |
| time_format | %H:%i:%s |
| time_zone | SYSTEM |
| tmp_table_size | 33554432 |
| tmpdir | |
| transaction_alloc_block_size | 8192 |
| transaction_prealloc_size | 4096 |
| tx_isolation | REPEATABLE-READ |
| version | 4.1.22-standard |
| version_comment | MySQL Community Edition - Standard (GPL) |
| version_compile_machine | x86_64 |
| version_compile_os | unknown-linux-gnu |
| wait_timeout | 10 |
+---------------------------------+---------------------------------------------+
+----------------------------+-------------+
| Variable_name | Value |
+----------------------------+-------------+
| Aborted_clients | 11872 |
| Aborted_connects | 37 |
| Binlog_cache_disk_use | 0 |
| Binlog_cache_use | 0 |
| Bytes_received | 1523092652 |
| Bytes_sent | 91027044680 |
| Com_admin_commands | 0 |
| Com_alter_db | 0 |
| Com_alter_table | 35 |
| Com_analyze | 0 |
| Com_backup_table | 0 |
| Com_begin | 0 |
| Com_change_db | 252989 |
| Com_change_master | 0 |
| Com_check | 0 |
| Com_checksum | 0 |
| Com_commit | 0 |
| Com_create_db | 0 |
| Com_create_function | 0 |
| Com_create_index | 0 |
| Com_create_table | 56 |
| Com_dealloc_sql | 2551 |
| Com_delete | 56436 |
| Com_delete_multi | 0 |
| Com_do | 0 |
| Com_drop_db | 0 |
| Com_drop_function | 0 |
| Com_drop_index | 0 |
| Com_drop_table | 56 |
| Com_drop_user | 0 |
| Com_execute_sql | 2551 |
| Com_flush | 4 |
| Com_grant | 12 |
| Com_ha_close | 0 |
| Com_ha_open | 0 |
| Com_ha_read | 0 |
| Com_help | 0 |
| Com_insert | 49532 |
| Com_insert_select | 56 |
| Com_kill | 0 |
| Com_load | 0 |
| Com_load_master_data | 0 |
| Com_load_master_table | 0 |
| Com_lock_tables | 133 |
| Com_optimize | 88 |
| Com_preload_keys | 0 |
| Com_prepare_sql | 2551 |
| Com_purge | 0 |
| Com_purge_before_date | 0 |
| Com_rename_table | 0 |
| Com_repair | 0 |
| Com_replace | 7233 |
| Com_replace_select | 0 |
| Com_reset | 0 |
| Com_restore_table | 0 |
| Com_revoke | 0 |
| Com_revoke_all | 0 |
| Com_rollback | 0 |
| Com_savepoint | 0 |
| Com_select | 974361 |
| Com_set_option | 5920 |
| Com_show_binlog_events | 0 |
| Com_show_binlogs | 2 |
| Com_show_charsets | 6 |
| Com_show_collations | 6 |
| Com_show_column_types | 0 |
| Com_show_create_db | 16 |
| Com_show_create_table | 1209 |
| Com_show_databases | 11 |
| Com_show_errors | 0 |
| Com_show_fields | 1461 |
| Com_show_grants | 72 |
| Com_show_innodb_status | 0 |
| Com_show_keys | 0 |
| Com_show_logs | 0 |
| Com_show_master_status | 0 |
| Com_show_ndb_status | 0 |
| Com_show_new_master | 0 |
| Com_show_open_tables | 0 |
| Com_show_privileges | 0 |
| Com_show_processlist | 335 |
| Com_show_slave_hosts | 0 |
| Com_show_slave_status | 0 |
| Com_show_status | 1 |
| Com_show_storage_engines | 0 |
| Com_show_tables | 1279 |
| Com_show_variables | 51 |
| Com_show_warnings | 0 |
| Com_slave_start | 0 |
| Com_slave_stop | 0 |
| Com_stmt_close | 2551 |
| Com_stmt_execute | 2551 |
| Com_stmt_prepare | 2551 |
| Com_stmt_reset | 0 |
| Com_stmt_send_long_data | 0 |
| Com_truncate | 56 |
| Com_unlock_tables | 130 |
| Com_update | 198731 |
| Com_update_multi | 60 |
| Connections | 196499 |
| Created_tmp_disk_tables | 4814 |
| Created_tmp_files | 48518 |
| Created_tmp_tables | 26395 |
| Delayed_errors | 0 |
| Delayed_insert_threads | 0 |
| Delayed_writes | 0 |
| Flush_commands | 1 |
| Handler_commit | 14 |
| Handler_delete | 37696 |
| Handler_discover | 0 |
| Handler_read_first | 177355 |
| Handler_read_key | 123250425 |
| Handler_read_next | 4057197618 |
| Handler_read_prev | 3595536 |
| Handler_read_rnd | 1979890957 |
| Handler_read_rnd_next | 3848135585 |
| Handler_rollback | 4 |
| Handler_update | 984721 |
| Handler_write | 169225451 |
| Key_blocks_not_flushed | 0 |
| Key_blocks_unused | 11113 |
| Key_blocks_used | 53585 |
| Key_read_requests | 829210462 |
| Key_reads | 769329 |
| Key_write_requests | 499686 |
| Key_writes | 241059 |
| Max_used_connections | 151 |
| Not_flushed_delayed_rows | 0 |
| Open_files | 214 |
| Open_streams | 0 |
| Open_tables | 128 |
| Opened_tables | 41538 |
| Qcache_free_blocks | 5235 |
| Qcache_free_memory | 41214344 |
| Qcache_hits | 1215239 |
| Qcache_inserts | 921349 |
| Qcache_lowmem_prunes | 26889 |
| Qcache_not_cached | 51791 |
| Qcache_queries_in_cache | 10723 |
| Qcache_total_blocks | 27252 |
| Questions | 2961079 |
| Rpl_status | NULL |
| Select_full_join | 14999 |
| Select_full_range_join | 0 |
| Select_range | 160094 |
| Select_range_check | 0 |
| Select_scan | 172604 |
| Slave_open_temp_tables | 0 |
| Slave_retried_transactions | 0 |
| Slave_running | OFF |
| Slow_launch_threads | 36 |
| Slow_queries | 3315 |
| Sort_merge_passes | 62198 |
| Sort_range | 221192 |
| Sort_rows | 2045951624 |
| Sort_scan | 24511 |
| Table_locks_immediate | 2114981 |
| Table_locks_waited | 66390 |
| Threads_cached | 2 |
| Threads_connected | 6 |
| Threads_created | 10542 |
| Threads_running | 4 |
| Uptime | 100027 |
+----------------------------+-------------+
Uptime: 100027 Threads: 6 Questions: 2961080 Slow queries: 3315 Opens: 41538 Flush tables: 1 Open tables: 128 Queries per second avg: 29.603
mysqladmin Ver 8.41 Distrib 4.1.22, for unknown-linux-gnu on x86_64
Copyright (C) 2000 MySQL AB & MySQL Finland AB & TCX DataKonsult AB
This software comes with ABSOLUTELY NO WARRANTY. This is free software,
and you are welcome to modify and redistribute it under the GPL license

Server version 4.1.22-standard
Protocol version 10
Connection Localhost via UNIX socket
UNIX socket /var/lib/mysql/mysql.sock
Uptime: 1 day 3 hours 47 min 7 sec

Threads: 6 Questions: 2961080 Slow queries: 3315 Opens: 41538 Flush tables: 1 Open tables: 128 Queries per second avg: 29.603
+--------+------------------+-----------+-------------------+---------+------+--------------+------------------------------------------------------------------------------------------------------+
| Id | User | Host | db | Command | Time | State | Info |
+--------+------------------+-----------+-------------------+---------+------+--------------+------------------------------------------------------------------------------------------------------+
| 196493 | bandaids_atropos | localhost | bandaids_basilik | Query | 1 | Sending data | SELECT user.*, usergroup.usergroupid, usergroup.title, user.options, usertextfield.*, userfield.*,
|
| 196494 | bandaids_thetis | localhost | bandaids_sunprint | Query | 0 | Sending data | SELECT pid FROM cpg1411_pictures WHERE filepath='2680/' AND filename='Ryan_Seacrest_Interview_pt1_20 |
| 196495 | bandaids_atropos | localhost | bandaids_basilik | Sleep | 0 | | |
| 196496 | bandaids_thetis | localhost | bandaids_sunprint | Query | 0 | Sending data | SELECT pid FROM cpg1411_pictures WHERE filepath='2680/' AND filename='Ryan_Seacrest_Interview_pt1_20 |
| 196497 | bandaids_atropos | localhost | bandaids_basilik | Sleep | 0 | | |
| 196498 | root | localhost | | Query | 0 | | show processlist |
+--------+------------------+-----------+-------------------+---------+------+--------------+------------------------------------------------------------------------------------------------------+

9. Coppermine image gallery, AttachMax may be migrated over in the future

10. 400 users average; max 4,000
Cookie timeout: 1,200

11. http://www.avrilbandaids.com/1AxhZ2/

12.
KeepAlive Off
MaxKeepAliveRequests 80
KeepAliveTimeout 3
MinSpareServers 10
MaxSpareServers 20
StartServers 10

AND MaxRequestsPerChild 500

13.
/backup/cpbackup/weekly/bandaids.tar.gz
/backup/cpbackup/daily/bandaids.tar.gz
/backup/cpbackup/monthly/bandaids.tar.gz

14.
Linux apollo.avrilbandaids.com 2.6.9-55.0.12.ELsmp #1 SMP Fri Nov 2 12:38:56 EDT 2007 x86_64 x86_64 x86_64 GNU/Linux

core file size (blocks, -c) unlimited
data seg size (kbytes, -d) unlimited
file size (blocks, -f) unlimited
pending signals (-i) 1024
max locked memory (kbytes, -l) 32
max memory size (kbytes, -m) unlimited
open files (-n) 1024
pipe size (512 bytes, -p) 8
POSIX message queues (bytes, -q) 819200
stack size (kbytes, -s) unlimited
cpu time (seconds, -t) unlimited
max user processes (-u) 29951
virtual memory (kbytes, -v) unlimited
file locks (-x) unlimited

processor : 0
vendor_id : AuthenticAMD
cpu family : 15
model : 5
model name : AMD Opteron(tm) Processor 246
stepping : 10
cpu MHz : 1991.526
cache size : 1024 KB
fpu : yes
fpu_exception : yes
cpuid level : 1
wp : yes
flags : fpu vme de pse tsc msr pae mce cx8 apic sep mtrr pge mca cmov pat pse36 clflush mmx fxsr sse sse2 syscall nx mmxext lm 3dnowext 3dnow
bogomips : 3988.48
TLB size : 1088 4K pages
clflush size : 64
cache_alignment : 64
address sizes : 40 bits physical, 48 bits virtual
power management: ts fid vid ttp

processor : 1
vendor_id : AuthenticAMD
cpu family : 15
model : 5
model name : AMD Opteron(tm) Processor 246
stepping : 10
cpu MHz : 1991.526
cache size : 1024 KB
fpu : yes
fpu_exception : yes
cpuid level : 1
wp : yes
flags : fpu vme de pse tsc msr pae mce cx8 apic sep mtrr pge mca cmov pat pse36 clflush mmx fxsr sse sse2 syscall nx mmxext lm 3dnowext 3dnow
bogomips : 3982.25
TLB size : 1088 4K pages
clflush size : 64
cache_alignment : 64
address sizes : 40 bits physical, 48 bits virtual
power management: ts fid vid ttp
eva2000
Tue 8th Jul '08, 10:08am
Try the following in this exact order. You can ignore any of the suggestions that you have already done.

1. Upgrade MySQL 5.0.45 or 5.0.51 if possible and then upgrade PHP to 5.2.5 / 5.2.6 or if you have problems install PHP 4.4.8 (in either case install as apache module and NOT CGI. For windows based PHP try FastCGI method or ISAPI method). Backup your databases prior to mysql upgrades where possible using mysqldump via ssh telnet and not via admincp backup options or phpmyadmin which in some cases of large databases can result in incomplete backups!
2. Edit mysql server's /etc/my.cnf or c:\my.ini for windows and place the following mysql server settings in /etc/my.cnf and restart mysql server afterwards. Make sure to restart mysql server everytime you make changes to your my.cnf for the changes to take effect.

If mysql doesn't restart properly after my.cnf changes and you're on VPS server, make sure skip-innodb entry is removed or commented out from below my.cnf


[mysqld]
#skip-name-resolve
safe-show-database
#old_passwords
back_log = 50
skip-innodb
max_connections = 500
key_buffer_size = 64M
myisam_sort_buffer_size = 64M
join_buffer_size = 1M
read_buffer_size = 1M
sort_buffer_size = 2M
table_cache = 4000
thread_cache_size = 256
wait_timeout = 20
connect_timeout = 10
tmp_table_size = 64M
max_heap_table_size = 64M
max_allowed_packet = 64M
net_buffer_length = 16384
max_connect_errors = 10
thread_concurrency = 4
concurrent_insert = 2
table_lock_wait_timeout = 30
read_rnd_buffer_size = 786432
bulk_insert_buffer_size = 8M
query_cache_limit = 3M
query_cache_size = 64M
query_cache_type = 1
query_prealloc_size = 262144
query_alloc_block_size = 65536
transaction_alloc_block_size = 8192
transaction_prealloc_size = 4096
default-storage-engine = MyISAM
max_write_lock_count = 16

[mysqld_safe]
nice = -10
open_files_limit = 8192

[mysqldump]
quick
max_allowed_packet = 16M

[myisamchk]
key_buffer = 64M
sort_buffer = 64M
read_buffer = 16M
write_buffer = 16M


If you get mysql server gone away error messages, then keep increasing wait_timeout value in my.cnf by 60 second increments, then restart mysql after my.cnf changes for it to take effect. Test for a few days and see if you get less or eliminate that error message. If it still occurs, then keep repeating the 60 second increment until the message goes away. Each vB forum and server will have different optimal wait_timeout values depending on your vB forum traffic patterns and server hardware specifications.

3. Remove Eaccelerator or APC Cache if they're installed (check phpinfo.php url of yours to see) and instead install Xcache v1.2.1 final release or Xcache v1.2.2 http://xcache.lighttpd.net/wiki/Release-1.2.2 which seems to be a bit faster than APC Cache - http://www.vbulletin.com/forum/showthread.php?t=213267. Xcache site http://xcache.lighttpd.net/, documentation http://trac.lighttpd.net/trac/wiki/Docs and forums http://forum.lighttpd.net/forum/4

Remember to set in php.ini the values for xcache.size to 32M or 64M and for xcache.count to a value of equal to number of processor cores you have so single core cpu = 1 or single dual core cpu = 2 or single quad core cpu = 4 or dual cpus each with dual core = 4 or dual cpus each with quad core = 8.

4. Upgrade to vB 3.0.17 http://www.vbulletin.com/forum/showthread.php?t=209720 if you're on vB 3.0.xx or upgrade to vB 3.5.8 http://www.vbulletin.com/forum/showthread.php?t=221903 if you're on vB 3.5.x. Or if on vB 3.6.x, upgrade to vB 3.6.10 PL3 http://www.vbulletin.com/forum/showthread.php?t=277945.

But ultimately, the latest stable vB 3.7.2 PL1 is highly recommended http://www.vbulletin.com/forum/showthread.php?postid=1585047. You can use my method of upgrading outlined at http://www.vbulletin.com/forum/showthread.php?t=187770 which is essentially same in that you make a copy of your live database and import it into a new empty database and point vB 3.7.0 config.php to that new imported database name, so you essentially do an upgrade on a copy of your database, leaving original database intact in case of any problems. This method also allows you to run the original database on a different directory so to run both original forum/database along side the upgraded forum/database so you can easily revert all changed templates on upgraded forum and then using old forum/database transfer or port your custom style/images etc to the new upgrade database.

Read each versions listed thread to understand the changes that have occured etc.

5. If you just upgraded to vB 3.5.x/3.6.x try to disable these 4 options:

Admin CP -> vBulletin Options -> Forums Home Page Options -> Display Logged in Users?

Admin CP -> vBulletin Options -> Forum Display Options (forumdisplay) -> Show Users Browsing Forums

Admin CP -> vBulletin Options -> Thread Display Options -> Show Users Browsing Thread

Admin CP -> vBulletin Options -> Message Searching Options -> Automatic Similar Thread search

Or relevant sections in vB 3.7.x

6. Check phpinfo.php url to see if you have mod_gzip (Apache 1.3.x) or mod_deflate (Apache 2.x) loaded/installed (on phpinfo.php url page in browser you can do CTRL+F to bring up find prompt and type in mod_gzip or mod_deflate to quickly see). If you have either mod_gzip or mod_deflate loaded, then ensure vB admincp gzip compression is disabled since it's the same thing as mod_gzip or mod_deflate and double compression will just increase cpu loads. If you don't have mod_gzip or mod_deflate installed, then DO NOT set vB admincp gzip compression to a level higher than 1. Higher than 1, will only increase cpu loads unncessarily.

7. Edit httpd.conf values to following and restart apachee for each change to take effect

KeepAlive: Off
MaxKeepAliveRequests: 100
KeepAliveTimeout: 2
MinSpareServers: 10
MaxSpareServers: 15
StartServers: 10
MaxClients: 180
MaxRequestsPerChild: 500
staticrebelle
Tue 8th Jul '08, 5:47pm
Thank you for your help.

I have a quick question: why does it say that vBulletin 3.7.2 runs best with APC and then you tell me xCache is better?

We currently run vBSEO, I am not sure if you needed to know that or not.


Thanks again.
staticrebelle
Thu 10th Jul '08, 5:54pm
Sorry for the double post, but since I upgraded and changed my.cnf to your suggestions I've noticed a few things.

It is running poorer than MySQL 4 and every 10 minutes it gets so slow that the MySQL process disappears and comes back.

Our exact MySQL version is now 5.0.51a-community as updated by WHM/cPanel.

The site is now running faster based on our current MySQL 5 my.cnf here:

[mysqld]
# max_connections = 75
max_connections = 250
safe-show-database
skip-locking
key_buffer = 64M
max_allowed_packet = 1M
table_cache = 128
sort_buffer_size = 2M
read_buffer_size = 2M
read_rnd_buffer_size = 2M
myisam_sort_buffer_size = 64M
thread_cache_size = 8
query_cache_size= 64M
thread_concurrency = 8
wait_timeout = 10
interactive_timeout = 30

[mysqldump]
quick
max_allowed_packet = 8M

[mysql]
no-auto-rehash

[isamchk]
key_buffer = 64M
sort_buffer_size = 64M
read_buffer = 2M
write_buffer = 2M

[myisamchk]
key_buffer = 64M
sort_buffer_size = 64M
read_buffer = 2M
write_buffer = 2M

And the mysqlreport here:

#
# Beginning report, 0 0:0:0
#
MySQL 5.0.51a-community uptime 0 0:28:21 Thu Jul 10 16:50:13 2008

__ Key __________________________________________________ _______________
Buffer used 22.02M of 64.00M %Used: 34.41
Current 33.69M %Usage: 52.64
Write hit 37.93%
Read hit 99.89%

__ Questions __________________________________________________ _________
Total 73.38k 43.1/s
DMS 32.75k 19.3/s %Total: 44.63
QC Hits 30.37k 17.9/s 41.39
Com_ 6.32k 3.7/s 8.62
COM_QUIT 4.17k 2.4/s 5.68
-Unknown 230 0.1/s 0.31
Slow 10 s 136 0.1/s 0.19 %DMS: 0.42 Log: OFF
DMS 32.75k 19.3/s 44.63
SELECT 25.12k 14.8/s 34.24 76.72
UPDATE 4.70k 2.8/s 6.41 14.36
DELETE 1.47k 0.9/s 2.00 4.48
INSERT 1.27k 0.7/s 1.73 3.88
REPLACE 183 0.1/s 0.25 0.56
Com_ 6.32k 3.7/s 8.62
change_db 5.87k 3.4/s 8.00
set_option 97 0.1/s 0.13
stmt_prepar 56 0.0/s 0.08

__ SELECT and Sort __________________________________________________ ___
Scan 3.80k 2.2/s %SELECT: 15.11
Range 3.74k 2.2/s 14.90
Full join 410 0.2/s 1.63
Range check 0 0/s 0.00
Full rng join 0 0/s 0.00
Sort scan 855 0.5/s
Sort range 4.29k 2.5/s
Sort mrg pass 155 0.1/s

__ Query Cache __________________________________________________ _______
Memory usage 9.22M of 64.00M %Used: 14.41
Block Fragmnt 10.49%
Hits 30.37k 17.9/s
Inserts 23.55k 13.8/s
Insrt:Prune 23.55k:1 13.8/s
Hit:Insert 1.29:1

__ Table Locks __________________________________________________ _______
Waited 2.21k 1.3/s %Total: 4.10
Immediate 51.86k 30.5/s

__ Tables __________________________________________________ ____________
Open 128 of 128 %Cache: 100.00
Opened 2.69k 1.6/s

__ Connections __________________________________________________ _______
Max used 67 of 250 %Max: 26.80
Total 4.37k 2.6/s

__ Created Temp __________________________________________________ ______
Disk table 226 0.1/s
Table 1.06k 0.6/s Size: 32.0M
File 297 0.2/s

__ Threads __________________________________________________ ___________
Running 1 of 5
Cached 3 of 8 %Hit: 90.93
Created 396 0.2/s
Slow 0 0/s

__ Aborted __________________________________________________ ___________
Clients 396 0.2/s
Connects 3 0.0/s

__ Bytes __________________________________________________ _____________
Sent 1.62G 950.6k/s
Received 49.49M 29.1k/s

__ InnoDB Buffer Pool __________________________________________________
Usage 336.00k of 8.00M %Used: 4.10
Read hit 94.59%
Pages
Free 491 %Total: 95.90
Data 21 4.10 %Drty: 0.00
Misc 0 0.00
Latched 0 0.00
Reads 259 0.2/s
From file 14 0.0/s 5.41
Ahead Rnd 1 0.0/s
Ahead Sql 0 0/s
Writes 0 0/s
Flushes 0 0/s
Wait Free 0 0/s

__ InnoDB Lock __________________________________________________ _______
Waits 0 0/s
Current 0
Time acquiring
Total 0 ms
Average 0 ms
Max 0 ms

__ InnoDB Data, Pages, Rows ____________________________________________
Data
Reads 27 0.0/s
Writes 3 0.0/s
fsync 3 0.0/s
Pending
Reads 0
Writes 0
fsync 0

Pages
Created 0 0/s
Read 21 0.0/s
Written 0 0/s

Rows
Deleted 0 0/s
Inserted 0 0/s
Read 0 0/s
Updated 0 0/s

#
# Interval report 1, +0 0:0:10
#
MySQL 5.0.51a-community uptime 0 0:28:31 Thu Jul 10 16:50:23 2008

__ Key __________________________________________________ _______________
Buffer used 22.06M of 64.00M %Used: 34.46
Current 33.73M %Usage: 52.70
Write hit 12.70%
Read hit 99.78%

__ Questions __________________________________________________ _________
Total 431 43.1/s
DMS 201 20.1/s %Total: 46.64
QC Hits 151 15.1/s 35.03
Com_ 45 4.5/s 10.44
COM_QUIT 28 2.8/s 6.50
+Unknown 6 0.6/s 1.39
Slow 10 s 0 0/s 0.00 %DMS: 0.00 Log: OFF
DMS 201 20.1/s 46.64
SELECT 147 14.7/s 34.11 73.13
UPDATE 35 3.5/s 8.12 17.41
INSERT 7 0.7/s 1.62 3.48
REPLACE 6 0.6/s 1.39 2.99
DELETE 6 0.6/s 1.39 2.99
Com_ 45 4.5/s 10.44
change_db 42 4.2/s 9.74
show_status 1 0.1/s 0.23
set_option 1 0.1/s 0.23

__ SELECT and Sort __________________________________________________ ___
Scan 30 3.0/s %SELECT: 20.41
Range 28 2.8/s 19.05
Full join 2 0.2/s 1.36
Range check 0 0/s 0.00
Full rng join 0 0/s 0.00
Sort scan 6 0.6/s
Sort range 25 2.5/s
Sort mrg pass 0 0/s

__ Query Cache __________________________________________________ _______
Memory usage 9.48M of 64.00M %Used: 14.81
Block Fragmnt 10.02%
Hits 151 15.1/s
Inserts 143 14.3/s
Insrt:Prune 143:1 14.2/s
Hit:Insert 1.06:1

__ Table Locks __________________________________________________ _______
Waited 1 0.1/s %Total: 0.29
Immediate 346 34.6/s

__ Tables __________________________________________________ ____________
Open 128 of 128 %Cache: 100.00
Opened 0 0/s

__ Connections __________________________________________________ _______
Max used 67 of 250 %Max: 26.80
Total 30 3.0/s

__ Created Temp __________________________________________________ ______
Disk table 0 0/s
Table 9 0.9/s Size: 32.0M
File 0 0/s

__ Threads __________________________________________________ ___________
Running 1 of 1
Cached 7 of 8 %Hit: 100
Created 0 0/s
Slow 0 0/s

__ Aborted __________________________________________________ ___________
Clients 0 0/s
Connects 0 0/s

__ Bytes __________________________________________________ _____________
Sent 11.91M 1.2M/s
Received 271.03k 27.1k/s

__ InnoDB Buffer Pool __________________________________________________
Usage 336.00k of 8.00M %Used: 4.10
Read hit 0.00%
Pages
Free 491 %Total: 95.90
Data 21 4.10 %Drty: 0.00
Misc 0 0.00
Latched 0 0.00
Reads 0 0/s
From file 0 0/s 0.00
Ahead Rnd 0 0/s
Ahead Sql 0 0/s
Writes 0 0/s
Flushes 0 0/s
Wait Free 0 0/s

__ InnoDB Lock __________________________________________________ _______
Waits 0 0/s
Current 0
Time acquiring
Total 0 ms
Average 0 ms
Max 0 ms

__ InnoDB Data, Pages, Rows ____________________________________________
Data
Reads 0 0/s
Writes 0 0/s
fsync 0 0/s
Pending
Reads 0
Writes 0
fsync 0

Pages
Created 0 0/s
Read 0 0/s
Written 0 0/s

Rows
Deleted 0 0/s
Inserted 0 0/s
Read 0 0/s
Updated 0 0/s
eva2000
Sun 13th Jul '08, 11:01am
have you checked the mysql error log during using my my.cnf to see if any errors are logged ? not sure why you'd run slower on my my.cnf unless it's coincidence your forums/server was busy during that time than your current my.cnf which agrees with the last mysqlreport you posted, which has your mysql usage loads for mysql concurrent connections and mysql queries per second at half the load compared to your original post suggesting less busy period/traffic when your posted those stats

unless you want to try reverting to my my.cnf for a few days and repost output stats during that time.

Thank you for your help.

I have a quick question: why does it say that vBulletin 3.7.2 runs best with APC and then you tell me xCache is better?

We currently run vBSEO, I am not sure if you needed to know that or not.


Thanks again. to each his own, vB dev who posted the announcement has more experience with APC than xcache so more likely he wrote and developed that with vB in mind. However, I've had much better experience with xcache than APC and so have other vB users.
staticrebelle
Sun 13th Jul '08, 12:41pm
I've been getting a lot of MySQL errors like this:

Database error in vBulletin 3.6.10:

Invalid SQL:

SELECT pm.*, pmtext.*
, icon.title AS icontitle, icon.iconpath
FROM pm AS pm
LEFT JOIN pmtext AS pmtext ON(pmtext.pmtextid = pm.pmtextid)
LEFT JOIN icon AS icon ON(icon.iconid = pmtext.iconid)
WHERE pm.userid=25214 AND pm.folderid=0
ORDER BY pmtext.dateline DESC
LIMIT 0, 50;

MySQL Error : Got error 28 from storage engine
Error Number : 1030
Date : Sunday, July 13th 2008 @ 06:55:56 AM
Script : http://www.avrilbandaids.com/forums/private.php
Referrer : http://www.avrilbandaids.com/forums/posting-games-sundry/59110-avies-nats-coffee-shop-11.html
IP Address : 82.6.197.228 (http://82.6.197.228/)
Username : 3.1415926
Classname : vB_Database_MySQLi

**

Database error in vBulletin 3.6.10:

Invalid SQL:
select * from vbchat_datastore where did='1';

MySQL Error : Table 'bandaids_basilik.vbchat_datastore' doesn't exist
Error Number : 1146
Date : Sunday, July 13th 2008 @ 08:38:24 AM
Script : http://www.avrilbandaids.com/forums/chat.php
Referrer :
IP Address : 208.36.144.8 (http://208.36.144.8/)
Username : Unregistered
Classname : vB_Database_MySQLi


**

Database error in vBulletin 3.6.10:

Invalid SQL:

SELECT post.postid
FROM post AS post

WHERE post.threadid = 26790
AND post.visible = 1


ORDER BY post.dateline
LIMIT 45885, 15;

MySQL Error : Error writing file '/tmp/MYeLJoer' (Errcode: 28)
Error Number : 3
Date : Sunday, July 13th 2008 @ 08:02:47 AM
Script : http://www.avrilbandaids.com/forums/showthread.php?t=26790&page=3060
Referrer :
IP Address : 74.6.17.167 (http://74.6.17.167/)
Username : Unregistered
Classname : vB_Database_MySQLi

These errors always comes in chunks, which makes me think its right when the server overloads and resets. We've now switched back to yours, we'll wait and see what happens.

Right now this isn't exactly peak hours, so I'll wait till then to post a good mysqlreport. *** Actually I was about to post but right then the load averages spiked to 33 so I ran a report.

mysqlreport is writing relative reports to '/tmp/4TzKI4Oq8m'.
#
# Beginning report, 0 0:0:0
#
MySQL 5.0.51a-community uptime 0 23:36:20 Sun Jul 13 10:34:59 2008

__ Key __________________________________________________ _______________
Buffer used 52.33M of 64.00M %Used: 81.76
Current 64.00M %Usage: 100.00
Write hit 86.42%
Read hit 99.96%

__ Questions __________________________________________________ _________
Total 2.99M 35.1/s
QC Hits 1.33M 15.7/s %Total: 44.65
DMS 1.26M 14.9/s 42.29
Com_ 215.46k 2.5/s 7.22
COM_QUIT 191.43k 2.3/s 6.41
-Unknown 17.02k 0.2/s 0.57
Slow 10 s 4.37k 0.1/s 0.15 %DMS: 0.35 Log: OFF
DMS 1.26M 14.9/s 42.29
SELECT 965.85k 11.4/s 32.35 76.51
UPDATE 193.11k 2.3/s 6.47 15.30
DELETE 52.79k 0.6/s 1.77 4.18
INSERT 43.36k 0.5/s 1.45 3.43
REPLACE 7.29k 0.1/s 0.24 0.58
Com_ 215.46k 2.5/s 7.22
change_db 183.25k 2.2/s 6.14
set_option 5.71k 0.1/s 0.19
stmt_prepar 4.25k 0.1/s 0.14

__ SELECT and Sort __________________________________________________ ___
Scan 167.39k 2.0/s %SELECT: 17.33
Range 129.40k 1.5/s 13.40
Full join 15.57k 0.2/s 1.61
Range check 0 0/s 0.00
Full rng join 0 0/s 0.00
Sort scan 26.65k 0.3/s
Sort range 171.49k 2.0/s
Sort mrg pass 8.58k 0.1/s

__ Query Cache __________________________________________________ _______
Memory usage 23.47M of 64.00M %Used: 36.67
Block Fragmnt 25.92%
Hits 1.33M 15.7/s
Inserts 929.47k 10.9/s
Insrt:Prune 68.69:1 10.8/s
Hit:Insert 1.43:1

__ Table Locks __________________________________________________ _______
Waited 40.32k 0.5/s %Total: 1.83
Immediate 2.16M 25.4/s

__ Tables __________________________________________________ ____________
Open 1665 of 4000 %Cache: 41.62
Opened 2.46k 0.0/s

__ Connections __________________________________________________ _______
Max used 299 of 500 %Max: 59.80
Total 191.94k 2.3/s

__ Created Temp __________________________________________________ ______
Disk table 8.92k 0.1/s
Table 29.86k 0.4/s Size: 64.0M
File 13.11k 0.2/s

__ Threads __________________________________________________ ___________
Running 6 of 13
Cached 251 of 256 %Hit: 99.84
Created 305 0.0/s
Slow 0 0/s

__ Aborted __________________________________________________ ___________
Clients 1.02k 0.0/s
Connects 0 0/s

__ Bytes __________________________________________________ _____________
Sent 69.34G 815.9k/s
Received 1.97G 23.2k/s

__ InnoDB Buffer Pool __________________________________________________
Usage 0 of 0 %Used: 0.00
Read hit 0.00%
Pages
Free 0 %Total: 0.00
Data 0 0.00 %Drty: 0.00
Misc 0 0.00
Latched 0 0.00
Reads 0 0/s
From file 0 0/s 0.00
Ahead Rnd 0 0/s
Ahead Sql 0 0/s
Writes 0 0/s
Flushes 0 0/s
Wait Free 0 0/s

__ InnoDB Lock __________________________________________________ _______
Waits 0 0/s
Current 0
Time acquiring
Total 0 ms
Average 0 ms
Max 0 ms

__ InnoDB Data, Pages, Rows ____________________________________________
Data
Reads 0 0/s
Writes 0 0/s
fsync 0 0/s
Pending
Reads 0
Writes 0
fsync 0

Pages
Created 0 0/s
Read 0 0/s
Written 0 0/s

Rows
Deleted 0 0/s
Inserted 0 0/s
Read 0 0/s
Updated 0 0/s

#
# Interval report 1, +0 0:0:10
#
MySQL 5.0.51a-community uptime 0 23:36:38 Sun Jul 13 10:35:09 2008

__ Key __________________________________________________ _______________
Buffer used 52.33M of 64.00M %Used: 81.76
Current 64.00M %Usage: 100.00
Write hit 27.59%
Read hit 100.00%

__ Questions __________________________________________________ _________
Total 767 42.6/s
DMS 449 24.9/s %Total: 58.54
QC Hits 248 13.8/s 32.33
Com_ 32 1.8/s 4.17
COM_QUIT 28 1.6/s 3.65
+Unknown 10 0.6/s 1.30
Slow 10 s 2 0.1/s 0.26 %DMS: 0.45 Log: OFF
DMS 449 24.9/s 58.54
SELECT 399 22.2/s 52.02 88.86
UPDATE 35 1.9/s 4.56 7.80
INSERT 9 0.5/s 1.17 2.00
DELETE 5 0.3/s 0.65 1.11
REPLACE 1 0.1/s 0.13 0.22
Com_ 32 1.8/s 4.17
change_db 28 1.6/s 3.65
show_status 1 0.1/s 0.13
set_option 1 0.1/s 0.13

__ SELECT and Sort __________________________________________________ ___
Scan 37 2.1/s %SELECT: 9.27
Range 48 2.7/s 12.03
Full join 6 0.3/s 1.50
Range check 0 0/s 0.00
Full rng join 0 0/s 0.00
Sort scan 8 0.4/s
Sort range 41 2.3/s
Sort mrg pass 5 0.3/s

__ Query Cache __________________________________________________ _______
Memory usage 25.60M of 64.00M %Used: 40.00
Block Fragmnt 24.65%
Hits 248 13.8/s
Inserts 396 22.0/s
Insrt:Prune 396:1 21.9/s
Hit:Insert 0.63:1

__ Table Locks __________________________________________________ _______
Waited 9 0.5/s %Total: 1.33
Immediate 669 37.2/s

__ Tables __________________________________________________ ____________
Open 1665 of 4000 %Cache: 41.62
Opened 0 0/s

__ Connections __________________________________________________ _______
Max used 299 of 500 %Max: 59.80
Total 30 1.7/s

__ Created Temp __________________________________________________ ______
Disk table 3 0.2/s
Table 10 0.6/s Size: 64.0M
File 5 0.3/s

__ Threads __________________________________________________ ___________
Running 2 of 5
Cached 253 of 256 %Hit: 100
Created 0 0/s
Slow 0 0/s

__ Aborted __________________________________________________ ___________
Clients 0 0/s
Connects 0 0/s

__ Bytes __________________________________________________ _____________
Sent 17.07M 948.2k/s
Received 364.82k 20.3k/s

__ InnoDB Buffer Pool __________________________________________________
Usage 0 of 0 %Used: 0.00
Read hit 0.00%
Pages
Free 0 %Total: 0.00
Data 0 0.00 %Drty: 0.00
Misc 0 0.00
Latched 0 0.00
Reads 0 0/s
From file 0 0/s 0.00
Ahead Rnd 0 0/s
Ahead Sql 0 0/s
Writes 0 0/s
Flushes 0 0/s
Wait Free 0 0/s

__ InnoDB Lock __________________________________________________ _______
Waits 0 0/s
Current 0
Time acquiring
Total 0 ms
Average 0 ms
Max 0 ms

__ InnoDB Data, Pages, Rows ____________________________________________
Data
Reads 0 0/s
Writes 0 0/s
fsync 0 0/s
Pending
Reads 0
Writes 0
fsync 0

Pages
Created 0 0/s
Read 0 0/s
Written 0 0/s

Rows
Deleted 0 0/s
Inserted 0 0/s
Read 0 0/s
Updated 0 0/s
staticrebelle
Wed 16th Jul '08, 3:23pm
Sorry for the many posts.

Please ignore all of the above. Your suggested settings for MySQL 5.0.51a-community with vB 3.7.2 PL1, Apache 2.2.9, and PHP 5.2.6 w/ APC 3.0.19 has resulted in 20-30 constant load averages with both CPUs at 100% usage. Page loads take 20-60 seconds and posts take even longer.

I've reverted the configuration to my host's modified defaults. Could we take another look? Since I'm now running on new versions of software and daemons, I think the above statistics are now somewhat invalid.

Please advise on what to do.
eva2000
Thu 17th Jul '08, 7:49am
ah ha there's you problem

perror 28 = Error code 28: No space left on device

means one of your disk partitions has run out of free disk space

you can find which partition it via command in ssh telnet

df -h

now my my.cnf uses more memory than the one you used and if you are swapping to disk and the disk doesn't have enough free disk space it can compound the problem!

you need to add a new hard drive or larger drive and then try my my.cnf
staticrebelle
Thu 17th Jul '08, 1:45pm
By default I assume my.cnf uses /tmp?

Here is what df -h shows for my system:

root@apollo [~]# df -h
Filesystem Size Used Avail Use% Mounted on
/dev/sda7 2.0G 1.2G 697M 64% /
/dev/sdb1 147G 18G 122G 13% /backup
/dev/sda1 1012M 84M 877M 9% /boot
none 1.8G 0 1.8G 0% /dev/shm
/dev/sda8 121G 41G 74G 36% /home
/dev/sda6 2.0G 1.9G 0 100% /tmp
/dev/sda2 9.9G 4.1G 5.4G 44% /usr
/dev/sda5 9.9G 4.1G 5.3G 44% /var
/tmp 2.0G 1.9G 0 100% /var/tmp
/So I see my /tmp has filled up completely.. I am unsure what it is so I ran this command:
root@apollo [/tmp]# du -hx --max-depth 1
12K ./.font-unix
60K ./optional_rules
4.0K ./rcsqxgwGx
7.7M ./mlogc-src_1.4.4
4.0K ./rcsRjejdo
4.0K ./rcsjb2LZH
4.0K ./rcsoqYhQS
4.0K ./rcsUXXfam
4.0K ./rcs5x0qgL
4.0K ./rcsw2zzoo
7.9M ./pcre-7.7
4.0K ./rcsUY7zXl
4.0K ./pear-build-root
4.0K ./rcsQNLT1v
4.0K ./rcs33xGOL
4.0K ./clamav-2aac6256860e473f2eb7df7d1a6aa944
4.0K ./rcsCPwmVj
16K ./lost+found
4.0K ./rcsN2Px6i
4.0K ./rcsIPNObs
4.0K ./rcs7wRlJb
744K ./chkrootkit-0.48
4.0K ./clamav-b8981ffbc9a721935a2847893d917db6
3.5M ./pear
4.0K ./rcsdOrcYC
4.0K ./rcsfviQuQ
8.0K ./.ICE-unix
4.0K ./.webmin
4.0K ./rcsoFnPPl
8.0K ./screens
1.2G .
root@apollo [/tmp]# ls -lsah
total 1.3G
204K drwxrwxrwx 32 root root 200K Jul 17 12:21 ./
4.0K drwxr-xr-x 26 root root 4.0K Jul 17 08:28 ../
12K -rwxrwxrwx 1 root root 11K Apr 23 07:46 CHANGELOG*
4.0K drwxrwxrwx 2 1000 1000 4.0K Jul 7 19:11 chkrootkit-0.48/
40K -rwxrwxrwx 1 root root 38K Jul 7 19:08 chkrootkit.tar.gz*
4.0K drwxrwxrwx 2 root root 4.0K Jun 22 22:50 clamav-2aac6256860e473f2eb7df7d1a6aa944/
4.0K drwxrwxrwx 2 root root 4.0K Jun 25 05:31 clamav-b8981ffbc9a721935a2847893d917db6/
916K -rwxrwxrwx 1 root root 909K Jul 9 05:29 .cpanel_easy-.oyHIPcXHMCEF6g0Y*
8.0K drwxrwxrwt 2 root root 4.0K Jul 17 08:28 .font-unix/
55M -rwxrwxrwx 1 root root 55M Jul 6 04:15 gallery_sql-dump.sql*
0 -rwxrwxrwx 1 nobody nobody 0 Jul 4 01:51 global.dir*
4.0K -rwxrwxrwx 1 nobody nobody 1.0K Jul 6 14:43 global.pag*
8.0K drwxrwxrwt 2 root root 4.0K Jul 17 08:28 .ICE-unix/
20K -rwxrwxrwx 1 root root 18K Apr 23 07:46 LICENSE*
16K drwxrwxrwx 2 root root 16K Feb 19 2007 lost+found/
4.0K drwxrwxrwx 3 1000 1000 4.0K Jul 4 13:09 mlogc-src_1.4.4/
4.0K lrwxrwxrwx 1 root root 30 Jul 17 12:13 mysql.sock -> ../../var/lib/mysql/mysql.sock=
4.0K drwxrwxrwx 2 root root 4.0K Jun 30 15:48 optional_rules/
4.0K drwxrwxrwx 7 1169 1169 4.0K Jul 1 11:29 pcre-7.7/
4.0K drwxrwxrwx 5 root root 4.0K Jun 29 03:32 pear/
4.0K drwxrwxrwx 2 root root 4.0K Jun 29 15:08 pear-build-root/
48K -rw------- 1 nobody nobody 47K Jul 16 02:06 phpjNC9U0
36K -rw------- 1 nobody nobody 35K Jul 16 02:00 phpmfrtsL
60K -rw------- 1 nobody nobody 55K Jul 16 02:06 phpXCNR1k
4.0K drwxrwxrwx 2 root root 4.0K Jun 28 16:49 rcs33xGOL/
4.0K drwxrwxrwx 2 root root 4.0K Jul 6 15:18 rcs5x0qgL/
4.0K drwxrwxrwx 2 root root 4.0K Jun 28 16:49 rcs7wRlJb/
4.0K drwxrwxrwx 2 root root 4.0K Jul 9 05:10 rcsCPwmVj/
4.0K drwxrwxrwx 2 root root 4.0K Jul 6 15:18 rcsdOrcYC/
4.0K drwxrwxrwx 2 root root 4.0K Jul 9 05:27 rcsfviQuQ/
4.0K drwxrwxrwx 2 root root 4.0K Jul 9 05:10 rcsIPNObs/
4.0K drwxrwxrwx 2 root root 4.0K Jun 28 16:48 rcsjb2LZH/
4.0K drwxrwxrwx 2 root root 4.0K Jul 9 05:27 rcsN2Px6i/
4.0K drwxrwxrwx 2 root root 4.0K Jul 6 15:19 rcsoFnPPl/
4.0K drwxrwxrwx 2 root root 4.0K Jun 28 16:48 rcsoqYhQS/
4.0K drwxrwxrwx 2 root root 4.0K Jul 9 05:27 rcsQNLT1v/
4.0K drwxrwxrwx 2 root root 4.0K Jul 9 05:10 rcsqxgwGx/
4.0K drwxrwxrwx 2 root root 4.0K Jul 9 05:11 rcsRjejdo/
4.0K drwxrwxrwx 2 root root 4.0K Jul 9 05:10 rcsUXXfam/
4.0K drwxrwxrwx 2 root root 4.0K Jul 6 15:18 rcsUY7zXl/
4.0K drwxrwxrwx 2 root root 4.0K Jul 6 15:18 rcsw2zzoo/
8.0K -rwxrwxrwx 1 root root 7.9K Apr 23 07:46 README*
4.0K drwxrwxrwx 3 root root 4.0K Jun 2 19:01 screens/
0 -rw------- 1 nobody nobody 0 Jul 16 05:42 sess_09ffabd067c275306b932d249caea569
0 -rw------- 1 nobody nobody 0 Jul 16 05:43 sess_0b2ec508214a5e34ab77cc50d02210d6
0 -rw------- 1 nobody nobody 0 Jul 15 22:42 sess_0cfc074fd3a8f69115924a6d8136bd39
4.0K -rw------- 1 nobody nobody 0 Jul 16 12:42 sess_15da19536558688e1acec6d085f8040e
0 -rw------- 1 nobody nobody 0 Jul 15 22:38 sess_1b2e939bb02b12e5bbac9969a2cab76b
0 -rw------- 1 nobody nobody 0 Jul 15 09:19 sess_1d6a58d4420290d55700f220b3176f00
0 -rw------- 1 nobody nobody 0 Jul 14 21:07 sess_1d6cc9cc8ee51e659ed01c2c7b4a8f1b
0 -rw------- 1 nobody nobody 0 Jul 15 14:51 sess_1f1f7cbd0ce8587bc82eba65f04f8395
4.0K -rw------- 1 nobody nobody 0 Jul 16 14:15 sess_23cf486d14e81cf58f8d5da8660a49b8
0 -rw------- 1 nobody nobody 0 Jul 14 17:52 sess_2e39a5bb0b323a30294c5fd87576d8b8
0 -rw------- 1 nobody nobody 0 Jul 15 08:54 sess_37f107130ce01ba86b106024ec35ce84
0 -rw------- 1 nobody nobody 0 Jul 14 15:52 sess_3882bfcdf3e2c3b69dbcc3ca42f41bb0
0 -rw------- 1 nobody nobody 0 Jul 15 14:11 sess_3e4d3c1fa8868d778937752f3296258f
0 -rw------- 1 nobody nobody 0 Jul 14 13:27 sess_42af5e23ccdb3076a3a2c8933ae43a31
4.0K -rw------- 1 nobody nobody 0 Jul 16 09:46 sess_44e994ca37345629e56c484d925da277
0 -rw------- 1 nobody nobody 0 Jul 16 05:09 sess_4867cf48ff8f430f9b42a472c455dbdf
4.0K -rw------- 1 nobody nobody 0 Jul 16 09:46 sess_5b2c18b2f52729b7a6ee5976f5502865
0 -rw------- 1 root root 0 Jul 14 17:28 sess_5f4c6eb3ca5c132945a4c3f2f17c4d35
4.0K -rw------- 1 nobody nobody 0 Jul 17 07:12 sess_6edb539c01782dbe0b8eb1d47e17851e
4.0K -rw------- 1 nobody nobody 0 Jul 16 14:19 sess_6f44460991200d4c87b4a192d606a0cd
4.0K -rw------- 1 nobody nobody 0 Jul 16 09:44 sess_7251979662873cedba4968e83de1faea
0 -rw------- 1 nobody nobody 0 Jul 15 16:41 sess_7f0b1920cdc0278f305509d91a7567b5
0 -rw------- 1 nobody nobody 0 Jul 16 05:10 sess_7fd550a51a0d4c331afc750147e0a7af
0 -rw------- 1 nobody nobody 0 Jul 14 13:15 sess_843a2fdb969dff339c0e7ea0ba9b90d0
4.0K -rw------- 1 nobody nobody 0 Jul 16 08:23 sess_8ad9d2816a587e1bbc4e7ff33dd35272
4.0K -rw------- 1 nobody nobody 0 Jul 16 22:18 sess_90d69c72f30ed1b6de686228c590756f
0 -rw------- 1 nobody nobody 0 Jul 15 13:11 sess_9243a7082ca05cb8bf627ab35ca27a56
0 -rw------- 1 root root 0 Jul 15 17:28 sess_9c0ed9366e80d35ecfd4db40c4f87fbb
4.0K -rw------- 1 root root 0 Jul 16 17:28 sess_9c16f01247b75950880f318ce2e705cb
0 -rw------- 1 nobody nobody 0 Jul 15 18:17 sess_a0d968f79fe4648430d3d6667bea80c0
0 -rw------- 1 nobody nobody 0 Jul 15 00:30 sess_a8dbc84934eb2fcbf446904fee929e66
0 -rw------- 1 nobody nobody 0 Jul 15 00:02 sess_abde9b899c56a90641e856cb29ce34ec
4.0K -rw------- 1 nobody nobody 0 Jul 16 14:24 sess_b87ef9db90d29656ce0bc4106467e41e
0 -rw------- 1 nobody nobody 0 Jul 15 14:43 sess_bddbc230aa82ff2b42534de830fabebe
0 -rw------- 1 nobody nobody 0 Jul 15 16:40 sess_c2f6e359f8f6eee334ffe077365486d0
0 -rw------- 1 nobody nobody 0 Jul 14 13:17 sess_c416b2677fe276bdd12470e56e00360a
4.0K -rw------- 1 nobody nobody 0 Jul 17 00:45 sess_c44b7d11665f8b73ca6a3f63bfc684f8
4.0K -rw------- 1 nobody nobody 0 Jul 16 07:38 sess_c4f2d73679c84c4d4d92a699575268c3
0 -rw------- 1 nobody nobody 0 Jul 15 08:54 sess_d8ce75bb1b738e0525b692542a4e2820
4.0K -rw------- 1 nobody nobody 213 Jul 15 14:00 sess_da5756323c5c7a0d57e0bfe800c4c59c
0 -rw------- 1 nobody nobody 0 Jul 16 04:24 sess_dd0fa519e3b8d4d98f28f3cd9eb22d7c
0 -rw------- 1 nobody nobody 0 Jul 15 20:22 sess_e09a61cfd24fd2eba68ad4e98e20d25f
4.0K -rw------- 1 nobody nobody 0 Jul 16 08:23 sess_e26b99220654a5190505e06750369af0
4.0K -rw------- 1 nobody nobody 0 Jul 16 13:21 sess_ee6b141906990a5890e5dd1779aab3d3
0 -rw------- 1 nobody nobody 0 Jul 15 19:39 sess_f3b920c733248c33f1960c12c18c3efa
4.0K -rw------- 1 nobody nobody 0 Jul 16 13:21 sess_f4271957144c5725eadd3bd721df2002
0 -rw------- 1 nobody nobody 0 Jul 15 00:30 sess_f4a0944497c4610d421114fee35e0f8c
288M -rw-rw---- 1 mysql mysql 287M Jul 17 12:19 #sql_3643_0.MYD
8.0K -rw-rw---- 1 mysql mysql 1.0K Jul 17 12:18 #sql_3643_0.MYI
288M -rw-rw---- 1 mysql mysql 287M Jul 17 12:10 #sql_3643_10.MYD
8.0K -rw-rw---- 1 mysql mysql 1.0K Jul 17 12:07 #sql_3643_10.MYI
117M -rw-rw---- 1 mysql mysql 117M Jul 17 12:21 #sql_3643_11.MYD
288M -rw-rw---- 1 mysql mysql 287M Jul 17 11:59 #sql_3643_2.MYD
8.0K -rw-rw---- 1 mysql mysql 1.0K Jul 17 11:58 #sql_3643_2.MYI
288M -rw-rw---- 1 mysql mysql 287M Jul 17 12:19 #sql_3643_5.MYD
8.0K -rw-rw---- 1 mysql mysql 1.0K Jul 17 12:18 #sql_3643_5.MYI
4.0K drwxr-xr-x 2 root root 4.0K Jul 12 21:11 .webmin/
272K -rw-r--r-- 1 root root 263K Dec 29 2007 xcache-1.2.2.tar.gzIs it MySQL using up the majority of /tmp?

And right now we're at peak loads (30 load averages for the past 6 hours from which I can assume is from the /tmp being full). I finally found out how to output all of "top":

root@apollo [~]# top -cSb n 1
top - 12:16:21 up 3:48, 2 users, load average: 27.41, 30.76, 26.81
Tasks: 281 total, 1 running, 280 sleeping, 0 stopped, 0 zombie
Cpu(s): 17.8% us, 7.8% sy, 0.0% ni, 17.9% id, 55.6% wa, 0.1% hi, 0.7% si
Mem: 3703588k total, 3459360k used, 244228k free, 64692k buffers
Swap: 2040244k total, 18568k used, 2021676k free, 329372k cached

PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND
13891 mysql 16 0 390m 172m 3764 S 4 4.8 15:32.01 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/apollo.avrilbandaids.com.pid
14935 nobody 16 0 236m 26m 19m S 4 0.7 0:05.11 /usr/local/apache/bin/httpd -k start -DSSL
4715 root 17 0 6420 1356 848 S 2 0.0 0:37.54 top
17201 nobody 16 0 234m 16m 10m S 2 0.4 0:00.30 /usr/local/apache/bin/httpd -k start -DSSL
17723 root 15 0 6284 1196 764 R 2 0.0 0:00.02 top -cSb n 1
1 root 16 0 4756 548 456 S 0 0.0 87:50.81 init [3]
2 root RT 0 0 0 0 S 0 0.0 0:00.00 [migration/0]
3 root 34 19 0 0 0 S 0 0.0 0:00.00 [ksoftirqd/0]
4 root RT 0 0 0 0 S 0 0.0 0:00.00 [migration/1]
5 root 34 19 0 0 0 S 0 0.0 0:00.00 [ksoftirqd/1]
6 root 5 -10 0 0 0 S 0 0.0 0:00.00 [events/0]
7 root 5 -10 0 0 0 S 0 0.0 0:00.01 [events/1]
8 root 5 -10 0 0 0 S 0 0.0 0:00.00 [khelper]
9 root 15 -10 0 0 0 S 0 0.0 0:00.00 [kacpid]
32 root 5 -10 0 0 0 S 0 0.0 0:00.00 [kblockd/0]
33 root 5 -10 0 0 0 S 0 0.0 0:00.00 [kblockd/1]
34 root 25 0 0 0 0 S 0 0.0 0:00.00 [khubd]
61 root 15 0 0 0 0 S 0 0.0 0:22.85 [kswapd0]
62 root 13 -10 0 0 0 S 0 0.0 0:00.00 [aio/0]
63 root 5 -10 0 0 0 S 0 0.0 0:00.00 [aio/1]
207 root 22 0 0 0 0 S 0 0.0 0:00.00 [kseriod]
439 root 5 -10 0 0 0 S 0 0.0 0:00.00 [ata/0]
440 root 5 -10 0 0 0 S 0 0.0 0:00.00 [ata/1]
441 root 8 -10 0 0 0 S 0 0.0 0:00.00 [ata_aux]
445 root 16 0 0 0 0 S 0 0.0 0:00.00 [scsi_eh_0]
446 root 15 0 0 0 0 S 0 0.0 0:00.00 [scsi_eh_1]
447 root 15 0 0 0 0 S 0 0.0 0:00.00 [scsi_eh_2]
448 root 15 0 0 0 0 S 0 0.0 0:00.00 [scsi_eh_3]
475 root 15 0 0 0 0 S 0 0.0 0:00.17 [kjournald]
1070 root 6 -10 0 0 0 S 0 0.0 0:00.00 [kauditd]
1835 root 6 -10 3608 452 372 S 0 0.0 0:01.76 udevd
2055 root 19 0 0 0 0 S 0 0.0 0:00.00 [kjournald]
2056 root 15 0 0 0 0 S 0 0.0 0:00.00 [kjournald]
2057 root 15 0 0 0 0 S 0 0.0 0:01.11 [kjournald]
2058 root 15 0 0 0 0 S 0 0.0 1:25.56 [kjournald]
2059 root 15 0 0 0 0 S 0 0.0 0:00.14 [kjournald]
2060 root 15 0 0 0 0 S 0 0.0 0:01.21 [kjournald]
2751 root 15 0 4428 716 216 S 0 0.0 0:00.00 /sbin/dhclient -1 -q -lf /var/lib/dhcp/dhclient-eth1.leases -pf /var/run/dhclient-eth1.pid eth1
2848 root 16 0 3632 560 448 S 0 0.0 0:00.22 syslogd -m 0
2852 root 15 0 2540 372 296 S 0 0.0 0:00.00 klogd -x
2865 root 16 0 2552 304 204 S 0 0.0 0:00.02 irqbalance
2880 named 18 0 64884 3496 1888 S 0 0.1 0:01.60 /usr/sbin/named -u named
2928 root 15 0 2528 284 216 S 0 0.0 0:00.00 /usr/sbin/courierlogger -pid=/var/spool/authdaemon/pid -facility=mail -start /usr/libexec/courier-authlib/authdaemond
2929 root 16 0 9032 624 504 S 0 0.0 0:00.00 /usr/libexec/courier-authlib/authdaemond
2954 root 16 0 9032 216 96 S 0 0.0 0:00.00 /usr/libexec/courier-authlib/authdaemond
2955 root 16 0 9032 216 96 S 0 0.0 0:00.00 /usr/libexec/courier-authlib/authdaemond
2956 root 16 0 9032 216 96 S 0 0.0 0:00.00 /usr/libexec/courier-authlib/authdaemond
2957 root 16 0 9032 216 96 S 0 0.0 0:00.00 /usr/libexec/courier-authlib/authdaemond
2958 root 16 0 9032 216 96 S 0 0.0 0:00.00 /usr/libexec/courier-authlib/authdaemond
2999 root 17 0 2916 500 264 S 0 0.0 0:00.00 /usr/sbin/smartd
3008 root 19 0 2544 448 364 S 0 0.0 0:00.00 /usr/sbin/acpid
3017 root 16 0 72264 2208 1488 S 0 0.1 0:00.02 cupsd
3046 root 17 0 21924 1180 780 S 0 0.0 0:02.25 /usr/sbin/sshd
3102 root 16 0 64712 4084 1332 S 0 0.1 0:13.13 chkservd
3114 root 16 0 2528 284 216 S 0 0.0 0:00.00 /usr/sbin/courierlogger -pid=/var/run/imapd.pid -start -name=imapd /usr/lib/courier-imap/libexec/couriertcpd -address=0 -m
3115 root 16 0 4684 512 428 S 0 0.0 0:00.02 /usr/lib/courier-imap/libexec/couriertcpd -address=0 -maxprocs=50 -maxperip=30 -nodnslookup -noidentlookup 143 /usr/lib/co
3123 root 18 0 2528 200 140 S 0 0.0 0:00.00 /usr/sbin/courierlogger -pid=/var/run/imapd-ssl.pid -start -name=imapd-ssl /usr/lib/courier-imap/libexec/couriertcpd -addr
3124 root 21 0 4684 496 412 S 0 0.0 0:00.00 /usr/lib/courier-imap/libexec/couriertcpd -address=0 -maxprocs=50 -maxperip=30 -nodnslookup -noidentlookup 993 /usr/lib/co
3129 root 16 0 2528 284 216 S 0 0.0 0:00.00 /usr/sbin/courierlogger -pid=/var/run/pop3d.pid -start -name=pop3d /usr/lib/courier-imap/libexec/couriertcpd -address=0 -m
3130 root 16 0 4684 512 428 S 0 0.0 0:00.10 /usr/lib/courier-imap/libexec/couriertcpd -address=0 -maxprocs=50 -maxperip=30 -nodnslookup -noidentlookup 110 /usr/lib/co
3135 root 21 0 2528 200 140 S 0 0.0 0:00.00 /usr/sbin/courierlogger -pid=/var/run/pop3d-ssl.pid -start -name=pop3d-ssl /usr/lib/courier-imap/libexec/couriertcpd -addr
3136 root 22 0 4684 496 412 S 0 0.0 0:00.00 /usr/lib/courier-imap/libexec/couriertcpd -address=0 -maxprocs=50 -maxperip=30 -nodnslookup -noidentlookup 995 /usr/lib/co
3203 mailnull 16 0 29204 1028 644 S 0 0.0 0:40.00 /usr/sbin/exim -bd -q60m
3208 mailnull 21 0 29204 964 580 S 0 0.0 0:00.00 /usr/sbin/exim -tls-on-connect -bd -oX 465
3227 root 16 0 162m 122m 960 S 0 3.4 0:04.29 /usr/sbin/clamd
3256 root 16 0 71076 38m 2344 S 0 1.1 0:33.07 /usr/bin/spamd -d --allowed-ips=127.0.0.1 --pidfile=/var/run/spamd.pid --max-children=5
3301 root 16 0 77444 45m 2428 S 0 1.3 0:12.57 spamd child
3310 root 16 0 63988 1224 876 S 0 0.0 0:00.59 pure-ftpd (SERVER)
3313 root 16 0 62684 728 600 S 0 0.0 0:00.25 /usr/sbin/pure-authd -s /var/run/ftpd.sock -r /usr/sbin/pureauth
3331 root 16 0 57084 1008 576 S 0 0.0 0:25.46 crond
3425 xfs 16 0 9768 1260 760 S 0 0.0 0:00.00 xfs -droppriv -daemon
3534 root 16 0 25856 7552 1872 S 0 0.2 0:02.01 tailwatchd
3626 root 16 0 28444 8232 1216 S 0 0.2 0:00.06 cPhulkd - processor
3660 root 15 0 51384 11m 440 S 0 0.3 0:00.00 cpdavd - accepting connections on 2077 and 2078
3681 root 34 19 45424 16m 2052 S 0 0.4 0:04.53 cpanellogd - sleeping for logs
3707 nobody 15 0 14204 2332 624 S 0 0.1 0:00.00 entropychat
3761 dbus 15 0 20948 968 760 S 0 0.0 0:00.01 dbus-daemon-1 --system
3773 root 16 0 15228 2484 1276 S 0 0.1 0:01.99 hald
3796 root 18 0 2548 308 236 S 0 0.0 0:00.00 /usr/sbin/portsentry -tcp
3849 root 16 0 68980 11m 1080 S 0 0.3 0:00.86 cpsrvd - waiting for connections
3922 root 16 0 36720 7740 1456 S 0 0.2 0:00.00 /usr/bin/perl /usr/local/webmin/miniserv.pl /etc/webmin/miniserv.conf
3926 root 18 0 2528 404 336 S 0 0.0 0:00.00 /sbin/mingetty tty1
3927 root 18 0 2528 404 336 S 0 0.0 0:00.00 /sbin/mingetty tty2
3928 root 18 0 2528 404 336 S 0 0.0 0:00.00 /sbin/mingetty tty3
3929 root 18 0 2528 404 336 S 0 0.0 0:00.00 /sbin/mingetty tty4
3930 root 18 0 2528 404 336 S 0 0.0 0:00.00 /sbin/mingetty tty5
3931 root 18 0 2528 404 336 S 0 0.0 0:00.00 /sbin/mingetty tty6
4614 root 16 0 38272 2680 2092 S 0 0.1 0:02.09 sshd: root@pts/0
4631 root 16 0 53984 1608 1204 S 0 0.0 0:00.11 -bash
13868 root 17 0 52772 1128 924 S 0 0.0 0:00.02 /bin/sh /usr/bin/mysqld_safe --datadir=/var/lib/mysql --pid-file=/var/lib/mysql/apollo.avrilbandaids.com.pid
13905 root 16 0 232m 8224 4576 S 0 0.2 7:05.11 /usr/local/apache/bin/httpd -k start -DSSL
13911 root 16 0 54700 2340 404 S 0 0.1 0:00.00 /usr/local/apache/bin/httpd -k start -DSSL
14084 nobody 15 0 236m 22m 15m D 0 0.6 0:05.73 /usr/local/apache/bin/httpd -k start -DSSL
14527 nobody 16 0 235m 27m 20m S 0 0.8 0:05.03 /usr/local/apache/bin/httpd -k start -DSSL
14605 nobody 15 0 235m 25m 18m S 0 0.7 0:05.75 /usr/local/apache/bin/httpd -k start -DSSL
14719 root 16 0 75424 43m 2388 S 0 1.2 0:00.86 spamd child
14747 nobody 17 0 236m 24m 17m S 0 0.7 0:03.45 /usr/local/apache/bin/httpd -k start -DSSL
14927 nobody 15 0 234m 22m 16m S 0 0.6 0:05.71 /usr/local/apache/bin/httpd -k start -DSSL
15068 nobody 15 0 236m 24m 17m S 0 0.7 0:04.04 /usr/local/apache/bin/httpd -k start -DSSL
15242 nobody 16 0 235m 23m 16m S 0 0.6 0:03.60 /usr/local/apache/bin/httpd -k start -DSSL
15244 nobody 16 0 235m 23m 16m S 0 0.6 0:04.47 /usr/local/apache/bin/httpd -k start -DSSL
15430 nobody 15 0 235m 23m 16m S 0 0.6 0:01.82 /usr/local/apache/bin/httpd -k start -DSSL
15444 nobody 16 0 234m 20m 14m S 0 0.6 0:02.81 /usr/local/apache/bin/httpd -k start -DSSL
15455 nobody 17 0 237m 26m 17m S 0 0.7 0:04.22 /usr/local/apache/bin/httpd -k start -DSSL
15476 nobody 15 0 235m 25m 17m S 0 0.7 0:02.60 /usr/local/apache/bin/httpd -k start -DSSL
15481 nobody 16 0 239m 26m 16m S 0 0.7 0:02.24 /usr/local/apache/bin/httpd -k start -DSSL
15484 nobody 16 0 239m 30m 21m S 0 0.9 0:03.37 /usr/local/apache/bin/httpd -k start -DSSL
15570 nobody 16 0 236m 23m 16m S 0 0.7 0:03.85 /usr/local/apache/bin/httpd -k start -DSSL
15747 nobody 15 0 239m 26m 15m S 0 0.7 0:01.27 /usr/local/apache/bin/httpd -k start -DSSL
16098 nobody 16 0 235m 22m 15m S 0 0.6 0:01.61 /usr/local/apache/bin/httpd -k start -DSSL
16103 nobody 15 0 236m 20m 12m D 0 0.6 0:05.56 /usr/local/apache/bin/httpd -k start -DSSL
16115 nobody 15 0 235m 20m 13m S 0 0.6 0:01.02 /usr/local/apache/bin/httpd -k start -DSSL
16120 nobody 15 0 239m 25m 14m S 0 0.7 0:01.78 /usr/local/apache/bin/httpd -k start -DSSL
16127 nobody 15 0 237m 22m 13m S 0 0.6 0:01.64 /usr/local/apache/bin/httpd -k start -DSSL
16130 nobody 16 0 239m 24m 13m S 0 0.7 0:01.33 /usr/local/apache/bin/httpd -k start -DSSL
16135 nobody 16 0 237m 24m 16m S 0 0.7 0:01.51 /usr/local/apache/bin/httpd -k start -DSSL
16138 nobody 16 0 235m 21m 14m S 0 0.6 0:01.24 /usr/local/apache/bin/httpd -k start -DSSL
16290 nobody 16 0 238m 23m 14m S 0 0.7 0:00.70 /usr/local/apache/bin/httpd -k start -DSSL
16310 nobody 15 0 234m 18m 13m S 0 0.5 0:01.05 /usr/local/apache/bin/httpd -k start -DSSL
16322 nobody 16 0 236m 21m 13m S 0 0.6 0:00.58 /usr/local/apache/bin/httpd -k start -DSSL
16324 nobody 15 0 235m 21m 14m S 0 0.6 0:01.12 /usr/local/apache/bin/httpd -k start -DSSL
16329 nobody 16 0 240m 22m 11m S 0 0.6 0:01.02 /usr/local/apache/bin/httpd -k start -DSSL
16330 nobody 15 0 239m 25m 13m S 0 0.7 0:01.42 /usr/local/apache/bin/httpd -k start -DSSL
16363 nobody 15 0 236m 20m 12m D 0 0.6 0:03.56 /usr/local/apache/bin/httpd -k start -DSSL
16372 nobody 17 0 240m 24m 12m S 0 0.7 0:00.71 /usr/local/apache/bin/httpd -k start -DSSL
16374 nobody 16 0 238m 21m 12m S 0 0.6 0:01.25 /usr/local/apache/bin/httpd -k start -DSSL
16380 nobody 16 0 235m 21m 14m S 0 0.6 0:00.95 /usr/local/apache/bin/httpd -k start -DSSL
16387 nobody 15 0 234m 19m 13m S 0 0.5 0:00.94 /usr/local/apache/bin/httpd -k start -DSSL
16397 nobody 15 0 234m 18m 12m S 0 0.5 0:00.72 /usr/local/apache/bin/httpd -k start -DSSL
16398 nobody 18 0 235m 11m 5592 D 0 0.3 0:03.08 /usr/local/apache/bin/httpd -k start -DSSL
16409 nobody 15 0 235m 20m 13m S 0 0.6 0:00.55 /usr/local/apache/bin/httpd -k start -DSSL
16410 nobody 16 0 235m 20m 14m S 0 0.6 0:01.76 /usr/local/apache/bin/httpd -k start -DSSL
16414 nobody 15 0 237m 22m 13m S 0 0.6 0:00.99 /usr/local/apache/bin/httpd -k start -DSSL
16431 nobody 15 0 237m 22m 14m S 0 0.6 0:01.75 /usr/local/apache/bin/httpd -k start -DSSL
16437 nobody 15 0 235m 20m 14m S 0 0.6 0:00.76 /usr/local/apache/bin/httpd -k start -DSSL
16453 nobody 15 0 235m 22m 15m S 0 0.6 0:00.47 /usr/local/apache/bin/httpd -k start -DSSL
16581 nobody 16 0 235m 17m 11m S 0 0.5 0:00.60 /usr/local/apache/bin/httpd -k start -DSSL
16597 nobody 15 0 235m 18m 11m S 0 0.5 0:00.99 /usr/local/apache/bin/httpd -k start -DSSL
16620 nobody 16 0 238m 25m 16m S 0 0.7 0:01.52 /usr/local/apache/bin/httpd -k start -DSSL
16622 nobody 16 0 235m 19m 13m S 0 0.6 0:00.76 /usr/local/apache/bin/httpd -k start -DSSL
16636 nobody 15 0 238m 22m 12m S 0 0.6 0:00.46 /usr/local/apache/bin/httpd -k start -DSSL
16637 nobody 15 0 239m 21m 11m S 0 0.6 0:00.89 /usr/local/apache/bin/httpd -k start -DSSL
16657 nobody 15 0 236m 20m 12m D 0 0.6 0:03.89 /usr/local/apache/bin/httpd -k start -DSSL
16660 nobody 15 0 234m 18m 12m S 0 0.5 0:00.39 /usr/local/apache/bin/httpd -k start -DSSL
16670 nobody 16 0 235m 21m 14m S 0 0.6 0:00.95 /usr/local/apache/bin/httpd -k start -DSSL
16680 nobody 16 0 240m 24m 13m S 0 0.7 0:00.50 /usr/local/apache/bin/httpd -k start -DSSL
16681 nobody 15 0 235m 17m 10m S 0 0.5 0:01.11 /usr/local/apache/bin/httpd -k start -DSSL
16682 nobody 16 0 235m 19m 12m S 0 0.5 0:01.00 /usr/local/apache/bin/httpd -k start -DSSL
16690 nobody 16 0 235m 19m 13m S 0 0.5 0:00.69 /usr/local/apache/bin/httpd -k start -DSSL
16694 nobody 16 0 238m 23m 14m S 0 0.7 0:00.44 /usr/local/apache/bin/httpd -k start -DSSL
16707 nobody 16 0 235m 19m 12m S 0 0.5 0:00.57 /usr/local/apache/bin/httpd -k start -DSSL
16708 nobody 16 0 238m 22m 13m S 0 0.6 0:00.92 /usr/local/apache/bin/httpd -k start -DSSL
16784 nobody 16 0 238m 19m 10m S 0 0.5 0:00.49 /usr/local/apache/bin/httpd -k start -DSSL
16791 nobody 16 0 235m 19m 12m S 0 0.5 0:00.85 /usr/local/apache/bin/httpd -k start -DSSL
16807 nobody 15 0 237m 21m 12m S 0 0.6 0:00.37 /usr/local/apache/bin/httpd -k start -DSSL
16808 nobody 16 0 239m 23m 12m S 0 0.6 0:00.28 /usr/local/apache/bin/httpd -k start -DSSL
16837 nobody 15 0 234m 19m 13m S 0 0.5 0:01.20 /usr/local/apache/bin/httpd -k start -DSSL
16838 nobody 15 0 235m 19m 12m S 0 0.5 0:01.11 /usr/local/apache/bin/httpd -k start -DSSL
16850 nobody 16 0 235m 19m 12m S 0 0.5 0:00.47 /usr/local/apache/bin/httpd -k start -DSSL
16853 nobody 16 0 238m 19m 10m S 0 0.5 0:00.42 /usr/local/apache/bin/httpd -k start -DSSL
16959 nobody 15 0 234m 16m 10m S 0 0.5 0:00.58 /usr/local/apache/bin/httpd -k start -DSSL
16967 nobody 16 0 235m 18m 11m S 0 0.5 0:00.28 /usr/local/apache/bin/httpd -k start -DSSL
16968 nobody 15 0 234m 18m 13m S 0 0.5 0:00.24 /usr/local/apache/bin/httpd -k start -DSSL
16971 nobody 15 0 234m 17m 11m S 0 0.5 0:00.35 /usr/local/apache/bin/httpd -k start -DSSL
16977 nobody 15 0 234m 17m 11m S 0 0.5 0:00.56 /usr/local/apache/bin/httpd -k start -DSSL
16979 nobody 16 0 235m 19m 13m S 0 0.5 0:00.10 /usr/local/apache/bin/httpd -k start -DSSL
16984 nobody 15 0 234m 16m 10m S 0 0.5 0:00.54 /usr/local/apache/bin/httpd -k start -DSSL
16985 nobody 15 0 234m 16m 10m S 0 0.5 0:00.68 /usr/local/apache/bin/httpd -k start -DSSL
16986 nobody 16 0 235m 20m 13m S 0 0.6 0:00.32 /usr/local/apache/bin/httpd -k start -DSSL
16993 nobody 16 0 235m 18m 11m S 0 0.5 0:00.85 /usr/local/apache/bin/httpd -k start -DSSL
16994 nobody 16 0 235m 19m 12m S 0 0.5 0:00.18 /usr/local/apache/bin/httpd -k start -DSSL
17005 nobody 16 0 235m 17m 11m S 0 0.5 0:00.24 /usr/local/apache/bin/httpd -k start -DSSL
17006 nobody 15 0 235m 18m 11m S 0 0.5 0:00.33 /usr/local/apache/bin/httpd -k start -DSSL
17008 nobody 16 0 235m 16m 10m S 0 0.5 0:00.15 /usr/local/apache/bin/httpd -k start -DSSL
17015 nobody 16 0 234m 12m 7012 S 0 0.3 0:00.05 /usr/local/apache/bin/httpd -k start -DSSL
17017 nobody 15 0 234m 17m 12m S 0 0.5 0:00.31 /usr/local/apache/bin/httpd -k start -DSSL
17018 nobody 15 0 234m 17m 11m S 0 0.5 0:00.71 /usr/local/apache/bin/httpd -k start -DSSL
17019 nobody 15 0 238m 20m 11m S 0 0.6 0:00.29 /usr/local/apache/bin/httpd -k start -DSSL
17022 nobody 16 0 236m 20m 13m S 0 0.6 0:00.38 /usr/local/apache/bin/httpd -k start -DSSL
17055 nobody 16 0 238m 20m 11m S 0 0.6 0:00.52 /usr/local/apache/bin/httpd -k start -DSSL
17062 nobody 16 0 235m 17m 10m S 0 0.5 0:00.22 /usr/local/apache/bin/httpd -k start -DSSL
17074 nobody 16 0 238m 19m 10m S 0 0.5 0:00.07 /usr/local/apache/bin/httpd -k start -DSSL
17078 nobody 16 0 235m 17m 10m S 0 0.5 0:00.21 /usr/local/apache/bin/httpd -k start -DSSL
17079 nobody 15 0 235m 17m 10m S 0 0.5 0:01.15 /usr/local/apache/bin/httpd -k start -DSSL
17085 nobody 16 0 236m 19m 12m S 0 0.5 0:00.27 /usr/local/apache/bin/httpd -k start -DSSL
17086 nobody 15 0 238m 20m 11m S 0 0.6 0:00.74 /usr/local/apache/bin/httpd -k start -DSSL
17093 nobody 16 0 235m 19m 12m S 0 0.5 0:00.48 /usr/local/apache/bin/httpd -k start -DSSL
17094 nobody 16 0 235m 20m 13m S 0 0.6 0:00.66 /usr/local/apache/bin/httpd -k start -DSSL
17095 nobody 16 0 237m 20m 11m S 0 0.6 0:00.35 /usr/local/apache/bin/httpd -k start -DSSL
17098 nobody 16 0 235m 17m 10m S 0 0.5 0:00.25 /usr/local/apache/bin/httpd -k start -DSSL
17101 nobody 15 0 233m 11m 6888 S 0 0.3 0:00.10 /usr/local/apache/bin/httpd -k start -DSSL
17109 nobody 16 0 236m 19m 12m S 0 0.6 0:00.43 /usr/local/apache/bin/httpd -k start -DSSL
17119 nobody 15 0 235m 18m 11m S 0 0.5 0:00.28 /usr/local/apache/bin/httpd -k start -DSSL
17121 nobody 16 0 238m 19m 10m S 0 0.5 0:00.22 /usr/local/apache/bin/httpd -k start -DSSL
17123 nobody 16 0 235m 16m 9984 S 0 0.4 0:00.11 /usr/local/apache/bin/httpd -k start -DSSL
17124 nobody 15 0 237m 17m 10m S 0 0.5 0:00.23 /usr/local/apache/bin/httpd -k start -DSSL
17125 nobody 15 0 234m 17m 11m S 0 0.5 0:00.63 /usr/local/apache/bin/httpd -k start -DSSL
17126 nobody 16 0 238m 18m 9.8m S 0 0.5 0:00.39 /usr/local/apache/bin/httpd -k start -DSSL
17128 nobody 15 0 236m 17m 10m S 0 0.5 0:00.16 /usr/local/apache/bin/httpd -k start -DSSL
17133 nobody 15 0 240m 24m 12m S 0 0.7 0:00.63 /usr/local/apache/bin/httpd -k start -DSSL
17134 nobody 18 0 235m 11m 5592 D 0 0.3 0:03.48 /usr/local/apache/bin/httpd -k start -DSSL
17135 nobody 16 0 234m 17m 12m S 0 0.5 0:00.14 /usr/local/apache/bin/httpd -k start -DSSL
17137 nobody 15 0 234m 16m 10m S 0 0.5 0:00.53 /usr/local/apache/bin/httpd -k start -DSSL
17138 nobody 15 0 234m 15m 10m S 0 0.4 0:00.15 /usr/local/apache/bin/httpd -k start -DSSL
17151 nobody 15 0 234m 18m 13m S 0 0.5 0:00.42 /usr/local/apache/bin/httpd -k start -DSSL
17166 nobody 15 0 235m 19m 12m S 0 0.5 0:00.29 /usr/local/apache/bin/httpd -k start -DSSL
17167 nobody 15 0 234m 16m 10m S 0 0.5 0:00.80 /usr/local/apache/bin/httpd -k start -DSSL
17172 root 15 0 0 0 0 S 0 0.0 0:00.14 [pdflush]
17178 nobody 16 0 234m 11m 5940 S 0 0.3 0:00.07 /usr/local/apache/bin/httpd -k start -DSSL
17182 nobody 16 0 234m 10m 6000 S 0 0.3 0:00.23 /usr/local/apache/bin/httpd -k start -DSSL
17183 nobody 16 0 234m 16m 10m S 0 0.5 0:00.34 /usr/local/apache/bin/httpd -k start -DSSL
17185 nobody 16 0 235m 17m