Re: Migration 4.0 to 4.1 performance problem

[Benjamin Fabre]

This is a very high number. I don't understand why, but it seems that queries/seconde has increase with the MySQL update. This is strange.

Below, the report you asked.

Thans for your help.

### ./mysqlreport -dms -com 5
MySQL 4.1.12 uptime 0 9:29:17 Tue Sep 13 08:48:30 2005

__ Key _________________________________________________________________
Buffer usage 29.91M of 384.00M %Used: 7.79
Write ratio 0.33
Read ratio 0.00

__ Questions ___________________________________________________________
Total 11.72M 343.26/s
Slow 0 0.00/s %Total: 0.00 %DMS: 0.00
DMS 1.80M 52.80/s 15.38
UPDATE 997.17k 29.19/s 8.50 55.29
SELECT 750.53k 21.97/s 6.40 41.61
INSERT 33.51k 0.98/s 0.29 1.86
DELETE 22.35k 0.65/s 0.19 1.24
REPLACE 0 0.00/s 0.00 0.00
Com_ 1.37M 39.98/s 11.65
change_db 1.36M 39.92/s 11.63
set_option 437 0.01/s 0.00
show_status 280 0.01/s 0.00
begin 274 0.01/s 0.00
commit 274 0.01/s 0.00

__ Table Locks _________________________________________________________
Waited 36.09k 1.06/s %Total: 1.58
Immediate 2.25M 65.85/s

__ Tables ______________________________________________________________
Open 512 of 512 %Cache: 100.00
Opened 1.06k 0.03/s

__ Connections _________________________________________________________
Max used 704 of 1200 %Max: 58.67
Total 1.28M 37.46/s

__ Created Temp ________________________________________________________
Disk table 28.27k 0.83/s
Table 87.37k 2.56/s
File 19 0.00/s