…-bounds case MySQL performs quite well, though we can see small performance drop in MySQL 5.6. In IO-bound cases MySQL still has performance issues…_binlog=0 max_connections=5000 table_open_cache=5000 table-definition-cache=1000 query_cache_size=0 query_cache_type=0 performance_schema…
Post: More on MySQL transaction descriptors optimization
April 26, 2013 By Leave a Comment
…= 8 innodb_io_capacity = 2000 max_connections=5000 table_open_cache=5000 query_cache_type=OFF performance_schema=0 warmup To warmup …shutdown=1 –max-time=120 –max-requests=0 –percentile=99 –mysql-user=root –mysql-db=sbtest8t1M –mysql-table-engine=INNODB –mysql-socket=/tmp/mysql.sock –oltp-…
Post: Percona Server for MySQL 5.5.30-30.2 now available
April 10, 2013 By 10 Comments
…MySQL has implemented priority connection scheduling for the Thread Pool. (Alexey Kopytov) Percona Server for MySQL…MySQL performance can be found in this blogpost. (Ignacio Nin) This release of Percona Server for MySQL has fixed a number of performance…
Post: Virident vCache vs. FlashCache: Part 2
May 17, 2013 By 3 Comments
… – MySQL parameter testing The first test was designed to look solely at vCache performance under some different sets of MySQL configuration… 120 max_connections = 5000 max_prepared_stmt_count=500000 max_connect_errors = 10 table_open_cache = 10240 max_allowed_packet = 16M binlog_cache_size = 16M max…
Post: Benchmarking Percona Server TokuDB vs InnoDB
May 7, 2013 By 32 Comments
…performs if PK is (`id`,`hid`,`mid`). This also will affect select performance…max_connections = 2000 max_prepared_stmt_count=500000 max_connect_errors = 10 table_open_cache = 2048 max_allowed_packet = 16M binlog_cache_size = 16M max…
Post: Percona Server 5.5.30-30.2 rerelease fixes non-restart issue
April 24, 2013 By Leave a Comment
…MySQL has implemented priority connection scheduling for the Thread Pool. (Alexey Kopytov) Percona Server for MySQL…MySQL performance can be found in this blogpost. (Ignacio Nin) This release of Percona Server for MySQL has fixed a number of performance…
Post: Ultimate MySQL variable and status reference list
January 8, 2011 By 4 Comments
…max_connect_errorsblogpercona.commanual max_connectionsblogpercona.commanual max_delayed_threadsblogpercona.commanual max_error_countblogpercona.commanual max_heap_table_sizeblogpercona.commanual max_insert_delayed_threadsblogpercona.commanual max…
Post: MySQL 5.5 and MySQL 5.6 default variable values differences
February 21, 2013 By 8 Comments
…/mysql-5.5.30-linux2.6-x86_ | /mnt/nfs/dist/mysql-5.6.10-linux-glibc2. | | PERFORMANCE_SCHEMA_MAX_COND_INSTANCES | 1000 | 836 | | PERFORMANCE_SCHEMA_MAX…_INCREMENT | 8 | 64 | | MAX_CONNECT_ERRORS | 10 | 100 | | SORT_BUFFER_SIZE | 2097152 | 262144 | | LC_MESSAGES_DIR | /mnt/nfs/dist/mysql-5.5.30…
Post: How to Monitor MySQL with Percona's Nagios Plugins
February 22, 2012 By 11 Comments
…-check-mysql-status plugin to alert when the server’s Uptime variable is too small. The server is approaching max_connections. Overflowing the max_connections… error appropriately. The pmp-check-mysql-status plugin can be configured to alert when Threads_connected approaches max_connections too closely, which can give… in that list, there are several others that can be performed with existing plugins, so there was no need to write…
Post: Multiple purge threads in Percona Server 5.1.56 and MySQL 5.6.2
May 3, 2011 By 13 Comments
… transaction commits and so the purge begins. The tests were performed on Percona’s R900 machine. The scripts and results are…_method=O_DIRECT innodb_max_dirty_pages_pct=80 innodb_file_format=barracuda innodb_file_per_table max_connections=2000 table_cache=2000… I am sure that next MySQL 5.6 versions will contain a fixed and much better performing implementation, which I am looking…
