0

Possible Duplicate:
In MySQL what does “Overhead” mean, what is bad about it, and how to fix it?

enter image description here

Hi experts,

As you can see there is an overhead warning.The table is actually contain no data at all..

I keep getting this warning so often..I wonder is mysql really overhead or it just phpMyadmin thinggy..

Sure when i optimize the table, the overhead warning is gone..But after some insertion and deletion (u know during develope some feature), the overhead warning will show up again.

Im really curious why is this happening..Any insight is greatly appreciated

Community
  • 1
  • 1
slier
  • 6,511
  • 6
  • 36
  • 55
  • i'm not an expert on the subject, but i think that overhead comes from things like indexes, or maybe cached or outdated data. i wouldn't worry about it too much; you can optimize your table once in awhile or maybe set up a cron. – mpen Jan 04 '13 at 17:06
  • @Mark is there any performance impact sir? – slier Jan 04 '13 at 17:07
  • Are we seriously talking about the performance impact of *18 bytes*? – DCoder Jan 04 '13 at 17:11
  • @DCoder im really sucky at database, yeah my question might look silly..im taking an effort to learn as much as i can about mysql..thx for ur input – slier Jan 04 '13 at 17:13
  • phpmyadmin is likely doing a comparison between your data usage and your overhead, and right now it thinks that the table is 100% overhead. It's technically correct, since it's empty, but that doesn't mean that it's anything to worry about. – Sammitch Jan 04 '13 at 17:47

1 Answers1

1

PHPmyAdmin is likely doing a comparison between your data usage and your overhead, and right now it thinks that the table is 100% overhead. It's technically correct, since it's empty, but that doesn't mean that it's anything to worry about.

Sammitch
  • 30,782
  • 7
  • 50
  • 77