From: tech user (techwwwyahoo.com.cn)
Date: Fri Apr 18 2008 - 00:56:13 CDT

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

Hello,

My mysql table has been created for long time, it increases day by day,
and become huge.
Right now a full scan to the table for the first time is very slow.
So I was thinking to optimize it.
This table is stored in many non-sequential disk fragments I think.
I want to make this table to be stored in disk with the sequential
fragments.That will increase the scan speed.
Is there any tool to do it? Thanks in advance.

--ken

      Get the name you always wanted with the new y7mail email address.
www.yahoo7.com.au/y7mail

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]