…: Percona Server for MySQL has implemented priority connection scheduling for the Thread Pool. (Alexey Kopytov) Percona Server for MySQL will now be shipped… which caused MySQL client to abort the connections on terminal resize. Bug fixed #925343 (Sergei Glushchenko). Percona Server for MySQL would re-create…
Post: trx descriptors: MySQL performance improvements in Percona Server 5.5.30-30.2
April 12, 2013 By 3 Comments
… reported as a part of MySQL bug #49169 and can be described as follows. Whenever a connection wants to create a consistent… to the following kinds of transactions: MySQL transactions started with START TRANSACTION READ ONLY MySQL transactions created by a non-locking SELECT… scan and it provides stable throughput even at 4096 concurrent connections. So both the general “trx descriptors” optimization introduced in Percona…
Post: MySQL 5.6 Compatible Percona Toolkit 2.2 Released
March 25, 2013 By 2 Comments
…. Basically, we re-focused it on its primary objective: analyzing MySQL query logs. So the ability to parse memcached, Postgres, Apache… (https) connection over the web, else it will use a standard (http) connection. pt-stalk and pt-mysql-summary have built-in MySQL options… me”. pt-stalk 2.2 and pt-mysql-summary 2.2 have all the standard MySQL options built-in, like other tools…
Post: Memory allocators: MySQL performance improvements in Percona Server 5.5.30-30.2
April 15, 2013 By
… can be the reason for notable MySQL performance drop. Now in Percona Server, for each connection we use a preallocated read view structure, reuse that memory during the entire connection lifetime and free it at disconnect. If some transactions require… test for glibc and jemalloc allocators. Observations: = MySQL 5.5.30 – throughput of MySQL 5.5.30 with glibc is limited first…
Post: More on MySQL transaction descriptors optimization
April 26, 2013 By Leave a Comment
… innodb_write_io_threads = 8 innodb_io_capacity = 2000 max_connections=5000 table_open_cache=5000 query_cache_type=OFF performance… –max-requests=0 –percentile=99 –mysql-user=root –mysql-db=sbtest8t1M –mysql-table-engine=INNODB –mysql-socket=/tmp/mysql.sock –oltp-point-selects=1 –oltp…
Post: MySQL and Percona Server in LinkBench benchmark
May 8, 2013 By 18 Comments
…. Percona Server 5.5 outperforms MySQL in about 2x times. Both MySQL 5.5.30 and MySQL 5.6.11 demonstrate notable drops… we can see small performance drop in MySQL 5.6. In IO-bound cases MySQL still has performance issues around mutexes and…_threads = 8 innodb_io_capacity = 5000 sync_binlog=0 max_connections=5000 table_open_cache=5000 table-definition-cache=1000 query…
Post: Percona Monitoring Plugins 1.0.3 for MySQL now available
April 23, 2013 By 4 Comments
… Percona Monitoring Plugins 1.0.3 for MySQL — high-quality components to add enterprise-grade MySQL monitoring and graphing capabilities to your… issue (bug 1024001) * pmp-check-mysql-replication-running reported OK when a slave is in “Connecting” state (bug 1089506) Update note: Cacti… Utilities. Also the following Cacti graphs need to be recreated: MySQL “MySQL Threads”, Linux “Network Traffic”. A new tarball is available from…
Post: Why MySQL Performance at Low Concurrency is Important
March 27, 2013 By 8 Comments
… a number of recent blog posts and articles look at MySQL performance starting with certain concurrency as the low point. For example, MySQL 5.6 DBA and Developer Guide has a number of graphs starting with 32 connections at the low… jobs are written to be single-threaded. MySQL replication is single-thread too, and MySQL 5.6 brings some abilities of parallel…
Post: Open Source, the MySQL market (and TokuDB in particular)
May 10, 2013 By 13 Comments
…!” For some reason the author of that post makes a connection between a free account in a cloud-based service and… that article: “In principle, anyone who has an interest in MySQL and MariaDB surviving should contact the MariaDB foundation and ask… Tokutek). To summarize my thoughts: If you are in the MySQL market and your product is under proprietary license (not an…
Post: High-load problems? Investigate them with 'pt-query-digest'
April 23, 2013 By 2 Comments
… think is a little known goodie from Percona Toolkit for MySQL called pt-query-digest. One customer was suffering from periods… daunting task to review them in servers with thousands of connections. Enter pt-query-digest. The tool supports its share of… issues. If you regularly work with MySQL databases, getting familiar with Percona Toolkit for MySQL will let you do more work, in…
