Neohapsis is currently accepting applications for employment. For more information, please visit our website www.neohapsis.com or email email@example.com
From: Ananda Kumar (anandklgmail.com)
Date: Mon May 26 2008 - 03:58:49 CDT
Can you please give me an example of merge and myisam tables or point me to
any doc where i can look at this option.
On 5/26/08, Alex Arul Lurthu <alexjyahoo-inc.com> wrote:
> Few things you can do to help already running optimize table processes :
> 1. Turn off competing processes.
> 2. Make sure there is no read caching on in your raid controller.
> 3. Taking the machine OOR also helps.
> For future optimize commands :
> Is your deletion process based on some date ? If so have you considered
> using Merge tables and MyISAM. If you do so, then purging becomes just
> dropping a table an running an alter table on Merge which is very fast.
> On Mon, May 26, 2008 at 1:03 PM, Ananda Kumar <anandklgmail.com> wrote:
>> Hi Sebastian,
>> Now that table is already in production, so is there a way i can speed up
>> the optimize table command.
>> On 4/29/08, Sebastian Mendel <listssebastianmendel.de> wrote:
>> > Ananda Kumar schrieb:
>> >> Hi All,
>> >> I am using mysql 5.0.41 on debain.
>> >> I have 8 processor, 8 GB RAM.
>> >> I have atable with 95 Million records, each day there will be about 1.5
>> >> Million records deleted, and around 3.5 Million records added using
>> >> FILE" script.
>> >> Since there would daily deletes happening, there would be lot of
>> >> fragmention, so i used the
>> >> analyze table <table_name>; command to defragment it, it took close to
>> >> hrs. Is there any better and faster way to analyze or optimize the
>> >> to
>> >> defragmentation.
>> > having a fixed row length will prevent tale fragmentation
>> > --
>> > Sebastian
>> > --
>> > MySQL General Mailing List
>> > For list archives: http://lists.mysql.com/mysql
>> > To unsubscribe: http://lists.mysql.com/mysql?unsub=anandklgmail.com