PDA

View Full Version : Crazy MySQL overheads?!


BaussDesigns
01-16-2011, 04:34 PM
Lately, my forum has started lagging hard and loading times have significantly increased (Well, in most cases it doesn't load the page at all). While other sites ran fine, I looked at my mysql DB figures and saw that:

http://www.upload.ee/image/1056559/overhead.png


I've tried repairing-fixing those tables, but it does nothing, the figures stay and for all those tables with 53mb overhead, it says "Note: Table does not support optimize, doing recreate + analyze instead".



Can anyone please assist me?

snakes1100
01-17-2011, 09:11 PM
Those be INNODB tables, anal-ize those to rebuild/opt them.

benstillman
01-19-2011, 06:20 PM
Those be INNODB tables, anal-ize those to rebuild/opt them.

LOL

I'm slipping that into my next project report.