This blog post is part two of two. Like
href="http://www.mysqlperformanceblog.com/2013/04/16/is-your-mysql-buffer-pool-warm-make-it-sweat/" target="_blank">part one, published Wednesday, this is a cross-post from
href="https://engineering.groupon.com/2013/mysql/rotating-mysql-slow-logs-safely/" target="_blank">Groupon’s engineering blog. Thanks again to Kyle Oppenheim at Groupon. And one more reminder that I’ll be at the
Almost after every recovery case the same question arises. How many records were recovered and how many were lost.
Until now there were no means to answer the question without manual investigation. As it turned out a small change can make a big difference.
There are two ways to know how many records an InnoDB page stores. The index page has a header PAGE_N_RECS – this is a number of records the page stores. Obviously it doesn’t count any deleted records. The second method to know how many records are in the page is to follow by records pointers and just count them.
6031 Connection Drive
Las Colinas, TX 75039
Event is free to the public. But please RSVP so we order enough pizza.
Learn how to set up MySQL replication for simple master/slave relationship, including a live demo. Then we will cover how to scale using replication and advanced strategies. Giveaways include books from Oracle press!
It’s not uncommon to promote a server from slave to master. One of the key things to protect your data integrity is to make sure that the promoted slave is permanently disconnected from its old master. If not, it may get writes from the old master, which can cause all kinds of data corruption. MySQL provides the handy RESET SLAVE command. But as we’ll see, its behavior has changed along with the MySQL versions and it’s easy to shoot yourself in the foot if you use it incorrectly. So how do you safely disconnect a replication slave?
Percona is glad to announce the release of Percona XtraDB Cluster 5.5.30-23.7.4 for MySQL on April 17, 2013. Binaries are available from the
href="http://www.percona.com/downloads/Percona-XtraDB-Cluster/5.5.30-23.7.4/">downloads area or from our
I’m scheduled to talk about Go a couple times in the upcoming weeks.
The first is May 4th in Arlington at A Day Of Foster.ly. I’ll be a participant in a panel titled Add To Your Programming Toolkit: Languages You Should Know About (Erlang, Clojure, R, Go, etc…). I’m talking about Go, naturally.
Today’s blog post diving into the waters of the MySQL buffer pool is a cross-post from
href="https://engineering.groupon.com/2013/mysql/mysql-buffer-pool-warming/" target="_blank">Groupon’s engineering blog, and is Part 1 of 2. Thank you to
href="http://www.linkedin.com/in/koppenheim">Kyle Oppenheim at Groupon for contributing to this project and post. We’ll be posting Part 2 on Thursday. And we’ll both be at the
The Micron P320h SSD is an SLC-based PCIe solid-state storage device which claims to provide the highest read throughput of any server-grade SSD, and at Micron’s request, I recently took some time to put the card through its paces, and the numbers are indeed quite impressive.