…to use an account with only the necessary privileges. It is also important to note to run pt-upgrade itself on a 3rd server if the servers…tells in general how each fingerprint performs on the test servers. About 10% variation is tolerable and can be…
Post: Can MySQL temporary tables be made safe for statement-based replication?
May 26, 2008 By 8 Comments
…how to make MySQL replication reliable, part of which is to eliminate temporary tables. The idea is this: if a slave…to tell for sure is to really test it. Since I’d stopped the slave…Server_id: 1 End_log_pos: 279 Info: use…
Post: Managing Slave Lag with MySQL Replication
October 12, 2007 By 15 Comments
…Slave Server Load – MySQL Replication goes in single thread so it is really vulnerable to the server load. If…tell what time replication thread was busy processing events compared to being idle. This would help a lot to see when you’re close to…to know how to…
Post: Three ways to know when a MySQL slave is about to start lagging
October 8, 2008 By 8 Comments
…be indistinguishable from one that’s at 5% of its capacity. So how can you tell when your slave is nearing its capacity to…slave) to see how much of the time the slave thread was actively processing statements. If the slave threads are always running, you can just use the server…
Post: Heikki Tuuri answers to Innodb questions, Part II
November 4, 2007 By 13 Comments
…be implemented on larger servers? HT: I think Linux often likes to use about 20 % of the available RAM as…to prevent double buffering. Configure as much memory as possible to InnoDB’s buffer pool. For this, you need to find a way to tell Linux to…
Post: 10 things you need to know about backup solutions for MySQL
March 3, 2009 By 23 Comments
…to be able to answer: Does the backup require shutting down MySQL? If not, what is the impact on the running server… replication? Can you use the system to set up new MySQL replication slaves? How? Does the system … basic information such as “dump or file copy.” Sometimes they tell me to register and …
Post: KISS KISS KISS
March 1, 2009 By 7 Comments
…How far you want to go making your application being capable to read from the slave ? Remember as…server should be able to handle all traffic from capacity planning standpoint anyway. At the same time slave can be perfect to be used…
Post: Estimating Replication Capacity
July 20, 2010 By 4 Comments
…as well as how long replication warmup takes. It is very typical for servers with cold cache to…if you have slave which is used for backups/reporting etc) is to stop the replication for some time and when see how…
Post: Debugging problems with row based replication
May 6, 2010 By 12 Comments
…if triggers or stored procedures are used, or if non deterministic functions like RAND() are used in DML statements. A statement based replication slave…be found on the slave:HA_ERR_KEY_NOT_FOUND. It doesn’t tell…server is trying to find is c1=1, but how can we find that out if…
Post: Profiling MySQL Memory Usage With Valgrind Massif
January 9, 2013 By 3 Comments
…to know exactly how much memory the mysqld server (or any other program) is using, where (i.e. for what function) it was allocated, how…being simply the allotted pool of memory for use by programs); Massif tells you not only how much heap memory your program is using…
