…_buffer_size=131072 max_used_connections=13 max_threads=2002 thread_count=6 connection_count=6 It is possible that mysqld could use up to key_buffer_size + (read_buffer_size + sort_buffer_size)*max…:53:56 mysqld_safe mysqld from pid file /var/lib/mysql/srv-d2-mysql02.pid ended in an another environment I…
Post: More on MySQL transaction descriptors optimization
April 26, 2013 By Leave a Comment
…communication). Results: First of all, we used a smaller dataset for this …_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
… load of data size of datadir ~10GB). We used this dataset to check server behavior when data …Server 5.5 outperforms MySQL in about 2x times. Both MySQL 5.5.30 and MySQL 5.6.11 demonstrate … = 8 innodb_io_capacity = 5000 sync_binlog=0 max_connections=5000 table_open_cache=5000 table-definition-cache=…
Post: Percona Server for MySQL 5.5.30-30.2 now available
April 10, 2013 By 10 Comments
… the slave_max_allowed_packet variable. Bug fixed #1135097 (George Ormond Lorch III). Fixed the upstream bug #62578 which caused MySQL client… the connections on terminal resize. Bug fixed #925343 (Sergei Glushchenko). Percona Server for MySQL would re-create the test database when using rpm…
Post: Virident vCache vs. FlashCache: Part 2
May 17, 2013 By 3 Comments
… in use for all of the benchmarks on both systems. The benchmark tool used was sysbench 0.5 and the version of MySQL used… = 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_heap…
Post: Benchmarking Percona Server TokuDB vs InnoDB
May 7, 2013 By 32 Comments
…10000 –mysql-user=root –oltp-tables-count=32 –mysql_table_engine=tokudb –oltp_auto_inc=on –max-time=18000 –report-interval=10 –max-…= 4000 innodb_use_native_aio=0 #not innodb options (fixed) port = 3306 back_log = 50 max_connections = 2000 max_prepared_stmt_count=500000 max_connect_errors…
Post: Percona Server 5.5.30-30.2 rerelease fixes non-restart issue
April 24, 2013 By Leave a Comment
… the slave_max_allowed_packet variable. Bug fixed #1135097 (George Ormond Lorch III). Fixed the upstream bug #62578 which caused MySQL client… the connections on terminal resize. Bug fixed #925343 (Sergei Glushchenko). Percona Server for MySQL would re-create the test database when using rpm…
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: 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… needed as it is easy enough to set max_connections to over 5000 or use more than 5000 tables. There is also little…
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… unless opening and closing files is expensive operation (such as using MySQL on NFS file system). innodb_data_file_path got a…
