… this scenario: CREATE TABLE `t1` ( `c1` int(11) NOT NULL AUTO_INCREMENT, `c2` varchar(10) NOT NULL, PRIMARY KEY (`c1`) ) ENGINE… an accidental UPDATE statement that changes a row: UPDATE `t1` SET `c2` = ‘tom’ WHERE `c1` = 2; If we examine this UPDATE using the… 39 flags: STMT_END_F BINLOG ‘ crSBUBMBAAAALAAAAMYDAAAAACcAAAAAAAEABHRlc3QAAnQxAAIDDwIKAAA= crSBUBgBAAAAYAAAACYEAAAAACcAAAAAAAEAAv///AEAAAAHbWljaGFlbPwBAAAABG1hdHT8AgAA AAV2YWRpbfwCAAAABG1hdHT8AwAAAAZhYW1pbmH8AwAAAARtYXR0 ‘/*!*/; ### UPDATE test.t1 ### WHERE ### @1=1 /* INT meta=0 nullable=0…
Comment: When Does InnoDB Update Table Statistics? (And When It Can Bite)
October 7, 2011 By 7 Comments
… exist – innodb_stats_on_metadata is authoritative, if innodb_stats_auto_update=0, innodb_stats_on_metadata should also be 0 to… your indexes. @Steve, Adding this options may disable the statistics update based on modified rows but not when using the metadata…
Comment: When Does InnoDB Update Table Statistics? (And When It Can Bite)
October 6, 2011 By 7 Comments
… the sentence “When set to 0, …” refers to “innodb_stats_auto_update“. On my MySQL Community servers I always set “innodb_stats…
Comment: Should we proclaim MySQL Community Edition Dead ?
July 3, 2008 By 34 Comments
Well, I’ve give a try to Provenscaling Yum Repository. 5.0.54 works fine, so I trun auto update on. But 5.0.60 broken our internal server. Then I dicide just stick with old-good 5.0.51a.
Post: Edge-case behavior of INSERT...ODKU
October 27, 2012 By 6 Comments
… table to illustrate the situation: CREATE TABLE update_test ( id INT UNSIGNED NOT NULL AUTO_INCREMENT, username VARCHAR(20) NOT NULL, host… end of the auto-increment range, and then try to insert another one: (root@localhost) [test]> insert into update_test (id,username… the id is equal to the auto-increment max value, which is the one that got updated. The secondary UNIQUE on username…
Post: Efficient Boolean value storage for Innodb Tables
April 23, 2008 By 6 Comments
…_length: 0 Data_free: 0 Auto_increment: NULL Create_time: 2008-04-24 00:54:18 Update_time: NULL Check_time: NULL…_length: 0 Data_free: 0 Auto_increment: NULL Create_time: 2008-04-24 00:37:48 Update_time: NULL Check_time: NULL…_length: 0 Data_free: 0 Auto_increment: NULL Create_time: 2008-04-24 00:58:01 Update_time: NULL Check_time: NULL…
Post: Ultimate MySQL variable and status reference list
January 8, 2011 By 4 Comments
…suspicious_udfsblogpercona.commanual ansiblogpercona.commanual auto_increment_incrementblogpercona.commanual auto_increment_offsetblogpercona.commanual …tx_isolationblogpercona.commanual unique_checksblogpercona.commanual updatable_views_with_limitblogpercona.commanual Uptimeblogpercona.commanual…
Post: Improved InnoDB fast index creation
November 6, 2011 By 4 Comments
… copying the data into a temporary table, secondary indexes are updated by inserting individual rows rather than sorting; OPTIMIZE TABLE could…_length: 278839296 Data_free: 1838153728 Auto_increment: 4587468 Create_time: 2011-11-06 10:01:18 Update_time: NULL Check_time: NULL…_length: 187465728 Data_free: 1930428416 Auto_increment: 4587468 Create_time: 2011-11-06 10:04:10 Update_time: NULL Check_time: NULL…
Post: MySQL Users Conference - Innodb
May 9, 2007 By 6 Comments
… range scans. We surely should benchmark this aspect separately. Improved Auto Increment handling Yet another known Innodb problem is table locks… auto increment values are assigned but never used. There are probably similar problems in INSERT IGNORE and ON DUPLICATE KEY UPDATE cases… match where clause (think for example about running not-indexed UPDATE which has to lock all rows in Innodb right now…
Post: How much space does empty Innodb table take ?
December 16, 2008 By 7 Comments
…_length: 32768 Data_free: 0 Auto_increment: NULL Create_time: 2008-12-16 20:43:31 Update_time: NULL Check_time: NULL…_length: 360448 Data_free: 0 Auto_increment: NULL Create_time: 2008-12-16 20:58:49 Update_time: NULL Check_time: NULL…_length: 671744 Data_free: 0 Auto_increment: NULL Create_time: 2008-12-16 20:58:49 Update_time: NULL Check_time: NULL…
