… 10GB key buffer. I used ALTER TABLE DISABLE KEYS and built the keys with sort via ALTER TABLE ENABLE KEYS. my.cnf [mysqld…_hash_instances=32 table_open_cache_instances=8 sort_buffer_size=128k read_rnd_buffer_size=8M join_buffer_size=8M default_tmp_storage_engine=myisam tmpdir=/dev/shm innodb_undo_logs=32 innodb_old_blocks_time=0 table_open_cache=2048 table_definition_cache…
Post: Benchmarking Percona Server TokuDB vs InnoDB
May 7, 2013 By 32 Comments
…about 2.8x better throughput, and on data size: InnoDB table: 58GB and 244.980.192 records TokuDB table: 15GB and 232.927.460 records …_size = 4M thread_cache_size = 1000 query_cache_size = 0 query_cache_type = 0 ft_min_word_len = 4 #default_table_type = InnoDB thread_stack = 192K tmp_table_size…
Post: Virident vCache vs. FlashCache: Part 2
May 17, 2013 By 3 Comments
…deployment has a massive data set size in relation to both the working set and the cache device size, the numbers are encouraging. …buffer_size = 4M join_buffer_size = 4M thread_cache_size = 1000 query_cache_size = 0 query_cache_type = 0 ft_min_word_len = 4 thread_stack = 192K tmp_table_size…
Post: More on MySQL transaction descriptors optimization
April 26, 2013 By Leave a Comment
…table_open_cache=5000 query_cache_type=OFF performance_schema=0 warmup To warmup server and load data and…1024> –test=oltp.lua –oltp_tables_count=8 –oltp-table-size=1000000 –rand-init=on –report-…root –mysql-db=sbtest8t1M –mysql-table-engine=INNODB –mysql-socket=/tmp/mysql.sock –oltp-point-…
Post: Ultimate MySQL variable and status reference list
January 8, 2011 By 4 Comments
… and variable reference table. …cache_hitsblogpercona.commanual Ssl_session_cache_missesblogpercona.commanual Ssl_session_cache_modeblogpercona.commanual Ssl_session_cache_overflowsblogpercona.commanual Ssl_session_cache_sizeblogpercona.commanual Ssl_session_cache….commanual tmp_table_sizeblogpercona…
Post: How much overhead is caused by on disk temporary tables
August 16, 2007 By 26 Comments
… tables. Which one will be used depends on the allowed tmp_table_size and also by the data which needs to be put to temporary tables…> set global max_heap_table_size=1000000000; Query OK, 0 rows affected (0.00 sec) mysql> set global tmp_table_size=1000000000; Query OK, 0… table even in case temporary table is small enough to fit in OS cache and key_buffer. My next intension was to test placing table…
Post: Join Optimizations in MySQL 5.6 and MariaDB 5.5
April 4, 2012 By 4 Comments
… and ran it on TPC-H dataset (InnoDB tables) with a Scale Factor of 2 (InnoDB dataset size ~5G). Note that query cache is disabled during these benchmark runs and that… w/ join_buffer_size=4M & mrr_buffer_size=4M Created_tmp_disk_tables 0 0 0 0 0 0 Created_tmp_tables 1 1 1 1…
Comment: MySQL File System Fragmentation Benchmarks
July 9, 2008 By 28 Comments
…cache_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: What to tune in MySQL Server after installation
June 22, 2009 By 118 Comments
… running frequently. One has 40 tables and other has 120 tables. and they contains 133478 rows in each table. Mysql configuration is as …_cache_size=8M table_cache=510 tmp_table_size=13M thread_cache_size=12 myisam_max_sort_file_size=100G myisam_max_extra_sort_file_size=100G myisam_sort_buffer_size…
Post: Side load may massively impact your MySQL Performance
November 13, 2011 By 7 Comments
…-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…-table-name=md_cache_test_big –oltp-table-size=17600000 –mysql-user=msandbox –mysql-password=msandbox –mysql-socket=/tmp/mysql_sandbox5516.sock prepare Running Sysbench and…
