…-running transaction with a REPEATABLE READ isolation level and started WITH … settings were innodb_buffer_pool_size=16G innodb_log_file_size=1900M innodb_…max_dirty_pages_pct=80 innodb_file_format=barracuda innodb_file_per_table max_connections… TPS. MySQL 5.6.2 Results Now let’s test MySQL 5.6…
Comment: Database problems in MySQL/PHP Applications
November 6, 2006 By 13 Comments
… situation where mysql reports max connections reached and freezes, with a bunch of processes waiting to finish. Also, mysql will … tmp_table_size=1000M sort_buffer_size = 100M read_buffer_size = 100M read_rnd_buffer_size = 100M myisam_sort_buffer_size = 100M max_length_for_sort_data=2048 max_sort_…
Comment: MySQL Server Memory Usage
September 1, 2006 By 21 Comments
…mysql/slow-queries.log max_connections=650 open_files_limit=6144 max_connect_errors=10000 interactive_timeout=3600 wait_timeout=3600 key_buffer_size…
Comment: New Forum Categories: Help Wanted, For Hire
March 5, 2013 By 1 Comment
…max_allowed_packet = 50M # performance sort_buffer_size = 8M read_buffer_size = 2M query_prealloc_size = 65536 read_rnd_buffer_size = 8M table_open_cache = 1024 thread_cache_size…
Post: Aligning IO on a hard disk RAID – the Benchmarks
June 9, 2011 By 13 Comments
…buffer_size = 8M innodb_buffer_pool_size = 128M innodb_log_file_size = 64M innodb_log_files_in_group = 2 innodb_read…max_connections = 2500 max_connect_errors = 10 table_cache = 2048 max_allowed_packet = 16M binlog_cache_size = 16M max_heap_table_size = 64M thread_cache_size = 32 query_cache_size…
Post: New SpecJAppServer results at MySQL and Sun.
November 12, 2008 By Leave a Comment
…READ-COMMITTED max_allowed_packet = 1M max_connections=300 max_connect_errors=100 table_cache = 6000 read_rnd_buffer_size = 2M sort_buffer_size = 32k thread_cache = 16 query_cache_size…
Comment: Solving RPM installation conflicts in CentOS 5 and CentOS 6
February 21, 2013 By 6 Comments
…read_buffer_size=131072 max_used_connections=0 max_threads=151 thread_count=0 connection_count=0 It is possible that mysqld could use up to key_buffer_size + (read_buffer_size…
Comment: MySQL Server Memory Usage
December 20, 2012 By 21 Comments
…max_connections = 600 #thread_stack= 150M key_buffer = 256M key_buffer_size = 256M myisam_sort_buffer_size = 16M join_buffer_size = 64M read_buffer_size = 16M sort_buffer_size…
Comment: What to tune in MySQL Server after installation
October 8, 2012 By 118 Comments
…Buffers] join_buffer_size = 32M key_buffer_size = 640M myisam_sort_buffer_size = 64M sort_buffer_size = 4M read_rnd_buffer_size = 12M read_buffer_size = 4M [Server] server-id = 1 log-bin=/data/mysql…
Comment: MySQL Connection Timeouts
January 24, 2013 By 4 Comments
…size=100G myisam_sort_buffer_size=30M key_buffer_size=129M read_buffer_size=64K read_rnd_buffer_size=256K sort_buffer_size=256K #*** INNODB Specific options *** innodb_data_home_dir=”D:/work/MySQL…
