…default value I believe there was attempt to enable it and it did not make things better. max_heap_table_size…tmp_table_size to deal with implicit memory tables. innodb_file_per_table – so I assume storing each table…
Post: Aligning IO on a hard disk RAID – the Benchmarks
June 9, 2011 By 13 Comments
…xfs inodes (which are used by default) have to live in the …, not different MySQL configurations, I didn’t try out different MySQL versions or …table_size = 64M thread_cache_size = 32 query_cache_size = 0 tmp_table_size = 64M key_buffer_size = 8M bulk_insert_buffer_size = 8M myisam_sort_buffer_size…
Post: Is MySQL 5.6 slower than MySQL 5.5?
February 18, 2013 By 23 Comments
…_6_10# sysbench –test=oltp –mysql-socket=/tmp/mysql_sandbox5610.sock –mysql-user=msandbox_rw –mysql-password=msandbox –oltp-table-size=1000000 –num-threads=1 –oltp-read… action for many MySQL users out there, also was not change of defaults in MySQL 5.6 had more reasonable defaults as its goal…
Comment: Database problems in MySQL/PHP Applications
November 6, 2006 By 13 Comments
…table_cache = 3072 open_files_limit = 9216 tmp_table_size=1000M sort_buffer_size = 100M read_buffer_size = 100M read_rnd_buffer_size = 100M myisam_sort_buffer_size…
Post: Side load may massively impact your MySQL Performance
November 13, 2011 By 7 Comments
…-driver=mysql –mysql-host=localhost –mysql-table-engine=innodb –mysql-db=test –oltp-table-name=md_cache_test_small –oltp-table-size=1100000 –mysql-user=msandbox –mysql-password=msandbox –mysql-socket=/tmp/mysql… –oltp-table-size=1100000 –mysql-user=msandbox –mysql-password=msandbox –mysql-socket=/tmp/mysql_sandbox5516.sock run [root@localhost msb_ps_5_5_15]# time mysqldump –defaults-file…
Post: Multi Range Read (MRR) in MySQL 5.6 and MariaDB 5.5
March 21, 2012 By 10 Comments
…_buffer_size, while MariaDB introduces a different variable to control the MRR buffer size mrr_buffer_size. Both buffer sizes default to 256K in MySQL 5….6 MySQL 5.6 w/ read_rnd_bufer_size=4M MariaDB 5.5 MariaDB 5.5 w/ mrr_buffer_size=4M Created_tmp_disk_tables 1 1 1 1 1 Created_tmp_tables…
Comment: ORDER BY ... LIMIT Performance Optimization
September 1, 2006 By 100 Comments
…=MyISAM DEFAULT CHARSET=utf8 CNF ——- [mysqld] socket = /var/lib/mysql/mysql.sock skip-locking key_buffer = 384M max_allowed_packet = 256M table_cache = 512M…_table_size=1073741824 local_infile=0 ft_min_word_len=3 tmpdir = /opt/ key_buffer_size=256M connect_timeout=180 wait_timeout=360 tmp_table_size…
Comment: MySQL File System Fragmentation Benchmarks
July 9, 2008 By 28 Comments
…size=0 table_cache=256 tmp_table_size=93M thread_cache_size=8 #*** MyISAM Specific options myisam_max_sort_file_size=100G myisam_max_extra_sort_file_size…
Comment: MySQL Connection Timeouts
January 24, 2013 By 4 Comments
…table=schema1.% replicate-ignore-table=schema1.table1 basedir=”C:/Program Files/MySQL/MySQL Server 5.0/” datadir=”D:/work/MySQL Datafiles/” default-character-set=latin1 default…query_cache_size=128M table_cache=256 tmp_table_size=103M thread_cache_size=15 log-slow-queries = “D:/work/MySQL Datafiles/…
Comment: MySQL Server Memory Usage
December 20, 2012 By 21 Comments
…_size = 8M table_cache = 3600 table_definition_cache = 4096 thread_cache_size = 16K wait_timeout = 120 connect_timeout = 60 tmp_table_size = 192M max_heap_table_size = …-queries = /var/log/mysql-slow-query.log # Default to using old password format for compatibility with mysql 3.x # clients (those …
