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. --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
