Migration 4.0 to 4.1 performance problem
Hi,
I host a big french website including forum (phpbb), search engine (mnogo), album (smartor), blogs... around 780Mo in MySQL
Everything work fine with my old configuration :
- One SQL/mail server bi-Xeon, 2.6Ghz, 3Go :
........FC4, MySQL 4.0, Postfix-Mysql, Courier-imap Mysql
- One front server vi-Xeon, 2.2Gh, 2Go :
.......FC2, Apache 1.33, php 4.4.0
Yersterday, I decided to update from mysql 4.0 to mysql 4.1.
I simply use "rpm -Uv MySQL-server....rpm"
Since this update, I see many mysql_too_many_connection.
So I deciede to increase this setting in my my.cnf from 500 to 1000.
But I don't know why Mysql is so slow to return query.
The server keep a low load average around 1-2 and CPU's usage around 20%.
I also try to use Fedora RPM, But problem is still present.
Please help me, my visitors become crazy ;-)
Below, I paste my different data :
Thanks.
Ben
### /etc/my.cnf
[mysqld]
port = 3306
socket = /var/lib/mysql/mysql.sock
skip-locking
key_buffer = 384M
max_allowed_packet = 1M
table_cache = 512
sort_buffer_size = 2M
read_buffer_size = 2M
read_rnd_buffer_size = 8M
myisam_sort_buffer_size = 64M
thread_cache = 60
query_cache_size = 32M
# Try number of CPU's*2 for thread_concurrency
thread_concurrency = 8
#log=/home/logs/mysql_log
max_connections = 1200
log_error = /var/lib/mysql/mysql_error_log
old_passwords=1
### mysqlreport
MySQL 4.1.12 uptime 0 0:47:27 Tue Sep 13 00:06:40 2005
__ Key _________________________________________________________________
Buffer usage 18.51M of 384.00M %Used: 4.82
Write ratio 0.42
Read ratio 0.00
__ Questions ___________________________________________________________
Total 2.39M 838.96/s
Slow 0 0.00/s %Total: 0.00 %DMS: 0.00
DMS 381.82k 134.11/s 15.99
__ Table Locks _________________________________________________________
Waited 18.69k 6.57/s %Total: 3.88
Immediate 462.66k 162.51/s
__ Tables ______________________________________________________________
Open 512 of 512 %Cache: 100.00
Opened 895 0.31/s
__ Connections _________________________________________________________
Max used 704 of 1200 %Max: 58.67
Total 275.89k 96.91/s
__ Created Temp ________________________________________________________
Disk table 5.98k 2.10/s
Table 17.80k 6.25/s
File 7 0.00/s
### top
top - 00:02:46 up 5:38, 3 users, load average: 1.84, 1.71, 1.50
Tasks: 165 total, 1 running, 164 sleeping, 0 stopped, 0 zombie
Cpu(s): 9.8% us, 2.4% sy, 0.0% ni, 87.0% id, 0.4% wa, 0.1% hi, 0.3% si
Mem: 3115044k total, 3036040k used, 79004k free, 545064k buffers
Swap: 2031608k total, 0k used, 2031608k free, 620516k cached