… the next transaction. There are two aspects of this problem: 1) memory allocation is an costly operation and if memory allocator… helps MySQL 5.5.30 to fix issues with malloc scalability but still scanning of the transaction list causes performance drop = MySQL 5.6.10 – in autocommit mode 5.6.10 has no problem with…
Post: Memory allocators: MySQL performance improvements in Percona Server 5.5.30-30.2
April 15, 2013 By
Post: Percona Server for MySQL 5.5.30-30.2 now available
April 10, 2013 By 10 Comments
…Based on MySQL 5.5.30, including all the bug fixes in it, Percona Server 5.5.30-30…. has fixed a number of performance bugs. (Alexey Kopytov) Drop table performance feature has been removed … Bychko). UDF/configure.ac was incompatible with automake 1.12. Bug fixed #1099387 (Alexey Bychko). Reduced …
Post: Announcing Percona XtraBackup 2.1.1 GA
May 15, 2013 By Leave a Comment
… unique features for MySQL backup. The new 2.1.1 GA version offers improved performance, enterprise-grade security, and lower resource usage. This… spawning the MySQL command line client. Support for InnoDB 5.0 and InnoDB 5.1 builtin has been removed from Percona XtraBackup. After… removed in Percona XtraBackup 2.1. Percona XtraBackup can use XtraDB changed page tracking feature to perform the Incremental Backups now. Bugs…
Post: 10 years of MySQL User Conferences
April 11, 2013 By 6 Comments
… Performance MySQL” 1st edition written by Jeremy and Derek was also available. MySQL 4.0.18 was GA and 4.1.1 as… Enterprise,” and MySQL 5.0 is finally available as GA with version 5.0.20a… MySQL 5.1 is in development (5.1.9) 2007 is… improved and extended Innodb Plugin version, MySQL 5.1 is FA with 5.1.34 and MySQL 5.4.0 is in a nonGA version…
Post: Virident vCache vs. FlashCache: Part 2
May 17, 2013 By 3 Comments
… tool used was sysbench 0.5 and the version of MySQL used was Percona Server 5.5.30-rel30.1-465. Each test was… – SSD config) which shows the most consistent performance. The others all have assorted performance drops scattered throughout the graph. We see the… time-based flushing enabled actually produces better and more consistent performance than vCache without time-based flushing, but even at its…
Post: More on MySQL transaction descriptors optimization
April 26, 2013 By Leave a Comment
…. in the first two cases Percona Server performance is even slightly ahead of MySQL 5.6.10, but nothing unexpected. So while…_connections=5000 table_open_cache=5000 query_cache_type=OFF performance_schema=0 warmup To warmup server and load data and…-engine=INNODB –mysql-socket=/tmp/mysql.sock –oltp-point-selects=1 –oltp-simple-ranges=0 –oltp-sum-ranges=0 –oltp-order…
Post: Why MySQL Performance at Low Concurrency is Important
March 27, 2013 By 8 Comments
… and articles look at MySQL performance starting with certain concurrency as the low point. For example, MySQL 5.6 DBA and Developer… wild have Threads_running on average of 5 or less, at least the system is performing well, pointing to rather low concurrency… would love to see results published starting from concurrency of 1 if possible so we can see the full picture. In…
Post: Benchmarking Percona Server TokuDB vs InnoDB
May 7, 2013 By 32 Comments
… InnoDB and TokuDB performs if PK is (`id`,`hid`,`mid`). This also will affect select performance, so we…_safe] numa-interleave malloc-lib=/usr/local/Percona-Server-5.5.30-rel30.2-500.Linux.x86_64/lib…_extra_sort_file_size = 10G myisam_repair_threads = 1 myisam_recover socket=/var/lib/mysql/mysql.sock…
Comment: Investigating MySQL Replication Latency in Percona XtraDB Cluster
May 17, 2013 By 13 Comments
… setting in my.cnf file, site performance was good. But from second day again performance degradation started and now it is slow… (CentOS) PHP Version – 5.3.3 MySQL – 5.1.66 [Percona XtraDB Cluster (GPL) (5.5.30)] (InnoDB Engine) PHP My Admin – 5.3.3 Hardware: Node:2 CPU = Quard Core RAM = 12 GB HDD = 1 TB…
Comment: MySQL and Percona Server in LinkBench benchmark
May 8, 2013 By 18 Comments
… to waste time and lose performance because of this. I am one of those people. When MySQL 5.6 spends a lot…_free_block you are not going to have good performance results. Prior to 5.6 foreground threads were responsible for moving pages… option to fix the stalls and that change makes 5.1 competitive with 5.6 (http://mysqlha.blogspot.com/2013/02/mysql-56…
