…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… Glushchenko). Suboptimal code for User Statistics feature has…
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-requests=… 50 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: More on MySQL transaction descriptors optimization
April 26, 2013 By Leave a Comment
…= 8 innodb_write_io_threads = 8 innodb_io_capacity = 2000 max_connections=5000 table_open_cache=5000 query_cache_type=OFF …–forced-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: MySQL and Percona Server in LinkBench benchmark
May 8, 2013 By 18 Comments
… MySQL still has performance issues around mutexes and Percona Server shows much better results Configurations and how to run benchmark: [mysqld] user…_io_threads = 8 innodb_io_capacity = 5000 sync_binlog=0 max_connections=5000 table_open_cache=5000 table-definition-cache=1000 query…
Post: Percona Server 5.5.30-30.2 rerelease fixes non-restart issue
April 24, 2013 By Leave a Comment
… some problems for some users, especially if automatic …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…
Comment: Can't Create Thread: Errno 11 (A Tale of Two Ulimits)
April 17, 2013 By 12 Comments
…, connect ssh to server and restart: $ sudo service mysql2 restart [linko@g4 ~]$ ps -ax | grep mysql …var/lib/mysql2 –plugin-dir=/usr/lib64/mysql/plugin –user=mysql –log-error=/var/log/mysqld2.log –open-…to server and start mysqld. And still get: Max processes 1024 unlimited processes I’ll try …
Post: Virident vCache vs. FlashCache: Part 2
May 17, 2013 By 3 Comments
…max-time=7200 –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…
Post: Ultimate MySQL variable and status reference list
January 8, 2011 By 4 Comments
…max_seeks_for_keyblogpercona.commanual max_sort_lengthblogpercona.commanual max_sp_recursion_depthblogpercona.commanual max_tmp_tablesblogpercona.commanual Max_used_connectionsblogpercona.commanual max_user_connectionsblogpercona.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… to reduce fragmentation and make file growth more rare event. max_connect_errors was raised from 10 to 100 which is good… starvation of queued threads especially for IO bound workloads. Most users will not be affected though as innodb_thread_concurrency is…
Post: Troubleshooting MySQL Memory Usage
March 21, 2012 By 5 Comments
…, user variables, huge network buffer (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 (or stopping…
