…for this workload. Notes MySQL version used: 5.6.11, custom compiled to remove…ALTER TABLE DISABLE KEYS and built the keys with sort via ALTER TABLE ENABLE KEYS. my.cnf […size=8M default_tmp_storage_engine=myisam tmpdir=/dev/shm innodb_undo_logs=32 innodb_old_blocks_time=0 table_open_cache=2048 table…
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
…tmp_tables and Created_disk_tmp_tables, I’ll paste in mysql> show global variables like ‘%table_size%’; +———————+———–+ | Variable_name | Value | +———————+———–+ | max_heap_table_size | 268435456 | | tmp_table_size…
Post: Shard-Query EC2 images available
May 11, 2011 By 2 Comments
…5.5… ) 1 rows returned (0.084244966506958s, 0.078309059143066s, 0…my.cnf [client] port=3306 socket=/tmp/mysql-inno.sock [mysqld] socket=/tmp…size=512K sql-mode=STRICT_TRANS_TABLES symbolic-links table-definition-cache=16384 table-open-cache=128 thread-cache-size=32 thread-stack=256K tmp-table-size…
Post: Aligning IO on a hard disk RAID – the Benchmarks
June 9, 2011 By 13 Comments
…size = 16M max_heap_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…
Comment: MySQL File System Fragmentation Benchmarks
July 9, 2008 By 28 Comments
…this benchmark. Could you post the my.cnf file used and the computer …/MySQL Server 5.0/” datadir=”C:/Program Files/MySQL/MySQL Server 5.0/Data/” …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…
Post: Can we improve MySQL variable handling ?
February 18, 2012 By 8 Comments
…my.cnf to those server is currently running with. The problem however this only works well if settings are set in my.cnf…tmp-table-size 16777216 tmpdir /tmp transaction-alloc-block-size 8192 transaction-isolation REPEATABLE-READ transaction-prealloc-size…5.5…
Post: New SpecJAppServer results at MySQL and Sun.
November 12, 2008 By Leave a Comment
… Settings are probably what is the most interesting: MySQL 5.0 Tuning in /etc/my.cnf (included in FDA) [mysqld] sql-mode = IGNORE_SPACE… MEMORY tables use in the benchmarks ? As otherwise you also need to boost tmp_table_size to deal with implicit memory tables. innodb_file_per_table – so I assume storing each table in its own…
Post: XtraDB/InnoDB CPU bound benchmarks on 24cores server
December 29, 2008 By 6 Comments
…my.cnf is [mysqld] user=root binlog_cache_size=1M default_table_type=MYISAM ft_min_word_len=4 innodb_additional_mem_pool_size…size=0 skip_grant_tables skip_locking sort_buffer_size=64K table_cache=2048 thread_cache_size=16 thread_concurrency=16 thread_stack=196K tmp_table_size…
Comment: Why MySQL could be slow with large tables ?
June 20, 2007 By 141 Comments
… this is a predominantly SELECTed table, I went for MYISAM. My my.cnf variables were as follows …5 thread_cache_size=60 key_buffer=750M join_buffer=10M max_heap_table_size=50M tmp_table_size=64M max_allowed_packet=16M table… would execute in 0.00 seconds. The problem was: why would this table get so …
Comment: table_cache negative scalability
April 14, 2010 By 23 Comments
…open tables issue? Thanks for your help! Server info: Server version: 5.0.79-enterprise-log MySQL Enterprise Server (Commercial) my.cnf: [mysqld…= 40000 max_binlog_size = 500M max_allowed_packet = 20M tmp_table_size = 100M max_heap_table_size = 100M query_cache_size = 100M default_table_type = MYISAM…
