… enable innodb_locks_unsafe_for_binlog option, which will relax locks which Innodb sets on statement execution, which generally gives better concurrency. However… to use: SELECT * FROM tbl1 INFO OUTFILE ‘/tmp/tbl1.txt’; LOAD DATA INFILE ‘/tmp/tbl1.txt’ INTO TABLE tbl2; instead of: INSERT INTO…
Post: Concurrent inserts on MyISAM and the binary log
May 14, 2008 By 7 Comments
… had an interesting surprise with concurrent inserts into a MyISAM table. The inserts were not happening concurrently with SELECT statements; they were… the middle of it and prevents concurrent inserts. (You can configure the server to permit concurrent inserts even when there are holes… the old trick of SELECT INTO OUTFILE followed by LOAD DATA INFILE. You can use InnoDB instead. Or you can do something more elaborate…
Post: MySQL Users Conference - Innodb
May 9, 2007 By 6 Comments
…with most popular transactional storage engine for MySQL – Innodb. Innodb Storage Engine was covered in a lot of…not yet know answer for – for example will LOAD DATA INFILE be optimized same way as for MyISAM tables…cases. Gap or next-key locks which limit concurrency in many cases can be removed for …
Post: High Rate insertion with MySQL and Innodb
January 7, 2011 By 16 Comments
…about 15% in MySQL 5.5.8 with 8 concurrent threads. This both shows there is a substantial … used for start. Using multiple buffer pools with innodb_buffer_pool_instances=8 was very important. Second thing …would get much lower numbers. In fact we used load data infile which is one of the ways to get …
Post: XtraDB/InnoDB CPU bound benchmarks on 24cores server
December 29, 2008 By 6 Comments
…innodb_log_file_size=512M innodb_status_file=0 innodb_thread_concurrency=0 innodb_io_capacity=1000 innodb_write_io_threads = 16 innodb…concurrency=16 thread_stack=196K tmp_table_size=64M transaction_isolation=REPEATABLE-READ local-infile…
Post: Ultimate MySQL variable and status reference list
January 8, 2011 By 4 Comments
…innodb_concurrency_ticketsblogpercona.commanual innodb_data_file_pathblogpercona.commanual Innodb_data_fsyncsblogpercona.commanual innodb_data_home_dirblogpercona.commanual Innodb_data_pending_fsyncsblogpercona.commanual Innodb_data_pending_readsblogpercona.commanual Innodb_data…slave_load_…
Post: Shard-Query EC2 images available
May 11, 2011 By 2 Comments
…loaded with the data used in the previous Shard-Query blog post. The data…innodb-stats-sample-pages=256 innodb-stats-update-need-lock=0 innodb-status-file innodb-strict-mode innodb-thread-concurrency=0 innodb-thread-concurrency-timer-based innodb…
