MySQL Performance: MySQL => MySQL 4.1.13: replication and myisampack

Members

Help

Home

Home » Performance » MySQL » MySQL 4.1.13: replication and myisampack

Show: Today's Messages :: Show Polls :: Message Navigator

MySQL 4.1.13: replication and myisampack [message #3121]

Sun, 25 May 2008 13:01

nicku
Messages: 2
Registered: May 2008

Junior Member

Dear Folks,

We have a master with slaves. The disks are all getting full, and I'd like to compress some historical data with myisampack. All are running MySQL 4.1.13. Turning off the master for more than a very short time is not an option.

Can I use myisampack on the master safely?
Will this compression be replicated in any way to the slaves?
Would it be better to run myisampack on one of the slaves and then netcat the result to the master and other slaves?
Can you suggest any safety precautions?

Report message to a moderator

Re: MySQL 4.1.13: replication and myisampack [message #3283 is a reply to message #3121 ]

Sun, 13 July 2008 23:56

nicku
Messages: 2
Registered: May 2008

Junior Member

1. Yes.
2. No.
3. I don't think so.
4. Never change the data content on the slave; myisampack just changes the packaging, not the content. Okay to pack the historical data, since it is not being written to any more.

Report message to a moderator

Previous Topic:	Reduce InnoDB Table Space
Next Topic:	Raid disk configuration for InnoDB

Goto Forum:

-=] Back to Top [=-

[ Generate printable PDF ] [ Syndicate this forum (XML) ] [

]

Current Time: Thu Jan 8 23:56:35 EST 2009

Total time taken to generate the page: 0.01983 seconds

.:: Contact :: Home :: MySQL Support by Percona.com ::.