… downward spikes in performance. Other then that, I have also disabled query cache to avoid contention caused by query cache on write heavy… read performance to improve, but they have an impact on the write performance. Well most of the apps rely on read performance and… important things to consider when you are concerned with write performance is using partitioning to reduce the size of the B…
Post: Testing Samsung SSD SATA 256GB 830 - not all SSD created equal
April 25, 2012 By 10 Comments
… the most popular. I do not particularly like its write performance – I wrote about it before, that’s why I am… gather metrics every 10 sec to see how stable the performance is, and it really helps to observe some artifacts, as… wild guess about drops – the drive periodically cleans an internal cache or something. To understand better what kind of response time…
Post: Index Condition Pushdown in MySQL 5.6 and MariaDB 5.5 and its performance impact
March 12, 2012 By 12 Comments
I have been working with Peter in preparation for the talk comparing the optimizer enhancements in MySQL 5.6 and MariaDB 5.5. We are taking a look at and benchmarking optimizer enhancements one by one. So in the same way this blog post is aimed at a new optimizer enhancement Index Condition …
Post: Join Optimizations in MySQL 5.6 and MariaDB 5.5
April 4, 2012 By 2 Comments
…’ optimizer_switch=’join_cache_incremental=on’ optimizer_switch=’join_cache_hashed=on’ optimizer_switch=’join_cache_bka=on’ join_cache_level=8 join_buffer… MRR performance, and BKA uses the MRR interface, so these buffers indirectly impact BKA performance. I did not find much of a performance…
Post: Multi Range Read (MRR) in MySQL 5.6 and MariaDB 5.5
March 21, 2012 By 10 Comments
… MySQL 5.6 and MariaDB 5.5. Note that query cache is disabled during these benchmark runs and that the disks… counters. MySQL Status Counters These status counters were captured when performing the benchmark on IO bound workload, mentioned above. Counter Name… calls made to the storage engine to perform the index record read and then to perform the MRR range scan on the…
Post: MariaDB 5.3 is released as GA!
March 5, 2012 By 17 Comments
…-class member of the MySQL family of databases. Finally, High Performance MySQL, Third Edition mentions MariaDB in many places, so you… useless tables in joins Thread pooling and a segmented key cache for improved scalability That’s really just a sampling. A… different needs and personalities, with different characteristics, and feature and performance improvements are moving rapidly forward for the MySQL world as…
Post: Announcing Percona XtraBackup 1.9.1
February 27, 2012 By 9 Comments
…. Parallel compression Percona XtraBackup can now use multiple CPUs to perform a compressed backup, significantly reducing the amount of time needed… The new xbstream format works with parallel compression to (without caching) stream several compressed files at once. tar4ibd functionality is replaced…
Post: ext4 vs xfs on SSD
March 15, 2012 By 23 Comments
…: 74 MiB/sec xfs 4 threads: 97 MiB/sec Dropping performance in case with 4 threads for ext4 is a signal…=${size}G prepare sync echo 3 > /proc/sys/vm/drop_caches for numthreads in 4 do sysbench –test=fileio –file-total…
Post: Cache Performance Comparison
August 9, 2006 By 73 Comments
… continues cache experiements and has compared performance of MySQL Query Cache and File Cache. Jay uses Apache Benchmark to compare full full stack, cached or… Performance tuning ? Not surpising associative array cache performs the best, almost 4 times faster than APC shared memory cache – closest competitor. In real life performance…
Post: MySQL Query Cache
July 27, 2006 By 69 Comments
… cache or memcached. Well honestly speaking if performance would be problem I should have started with full page caching rather than MySQL level caching… for high performance is Query Cache performs query lookup in the cache before query parsing, so if result is served from query cache, query parsing…
