RE: Setup a replication slave without stopping master
Claudio, please provide details: Which engine (InnoDB or MyISAM) are you running? Which MySQL version are you running? What is the OS? What is the files system? Regards Theo -Original Message- From: Claudio Nanni [mailto:claudio.na...@gmail.com] Sent: Tuesday, 6 January 2009 10:05 PM To: mysql@lists.mysql.com Subject: Setup a replication slave without stopping master All, Happy New Year, and let's hope somebody tries to stop the killing in gaza. I need to setup a replication slave off a master that is currently production and not stoppable or lockable(possibly). Do you have any idea on how to setup the slave with minimum or no impact on the master? The database is about 80GB. Thanks C. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
RE: optimize table
Hi Ananda, 1. Long term solution: When you upgrade to MySQL 5.1 partition the table e.g. by time. This approach was used for 10s of years in the other DBs. http://dev.mysql.com/tech-resources/articles/performance-partitioning.ht ml http://dev.mysql.com/tech-resources/articles/mysql_5.1_partitioning.html http://dev.mysql.com/doc/refman/5.1/en/partitioning.html 2. Short term: There is no point to defragment the table. On the file system it will be fragmented any way. Just defragment the indexes, which is faster. May be once a week will be OK. REPAIR TABLE your_table archive QUICK; Regards Theo -Original Message- From: Ananda Kumar [mailto:[EMAIL PROTECTED] Sent: Monday, 15 September 2008 9:45 PM To: mysql Subject: optimize table I have a table which adds on a daily basis around 3 million records. We have a automated stored proc, which deletes 1 million reocrds. Now the optimize table command takes loot of time for me to defragment the table. Is there a any way i can improve the speed of optimize table command. My mysql version is 5.0.41 and have 16GB RM and 8 CPU's regards anandkl -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]