… posts and articles look at MySQL performance starting with certain concurrency as the low point. For example, MySQL 5.6 DBA and Developer… system is performing well, pointing to rather low concurrency in the normal system operation. Much higher concurrency in most cases is seen when the system…
Post: Percona XtraDB Cluster 5.5.30-23.7.4 for MySQL now available
April 17, 2013 By 2 Comments
…Benchmark showing the impact of memory allocators on MySQL performance can be found in this blogpost. This…when appending exclusive key for cascading delete operation. Bug fixed #1089490 (Seppo Jaakola). Parallel applying…, please report them to our bug tracking system. UPDATE[18-04-2013]: There was a…
Post: Virident vCache vs. FlashCache: Part 2
May 17, 2013 By 3 Comments
… device. EXT4 is the filesystem, and CentOS 6.4 the operating system, although the pre-release modules I received from Virident required…. vCache – MySQL parameter testing The first test was designed to look solely at vCache performance under some different sets of MySQL configuration parameters…
Post: Galera Flow Control in Percona XtraDB Cluster for MySQL
May 2, 2013 By 5 Comments
… find in standard async MySQL replication. It is my belief that the lack of understanding of this system, or even that it… other magic that helps single node writing in PXC to perform better. gcs.fc_factor If fc_limit controls when flow…. In normal operation we would expect that a large receive queue might be the result of some brief performance issue on a…
Post: The write cache: Swap insanity tome III
April 19, 2013 By 5 Comments
… has always been something bad for MySQL performance but it is even more important for HA systems. It is so important to avoid… free memory but the push to S3 involves a split operation to create files of 5GB since the backup size is… 22 10:03:22 UTC 2013 procs ———–memory———- —swap– —–io—- –system– —–cpu—– Fri Mar 22 10:03:22 UTC 2013 r…
Post: Testing the Micron P320h
April 16, 2013 By 7 Comments
… small handful of additional tests were also performed using the Cisco UCS C250. The operating system in use was CentOS 6.3, and… throughput with latency just over 3ms. How well does it perform with MySQL? Exact results vary, depending upon the usual factors (read… the graph below we compare the performance of the P320h on a standard TPCC-MySQL test to the original FusionIO and the…
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
… what hardware and operating system I’m working with. System performance Next I investigate what the system is doing, in terms of performance. There are two…=/var/db/mysql –user=mysql –pid-file=/var/run/mysqld/mysqld.pid –skip-external-locking –port=3306 –socket=/var/db/mysql/mysql.sock consult…
Post: Reasons for MySQL Replication Lag
July 29, 2011 By 9 Comments
…good” change as increasing buffer pool size could cause performance problems. MySQL Restart MySQL Restarts may include recovery time but what is the…lag. Same may happen with operating system and other system software involved. In could be even system which queries mysql. I’ve seen monitoring updates…
Post: MySQL performance on EC2/EBS versus RDS
August 4, 2011 By 11 Comments
…these two approaches to hosting MySQL in the Amazon cloud. In general, MySQL performance overall on EC2 and …onto the local disks, for example — the more operational complexity and cost you have, so that’…LVM snapshots, in terms of impact to the system‘s performance and ability to mount them on other…
Post: Which Linux distribution for a MySQL database server? A specific point of view.
December 8, 2011 By 38 Comments
… used. All use common Linux kernel – the heart of Linux operating system – which in principle will behave the same way in all… may carry new features or slight performance improvements, however these days it is rarely important to MySQL users. If it is to…, is for example a requirement for commercial support for the operating system. You will have to choose between RedHat or SuSE. Another…
