List:General Discussion« Previous MessageNext Message »
From:Gleb Paharenko Date:May 12 2005 3:37am
Subject:Re: table optimisation
View as plain text  
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 <sqlserverdb@stripped> wrote:
> [-- text/plain, encoding 7bit, charset: us-ascii, 9 lines --]
> 
> 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.


-- 
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.NET http://www.ensita.net/
   __  ___     ___ ____  __
  /  |/  /_ __/ __/ __ \/ /    Gleb Paharenko
 / /|_/ / // /\ \/ /_/ / /__   Gleb.Paharenko@stripped
/_/  /_/\_, /___/\___\_\___/   MySQL AB / Ensita.NET
       <___/   www.mysql.com



Thread
table optimisationSeena Blace12 May
  • RE: table optimisationThomas Sundberg12 May
  • Re: table optimisationGleb Paharenko12 May
RE: table optimisationSeena Blace12 May
  • Re: table optimisationPeter Brawley12 May