…MySQL upgrade – version change but in a lot of cases this will happen when settings are changed at the same time, operating system…MySQL Servers side by side (for example with MySQL Sandbox) can especially be helpful. Once you have spotted the query which performs differently between MySQL…
Post: Aligning IO on a hard disk RAID – the Benchmarks
June 9, 2011 By 11 Comments
…best configuration, I added LVM on top of that and the performance…system on a raw partition I was using full partition size which was slightly over 1TB in size. When I added LVM on…performance with different IO alignment, not different MySQL configurations, I didn’t try out different MySQL… operations…
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
…is best for you, which is …System performance Next I investigate what the system is doing, in terms of performance. There are two key commands for this on most operating systems…which in a high-performance system is virtually every query.) If it’s not possible to use a patched binary, we can use MySQL…
Post: Which Linux distribution for a MySQL database server? A specific point of view.
December 8, 2011 By 37 Comments
… – the heart of Linux operating system – which in principle will …performance improvements, however these days it is rarely important to MySQL…log in to a system based on either distribution …MySQL either until the problem is fixed. In a stressful situation when downtime clock ticks – annoying at best…
Post: The story of one MySQL Upgrade
October 8, 2010 By 8 Comments
…on the master. To do this we set up replication from Percona Server 5.1 back to MySQL 5.0 and performed…best choice as with New MySQL version upgrade involves new Operating System and hardware and any of them could be potential cause of rollback. MySQL…
Post: MySQL Query Cache
July 27, 2006 By 69 Comments
MySQL has a great feature called “Query Cache” which is quite helpful for MySQL Performance…systems can effectively use memory on multiple systems so there is no duplication. Memcached is probably the most popular distributed caching system…
Post: Why you should ignore MySQL's key cache hit ratio
February 28, 2010 By 27 Comments
…which the ratio is derived (but not the ratio itself, which you should ignore). Read on…operating system‘s cache, then a Key_read is a disk read — but if it is cached, then it’s just a system…MySQL to guide your decisions. It is also not the be-all and end-all of MySQL performance… is the best way to…
Post: New SpecJAppServer results at MySQL and Sun.
November 12, 2008 By Leave a Comment
…system got saturated before the database ? Or does it mean MySQL did not scale well to 8 cores on…in Innodb (and we have patches for this) Operating System Notes from database server: UFS Options for …it has many nice features which are worth a bit of performance overhead. My best wishes to the Tom …
Post: MySQL caching methods and tips
April 4, 2011 By 4 Comments
… the unpredictable performance of the MySQL query cache, …best performance one should pre-compute the data for expensive keys. That is, the keys which…sorting, aggregation and join operations are still CPU …a monitoring system, or the like, which is to be…. My latest post on using Flexviews addresses …
Post: Setting up XFS on Hardware RAID -- the simple edition
December 16, 2011 By 9 Comments
…best choice for operability in the majority of normal configurations. Are there ways to squeeze more performance… to partition is a lot of operational work which should be spent only when …on modern Linux systems for this to be off? Maybe not, but here’s how you check. We want to use mysql on…
