Emergency

Search Results for: author mysql high performance

SimCity outages, traffic control and Thread Pool for MySQL

For this post I’m going to shamelessly exploit the litany of technical problems SimCity players encountered earlier this month and a few examples of how Thread Pool for MySQL and Percona Server for MySQL can help …


ODBMS Interview: Scaling MySQL and MariaDB to TBs

Recently, our CTO, Martín Farach-Colton had a chance to talk about scaling MySQL and MariaDB with Roberto Zicari of ODBMS. In the article, Martin states “While I believe that one size fits most, claims that …


Webinar: TokuDB v6 Replication Performance

TokuDB® is a proven solution that scales MySQL® and MariaDB® from GBs to TBs with unmatched insert and query speed, compression, and online schema flexibility. Tokutek’s recently launched TokuDB v6 delivers all of these features …


Are You Forcing MySQL to Do Twice as Many JOINs as Necessary?

. Baron Schwartz This guest post is from our friends at Percona. They’re hosting Percona Live London from October 24-25, 2011. Percona Live is a two day summit with 100% technical sessions led by some …


Why you should ignore MySQL’s key cache hit ratio

I have not caused a fist fight in a while, so it’s time to take off the gloves. I claim that somewhere around of 99% of advice about tuning MySQL’s key cache hit ratio is …


How we work on High Performance MySQL Second Edition

Baron have been updating you a lot about chapter by chapter progress so I should not repeat it, instead I thought it would be a good idea to write a bit about how we work …


Working on “High Performance MySQL, Second Edition”, how you can help?

As you may already have seen announcement by Baron we’re working on major rewrite of High Performance MySQL book – the most famous book about MySQL Performance on the market… which is getting old though. …


Getting use of Slave in MySQL Replication

MySQL Replication is asynchronous which causes problems if you would like to use MySQL Slave as it can contain stale data. It is true delay is often insignificant but in times of heavy load or …


Maybe You Should Try Taking a Walk in My Shoes

The title of this post should really be, “Maybe He Should Try Taking a Walk in Your Shoes.” The he I’m referring to is economist and author, Tim Harford. The you is the people who …


My Favorite MongoDB Replication Feature: Crash Safety

At an extremely high level, replication in MongoDB and MySQL are similar. Both databases have exactly one machine, the primary (or master), that accepts writes from clients. With a single transaction (or atomic operation, in …