MySQL Forums
Forum List  »  Performance

Migration 4.0 to 4.1 performance problem
Posted by: Benjamin Fabre
Date: September 12, 2005 04:08PM

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

Options: ReplyQuote


Subject
Views
Written By
Posted
Migration 4.0 to 4.1 performance problem
1931
September 12, 2005 04:08PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.