… (and by extension, safer) to run (CREATE TABLE AS SELECT *, UPDATE host, INSERT) a few times than trying to recreate the grants…
Comment: Follow these basics when migrating to Percona XtraDB Cluster for MySQL
May 2, 2013 By 10 Comments
Comment: MySQL 5.6 - InnoDB Memcached Plugin as a caching layer
March 29, 2013 By 10 Comments
… about SQL INSERT? How does it compare to InnoDB Memcache storing? 2) The gain in performance from SQL SELECT to InnoDB Memcache…
Post: Concurrent inserts on MyISAM and the binary log
May 14, 2008 By 7 Comments
… was only inserted into (and selected from). Instead, the blocked statements were because of INSERT… SELECT statements that were running against the table, selecting data…, concurrent inserts are converted to normal inserts for CREATE … SELECT or INSERT … SELECT statements. If you use mysqladmin debug, you’ll see an ordinary SELECT gets…
Post: INSERT INTO ... SELECT Performance with Innodb tables.
July 12, 2006 By 22 Comments
… transaction which is running INSERT .. SELECT statement. This would make this transaction to be applied on the slave before INSERT… SELECT statement and possibly… id 6994931 localhost root Sending data insert into test select * from sample ——– As you can see INSERT… SELECT has a lot of lock structs…
Post: Ultimate MySQL variable and status reference list
January 8, 2011 By 4 Comments
…commanual delayed_insert_limitblogpercona.commanual Delayed_insert_threadsblogpercona.commanual delayed_insert_timeoutblogpercona….Select_full_joinblogpercona.commanual Select_full_range_joinblogpercona.commanual Select_rangeblogpercona.commanual Select_range_checkblogpercona.commanual Select…
Post: Avoiding auto-increment holes on InnoDB with INSERT IGNORE
November 29, 2011 By 8 Comments
… problems are even worse with long running queries like INSERT INTO table1 … SELECT … FROM table2. In version 5.1.22 and later… KEY `uniqname` (`name`) ) ENGINE=InnoDB; Insert a value using a LEFT OUTER JOIN: insert into foo(name) select 1 from mutex left outer… will see, the INSERT is ignored and no rows are inserted. The same behaviour as INSERT IGNORE: insert into foo(name) select 1 from mutex…
Post: Faster MySQL failover with SELECT mirroring
February 1, 2009 By 9 Comments
… the insert buffer. As Peter explained in his recent post on the insert buffer, the other thing the SELECTs do is keep the insert buffer in a production steady-state. The buffered records are forced to be merged by the SELECTs, and a lot more of the pages from the insert buffer are in the buffer…
Post: Edge-case behavior of INSERT...ODKU
October 27, 2012 By 6 Comments
… this table were almost exclusively INSERT … ON DUPLICATE KEY UPDATE (INSERT ODKU), with the columns from the INSERT part of the statement corresponding… happens if we try an INSERT … ODKU? First, recall what’s in our table: (root@localhost) [test]> select * from update_test; +————+———-+———+———————+ | id…
Post: Debugging problems with row based replication
May 6, 2010 By 12 Comments
…) Insert a single “seed” row into the table: INSERT INTO repl.t1 VALUES (); Query OK, 1 row affected (0.00 sec) INSERT … SELECT a few times to get some dummy data: insert into repl.t1 select NULL from t1; Query OK…
Comment: MySQL Server Memory Usage
September 1, 2006 By 21 Comments
…’, ’0′ ‘Com_ha_read’, ’0′ ‘Com_help’, ’0′ ‘Com_insert‘, ’17889656′ ‘Com_insert_select‘, ’11′ ‘Com_kill’, ’47′ ‘Com_load’, ’0′ ‘Com_load…’, ’1462755007′ ‘Rpl_status’, ‘NULL’ ‘Select_full_join’, ’0′ ‘Select_full_range_join’, ’0′ ‘Select_range’, ’5683551′ ‘Select_range_check’, ’0′ ‘Select_scan’, ’1104831′ ‘Slave_open…
