… benefit of using GTIDs is to have much easier failover than with file-based replication. We will see how to change the replication topology… be read in the auto.cnf file in the datadir). So the last executed event is 219be3a9-c3ae-11e2-b985-0800272864ba:1. How can I instruct mysqlbinlog to start reading…
Post: Choosing a MySQL HA Solution - Post-Webinar Q&A
June 7, 2013 By Leave a Comment
…to the lower-level slaves. You can also use the slave_compressed_protocol option in /etc/my.cnf…reading over the manual’s description of how replication filtering rules are processed. There are some informative flowcharts in addition to… lot of “bad file descriptor” errors. I was able to get the …
Post: Disconnecting a replication slave is easier with MySQL 5.5+ (RESET SLAVE vs. RESET SLAVE ALL)
April 17, 2013 By 2 Comments
…and it’s easy to shoot yourself in the foot if you use it incorrectly. So how do you …from MySQL 5.5). If you want to know more details, please read on! MySQL 5.0/5.1 First… master-host and master-port in the my.cnf file? # cat my.cnf [...] master-user=rsandbox master-password=rsandbox master-host…
Post: Percona Playback 0.6 for MySQL now available
April 9, 2013 By 1 Comment
… of one database server to another. Currently it can read queries from MySQL query-log and MySQL tcpdump files and run them on other MySQL server. With Percona Playback you can measure how a server or database upgrade, change in my.cnf or schema change can affect the…
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
… lot of things like how to build for massive scalability, how to do read-write splitting without breaking the user experience, how to take online non-blocking… also elect to use in some cases): vmstat 5 5 iostat -dx 5 5 If you don’t know how to read these, there…/my.cnf, and the server is installed in /customsoftware/mysql with a different my.cnf file. The way to find this out is to look…
Post: How to recover a single InnoDB table from a Full Backup
January 25, 2012 By 10 Comments
…. # innobackupex –defaults-file=/etc/my.cnf –export /tmp/ Then apply the logs to get a consistent backup: # innobackupex –defaults-file=/etc/my.cnf –apply-log… process to work. You can read more about this feature in Percona Server Documentation In the next blog post I’ll explain how to…
Post: How innodb_open_files affects performance
November 18, 2009 By 4 Comments
… Starting crash recovery. InnoDB: Reading tablespace information from the .ibd files… InnoDB: Restoring possible half-…to raise the value of innodb_max_files_open in InnoDB: my.cnf. InnoDB: fil_sys open file… downs for replacing open files in the list. I guess Heikki knows how to implement LRU in …
Post: Heikki Tuuri answers to Innodb questions, Part II
November 4, 2007 By 13 Comments
…to the first file in the log file group? HT: InnoDB writes the checkpoint information to the first file. Q31: How… to Reads because Flash requires “erase” cycle to…cnf, to prevent double buffering. Configure as much memory as possible to InnoDB’s buffer pool. For this, you need to find a way to…
Post: What to tune in MySQL Server after installation
September 29, 2006 By 118 Comments
…’m surprised how many people fail to provide any reasonable answer to this question, and how many servers…to have threads created in normal operation. query_cache_size If your application is read intensive… contains bunch of sample my.cnf files which may be great templates to use. Typically they would…
Post: Profiling MySQL Memory Usage With Valgrind Massif
January 9, 2013 By 3 Comments
… (i.e. for what function) it was allocated, how it got there (a backtrace, please!), and …-file=/etc/my.cnf (if this is where your my.cnf file is located) in order to point mysqld to your settings file …allocated to the Log_event::read_log_event function. You can also see the memory allocated to the …
