…innobackupex automatic version detection did not work correctly for latest Percona Server and MySQL 5.1 releases which…wait_timeout option on the server to prevent server from closing connections if the global wait_timeout…are available in our online documentation. Bugs can be reported on the …
Post: Why MySQL Performance at Low Concurrency is Important
March 27, 2013 By 8 Comments
… in Percona Server providing some great illustration on the topic. This time I want to target an opposite question: why MySQL performance… point. For example, MySQL 5.6 DBA and Developer Guide has a number of graphs starting with 32 connections at the low… (MySQL server does not use multiple threads to execute query in parallel at this point). Response times at the variety of concurrency levels can…
Post: trx descriptors: MySQL performance improvements in Percona Server 5.5.30-30.2
April 12, 2013 By 3 Comments
… originally reported as a part of MySQL bug #49169 and can be described as follows. Whenever a connection wants to create a consistent… ONLY appropriately. Which is not always applicable or possible in practice. The “trx descriptors” optimization in Percona Server attacks this problem from…
Post: Benchmarking Percona Server TokuDB vs InnoDB
May 7, 2013 By 32 Comments
…10 min intervals and see throughput: We can see periodical drops, which I believe …Server-5.5.30-rel30.2-500.Linux.x86_64/lib/mysql/libjemalloc.so [mysqld] gdb datadir=/mnt/data/mysql…not innodb options (fixed) port = 3306 back_log = 50 max_connections = 2000 max_prepared_stmt_count=500000 max_connect…
Post: MySQL 5.6 Compatible Percona Toolkit 2.2 Released
March 25, 2013 By 2 Comments
…. saved results from running queries on a server. Granted, this can take a lot of disk space, but…connection over the web, else it will use a standard (http) connection. pt-stalk and pt-mysql-summary have built-in MySQL…in a new series, 2.2 features are not yet finalized. In other words, we may change…
Post: Memory allocators: MySQL performance improvements in Percona Server 5.5.30-30.2
April 15, 2013 By
…, BUG#49169. 2) memory allocation for read-view structure is not a direct malloc() call, but rather goes through the InnoDB… and in some cases 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…
Post: Virident vCache vs. FlashCache: Part 2
May 17, 2013 By 3 Comments
…0.5 and the version of MySQL used was Percona Server 5.5.30-rel30.1-…configuration, I think vCache can be declared the clear winner. Base MySQL & Benchmark Configuration All …not innodb options (fixed) back_log = 50 wait_timeout = 120 max_connections = 5000 max_prepared_stmt_count=500000 max_connect…
Post: How Percona diagnoses MySQL server stalls
March 3, 2011 By 6 Comments
… names suggest, they are used to watch the server, gather diagnostic data when the condition occurs, … is the thing to check for. VARIABLE=${VARIABLE:-Threads_connected} You need to change the threshold to 15,…that you are not aware of. There are many things that can cause a stall in MySQL, and they…
Post: Troubleshooting MySQL Memory Usage
March 21, 2012 By 5 Comments
…can grow up to max_packet_size per connection) are all connection buffers and so if you close connection MySQL can clean them up. Killing connections…connection. In Percona Server you can do better as you can query temporary tables too: mysql…
Post: How to Monitor MySQL with Percona's Nagios Plugins
February 22, 2012 By 11 Comments
… is not logically identical to its master. The server is allocating too much memory. A runaway server process, or poorly optimized queries, can consume… can use the pmp-check-mysql-status plugin to alert when the server‘s Uptime variable is too small. The server is approaching max_connections…
