RE: table optimisation

2005-05-12 Thread Thomas Sundberg
-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

RE: table optimisation

2005-05-12 Thread Seena Blace
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

Re: table optimisation

2005-05-12 Thread Peter Brawley
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

Re: table optimisation

2005-05-12 Thread Gleb Paharenko
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

table optimisation

2005-05-11 Thread Seena Blace
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.