…_cache = 512M sort_buffer_size = 2M read_buffer_size = 2M read_rnd_buffer_size = 1M myisam_sort_buffer_size = 64M thread_cache_size = 80 query_cache_size = 32M thread_concurrency = 8 query_cache_type = 1 query_cache_limit = 32M thread_stack=256K myisam_data_pointer_size…
Comment: What to tune in MySQL Server after installation
June 29, 2009 By 118 Comments
…=255 query_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…_flush_log_at_trx_commit=1 innodb_log_buffer_size=1M innodb_buffer_pool_size=200M innodb_log_file_size=10M innodb_thread_concurrency=8
Comment: What to tune in MySQL Server after installation
June 22, 2009 By 118 Comments
…=255 query_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…_commit=1 innodb_log_buffer_size=1M innodb_buffer_pool_size=200M innodb_log_file_size=10M innodb_thread_concurrency=8 My Problem is that…
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…_size=4M innodb_buffer_pool_size=304M innodb_log_file_size=152M innodb_thread_concurrency=8 RAM: 1GB Processor: Intel P4 2.253GHz Cache size:…
Comment: table_cache negative scalability
April 14, 2010 By 23 Comments
… 2 thread_cache_size = 100 max_connections = 400 table_cache = 20000 open_files_limit = 40000 max_binlog_size = 500M max_allowed_packet = 20M tmp_table_size…log_buffer_size = 8M innodb_additional_mem_pool_size = 8M innodb_log_file_size = 256M innodb_log_files_in_group = 2 innodb_thread_concurrency = …
Comment: table_cache negative scalability
April 14, 2010 By 23 Comments
… 2 thread_cache_size = 100 max_connections = 400 table_cache = 20000 open_files_limit = 40000 max_binlog_size = 500M max_allowed_packet = 20M tmp_table_size…log_buffer_size = 8M innodb_additional_mem_pool_size = 8M innodb_log_file_size = 256M innodb_log_files_in_group = 2 innodb_thread_concurrency = …
Post: PBXT benchmarks
April 8, 2007 By 14 Comments
…(TM) CPU 3.20GHz stepping : 8 cpu MHz : 3192.222 cache size : 8192 KB 32GB of RAM Fedora Core release 5 (Bordeaux… Opteron(tm) Processor 2210 stepping : 2 cpu MHz : 1800.163 cache size : 1024 KB 4GB of RAM MySQL version We used MySQL… for 1, 4, 16, 64, 128, 256, 512 concurrent threads. 3. For each thread perform a warm-up run (duration 180 sec), and…
Post: SSD, XFS, LVM, fsync, write cache, barrier and lost transactions
March 2, 2009 By 32 Comments
… field into InnoDB table. InnoDB parameters are innodb_buffer_pool_size=3G innodb_data_file_path=ibdata1:10M:autoextend innodb_file…=1 innodb_log_buffer_size=8M innodb_log_files_in_group=2 innodb_log_file_size=256M innodb_thread_concurrency=0 innodb_flush_log… to warranty Durability with SSD we have to disable write-cache which can affect performance results significantly (I have no results…
Post: Aligning IO on a hard disk RAID – the Benchmarks
June 9, 2011 By 13 Comments
…= 16M binlog_cache_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…and improves performance up to 15% in case of 8 threads running concurrently. Because the customer was running a database which …
Comment: New Forum Categories: Help Wanted, For Hire
March 5, 2013 By 1 Comment
…_rnd_buffer_size = 8M table_open_cache = 1024 thread_cache_size = 8 query_cache_size = 128M join_buffer_size = 8M long_query_time=300 key_buffer_size = 500M concurrent_insert…_rnd_buffer_size = 8M table_open_cache = 1024 thread_cache_size = 8 query_cache_size = 128M join_buffer_size = 8M long_query_time=300 key_buffer_size = 500M concurrent_insert…
