… fast machine with a Xeon E5-2680 (8 cores, 16 threads) with fast IO (OCZ R4 1.6TB) and 128GB memory…. MyISAM does not maintain checksum consistency during regular operations and is not ACID compliant. MyISAM and InnoDB may perform differently under concurrency, which this benchmark does not cover. I will make a follow-up post about concurrency…
Post: MyISAM Scalability and Innodb, Falcon Benchmarks
October 12, 2007 By 10 Comments
… System: Threads queries/sec 1 161 2 107 4 110 8 121 16 138 As you see running 2-4 threads concurrently we get result by 30% worse than with 1 thread, although it’s only simple… with disabled key_cache (=0). Results for MyISAM with key_buffer_size=0 Threads queries/sec 1 128 2 113 4 193…
Post: InnoDB vs MyISAM vs Falcon benchmarks - part 1
January 8, 2007 By 117 Comments
…-buffer-pool-size=1500M –innodb-log-file-size=100M –innodb-thread-concurrency=8 –max-connections=1500 –table-cache=512 –net_read_timeout… query for 1, 4, 16, 64, 128, 256 concurrent threads. 3. For each thread perform a warm-up run (duration 180 sec), and… all million rows. InnoDB is better than MyISAM by ~30% with 4-16 threads, but MyISAM scales a bit better in this case…
Post: Ultimate MySQL variable and status reference list
January 8, 2011 By 4 Comments
…thread_cache_sizeblogpercona.commanual thread_concurrencyblogpercona.commanual thread_handlingblogpercona.commanual thread_stackblogpercona.commanual Threads_cachedblogpercona.commanual Threads_connectedblogpercona.commanual Threads_createdblogpercona.commanual Threads…
Post: MySQL 5.5 and MySQL 5.6 default variable values differences
February 21, 2013 By 8 Comments
…good change as trying to create Innodb table but getting MyISAM because Innodb was disabled for some reason was very …innodb_thread_concurrency this will reduce overhead associated with grabbing and releasing innodb_thread_concurrency slot but will increase potential starvation of queued threads …
Comment: New Forum Categories: Help Wanted, For Hire
March 5, 2013 By 1 Comment
… = 8M long_query_time=300 key_buffer_size = 500M concurrent_insert=2 myisam_sort_buffer_size = 64M # innodb innodb_additional_mem_pool…_at_trx_commit=1 innodb_flush_method=O_DIRECT innodb_thread_concurrency=16 innodb_buffer_pool_size = 4500M innodb_lock_wait_timeout…_at_trx_commit=1 innodb_flush_method=O_DIRECT innodb_thread_concurrency=16 innodb_buffer_pool_size = 4500M innodb_lock_wait_timeout…
Post: MyISAM concurrent insert
June 13, 2006 By 12 Comments
…better) threads Quadxeon with enabled concurrent-insert Quadxeon –skip-concurrent-insert Sun V40z with enabled concurrent-insert Sun V40z –skip-concurrent-insert 1…doing INSERT not often than disabling concurrent-insert with –skip-concurrent-insert can improve MyISAM performance. As I said the …
Comment: What to tune in MySQL Server after installation
December 7, 2006 By 118 Comments
… servers are on same gig network. All my tables are MyIsam. Following is out of mytop MySQL on localhost (5.0… sort_buffer_size = 1024M read_buffer_size = 512M myisam_sort_buffer_size = 1024M thread_cache = 16 query_cache_size = 512M max_connections…=wait_timeout=3000 # Try number of CPU’s*2 for thread_concurrency thread_concurrency = 8 Please suggest which parameter to tweak. And where to…
Post: Fix of InnoDB/XtraDB scalability of rollback segment
January 18, 2009 By 9 Comments
… insert/delete queries). By our results the problem is in concurrency on rollback segment, which by default is single and all…] #mysqld options in alphabetical order user=root default_table_type=MYISAM innodb_buffer_pool_size=6G innodb_data_file_path=ibdata1…_files_in_group=2 innodb_log_file_size=128M innodb_thread_concurrency=0 innodb_extra_rsegments=16 max_connections=3000 query_cache…
Comment: Why MySQL could be slow with large tables ?
June 20, 2007 By 141 Comments
… are specifics from one system. It has exactly one table. MYISAM table with the following activity: Per day: 1. INSERTS: 1…_size=24M read_buffer_size=9M max_connect_errors=10 thread_concurrency=4 myisam_sort_buffer_size=950M character-set-server=utf8 default…_slow_queries=/var/log/mysql-slow.log sql-mode=TRADITIONAL concurrent_insert=2 low_priority_updates=1 The problem was that…
