Hello,
I have trouble with mysql consuming too much CPU with
a few number of threads running. How could I reduce
the CPU usage ? I unterstand that, in plain charge the
CPU is high but why does it stay at that level when the
charge is becoming smaller ? The process seems in major
to be sleeping and must die after few minutes
(wait_timeout=250). Also other question is :
Should I reduce the number of threads running (is it done by
the way of reducing "max_connections" in my.cnf) ?
Could someone help ?
Config : mysql 3.23.36 Linux kernel 2.4 - 2 processors -
2 Go RAM (php+apache+mysql) - 100 max-links from
on each 3 webservers (in php.ini)
+--------------------------+------------+
| Variable_name | Value |
+--------------------------+------------+
| Aborted_clients | 3608 |
| Aborted_connects | 0 |
| Bytes_received | 434183878 |
| Bytes_sent | 1437881936 |
| Connections | 12387 |
| Created_tmp_disk_tables | 408 |
| Created_tmp_tables | 55294 |
| Created_tmp_files | 0 |
| Delayed_insert_threads | 0 |
| Delayed_writes | 0 |
| Delayed_errors | 0 |
| Flush_commands | 1 |
| Handler_delete | 524 |
| Handler_read_first | 16 |
| Handler_read_key | 28629764 |
| Handler_read_next | 1470906927 |
| Handler_read_prev | 0 |
| Handler_read_rnd | 2254162 |
| Handler_read_rnd_next | 451113758 |
| Handler_update | 365596 |
| Handler_write | 4046959 |
| Key_blocks_used | 20820 |
| Key_read_requests | 146486605 |
| Key_reads | 14735 |
| Key_write_requests | 69859 |
| Key_writes | 68907 |
| Max_used_connections | 351 |
| Not_flushed_key_blocks | 0 |
| Not_flushed_delayed_rows | 0 |
| Open_tables | 91 |
| Open_files | 123 |
| Open_streams | 0 |
| Opened_tables | 97 |
| Questions | 1742927 |
| Select_full_join | 0 |
| Select_full_range_join | 1792 |
| Select_range | 44809 |
| Select_range_check | 0 |
| Select_scan | 37202 |
| Slave_running | OFF |
| Slave_open_temp_tables | 0 |
| Slow_launch_threads | 0 |
| Slow_queries | 8 |
| Sort_merge_passes | 0 |
| Sort_range | 4146 |
| Sort_rows | 2253757 |
| Sort_scan | 31084 |
| Table_locks_immediate | 1686804 |
| Table_locks_waited | 2017 |
| Threads_cached | 44 |
| Threads_created | 441 |
| Threads_connected | 205 |
| Threads_running | 2 |
| Uptime | 60481 |
and /etc/my.cnf:
[mysqld]
port = 3306
socket = /var/lib/mysql/mysql.sock
datadir = /data/sqldata/mysql
log-slow-queries=/var/log/mysql_slow_queries.log
log-bin
#server-id=1
skip-locking
set-variable = key_buffer=768M
#set-variable = join_buffer_size=768M
set-variable = max_allowed_packet=3M
set-variable = table_cache=1024
set-variable = sort_buffer=768M
set-variable = record_buffer=128M
set-variable = thread_cache=80
set-variable = thread_concurrency=4 # Try number of CPU's*2
set-variable = myisam_sort_buffer_size=128M
set-variable = max_connections=1000
#set-variable = wait_timeout=600
#set-variable = interactive_timeout=600
set-variable = wait_timeout=250
set-variable = interactive_timeout=250
set-variable = max_connect_errors=1000
[mysql.server]
user=mysql
basedir=/var/lib
[safe_mysqld]
err-log=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
[mysqldump]
quick
set-variable = max_allowed_packet=16M
---------------------------------
Thanks in advance,
Jerome
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
