I will optimize master dB server, your suggestions will help me to do more best in this regard.
my single table count increases rapidly, you can see my last post counts were
| count(*) |
| 52433939 |
and current count on master DB are
| count(*) |
| 54210071 |
I am using MySQL enterprise 5.0. can you help me, how do i get performance on this DB. should i use "Archive storage engine" on slave and "MOVE" all records till previous month to "archive_table" and leave the current month records.
i change the DB to MySQL 5.1 to use partitioning , only on slave?
DB should be changed on both Master and slave and other than MySQL e.g Oracle.................etc.
trying to run different tabletypes on master and slave
servers will very likely run you into trouble as replication
is ment to give exact copy of the master server besides the
delay. So different features or restrictions of the table type
could cause failure on the replication server then replaying the
As I don't no very much about your table structure and row size I'm
afraid I cannot give much more hints besides that you could also think
about putting the table into a dedicated database and mount the
database directory on a dedicated harddisk if IO performance is