… the system with 8 cores was used while for database 4 cores was enough. Does it mean the J2EE system got…_buffer_size = 2M sort_buffer_size = 32k thread_cache = 16 query_cache_size = 0M thread_concurrency = 8 max_heap_table_size=200M log… of performance. innodb_thread_concurrency = 0 Good! So Innodb performed best in this workload without restricting number of threads inside Innodb Kernel. Again…
Post: XtraDB/InnoDB CPU bound benchmarks on 24cores server
December 29, 2008 By 6 Comments
…_size=1M default_table_type=MYISAM ft_min_word_len=4 innodb_additional_mem_pool_size=16M innodb_buffer_pool_size…_status_file=0 innodb_thread_concurrency=0 innodb_io_capacity=1000 innodb_write_io_threads = 16 innodb_read_io_threads = 16 join_buffer_size…_locking sort_buffer_size=64K table_cache=2048 thread_cache_size=16 thread_concurrency=16 thread_stack=196K tmp_table_size=64M transaction_isolation…
Comment: Returning to InnoDB scalability
August 6, 2006 By 42 Comments
… innodb_thread_concurrency to 12. Currently I’m not seeing any of the problems I was seeing before when innodb_thread_concurrency was over 4. On a side note, would you still recommend following the innodb_thread_concurrency = ( 2* cpu ) pattern…
Post: Announcing Percona XtraBackup 2.0.4
December 4, 2012 By 2 Comments
… the safe-slave-backup option, SQL_THREAD was left in stopped state causing the slave thread to lag behind. This was fixed… before terminating with a timeout error and starting the SQL_THREAD only if it was running initially. Bug fixed #1037379 (Alexey… be run concurrently. Bug fixed #1077800 (Stewart Smith). Release notes with all the bugfixes for Percona XtraBackup 2.0.4 are available…
Post: InnoDB benchmarks
January 3, 2007 By 15 Comments
….12 with fix of thread trashing 5.1.14 with all fixes 5.0.30 just for comparison. 4.1.22 old…-buffer-pool-size=1500M –innodb-log-file-size=100M –innodb-thread-concurrency=8 –max-connections=1500 –table-cache=512 Description of benchmark… were affected on multi-CPU systems. Used hardware: CentOS release 4.4 (Final) 2 Ñ… Dual Core Intel XEON 5130 model name…
Comment: What to tune in MySQL Server after installation
June 22, 2009 By 118 Comments
…_buffer_pool_size=200M innodb_log_file_size=10M innodb_thread_concurrency=8 My Problem is that, day by day i see… use Current pager: stdout Using outfile: ” Using delimiter: ; Server version: 4.1.20 Protocol version: 10 Connection: Localhost via UNIX socket….sock Uptime: 72 days 19 hours 45 min 58 sec Threads: 1 Questions: 10163302 Slow queries: 149 Opens: 149457 Flush tables…
Comment: T2000 CPU Performance - Watch out
May 1, 2008 By 12 Comments
… running best at 32 thread concurrency — showing I believe a limit of MySQL to scaling out to more threads than this. Disk IO… bottlenecks. With low numbers of threads the Niagara was (predictably) slow, I only have results here from 4 threads upwards, but I can…=oltp –num-threads= –max-time=60 –max-requests=0 –oltp-read-only=on run T5120: X=4: 400 TPS X…
Comment: What to tune in MySQL Server after installation
December 7, 2006 By 118 Comments
…. All slave are getting behind master. Server details Dual Xeon, 4 GB ram All servers are on same gig network. All… = 1024M read_buffer_size = 512M myisam_sort_buffer_size = 1024M thread_cache = 16 query_cache_size = 512M max_connections = 300 max…=wait_timeout=3000 # Try number of CPU’s*2 for thread_concurrency thread_concurrency = 8 Please suggest which parameter to tweak. And where to…
Comment: Choosing innodb_buffer_pool_size
September 24, 2010 By 39 Comments
…_buffer_pool_size 1G innodb_log_file_size 24M innodb_thread_concurrency 16 innodb_lock_wait_timeout 120 max_heap_table_size… innodb_data_file_path ibdata1:10M:autoextend innodb_file_io_threads 4 thread_concurrency 8 innodb_max_dirty_pages_pct 90 When i run…
Comment: What to tune in MySQL Server after installation
December 15, 2009 By 118 Comments
…, 0.0% sy, 0.0% ni, 98.6% id, 1.4% wa, 0.0% hi, 0.0% si Cpu4 : 100.0… read_rnd_buffer_size = 8M myisam_sort_buffer_size = 64M thread_cache_size = 8 query_cache_size = 32M log_queries_not… skip-name-resolve # Try number of CPU’s*2 for thread_concurrency thread_concurrency = 16 set-variable=max_connections=2000 [mysql.server] user=mysql…
