…Xeon E5-2680 (8 cores, 16 threads) with fast IO (OCZ R4 1…MyISAM does not maintain checksum consistency during regular operations and is not ACID compliant. MyISAM and InnoDB may perform differently under concurrency…/data basedir=/usr/local/mysql socket=/var/lib/mysql/mysql.sock user=justin innodb_…
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
…getting MyISAM because Innodb was disabled for some reason was very error prone gotcha. Note this is as far as MySQL …innodb_thread_concurrency this will reduce overhead associated with grabbing and releasing innodb_thread_concurrency slot but will increase potential starvation of queued threads …
Post: InnoDB vs MyISAM vs Falcon benchmarks - part 1
January 8, 2007 By 117 Comments
… MySQL version We used MySQL 5.1.14-beta sources for MyISAM / InnoDB and MySQL 5.1.14-falcon bitkeeper tree bk://mysql.bkbits.net/mysql…-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…
Post: MyISAM Scalability and Innodb, Falcon Benchmarks
October 12, 2007 By 10 Comments
… benchmark shows following results for MyISAM using MySQL 5.0.45 run on 4 Core 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…
Post: MySQL Performance on Memory Appliance
March 31, 2008 By 23 Comments
…system. I helped Violin Memory to optimize MySQL for customer workload and Violin memory and…thread which grew to 13000 req/sec when 8 concurrent threads were used. Compare this to 20.000 queries/sec from single thread…back to the client. I tested MyISAM with myisam_use_mmap option which did not seems…
Post: Aligning IO on a hard disk RAID – the Benchmarks
June 9, 2011 By 13 Comments
…IO alignment, not different MySQL configurations, I didn’t try out different MySQL versions or settings….= 8M myisam_sort_buffer_size = 8M myisam_max_sort_file_size = 10G myisam_repair_threads = 1 myisam_recover …up to 15% in case of 8 threads running concurrently. Because the customer was running …
Comment: New Forum Categories: Help Wanted, For Hire
March 5, 2013 By 1 Comment
…_time=300 key_buffer_size = 500M concurrent_insert=2 myisam_sort_buffer_size = 64M # innodb …1 innodb_flush_method=O_DIRECT innodb_thread_concurrency=16 innodb_buffer_pool_size = 4500M …Replication-skip replicate-ignore-table=mysql.gsd_runs replicate-ignore-table=mysql.gsd_monitor ======== ==> max_…
Post: Innodb Table Locks
July 31, 2012 By 4 Comments
…, ACTIVE 26 sec mysql tables in use 2, locked 0 MySQL thread id 53038, OS thread handle 0x7ff759b22700, query … “IX” in SHOW ENGINE INNODB STATUS while concurrent updates to this table will be prevented… difference between MyISAM and Innodb when it comes to Table Level Locks. For MyISAM tables running…
Post: MyISAM concurrent insert
June 13, 2006 By 12 Comments
…threads Quadxeon with enabled concurrent-insert Quadxeon –skip-concurrent-insert Sun V40z with enabled concurrent-insert Sun V40z –skip-concurrent-…concurrent-insert with –skip-concurrent-insert can improve MyISAM performance. As I said the reason of bad scalability is rw-locks and currently MySQL…
