irocracer Posted December 20, 2005 Posted December 20, 2005 top - 14:59:59 up 9:07, 1 user, load average: 18.01, 10.46, 8.00 Tasks: 231 total, 3 running, 228 sleeping, 0 stopped, 0 zombie Cpu(s): 12.8% us, 5.8% sy, 0.0% ni, 1.5% id, 79.8% wa, 0.2% hi, 0.0% si Mem: 1026500k total, 533824k used, 492676k free, 2232k buffers Swap: 1028152k total, 9216k used, 1018936k free, 174272k cached PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND 6302 apache 15 0 93904 20m 11m R 4.3 2.0 0:00.13 httpd 30777 apache 16 0 93388 29m 21m S 2.7 3.0 0:05.83 httpd 30736 apache 15 0 93632 30m 22m S 2.0 3.1 0:05.48 httpd 6307 apache 17 0 93152 21m 13m S 1.3 2.1 0:00.09 httpd 6352 apache 17 0 93124 18m 11m S 1.3 1.9 0:00.04 httpd 39 root 15 0 0 0 0 D 0.7 0.0 1:20.71 kswapd0 25609 mysql 15 0 286m 75m 1992 D 0.7 7.5 0:08.75 mysqld 25814 mysql 15 0 286m 75m 1992 D 0.7 7.5 0:13.42 mysqld 30798 apache 15 0 93720 29m 20m S 0.7 2.9 0:05.82 httpd 2334 mysql 15 0 286m 75m 1992 D 0.7 7.5 0:04.61 mysqld 3262 mysql 15 0 286m 75m 1992 D 0.7 7.5 0:01.41 mysqld 3587 mysql 15 0 286m 75m 1992 D 0.7 7.5 0:02.31 mysqld 3599 mysql 15 0 286m 75m 1992 D 0.7 7.5 0:03.71 mysqld 4504 root 17 0 8648 1924 1528 S 0.7 0.2 0:00.28 exim 22432 mysql 15 0 286m 75m 1992 D 0.3 7.5 0:10.82 mysqld 25785 mysql 15 0 286m 75m 1992 D 0.3 7.5 0:08.62 mysqld 25863 mysql 15 0 286m 75m 1992 S 0.3 7.5 0:11.65 mysqld 2325 mysql 15 0 286m 75m 1992 D 0.3 7.5 0:02.09 mysqld 2802 mysql 15 0 286m 75m 1992 D 0.3 7.5 0:02.45 mysqld 2831 mysql 15 0 286m 75m 1992 D 0.3 7.5 0:02.52 mysqld 3003 mysql 18 0 286m 75m 1992 D 0.3 7.5 0:02.69 mysqld 3180 mysql 15 0 286m 75m 1992 D 0.3 7.5 0:06.77 mysqld 3594 mysql 15 0 286m 75m 1992 D 0.3 7.5 0:02.92 mysqld 3604 mysql 16 0 286m 75m 1992 S 0.3 7.5 0:04.62 mysqld 4056 root 16 0 2740 1052 744 R 0.3 0.1 0:02.47 top 4427 apache 15 0 93100 26m 18m S 0.3 2.6 0:01.40 httpd 5145 apache 16 0 93080 22m 14m S 0.3 2.2 0:00.68 httpd 5681 apache 16 0 93540 22m 13m S 0.3 2.2 0:00.29 httpd 6273 apache 16 0 91276 16m 10m S 0.3 1.6 0:00.01 httpd Server Spec Intel D 820 Dual Drive [ 120 WD 7200RPM:web | 80GB 7200 Hti 7200RPM: mysql ] both sata2 3.0gps 1 Gig Ram @ 533 DDr2 dual Channel my.cnf file [mysqld] skip-locking skip-innodb query_cache_limit=400K query_cache_size=8M query_cache_type=1 max_connections=700 interactive_timeout=80 wait_timeout=100 connect_timeout=10 thread_cache_size=60 key_buffer=150M join_buffer=1M max_allowed_packet=14M table_cache=384 record_buffer=700K sort_buffer_size=400K read_buffer_size=400K max_connect_errors=10 # Try number of CPU's*2 for thread_concurrency thread_concurrency=2 myisam_sort_buffer_size=54M log-bin server-id=1 [safe_mysqld] err-log=/var/log/mysqld.log open_files_limit=8192 [mysqldump] quick max_allowed_packet=16M [mysql] no-auto-rehash #safe-updates [isamchk] key_buffer=40M sort_buffer=40M read_buffer=10M write_buffer=10M [myisamchk] key_buffer=40M sort_buffer=40M read_buffer=10M write_buffer=10M [mysqlhotcopy] interactive-timeout httpd.conf Timeout 10 KeepAlive on MaxKeepAliveRequests 500 KeepAliveTimeout 1 MinSpareServers 5 MaxSpareServers 13 StartServers 8 MaxClients 450 MaxRequestsPerChild 1000 php.ini Output This program makes use of the Zend Scripting Language Engine: Zend Engine v1.3.0, Copyright © 1998-2004 Zend Technologies with eAccelerator v0.9.3, Copyright © 2004-2005 eAccelerator, by eAccelerator with Zend Extension Manager v1.0.8, Copyright © 2003-2005, by Zend Technologies with Zend Optimizer v2.5.10, Copyright © 1998-2005, by Zend Technologies Can Someone help ?
bfarber Posted December 21, 2005 Posted December 21, 2005 While those specs are quite technical, they don't really detail what your problem is... From the topic title I'm assuming your MySQL usage is causing a high server load. Run the query SHOW PROCESSLIST in your mysql command line when the server load starts spiking to find out what query is causing you problems. That would allow someone to give you a better idea of how to rectify the issue.
Recommended Posts
Archived
This topic is now archived and is closed to further replies.