MySQL help

software development

#1

Hi,

I’m trying to track down a problem I’ve been having with my site running slow. I’m pretty sure the problem is somewhere in the mySQL accesses so I’ve been trying to see if anyone can offer me some tips with MySQL troubleshooting.

Also, while I was looking around in the panel I noticed this report for MySQL usage and it seems a little odd…

Day Disk Usage Connects Queries (Conueries) (Ratio)
2008-09-15 222.871 MB 194 804 0.006 MCn 0.166
2008-09-16 222.871 MB 1943 142016 0.191 MCn 2.924
2008-09-17 222.496 MB 886 11383 0.034 MCn 0.514
2008-09-18 222.863 MB 2683 145534 0.213 MCn 2.170
2008-09-19 223.348 MB 954 12317 0.036 MCn 0.516
2008-09-20 223.465 MB 1585 14338 0.054 MCn 0.362
2008-09-21 223.738 MB 4927 163343 0.287 MCn 1.326
2008-09-22 223.488 MB 2373 23972 0.083 MCn 0.404
2008-09-23 223.246 MB 1049 14436 0.041 MCn 0.550
2008-09-24 224.043 MB 2668 27365 0.094 MCn 0.410
2008-09-25 224.473 MB 880 6422 0.028 MCn 0.292
2008-09-26 224.684 MB 1416 127747 0.163 MCn 3.609
2008-09-27 224.684 MB 459 2627 0.014 MCn 0.229
2008-09-28 224.715 MB 1522 9436 0.047 MCn 0.248
2008-09-29 224.652 MB 1527 16161 0.054 MCn 0.423
2008-09-30 224.395 MB 1144 10405 0.039 MCn 0.364
2008-10-01 225.082 MB 2609 148366 0.214 MCn 2.275
2008-10-02 221.535 MB 1174 11156 0.041 MCn 0.380
2008-10-03 221.645 MB 3147 31174 0.110 MCn 0.396
2008-10-04 221.949 MB 4014 36811 0.137 MCn 0.367
2008-10-05 222.395 MB 857 9272 0.031 MCn 0.433
2008-10-06 222.121 MB 0.000 MCn 1.000
2008-10-07 224.918 MB 10453 21411 0.283 MCn 0.082
2008-10-08 224.918 MB 6449 252559 0.414 MCn 1.567
2008-10-09 226.160 MB 2695 127450 0.195 MCn 1.892
Totals: 223.630 MB 57608 1366505 2.807 MCn 0.949

The hot and cold days on this report do not seem to correspond to hot and cold days on overall site usage. My site usage remains fairly constant from day to day.

Is there any way to determine what pages are generating so many queries? Is there a way to determine if anything I’m doing is causing queries to be returned so slowly?

Thanks!