…blog post, forum thread, image, movie etc was viewed. This is sometimes handy feature but it can be rather expensive from performance… not cause any synchronous IO and background IO can be batched rather effectively…solutions you can use memcache + another mysql instance (or simply the database which…
Post: The Math of Automated Failover
September 18, 2012 By 9 Comments
There are number of people recently blogging about MySQL automated failover, based on production incident which GitHub disclosed. Here … difference. The complex situations which happen with databases such as performance problems, running out of connections and so transient successful and… in performance problem on single node only such as disk failing in RAID, resync initiated, BBU starting “learning” are just some IO…
Post: Performance problem with Innodb and DROP TABLE
February 3, 2011 By 23 Comments
… was CPU bound rather than IO bound. I’ve got an …LRU_invalidate_tablespace 168823 0.6009 mysql mysql completion_hash_update(hashtable*, char*, unsigned … and find bug reports or blog posts about this topic. It …responsible for poor performance of SHOW STATUS and crash recovery performance over last …
Post: Looking on 5.4 - IO bound benchmarks
April 30, 2009 By 5 Comments
…our benchmarks. For first shoot I took tpcc-like IO-bound benchmark (100W, ~10GB of data, 3GB buffer_pool)…minute, more is better). So I can confirm that MySQL team did great job with 5.4 and it… more results you can find on Dimitri’s blog, one of Sun Performance Engineers. From our side we will look…
Post: SQL Injection Questions Followup
July 26, 2012 By 2 Comments
… the misconceptions that many other blogs and articles have about this security … in digital formats for Kindle, iOS, and PDF at the publisher … onto their database server. Their MySQL server became CPU-bound, while …for security very challenging. Whereas with performance, your site is working well …
Comment: MySQL 5.5.8 - in search of stability
January 5, 2011 By 11 Comments
… into a separate storage/disk (http://dimitrik.free.fr/blog/archives/2009/09/mysql-performance-io-optimization-innodb.html) – in this case you don…
Post: Setting up XFS on Hardware RAID -- the simple edition
December 16, 2011 By 9 Comments
…configurations. Are there ways to squeeze more performance out of a server by dividing the …Aurimas posted two excellent blogs on both the theory of Aligning IO on hardware RAID …mysql xfs nobarrier,noatime,nodiratime Setting the IO scheduler This is a commonly missed step related to getting the IO…
Post: How to estimate time it takes Innodb to Recover ?
May 9, 2007 By 7 Comments
…to be Innodb day in our Blog, but well this is the question which pops ups…performing are happening to some small amount of pages (for example you’re doing batch update for relatively small table) less IO… and undo phase – rolling back uncommitted transactions. As MySQL 5.0 these seems to be done in …
Post: Star Schema Bechmark: InfoBright, InfiniDB and LucidDB
January 7, 2010 By 48 Comments
… http://www.mysqlperformanceblog.com/2009/10/02/analyzing-air-traffic-performance-with-infobright-and-monetdb/, http://www.mysqlperformanceblog.com/2009/10… full IO bandwidth reading from disk. You can see more details on InfiniDB scalability on InfiniDB’s blog http://infinidb.org/infinidb-blog/mysql…
Post: Why you don't want to shard.
August 6, 2009 By 34 Comments
… cover sharding. If you follow our blog, you’ll notice we don’t … Optimize everything else first, and then if performance still isn’t good enough, it’… database. Too many writes – Either the IO system, or a slave can’t …tables, and move them onto their own MySQL server. Partition-by-function keeps …
