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/
