…Linux asynchronous IO library to get time metrics for particular IO …mode=rndwr –max-time=18000 –max-requests=0 –num-threads=$numthreads –rand-… related to internal garbage collector activity. The results for random read … with MySQL. I will publish sysbench oltp benchmarks running MySQL on RAID10…
Post: Product to try: MySQL/MariaDB-Galera 0.8
June 13, 2011 By 34 Comments
…active master – active master setups. You can write on both masters and do not worry about conflict resolution and get…is much more complex than an average MySQL master-slave setup. Potential performance penalty: Although… 0.8 I have one serious feature request for the Galera team: provide the ability…
Post: Should we give a MySQL Query Cache a second chance ?
April 10, 2011 By 63 Comments
…few cache implementations which I’d call an Active Cache meaning it takes care of the misses …cache and there are multiple connection requesting the same item. What MySQL will do ? It will allow all…speed for 1Gb networks. Plus if we can get MySQL protocol to support such light compression in addition…
Post: Reasons for MySQL Replication Lag
July 29, 2011 By 6 Comments
…performance causing replication to lag. Failed hard drive getting RAID in degraded mode could be one common …active and passive masters in Master-Master setup is often cause of the problem for similar reason as MySQL… less work is being done in terms of requests per second. Should be easy to see on…
Post: Active Cache for MySQL
January 10, 2010 By 11 Comments
… these problems could be solved with concept of active cache The idea with Active Cache is very simple – for any data retrieval… we can see for the same key we get a lot of requests when it is expired cache could decide to refresh… having max_age specified on GET request. In many applications expiration is not data driven but rather request driven. Consider for example posting…
Post: Death match! EBS versus SSD price, performance, and QoS
February 21, 2011 By 54 Comments
…, how expensive is it to get good performance, relative to what you get with physical hardware? Specifically, how… device was busy, and the average number of requests in progress at the time the samples were taken… latency of EBS storage means that if the active set of data stops fitting in memory, or…
Post: MySQL performance on EC2/EBS versus RDS
August 4, 2011 By 10 Comments
… micro-stalls to quite severe stalls as I/O requests stack up and other things block against them. If… of stock MySQL 5.1, EC2, and a 10-volume EBS RAID. However, I was able to get better performance…pool size, or the sheer volume of I/O activity you’re generating, whichever comes first. And you could…
Post: When would you use SAN with MySQL ?
March 9, 2009 By 18 Comments
…be serialized. Second, MySQL is often not able to submit a lot of outstanding IO requests which is needed … SAN based active-passive clusters for availability purposes and they look to do the same with MySQL. This …). Sure it needs double the storage but you get 2 copies of data too and using SAN …
Post: How Percona strives to remain neutral and independent
March 21, 2011 By Leave a Comment
… prominent companies in the MySQL ecosystem are Percona customers, including hardware manufacturers, software … In reality, this is rare. Most vendors have active sales efforts, so most evaluations are paid … sometimes seek out or respond to requests from vendors who want to get to know us and vice …
Post: Performance impact of complex queries
January 17, 2007 By 11 Comments
… working set from OS cache. Operation Systems and MySQL Itself employs various strategies to attempt to minimize … really can keep it always busy. As drive gets busy requests have to wait to be scheduled. You … server, for example it is old data purge activity you may at least chop it, meaning do …
