Hello.
It depends on the table's type. For MyISAM see:
http://dev.mysql.com/doc/mysql/en/optimize-table.html
For InnoDB:
http://dev.mysql.com/doc/mysql/en/innodb-file-defragmenting.html
Seena Blace <[EMAIL PROTECTED]> wrote:
> [-- text/plain, encoding 7bit, charset: us-ascii, 9 li
dberg <[EMAIL PROTECTED]> wrote:
-Original Message-
From: Seena Blace [mailto:[EMAIL PROTECTED]]
Sent: den 11 maj 2005 23:58
To: mysql@lists.mysql.com
Subject: table optimisation
Hi,
I have been noticing table performanace issue when # of rows
grows more.How to tune that table?
Addin
How to check whae are tables are having how many indexes on which columns ?
Thomas Sundberg <[EMAIL PROTECTED]> wrote:
> -Original Message-
> From: Seena Blace [mailto:[EMAIL PROTECTED]
> Sent: den 11 maj 2005 23:58
> To: mysql@lists.mysql.com
> Subject: table opti
> -Original Message-
> From: Seena Blace [mailto:[EMAIL PROTECTED]
> Sent: den 11 maj 2005 23:58
> To: mysql@lists.mysql.com
> Subject: table optimisation
>
> Hi,
> I have been noticing table performanace issue when # of rows
> grows more.How to tune that
Hi,
I have been noticing table performanace issue when # of rows grows more.How to
tune that table?
thanks
-Seena
-
Do you Yahoo!?
Read only the mail you want - Yahoo! Mail SpamGuard.
