Partitioned table maintenance

[Pandit P]

Hi,

I have these two maintenance scripts scheduled to run daily / weekly.

<code>

--Daily (except Sunday)
mysqlcheck --user=root --password='*******' --fast --auto-repair --optimize --force --silent --skip-write-binlog --databases testdatabase > /root/DBSCRIPTS/Maintenance_Daily.log

-- Weekly (only on Sunday)
mysqlcheck --user=root --password='*******' --quick --auto-repair --optimize --force --silent --skip-write-binlog --databases testdatabase > /root/DBSCRIPTS/Maintenance_Weekly.log

</code>

Recently I have created partitions of two tables which has 5 millions of data in each table and it is expected to grow by 1 million records every quarter.

So far there is no plan to archive the old data.

I have few questions.

1. Is the above maintenance mysqlcheck script able to take care of optimizing the partitions/

2. If yes, will it be able to optimize the table even when the table size grows with billions of records?

3. If I need to separate the maintenance script only for the partitioned tables, how can I do it with mysqlcheck command?


Please help.

Thanks and regards
Praveen