From: Alex Arul Lurthu (alexjyahoo-inc.com)
Date: Mon May 26 2008 - 04:44:55 CDT

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

On Mon, May 26, 2008 at 2:28 PM, 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.
>

Lets say you want to purge monthly data. Then you will create 12 tables
similar in schema structure representing each month in a year. Create a
merge table using the 12 monthly tables to create a single view of the 12
tables. Now if i want to delete one month of data, i drop that particular
table corresponding to the month and run an alter table on the merge table
removing the table to be dropped. Thats the long story in short.

Also , if you are bottle necked on disk, look at using xfs filesystem. Or if
you are using ext3 then try using the option data=writeback. Caveat : On
abnormal shutdown using this option, the filesystem can get hosed. Thats
again a trade off. You can enable this only when you are running your
optimize commands.

--
Thanks
Alex
http://alexlurthu.wordpress.com

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