…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… when plugin-dir option was set in the [client] section of the…
Post: Virident vCache vs. FlashCache: Part 2
May 17, 2013 By 3 Comments
… to look solely at vCache performance under some different sets of MySQL configuration parameters. For example, given that the front-…= 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
…mysql-user=root –oltp-tables-count=32 –mysql_table_engine=tokudb –oltp_auto_inc=on –max-time=18000 –report-interval=10 –max…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…good settings out…
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… when plugin-dir option was set in the [client] section of the…
Post: Review of MySQL 5.6 Defaults Changes
October 8, 2012 By 10 Comments
… posted the great summary of defaults changes in MySQL 5.6 compared to MySQL 5.5 In general there are a lot… 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… it could be needed as it is easy enough to set max_connections to over 5000 or use more than 5000 tables. There…
Post: Ultimate MySQL variable and status reference list
January 8, 2011 By 4 Comments
…MySQL…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
…_INCREMENT | 8 | 64 | | MAX_CONNECT_ERRORS | 10 | 100 | | SORT_BUFFER_SIZE | 2097152 | 262144 | | LC_MESSAGES_DIR | /mnt/nfs/dist/mysql-5.5.30…_intersection=on,engine_condition_pushdown=on 1 row in set (0.00 sec) mysql [localhost] {msandbox} (test) > select * from var56 where variable…
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 setting… error appropriately. The pmp-check-mysql-status plugin can be configured to alert when Threads_connected approaches max_connections too closely, which can give…
Post: Troubleshooting MySQL Memory Usage
March 21, 2012 By 5 Comments
… max_packet_size per connection) are all connection buffers and so if you close connection MySQL can clean them up. Killing connections … | sum(data_length+index_length) | +——————————-+ | 126984 | +——————————-+ 1 row in set (0.00 sec) You can even go deeper…
Post: Too many connections? No problem!
March 23, 2010 By 28 Comments
…@sandbox msb_5_0_87]$ gdb -p $(cat data/mysql_sandbox5087.pid) \ -ex “set max_connections=5000″ -batch [Thread debugging using libthread_db enabled... clear the current input statement. mysql [localhost] {msandbox} ((none)) > select @@global.max_connections; +————————–+ | @@global.max_connections | +————————–+ | 5000 | +————————–+ 1 row in set (0.00 sec) Credit for…
