…much better scalability in InnoDB high-concurrent workloads. Bugs fixed #1131189 (Alexey …max_allowed_packet variable. Bug fixed #1135097 (George Ormond Lorch III). Fixed the upstream bug #62578 which caused MySQL…1107539 (Sergei Glushchenko). Suboptimal code for User Statistics feature has been …
Post: More on MySQL transaction descriptors optimization
April 26, 2013 By Leave a Comment
…, start suffering from the trx_list overhead created by concurrent updates. Once we step away from this spherical read-…–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: Percona Server 5.5.30-30.2 rerelease fixes non-restart issue
April 24, 2013 By Leave a Comment
…This caused some problems for some users, especially if automatic upgrading was … much better scalability in InnoDB high-concurrent workloads. Bugs fixed #1131189 (Alexey Kopytov…max_allowed_packet variable. Bug fixed #1135097 (George Ormond Lorch III). Fixed the upstream bug #62578 which caused MySQL…
Post: Ultimate MySQL variable and status reference list
January 8, 2011 By 4 Comments
…MySQL manual….commanual concurrent_insertblogpercona….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
…_SIZE | 20 | 300 | | PERFORMANCE_SCHEMA_MAX_THREAD_INSTANCES | 1000 | 224 | | SOCKET | /tmp/mysql_sandbox5530.sock | /tmp/mysql_sandbox5610.sock | | INNODB_FILE_PER_TABLE… especially for IO bound workloads. Most users will not be affected though as innodb_thread_concurrency is 0 by default so this…
Post: Tuning InnoDB Concurrency Tickets
May 24, 2010 By 5 Comments
… stock install of MySQL, here are some example queries and the corresponding number of concurrency tickets used for each: mysql> CREATE TABLE test…=on –num-threads=16 –max-requests=0 –oltp-dist-type=uniform –max-time=300 –mysql-user=root –mysql-socket=/var/lib/mysql/mysql.sock run Applicable my…
Post: Modeling MySQL Capacity by Measuring Resource Consumptions
March 8, 2011 By 1 Comment
… kernel and user CPU usage of MySQL process…User Statistics *************************** 1. row *************************** USER:user TOTAL_CONNECTIONS: 1 CONCURRENT…, 0 QPS, 0x concurrency ________________ # Attribute total min max avg 95% stddev median # ============ ======= ======= ======= =======…
Post: Shard-Query EC2 images available
May 11, 2011 By 2 Comments
… Avg_row_length: 241 Data_length: 1616904192 Max_data_length: 0 Index_length: 539279360 Data…file innodb-strict-mode innodb-thread-concurrency=0 innodb-thread-concurrency-timer-based innodb-thread-…table-size=64M transaction-isolation=READ-COMMITTED user=mysql wait-timeout=86400 To be continued …
Post: Is MySQL 5.6 slower than MySQL 5.5?
February 18, 2013 By 23 Comments
… high concurrency compared to single thread ? Note Sysbench is simple enough it does not take advantage of any of new MySQL 5…/mysql_sandbox5610.sock –mysql-user=msandbox_rw –mysql-password=msandbox –oltp-table-size=1000000 –num-threads=1 –oltp-read-only=on –init-rng=on –max-requests=0 –max…
Post: Side load may massively impact your MySQL Performance
November 13, 2011 By 7 Comments
…concurrently. It is very typical to hear complains about MySQL…mysql-user=msandbox –mysql-password=msandbox –mysql-socket=/tmp/mysql_sandbox5516.sock prepare [root@localhost msb_ps_5_5_15]# sysbench –test=oltp –db-driver=mysql –mysql…
