…://blog.tsunanet.net/2011/09/ext4-2x-faster-than-xfs.html So we built all our MySQL … conversation with someone building a large Ceph cluster on top of XFS instead of btrfs, …the XFS world have greatly enhanced the metadata performance of XFS (especially with regards to metadata fragmentation…
Post: Top 5 Wishes for MySQL
June 29, 2007 By 10 Comments
… Marten, it is time for you to get your own blog). I should have replied much earlier but only found time… use them same as single MySQL server with improved performance and high availability. Of course there is MySQL Cluster but it does not get where quite yet having very particular performance properties…
Post: Finding your MySQL High-Availability solution - The definitions
October 9, 2009 By 10 Comments
… the MySQL Performance Blog, I joined Percona at the beginning September, I chose to cover the various high-availability (HA) options available for MySQL… of MySQL HA related engagements while working for Sun/MySQL over the last couple of years using Heartbeat, DRBD and NDB cluster and…
Post: Shard-Query EC2 images available
May 11, 2011 By 2 Comments
…=’Contains all avaialble data from 1988 to 2010′; mysql> use ontime1; Database changed mysql> show table status like ‘ontime_fact’G *************************** 1… way you can verify the numbers in my next blog post. I will compare performance of various cluster sizes on both storage engines.
Post: The two even more fundamental performance metrics
May 5, 2011 By 6 Comments
…blog post, I wrote about four fundamental metrics for system performance analysis. These are throughput, residence time,…maybe a bit longer. This is common in MySQL servers I work with when they’re … typical response time (which will usually be clustered tightly, given that this is an exponential …
Post: MySQL-Memcached or NOSQL Tokyo Tyrant - part 1
October 15, 2009 By 16 Comments
… is generally mean and lean and performs well. The issue is even this… I can then compare using MySQL to using MySQL + Memcached, and then to other… complex sharding systems, the discussions on cluster, more memcached. We need to cover…is silly. Yes the guy who blogs on bigdbahead.com and is writing…
Post: Why MySQL could be slow with large tables ?
June 9, 2006 By 139 Comments
…, mailing lists or blogs you probably heard complains about MySQL being unable to handle … LiveJournal,Technocarati MySQL has installations with many billions of rows and delivers great performance. What …. In MySQL single query runs as single thread (with exeption of MySQL Cluster) and MySQL issues …
Post: State of MySQL Market and will Replication live ?
April 9, 2008 By 29 Comments
…performance of MySQL is often the problem even for medium scale sites. As response to these things few things happen – MySQL…MySQL side we have further development of MySQL Cluster to be more usable for web apps as well as development of MySQL…PrimeBase is working on scalable blog streaming to make it…
Post: High availability for MySQL on Amazon EC2 – Part 4 - The instance restart script
August 19, 2010 By 6 Comments
… starting MySQL, Pacemaker invokes a script to start (or restart) the EC2 instance running MySQL. This blog … perform (the full script is given below). Kill the MySQL EC2 instance if running Make sure the MySQL… unicast with its partner node in the cluster, the node on which the restart script is…
Comment: InnoDB vs MyISAM vs Falcon benchmarks - part 1
June 7, 2007 By 117 Comments
[...] too easy. We ran a cluster on some dev boxes at first. We did some generic testing using the PHPTestSuite from the guys at MySQL Performance Blog. What we found was that while the cluster appeared slower [...]
