Home »
General »
Database discussions »
Performance Problems MySql (Performance Problems MySql)
Performance Problems MySql [message #40202] |
Tue, 22 January 2008 10:41 |
burton314
Messages: 1 Registered: January 2008
Karma:
|
Junior Member |
|
|
I would be grateful if anyone could give me a hint on why the performance of my MySql Server is that weak. I attached a report of mysqlreport.
Thank you.Jörg
MySQL 4.1.10a uptime 0 15:49:3 Tue Jan 22 09:18:49 2008
__ Key _________________________________________________________________
Buffer used 63.00k of 16.00M %Used: 0.38
Current 1.89M %Usage: 11.82
Write hit 99.76%
Read hit 99.38%
__ Questions ___________________________________________________________
Total 265.73k 4.7/s
DMS 257.09k 4.5/s %Total: 96.75
Com_ 5.38k 0.1/s 2.03
COM_QUIT 3.21k 0.1/s 1.21
+Unknown 46 0.0/s 0.02
Slow (10) 781 0.0/s 0.29 %DMS: 0.30 Log: OFF
DMS 257.09k 4.5/s 96.75
SELECT 249.38k 4.4/s 93.85 97.00
UPDATE 4.10k 0.1/s 1.54 1.60
INSERT 3.60k 0.1/s 1.35 1.40
DELETE 18 0.0/s 0.01 0.01
REPLACE 0 0/s 0.00 0.00
Com_ 5.38k 0.1/s 2.03
change_db 3.22k 0.1/s 1.21
show_tables 538 0.0/s 0.20
set_option 529 0.0/s 0.20
__ SELECT and Sort _____________________________________________________
Scan 98.55k 1.7/s %SELECT: 39.52
Range 0 0/s 0.00
Full join 16.20k 0.3/s 6.50
Range check 0 0/s 0.00
Full rng join 0 0/s 0.00
Sort scan 27.52k 0.5/s
Sort range 3.04k 0.1/s
Sort mrg pass 0 0/s
__ Table Locks _________________________________________________________
Waited 495 0.0/s %Total: 0.15
Immediate 325.38k 5.7/s
__ Tables ______________________________________________________________
Open 64 of 64 %Cache: 100.00
Opened 3.53k 0.1/s
__ Connections _________________________________________________________
Max used 30 of 100 %Max: 30.00
Total 3.22k 0.1/s
__ Created Temp ________________________________________________________
Disk table 6.23k 0.1/s
Table 10.14k 0.2/s Size: 32.0M
File 3 0.0/s
__ Threads _____________________________________________________________
Running 3 of 3
Cached 0 of 0 %Hit: 0.03
Created 3.22k 0.1/s
Slow 0 0/s
__ Aborted _____________________________________________________________
Clients 18 0.0/s
Connects 1 0.0/s
__ Bytes _______________________________________________________________
Sent 528.09M 9.3k/s
Received 56.95M 1.0k/s
|
|
|
Goto Forum:
Current Time: Mon Dec 02 17:59:10 GMT 2024
Total time taken to generate the page: 0.03987 seconds