List:General Discussion« Previous MessageNext Message »
From:Paul DuBois Date:April 19 2002 4:56pm
Subject:RE: Optimizing the table
View as plain text  
At 9:35 -0700 4/19/02, Soheil Shaghaghi wrote:
>Hi all,
>A few days ego, I asked the group about the meaning of the Overhead in sql.
>Some
>people were nice enough to answer me, and told me I needed to optimize the
>table.
>
>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:
>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?
>Thanks again.

Thread
RE: Optimizing the tableSoheil Shaghaghi19 Apr
  • RE: Optimizing the tablePaul DuBois19 Apr