Hello Heikki,
Wednesday, November 21, 2001, 8:34:13 PM, you wrote:
I see some more users are interested in optimize table to work.
Why don't you just map OPTIMIZE TABLE to ALTER TABLE for INNODB tables
so user may not care about table type, there currently one should
check the table type and use
Hi!
>On Wed, 2001-11-21 at 05:19, Heikki Tuuri wrote:
>> The way to defragment InnoDB tables, or tables in any database, is from time
>> to time to dump and reimport them. That can give a significant performance
>> boost.
>>
>
>That is actually not entirely true. For MyISAM tables, one simply n
On Wed, 2001-11-21 at 05:19, Heikki Tuuri wrote:
> The way to defragment InnoDB tables, or tables in any database, is from time
> to time to dump and reimport them. That can give a significant performance
> boost.
>
That is actually not entirely true. For MyISAM tables, one simply needs
to run
and reimport them. That can give a significant performance
boost.
Regards,
Heikki
-Original Message-
From: nsabbi <[EMAIL PROTECTED]>
To: Heikki Tuuri <[EMAIL PROTECTED]>
Cc: [EMAIL PROTECTED] <[EMAIL PROTECTED]>
Date: Wednesday, November 21, 2001 11:37 AM
Subject: inno
HI,
I have two problems:
1)
I have the following table:
desc users;
+--+--+--+-+-+---+
| Field| Type | Null | Key | Default | Extra |
+--+--+--+-+-+---+
| username | varchar(128) | | PRI |