Re: Linear MySQL Slow Downs Over Time

[Shawn Hogan]

Well EXPLAIN isn't a whole lot of help because the queries being run are pretty well optimized (not doing table scans, etc.) Plus it's not like a bunch of different queries start running after awhile. The queries (and volume of queries) is the same at any given point in time. I've run mysqlreport, and really the only difference between when mysqld is first started and after it's been running awhile is "Waited" table lock percentage rises, slow query percentage rises, etc.

<rant>
At this point it's driving me crazy and is becoming more and more impractical to continue using MySQL. I would *gladly* pay anyone (someone within MySQL or otherwise) who can fix this for me somehow. Hell, I would pay someone at MySQL just to *look* at it (even if they couldn't fix it, and simply said I should use a different platform or something). I just want it to be stable without requiring a restart of the mysqld process once or twice a day.
</rant>