-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 column
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 have been
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 column or columns
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
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.