MySQL Forums
Forum List  »  Performance

Re: Poor MySql Performance
Posted by: Jim Grago
Date: September 22, 2005 09:25AM

Hello, Here is my report:

__ Key _________________________________________________________________
Buffer usage 106.22M of 600.00M %Used: 17.70
Write ratio 0.11
Read ratio 0.01

__ Questions ___________________________________________________________
Total 2.39M 274.43/s
Slow 335 0.04/s %Total: 0.01 %DMS: 0.03
DMS 1.08M 124.11/s 45.23

__ Table Locks _________________________________________________________
Waited 151.90k 17.45/s %Total: 12.62
Immediate 1.05M 120.80/s

__ Tables ______________________________________________________________
Open 300 of 300 %Cache: 100.00
Opened 74.57k 8.57/s

__ Connections _________________________________________________________
Max used 934 of 1024 %Max: 91.21
Total 243.65k 27.99/s

__ Created Temp ________________________________________________________
Disk table 1.56k 0.18/s
Table 59.41k 6.83/s
File 14 0.00/s

Thanks,
Jim

Options: ReplyQuote


Subject
Views
Written By
Posted
1959
September 21, 2005 01:20PM
1412
September 21, 2005 01:46PM
Re: Poor MySql Performance
1383
September 22, 2005 09:25AM
1468
September 22, 2005 01:34PM
1500
September 22, 2005 01:55PM
1416
September 22, 2005 03:39PM
1452
September 23, 2005 07:11AM
1444
September 23, 2005 11:06AM
1500
September 23, 2005 11:25AM
1371
September 23, 2005 12:00PM


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.