…is likely to be impacted. If we manage to reduce Key_reads, we might make the database server faster overall, and perhaps the…What about InnoDB tuning? You might be wondering, what about InnoDB tuning? What is the…
Post: Tokyo Tyrant - The Extras Part I : Is it Durable?
November 10, 2009 By 5 Comments
…If it first checks if the file descriptor for the database is less then 0, or your not…is going to severely degrade performance. So what can we do to Make Cabinet more durable?  Well the best option in my opinion is…
Post: Improved InnoDB fast index creation
November 6, 2011 By 4 Comments
…the default method, because it does not have to do random disk seeks to fetch secondary index pages to the buffer pool. A benchmark is…the restore time for a regular dump with a dump created with –innodb-optimize-keys (the test database contained only the…
Post: Is disk Everything for MySQL Performance ?
April 25, 2008 By 7 Comments
…what is the most important. Assuming you have fixed amount of disk at your disposal and if you have BBU most likely data files is…is one) – you do not want your database box to swap actively – if it does your’re in trouble anyway so it is better to fix the…
Post: System size and Performance Optimization
February 27, 2007 By 2 Comments
…is worth to spend time and money implementing things as optimal as possible. If you’re using 50 5000$ database servers to run the…is enough to deliver performance required in cost efficient way, or if we should do…
Post: Shard-Query EC2 images available
May 11, 2011 By 2 Comments
…database. To do the size comparison, I used the…not even primary keys). Here is the complete InnoDB schema from one shard. The schema is duplicated 20 times (but not the ontime_fact data): DROP TABLE IF…we value throughput over response time, get a good plan optimizer…
Post: Evaluating IO subsystem performance for MySQL Needs
March 5, 2008 By 23 Comments
…is not perfect but usually can tell you quite a lot of what you should expect from the system. What I usually look for MySQL is…is single thread doing IO (just as with database log). We can see serialization with O_DIRECT however the impact is…
Comment: How to Identify Bad Queries in MySQL
January 11, 2011 By 16 Comments
…databases, we care most about the work the database is doing. That is, queries. There are other things we care about, but not…not optimal ( e.g. full tablescan, not using indexes). The trick is not to look for sub-optimality, but which SQL statement have a big impact on the database…
Post: KISS KISS KISS
March 1, 2009 By 7 Comments
…the conferences, read on the blogs, forums and Internet articles and they ask me if they should use them. My advice is frequently – do not. It is…
Post: How to estimate time it takes Innodb to Recover ?
May 9, 2007 By 7 Comments
…if Innodb needs to do crash recovery. I’m often something like what…the database and may not be as buffer pool flushes are not predictable. As Innodb is…the crash Even though this looks like something which has serious impact in reality it is not that significant. If checkpoints are not…
