Help - Search - Members - Calendar
Full Version: Mysql Question... What Is Overhead?
Movable Type Community Forum > Installing and Upgrading > Databases
joed86
Hi,

I am going batty trying to figure out why I get so many mysql errors and why my MT blog takes so long to publish post, pages, comments, etc.

I was looking at mysql which I know absolutely nothing about, but I have nobody else to help me but myself because of yahoos bad customer service.

I noticed that in a few of the tables, especially the ones that have been leading to frequent connect errors or other errors, there is this column called overhead.

mt-entry 12,600 bytes
mt-comments 11,540 bytes
mt-trackbacks 12,235 bytes
mt-session 12,530 bytes

Whenever my MT installation keeps giving me problems, one or all of these tables say the words "in use". Because I once remember being told by Yahoo, I then check the box and click repair table.

The problem is fixed and my blog works fine for about the next 6-8 hours until the errors begin again.

Does anybody know what I can do??

Thanks,

Joe
http://metsmerizedonline.com
Su-
You'd do better to ask these questions here than here.
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here.
Invision Power Board © 2001-2009 Invision Power Services, Inc.