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
Seena,
>How to check whae are tables are having how many
>indexes on which columns ?
http://dev.mysql.com/doc/mysql/en/show-index.html
and alternatively if you're using 5.03 or later, http://dev.mysql.com/doc/mysql/en/statistics-table.html
eg an approximate equivalent of SHOW KEYS FROM tbl
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 optimisation
>
> Hi,
> I ha
> -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?
Adding index on the col
