…scope of descriptors optimization. Server Configuration: [mysqld] user=root port=…threads = 8 innodb_io_capacity = 2000 max_connections=5000 table_open_cache=5000…max-time=120 –max-requests=0 –percentile=99 –mysql-user=root –mysql-db=sbtest8t1M –mysql-table-engine=INNODB –mysql-socket=/tmp/mysql…
Post: MySQL and Percona Server in LinkBench benchmark
May 8, 2013 By 18 Comments
… in MySQL 5.6. In IO-bound cases MySQL still has performance issues around mutexes and Percona Server shows much better results Configurations…_io_threads = 8 innodb_io_capacity = 5000 sync_binlog=0 max_connections=5000 table_open_cache=5000 table-definition-cache=1000 query…=256 innodb_buffer_pool_instances=16 # MySQL 5.5 and 5.6 loose-innodb_io_capacity_max = 15000 #Percona only innodb_adaptive…
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…max_allowed_packet variable. Bug fixed #1135097 (George Ormond Lorch III). Fixed the upstream bug #62578 which caused MySQL…1032139 (Alexey Bychko). UDF/configure.ac was incompatible …
Post: Virident vCache vs. FlashCache: Part 2
May 17, 2013 By 3 Comments
…max-requests=0 –percentile=95 \ –mysql-user=root –mysql-socket=/tmp/mysql.sock –mysql-table-engine=innodb \ –oltp-read-only=off run The base MySQL configuration (configuration…
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…max_allowed_packet variable. Bug fixed #1135097 (George Ormond Lorch III). Fixed the upstream bug #62578 which caused MySQL…1032139 (Alexey Bychko). UDF/configure.ac was incompatible …
Post: How to Monitor MySQL with Percona's Nagios Plugins
February 22, 2012 By 11 Comments
… this error appropriately. The pmp-check-mysql-status plugin can be configured to alert when Threads_connected approaches max_connections too closely, which can give… careful configuration, or it too can become a noise generator. However, if your application environment makes it difficult to handle max_connections problems…
Post: Review of MySQL 5.6 Defaults Changes
October 8, 2012 By 10 Comments
… to number of connections. You can get 1000s of connections a second even from as little as 100 connections, hence max_connections would be small… the first 500 max_connections + 1 for every 20 max_connections over 500, capped at 2000 Same thing. What number of max connections has to do… in the phones these days, I made in my Optimizing MySQL Configuration Webinar were heard 
Post: MySQL 5.5 and MySQL 5.6 default variable values differences
February 21, 2013 By 8 Comments
…_INCREMENT | 8 | 64 | | MAX_CONNECT_ERRORS | 10 | 100 | | SORT_BUFFER_SIZE | 2097152 | 262144 | | LC_MESSAGES_DIR | /mnt/nfs/dist/mysql-5.5.30… intensive workload will do a lot better on MySQL 5.6 with default configuration back_log Minor increase 50 to 80 does… to reduce fragmentation and make file growth more rare event. max_connect_errors was raised from 10 to 100 which is good…
Post: Percona Replication Manager, a solution for MySQL high availability with replication using Pacemaker
November 29, 2011 By 102 Comments
… on the master During a master switch, connections are killed on the demoted master to… ms ms_MySQL p_mysql \ meta master-max=”1″ master-node-max=”1″ clone-max=”3″ clone-node-max=”1″… There are not many requirements regarding the MySQL configuration, Pacemaker will automatically add “skip-start-slave”…
Post: New SpecJAppServer results at MySQL and Sun.
November 12, 2008 By Leave a Comment
… is no direct comparison available. The configuration Tom compares results to are not … them. The MySQL Settings are probably what is the most interesting: MySQL 5.0 …IGNORE_SPACE transaction-isolation = READ-COMMITTED max_allowed_packet = 1M max_connections=300 max_connect_errors=100 table_cache = …
