Home »
General »
Database discussions »
Performance Problems MySql (Performance Problems MySql)
Performance Problems MySql [message #40202 ]
Tue, 22 January 2008 05:41
burton314
Messages: 1Registered: January 2008
Karma: 0
Junior Member
add to buddy list ignore all messages by this user
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
Rate Topic
1 Worst
2
3
4
5 Best
Goto Forum:
- FUDforum FUDforum Documentation FUDforum Announcements FUDforum Installation Issues How To FUDforum Suggestions - FUDforum Development FUDforum 3.0+ Bug Reports Plugins and Code Hacks Converters Translations Forum Styles Icons & buttons Forum Showcase Marketplace - General General Chit Chat FUDforum in eGroupWare PHP discussions Database discussions HTML, Javascript, jQuery & AJAX Test Forum Test subforum 1 Test subforum 2 - Imported messages comp.lang.php
Current Time: Mon Apr 19 23:56:38 EDT 2021
Total time taken to generate the page: 0.00738 seconds