… users who want to continue running IBM i and MySQL. That’s why we’re happy to announce that we have assisted Zend to introduce… on the IBM i platform. Zend approached us to say that they want to ensure there’s a way forward for IBM i…. If you want to leave the IBM i platform and switch to Oracle’s MySQL on another platform, it will work seamlessly. Why is Percona…
Post: Benchmarking single-row insert performance on Amazon EC2
May 16, 2012 By 11 Comments
…, and I have some interesting results that I wanted to share. I used a nice and effective tool …” on the y-axis. The reason why I have chosen to show “millions of rows” on the x…. Other important things to consider when you are concerned with write performance is using partitioning to reduce the size …
Post: Joining many tables in MySQL - optimizer_search_depth
April 20, 2012 By 6 Comments
… which points to problem with optimizer performance. Note though if you have subqueries these might need to be executed…decided against using this as I did not want to risk likehood of execution plans changing for some… I was wondering if 0 is automatic selection why do we have value of 62 being …
Post: Win Free MySQL Conference Tickets!
March 14, 2012 By 2 Comments
… one event you should not miss if you‘re at all interested in MySQL. We really want you to be there — and that’s why we’re giving away free tickets and books, and making it easy for you to enter the contest! Here’s how you…
Post: Caching could be the last thing you want to do
July 24, 2010 By 14 Comments
… with a very popular PHP ecommerce package which makes me want to voice a recurring mistake I see in how many web… be your first choice. Here is why: Caching might not work for all visitors – You look at a page, it loads… applications just can’t live without. You don’t want that burden until you have exhausted all other easily reachable optimizations. What…
Post: Why you don't want to shard.
August 6, 2009 By 33 Comments
… seen that it causes architectures to be prematurely complicated. So let me state it: You don’t want to shard. Optimize everything else first, and then if performance still isn’t good enough, it’s time to take…; another solution is to have shards all store fragments of data, and to cross backup those fragments across shards.) Why is it so…
Post: Why you should ignore MySQL's key cache hit ratio
February 28, 2010 By 27 Comments
… badly tuned? If you said “I still can’t tell,” maybe you want more information, so I’ll tell you that both servers are…’s why its counters are big. Let’s say this is the case. Now, you‘ve got all the information you need to form… to configure my.cnf, and you have heard guidance that seems so definite, mathematical, and authoritative, but still makes no sense, why wouldn…
Post: 7 Reasons why MySQL Quality will never be the same
December 10, 2008 By 15 Comments
… Innodb Plugin which is separate from Innodb included default MySQL. Why is not this part of stock MySQL 5.1 ? I… affects bugs an not features ? Well if you want to use latest Innodb you will need to use plugin which is not part of standard… End The good news are you really do not need general “quality” or “being free from bugs” to run MySQL in production…
Post: How to Monitor MySQL with Percona's Nagios Plugins
February 22, 2012 By 8 Comments
… intended purpose. I want to add a little context. What problem were we trying to solve with these plugins? Why yet another set of… to trigger an alert on almost anything from SHOW VARIABLES and SHOW STATUS that you want. If you want to monitor ratios and rates, for example, you can certainly do so; it also supports an incremental mode of operation, so you…
Comment: "Shard early, shard often"
November 17, 2009 By 6 Comments
… with effective use of indexes. However, there are some reasons why you want to shared (or at least build it) from the start. Your… not have to deal with an application that has performance problems, all while the boss wants to add more features. If you do leave… about the potential technical debt, and it is accounted for. You don’t want to have to rush into sharding under pressure/stress.
