From: Ananda Kumar (anandklgmail.com)
Date: Mon May 26 2008 - 04:20:38 CDT

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

Hi Chandru,
As of now i dont think i can upgrade to 5.1. Also i am using 5.0.4, which
does not support concurrent inserts if there are HOLES in the middle of the
data files. Also, i cannot disable indexes as our application runs 24/7.

I will check Criag suggestions and try to work around it.

Also, will converting this MYISAM table to INNODB be of any HELP

regards
anandkl

On 5/26/08, Craig Huffstetler <craig.huffstetlergmail.com> wrote:
>
> I would read this entire thread (it's short and sweet as well):
>
> http://forums.mysql.com/read.php?112,57249,57315#msg-57315
>
> It will basically explains what you need to know (concerning MyISAM and
> it's merge capabilities), I believe.
>
> You also asked for a Merge Tables example. Here's an interesting case
> example for you using MyISAM as well on a MySQL Performance Blog:
>
> http://www.mysqlperformanceblog.com/2007/05/09/merge-tables-gotcha/
>
> Let me know if I/we can assist you further.
>
> Sincerely,
>
> Craig Huffstetler
> & xq on freenode
>
> On Mon, May 26, 2008 at 4:58 AM, Ananda Kumar <anandklgmail.com> wrote:
>
>> Hi Alex,
>> 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.
>>
>> regards
>> anandkl
>>
>>
>> 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.
>> >
>> > --
>> > Thanks
>> > Alex
>> > http://alexlurthu.wordpress.com
>> >
>> > 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.
>> >>
>> >> regards
>> >> anandkl
>> >>
>> >>
>> >> 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
>> >> "LOAD
>> >> >> 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
>> >> 12
>> >> >> hrs. Is there any better and faster way to analyze or optimize the
>> >> table
>> >> >> 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
>> >> >
>> >> >
>> >>
>> >
>> >
>> >
>> >
>> >
>>
>>
>
>

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