Hi,
I've recently installed a MySQL 5.1.23-rc-log:
| version |
5.1.23-rc-log |
| version_comment | MySQL Community Server
(GPL) |
| version_compile_machine |
x86_64 |
| version_compile_os |
redhat-linux-gnu |
I noticed that I always have 2 processes runing on Linux doesn't matter the
amount of concurrent connections that is running on MySQL.
Due to that, MySQL is using only 1 CPU instead of using 8 CPUs that exist on
this machine:
linux$ ps aux | grep mysql
root 20327 0.0 0.0 64048 1272 ? S 10:05 0:00 /bin/sh
./bin/mysqld_safe --defaults-extra-file=/mysql/my.cnf --datadir=/mysql/data
--pid-file=/mysql/data/mysql.pid
mysql 20690 0.8 5.0 1571908 411772 ? Sl 10:05 3:09
/usr/local/mysql/bin/mysqld --defaults-extra-file=/mysql/my.cnf
--basedir=/usr/local/mysql --datadir=/mysql/data --user=mysql
--log-error=/mysql/log/orion-err.log --pid-file=/mysql/data/mysql.pid
--port=3306
linux$ uname -a
Linux orion.servers 2.6.18-92.1.1.el5 #1 SMP Thu May 22 09:01:47 EDT 2008
x86_64 x86_64 x86_64 GNU/Linux
linux$ top
top - 15:58:49 up 12:48, 6 users, load average: 0.24, 0.23, 0.13
Tasks: 183 total, 1 running, 182 sleeping, 0 stopped, 0 zombie
Cpu0 : 4.7%us, 0.3%sy, 0.0%ni, 94.6%id, 0.0%wa, 0.0%hi, 0.3%si, 0.0%st
Cpu1 : 0.0%us, 0.3%sy, 0.0%ni, 99.7%id, 0.0%wa, 0.0%hi, 0.0%si, 0.0%st
Cpu2 : 0.0%us, 0.3%sy, 0.0%ni, 99.7%id, 0.0%wa, 0.0%hi, 0.0%si, 0.0%st
Cpu3 : 0.0%us, 0.0%sy, 0.0%ni,100.0%id, 0.0%wa, 0.0%hi, 0.0%si, 0.0%st
Cpu4 : 0.0%us, 0.0%sy, 0.0%ni,100.0%id, 0.0%wa, 0.0%hi, 0.0%si, 0.0%st
Cpu5 : 0.0%us, 0.0%sy, 0.0%ni,100.0%id, 0.0%wa, 0.0%hi, 0.0%si, 0.0%st
Cpu6 : 0.0%us, 0.0%sy, 0.0%ni,100.0%id, 0.0%wa, 0.0%hi, 0.0%si, 0.0%st
Cpu7 : 0.0%us, 0.0%sy, 0.0%ni,100.0%id, 0.0%wa, 0.0%hi, 0.0%si, 0.0%st
Mem: 8178664k total, 3641540k used, 4537124k free, 217664k buffers
Swap: 8191992k total, 0k used, 8191992k free, 2443964k cached
I've checked the new option thread_handling, but it indicates that MySQL has 1
thread per connection:
mysql> show variables like 'thread_h%';
+-----------------+---------------------------+
| Variable_name | Value |
+-----------------+---------------------------+
| thread_handling | one-thread-per-connection |
+-----------------+---------------------------+
1 row in set (0.00 sec)
Does anybody has any hints about it?
Thanks in advance.
Best wishes,
Eber.
Abra sua conta no Yahoo! Mail, o único sem limite de espaço para
armazenamento!
http://br.mail.yahoo.com/
