…size = 8M myisam_sort_buffer_size = 64M thread_cache_size = 8 query_cache_size = 32M log_queries_not_using_indexes = On log_slow_queries=/var/lib/mysql/log-slow-queries…
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=64M max_prepared_stmt_count=1000000 query_cache_size=0 skip_grant_tables skip_locking sort_buffer_size=64K table_cache=2048 thread_cache_size…
Comment: What to tune in MySQL Server after installation
December 7, 2006 By 118 Comments
…My.cnf key_buffer = 4096M max_allowed_packet = 32M table_cache = 812 sort_buffer_size = 1024M read_buffer_size = 512M myisam_sort_buffer_size = 1024M thread_cache = 16 query_cache_size…
Comment: Why MySQL could be slow with large tables ?
August 21, 2006 By 141 Comments
… running MySQL 4.1 on RedHat Linux. The box has 2GB of RAM, it has dual 2.8GHz Xeon processors, and /etc/my.cnf… = 8M table_cache = 512 sort_buffer_size = 32M read_buffer_size = 32M read_rnd_buffer_size = 128M myisam_sort_buffer_size = 256M thread_cache = 32 query_cache_size = 256M…
Post: Heikki Tuuri answers to Innodb questions, Part II
November 4, 2007 By 13 Comments
…for the aio read thread. Thus, about 4 readaheads can be in the queue at…cache. The ideal configuration in a dedicated server is: set innodb_flush_method=O_DIRECT in my.cnf…buffer_pool_size Q36: There have been several MySQL bugs opened about multi-core scalability (concurrent queries, autoincrement, …
Post: Updated msl (microslow) patch, installation walk-through!
April 20, 2008 By 17 Comments
…patching file sql/sql_cache.cc patching file …fstack-protector –param=ssp-buffer-size=4 -m64 -mtune=generic’ ‘CXX=gcc’…€™t specify it in my.cnf file, the remaining part…query_time=# Log all queries that have taken more than long_query_time microseconds to execute to file. This option is standard MySQL…
Post: Side load may massively impact your MySQL Performance
November 13, 2011 By 7 Comments
…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…
