Tag: mysql

19 Jun 2015 · by Tom Krouper
This past Wednesday, Box hosted the DBA community for a series of lightning talks by DBAs at Yelp, Facebook, Pinterest, and Box. During this night of networking and learning, engineers, developers, and interested employees joined us at Box headquarters to hear about the speakers' respective teams,...
05 Feb 2014 · by Gavin Towey
In Database Operations we believe in automation as much as possible, and we also try not to be afraid to take good tools and make them better. One such set of tools that practically every MySQL DBA knows is the Percona Toolkit.  They're a set of utility scripts written in PERL which are extremely...
06 Dec 2012 · by Gavin Towey
Anyone who spends time optimizing a Relational Database Management System (RDBMS) can tell you that the largest performance gains can be made from query optimization. It's true that selecting good hardware and tuning the OS and server settings matter a lot in this process. However, by tuning a...
19 Nov 2012 · by Gavin Towey
Cross posted from Gavin's personal blog, Information is Contagious. The slow query log is one of the most misused features of MySQL. I say this because I often talk to people who are using it, but they're not getting everything they could from it. It's an awesomely powerful source of information...