…MySQL replication from this instance, since MySQL replication is asynchronous. What about semi-sync MySQL… groups with some metadata: BEGIN; INSERT INTO users_groups (user_id, group…you can imagine plenty of concurrent clients attempting to modify the …the fsync: set innodb_flush_log_at_trx_commit to …
Post: Concurrent inserts on MyISAM and the binary log
May 14, 2008 By 7 Comments
… MySQL manual actually says this, but not in the clearest way. It just says If you are using the binary log, concurrent inserts are converted to normal inserts for CREATE … SELECT or INSERT … SELECT statements. If you use mysqladmin…
Post: Ultimate MySQL variable and status reference list
January 8, 2011 By 4 Comments
…MySQL manual, especially the…commanual Compressionblogpercona.commanual concurrent_insertblogpercona.commanual connect…insert_delayed_threadsblogpercona.commanual max_join_sizeblogpercona.commanual max_length_for_sort_datablogpercona.commanual max_prepared_stmt_countblogpercona.commanual max_relay_log…
Post: MySQL Server Variables - SQL layer or Storage Engine specific.
June 8, 2006 By 14 Comments
… memory tables. So first MySQL versions did not bother …inserts (multiple value inserts). Really helps if you have really bulk inserts 100-1000+ values per single insert statement. concurrent_insert – Enables concurrent insert… engines transaction logs, slow query log or general log. flush, flush_time…
Post: MySQL Slow query log in the table
May 31, 2007 By 1 Comment
As of MySQL 5.1 get MySQL slow query log logged in mysql.slow_log table instead of the file as you had in previous …, disable concurrent inserts and run long reporting query on the log file query execution is still proceeds. I have not checked if concurrent insert is always forced for log table if…
Post: MySQL Users Conference - Innodb
May 9, 2007 By 6 Comments
… statement duration for Inserts with auto-increment column. This starts giving you problems if you have a lot of concurrent inserts happening to the same table. This was born same as bunch of others due to statement level MySQL Replication… to unleash performance such as multiple purge threads or parallel log recovery features, which he however needs to test properly before…
Post: Announcing Percona Server 5.1.65-14.0
September 4, 2012 By Leave a Comment
… server. Bug fixed #999147 (Laurynas Biveinis). Fixed the upstream MySQL bug #66301. Concurrent INSERT … ON DUPLICATE KEY UPDATE statements on a table with… progress. Bug fixed #686534 (George Ormond Lorch III). Removed error log warnings that occured after enabling innodb_use_sys_stats_table…
Post: Announcing Percona Server 5.5.27-28.0
August 23, 2012 By 5 Comments
… allow access control to system variables. New table INNODB_UNDO_LOGS has been added to allow access to undo segment information… the upstream fix for MySQL bug #64284. Bug fixed #1015109 (Stewart Smith). Fixed the upstream MySQL bug #66301. Concurrent INSERT … ON DUPLICATE KEY UPDATE…
Post: Tuning InnoDB Concurrency Tickets
May 24, 2010 By 5 Comments
…MySQL, here are some example queries and the corresponding number of concurrency tickets used for each: mysql…INSERT w/PRIMARY KEY defined: Number of rows inserted – 1 INSERT w/FOREIGN KEY constraint: Number of rows inserted…
Post: SHOW INNODB STATUS walk through
July 17, 2006 By 40 Comments
… 1151088992 inserting, thread declared inside InnoDB 500 mysql tables in use 1, locked 1 3 lock struct(s), heap size 368, undo log entries 1 MySQL thread id 9697561, query id 188161264 localhost root update insert into child values(2,2… tickets to use. Innodb tries to limit thread concurrency allowing only innodb_thread_concurrency threads to run inside Innodb kernel at the…
