Re: running optimize/analyze command

[Alex Arul Lurthu]

On Mon, May 26, 2008 at 2:28 PM, Ananda Kumar <anandkl@stripped> 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