…assert that XFS is the way to go for MySQL, but I’m not sure how frequently they …conversation with someone building a large Ceph cluster on top of XFS instead of btrfs, and his feedback … the RAID array, or using nobarrier, all have no statistically significant impact on performance, which seems to …
Post: Testing STEC SSD MACH16 200GB SLC
April 25, 2012 By 7 Comments
… reliable latency though, as it appears there is no a reliable way in the Linux asynchronous IO…async IO threads): In general it shows stable throughput topping to 148 MiB/sec, but every 20 min, … suitable to work with MySQL. I will publish sysbench oltp benchmarks running MySQL on RAID10 over 4 STEC …
Post: Keep your MySQL backend online no matter what + TGIF Contest!
October 7, 2011 By 2 Comments
… I will be presenting my conference session “Keep your MySQL backend online no matter what” at the Percona Live London Conference. Considering their is a variety of highly knowledgeable MySQL experts speaking at…. In addition I will show an example for another alexa top 500 website, where downtime and customer satisfactory was the numer…
Post: Stripped MySQL builds, the optimization that isn't
December 7, 2010 By 7 Comments
I usually tell people to use official MySQL builds from MySQL, or from their operating system distribution if they don’t want to do that. (This assumes that there is no… try to “optimize” their server by custom compiling it. The top-tier users have reason to do so. Most users are…
Post: Identifying the load with the help of pt-query-digest and Percona Server
December 29, 2011 By 3 Comments
…atomically, not just for new connections as in MySQL. This is very helpful for measurement as …Hit: No Full_scan: Yes Full_join: No Tmp_table: No Tmp_table_on_disk: No # Filesort: No Filesort_on_disk: No Merge…the output ranks the queries and shows the top queries with largest impact – longest sum of …
Post: Aligning IO on a hard disk RAID – the Benchmarks
June 9, 2011 By 11 Comments
… IO alignment, not different MySQL configurations, I didn’t try out different MySQL versions or settings. …1. Baseline – misalignment on the partition table, no LVM and no alignment settings in the file system…. that (not verified). 6. Added LVM on top of aligned partition table, used proper file …
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
…=/var/db/mysql –user=mysql –pid-file=/var/run/mysqld/mysqld.pid –skip-external-locking –port=3306 –socket=/var/db/mysql/mysql.sock consult… the top 10 most expensive queries, in total execution time. By the way, the slow query logs in the stock MySQL server… the server’s true workload. At the moment there is no other technique that approaches the amount of information a Percona…
Post: Commodity Hardware, Commodity Software and Commodity People
June 15, 2007 By 9 Comments
… could be great MySQL Expert but have no experience with MySQL Cluster, other may be good with MySQL Cluster but have no idea how to… companies have their special “database” interfaces which run on top of MySQL or other databases. Other interesting development is Scalable Blob Streaming… storage engines out where are for MySQL but why could not one develop smaller and lighter top part ? The same way as…
Post: High-Performance Click Analysis with MySQL
December 22, 2008 By 13 Comments
…clients. Clicks by day, by customer, top ads by clicks, top ads by click-through ratio, and so …storing all the same data, right? Logically, yes; physically, no. Those values that we pivoted up beside their …that work by either using MySQL 5.1′s row-based replication, or in MySQL 5.0 and earlier, …
Post: XtraDB: The Top 10 enhancements
August 13, 2009 By 5 Comments
… following up with the top 10 enhancements that XtraDB has over the built-in InnoDB included in MySQL 5.0 and 5…’t try to aggressively free entries (a full buffer provides no use) or reduce its size (see docs). Data dictionary control… next post in this series will be on XtraDB: The Top 10 Configuration Parameters.
