MySQL Forums
Forum List  »  Italian

server linux va in blocco
Posted by: Damiano Sly
Date: June 05, 2009 01:47PM

Salve a tutti,

ultimamente il mio server dedicato va spesso in crash...mysql viene utilizzato pesantemente. La macchina ha 4GB e viene quasi sempre usata tutta quanta.

Vorrei capire se posso ottimizzare mysql, questo il report che mi da mysqlreport, mi potete dare qualche dritta?



MySQL 5.0.45 uptime 2 11:4:35 Fri Jun 5 23:11:06 2009

__ Key _________________________________________________________________
Buffer used 7.08M of 8.00M %Used: 88.48
Current 7.98M %Usage: 99.76
Write hit 98.69%
Read hit 99.99%

__ Questions ___________________________________________________________
Total 1.91M 9.0/s
DMS 1.68M 7.9/s %Total: 87.97
Com_ 156.73k 0.7/s 8.19
COM_QUIT 73.04k 0.3/s 3.82
+Unknown 478 0.0/s 0.02
Slow 10 s 0 0/s 0.00 %DMS: 0.00 Log: OFF
DMS 1.68M 7.9/s 87.97
SELECT 1.67M 7.9/s 87.51 99.48
UPDATE 5.78k 0.0/s 0.30 0.34
INSERT 1.89k 0.0/s 0.10 0.11
DELETE 1.04k 0.0/s 0.05 0.06
REPLACE 21 0.0/s 0.00 0.00
Com_ 156.73k 0.7/s 8.19
change_db 94.50k 0.4/s 4.94
set_option 57.40k 0.3/s 3.00
show_fields 1.04k 0.0/s 0.05

__ SELECT and Sort _____________________________________________________
Scan 105.11k 0.5/s %SELECT: 6.28
Range 155.00k 0.7/s 9.26
Full join 1 0.0/s 0.00
Range check 0 0/s 0.00
Full rng join 0 0/s 0.00
Sort scan 230.11k 1.1/s
Sort range 114.65k 0.5/s
Sort mrg pass 508 0.0/s

__ Table Locks _________________________________________________________
Waited 116 0.0/s %Total: 0.01
Immediate 2.10M 9.9/s

__ Tables ______________________________________________________________
Open 64 of 64 %Cache: 100.00
Opened 7.54k 0.0/s

__ Connections _________________________________________________________
Max used 22 of 100 %Max: 22.00
Total 73.05k 0.3/s

__ Created Temp ________________________________________________________
Disk table 121.69k 0.6/s
Table 230.82k 1.1/s Size: 32.0M
File 1.04k 0.0/s

__ Threads _____________________________________________________________
Running 2 of 2
Cached 0 of 0 %Hit: 0
Created 73.05k 0.3/s
Slow 38 0.0/s

__ Aborted _____________________________________________________________
Clients 22 0.0/s
Connects 10 0.0/s

__ Bytes _______________________________________________________________
Sent 791.71M 3.7k/s
Received 806.45M 3.8k/s

__ InnoDB Buffer Pool __________________________________________________
Usage 4.28M of 8.00M %Used: 53.52
Read hit 99.70%
Pages
Free 238 %Total: 46.48
Data 273 53.32 %Drty: 0.00
Misc 1 0.20
Latched 0 0.00
Reads 81.48k 0.4/s
From file 243 0.0/s 0.30
Ahead Rnd 3 0.0/s
Ahead Sql 1 0.0/s
Writes 1.39k 0.0/s
Flushes 321 0.0/s
Wait Free 0 0/s

__ InnoDB Lock _________________________________________________________
Waits 0 0/s
Current 0
Time acquiring
Total 0 ms
Average 0 ms
Max 0 ms

__ InnoDB Data, Pages, Rows ____________________________________________
Data
Reads 378 0.0/s
Writes 604 0.0/s
fsync 439 0.0/s
Pending
Reads 0
Writes 0
fsync 0

Pages
Created 1 0.0/s
Read 272 0.0/s
Written 321 0.0/s

Rows
Deleted 90 0.0/s
Inserted 21 0.0/s
Read 20.58k 0.1/s
Updated 181 0.0/s

Options: ReplyQuote


Subject
Views
Written By
Posted
server linux va in blocco
3782
June 05, 2009 01:47PM


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.