FUDforum: Database discussions » Performance Problems MySql

Home » General » Database discussions » Performance Problems MySql (Performance Problems MySql)

Show: Today's Messages :: Unread Messages :: Show Polls :: Message Navigator
| Subscribe to topic | Bookmark topic

Performance Problems MySql [message #40202]

Tue, 22 January 2008 05:41

burton314

Messages: 1
Registered: 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

Report message to a moderator

Rate author: +1 -1

Re: Performance Problems MySql [message #158014 is a reply to message #40202]

Mon, 19 January 2009 05:24

naudefj

Messages: 3690
Registered: December 2004

Karma: 20

Senior Member
Administrator
Core Developer

add to buddy list
ignore all messages by this user

Here is a useful script that will analyse your MySQL setup and recommend changes for increased performance and stability: http://wiki.mysqltuner.com/MySQLTuner

Report message to a moderator

Rate author: +1 -1