EmergencyEMERGENCY? Get 24/7 Help Now!

Is there room for more MySQL IO Optimization?

 | January 3, 2013 |  Posted In: Insight for DBAs, MySQL

I prefer to run MySQL with innodb_flush_method=O_DIRECT in most cases – it makes sure there is no overhead of double buffering and I can save the limited amount of file system cache I would normally have on database server for those things which need to be cached — system files, binary log, FRM files, MySQL […]

Read More

Marinating in 2013

 | January 3, 2013 |  Posted In: Tokutek, TokuView

What a flashback this week. Staring at a text terminal trying to establish a connection with a remote server, I began to fret whether I would get my homework assignment done on time. My mind raced back to college nights years ago in the Fishbowl, hunched over an Athena workstation. Would this be another late […]

Read More

Percona Toolkit by example – pt-stalk

 | January 3, 2013 |  Posted In: Insight for DBAs, MySQL, Percona Software, Percona Toolkit

pt-stalk recipes: Gather forensic data about MySQL when a server problem occurs It happens to us all from time to time: a server issue arises that leaves you scratching your head. That’s when Percona Toolkit’s pt-stalk comes into play, helping you diagnose the problem by capturing diagnostic data that helps you pinpoint what’s causing the […]

Read More

Serious build and testing automation

 | January 2, 2013 |  Posted In: MySQL

Here at Percona we’ve spent a lot of time improving our development and testing practices. Why? Because constant innovation keeps us ahead and more productive. We want to work smarter, not harder. One of the tools we use is the Jenkins Continuous Integration server. We use Jenkins pretty heavily to help with out development processes […]

Read More