Re: High CPU Utilization

[Craig Dominaux]

Here is mysqlreport

not sure that the indexes I created helped but the removal of GROUP BY and ORDER BY did. :)

MySQL 4.1.13 uptime 0 21:25:43 Fri Sep 23 14:22:42 2005

__ Key _________________________________________________________________
Buffer usage 39.25M of 512.00M %Used: 7.67
Write ratio 0.90
Read ratio 0.00

__ Questions ___________________________________________________________
Total 3.03M 39.25/s
Slow 3.94k 0.05/s %Total: 0.13 %DMS: 1.78
DMS 221.35k 2.87/s 7.31
SELECT 190.83k 2.47/s 6.30 86.21
INSERT 14.20k 0.18/s 0.47 6.41
UPDATE 11.44k 0.15/s 0.38 5.17
DELETE 4.89k 0.06/s 0.16 2.21
REPLACE 0 0.00/s 0.00 0.00
Com_ 1.57M 20.36/s 51.89
change_db 1.56M 20.24/s 51.57
set_option 4.76k 0.06/s 0.16
begin 2.38k 0.03/s 0.08

__ SELECT and Sort _____________________________________________________
Scan 98 0.00/s %SELECT: 0.05
Range 49.55k 0.64/s 25.96
Full join 0 0.00/s 0.00
Range check 0 0.00/s 0.00
Full rng join 0 0.00/s 0.00
Sort scan 98 0.00/s
Sort range 30.36k 0.39/s
Sort mrg pass 0 0.00/s

__ Query Cache _________________________________________________________
Memory usage 825.90k of 32.00M %Used: 2.52
Block Fragmnt 35.06%
Hits 604.44k 7.84/s
Inserts 175.99k 2.28/s
Prunes 1 0.00/s
Insert:Prune175987.:1 2.28/s
Hit:Insert 3.43:1

__ Table Locks _________________________________________________________
Waited 25.54k 0.33/s %Total: 9.58
Immediate 241.03k 3.12/s

__ Tables ______________________________________________________________
Open 138 of 2457 %Cache: 0.56
Opened 160 0.00/s

__ Connections _________________________________________________________
Max used 64 of 1638 %Max: 0.39
Total 145.25k 1.88/s

__ Created Temp ________________________________________________________
Disk table 0 0.00/s
Table 0 0.00/s
File 1 0.00/s

__ Threads _____________________________________________________________
Created 1278 0.02/s
Slow 0 0.00/s

__ Aborted _____________________________________________________________
Clients 16 0.00/s
Connects 1 0.00/s

__ Bytes _______________________________________________________________
Sent 430.33M 5.58k/s
Received 230.29M 2.99k/s