overheads in phpMyAdmin

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
CoreLEx
Forum Newbie
Posts: 10
Joined: Sun Jun 01, 2003 5:18 pm

overheads in phpMyAdmin

Post by CoreLEx »

hi guys,

I get the following in one of my tables:

Space usage : Type Usage
Data 1,388 Bytes
Index 2,048 Bytes
** Overhead 56 Bytes **
Effective 3,380 Bytes
Total 3,436 Bytes

"Overheads" appears in red. What does this mean?

Thanks.

CoreLEx
User avatar
Stoker
Forum Regular
Posts: 782
Joined: Thu Jan 23, 2003 9:45 pm
Location: SWNY
Contact:

Post by Stoker »

When you delete records it is still there using space...

OPTIMIZE TABLE mytable;
Post Reply