… default configuration you can’t assume locking table for write will mean no one will be able to …likely would not have change their result set but MySQL has no way to identify which one of them … of course inserts so you can see how much of inserted queries are used: Qcache_hits/Qcache_inserts Other …
Post: Percona XtraDB Cluster: Failure Scenarios with only 2 nodes
July 25, 2012 By 6 Comments
… mysql> insert into percona values (0,’percona1′,’peter’); ERROR 1213 (40001): Deadlock found when trying to get lock; try restarting transaction percona1 mysql> insert into… Percona XtraDB Cluster (mysqld) just run garbd: Currently there is no init script for garbd, but this is something easy to…
Post: Announcing Percona Server for MySQL version 5.1.67-14.4
March 8, 2013 By Leave a Comment
…Biveinis). The server could crash when executing an INSERT or UPDATE statement containing BLOB values for…command line option innodb_changed_pages_limit. MySQL option handling would then shadow the … prefetching the data pages for printing lock information even if no lock information was going to be …
Post: Announcing Percona Server for MySQL version 5.5.29-30.0
February 26, 2013 By Leave a Comment
…Glushchenko). The server could crash when executing an INSERT or UPDATE statement containing BLOB values …command line option innodb_changed_pages_limit. MySQL option handling would then shadow the … prefetching the data pages for printing lock information even if no lock information was going to be …
Post: INSERT INTO ... SELECT Performance with Innodb tables.
July 12, 2006 By 22 Comments
… sec, process no 29895, OS thread id 2894768 updating or deleting mysql tables in use 1, locked 1 LOCK WAIT 3 lock struct(s), heap…/sample` trx id 0 42304626 lock_mode X locks rec but not gap waiting Record lock, heap no 180 PHYSICAL RECORD: n_fields 2… 1, locked 1 2539 lock struct(s), heap size 224576 MySQL thread id 1794751, query id 6994931 localhost root Sending data insert into test…
Post: Test Drive of Solid
September 22, 2006 By 5 Comments
… from Innodb which will do READ-COMMITED for locking reads (SELECT FOR UPDATE/LOCK IN SHARE MODE) as only actual row versions… sec) Test 3: Phantom rows (no phantom rows in repeatable-reads): Session1: mysql> begin; Sessino2: mysql> begin; Session1: mysql> insert into test2 values (4,’FEDERATED…
Post: Improved InnoDB fast index creation
November 6, 2011 By 4 Comments
… mysql> INSERT INTO t(c) VALUES (RAND()); Query OK, 1 row affected (0.00 sec) mysql> INSERT … | init | 0.000008 | | Opening tables | 0.000118 | | System lock | 0.000007 | | setup | 0.000027 | | creating table | 0… with the optimization disabled, and absolutely no effect on the optimized case, which…
Post: Concurrent inserts on MyISAM and the binary log
May 14, 2008 By 7 Comments
… log can result in a different order of execution. The MySQL manual actually says this, but not in the clearest way… like this: Locked – read Low priority read lock But on INSERT…SELECT, you’ll see this: Read lock without concurrent inserts That read lock is what’s blocking the concurrent inserts from happening. There’s no…
Post: Identifying the load with the help of pt-query-digest and Percona Server
December 29, 2011 By 3 Comments
… logging atomically, not just for new connections as in MySQL. This is very helpful for measurement as otherwise we …# rec lock wai 0 0 0 0 0 0 0 # Boolean: # Filesort 4% yes, 95% no # Filesort on 0% yes, 99% no # …0449 0.6% 260 0.0002 1.00 0.00 INSERT poller_output # MISC 0xMISC 0.8137 10.0% 3853 …
Post: How much memory Innodb locks really take ?
July 13, 2006 By 11 Comments
After playing yesterday a bit with INSERT … SELECT I decided to check is Innodb locks are relly as efficient in terms of… bits per locked row; Now lets see how much exclusinve locks take: mysql> begin; Query OK, 0 rows affected (0.00 sec) mysql> select…, ACTIVE 195 sec, process no 10099, OS thread id 1878960 6093 lock struct(s), heap size 503104 MySQL thread id 7429, query id…
