…threadsblogpercona.commanual max_join_sizeblogpercona.commanual max_length_for_sort_datablogpercona.commanual max_prepared_…named_pipeblogpercona.commanual net_buffer_lengthblogpercona.commanual net_read_timeoutblogpercona.commanual net_retry_countblogpercona.commanual net_write_timeoutblogpercona….
Post: Shard-Query EC2 images available
May 11, 2011 By 2 Comments
… Row_format: Compact Rows: 6697533 Avg_row_length: 241 Data_length: 1616904192 Max_data_length: 0 Index_length: 539279360 Data_free: 4194304 Auto_increment…-buffer-size=64M local-infile=on lock-wait-timeout=300 log-error=/var/log/mysqld-innodb.log max-allowed-packet=1M net-buffer-length=16K #we value throughput over response time, get a good plan optimizer-prune-level=0 partition=ON port=3306 read-buffer…
Comment: ORDER BY ... LIMIT Performance Optimization
September 1, 2006 By 100 Comments
…_buffer = 384M max_allowed_packet = 256M table_cache = 512M sort_buffer_size = 2M read_buffer_size = 2M read_rnd_buffer_size = 1M myisam_sort_buffer…_limit = 32M thread_stack=256K myisam_data_pointer_size=6 net_buffer_length = 8K log-slow-queries=/var/lib/mysql/astdb01.as.osti…_infile=0 ft_min_word_len=3 tmpdir = /opt/ key_buffer_size=256M connect_timeout=180 wait_timeout=360 tmp_table…
