At 9:35 -0700 4/19/02, Soheil Shaghaghi wrote:
>A few days ego, I asked the group about the meaning of the Overhead in sql.
>people were nice enough to answer me, and told me I needed to optimize the
>Here is what phpMyAdmin reports on the table:
>Space usage : Type Usage
>Data 1,602 KB
>Index 3,729 KB
>Overhead 24,718 Bytes
>Effective 5,307 KB
>Total 5,331 KB
>Now, when I try to optimize the table, OPTIMIZE TABLE USERS; I get this
>error: The handler for the table doesn't support check/repair
OPTIMIZE TABLE works only for MyISAM tables.
Is your table a different type?
>Does anyone know what the problem is here?