FUDforum
Fast Uncompromising Discussions. FUDforum will get your users talking.

Home » General » Database discussions » Performance Problems MySql (Performance Problems MySql)
Show: Today's Messages :: Polls :: Message Navigator
Switch to threaded view of this topic Create a new topic Submit Reply
Performance Problems MySql [message #40202] Tue, 22 January 2008 10:41 Go to next message
burton314 is currently offline  burton314   Germany
Messages: 1
Registered: January 2008
Karma: 0
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
Re: Performance Problems MySql [message #158014 is a reply to message #40202] Mon, 19 January 2009 10:24 Go to previous message
naudefj is currently offline  naudefj   South Africa
Messages: 3772
Registered: December 2004
Karma: 28
Senior Member
Administrator
Core Developer
Here is a useful script that will analyse your MySQL setup and recommend changes for increased performance and stability: http://wiki.mysqltuner.com/MySQLTuner
  Switch to threaded view of this topic Create a new topic Submit Reply
Previous Topic: mysql tmp tables created of size 5GB
Next Topic: table is crashed and should be repaired
Goto Forum:
  

-=] Back to Top [=-
[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Mon Dec 23 11:55:58 GMT 2024

Total time taken to generate the page: 0.02889 seconds