… thread_id=8 exec_time=0 error_code=0 SET TIMESTAMP=1359714063/*!*/; ALTER TABLE test add column id_2 int(11… thread_id=7 exec_time=0 error_code=0 SET TIMESTAMP=1359714099/*!*/; BEGIN /*!*/; # at 726 # at 773 #130201 11:21:35… for update; +—+ | i | +—+ | 1 | +—+ 1 row in set (0.00 sec) session2 > CREATE TABLE t1(i int(11) not null auto_increment…
Post: Using Flexviews - part two, change data capture
March 25, 2011 By 26 Comments
… usually operate in one of the following ways: Timestamps (usually more than one) to identify rows that… –table=demo success Note that you can enable auto_changelog=true in the config file to …the deletion. Though they are none shown here, updates would be represented by a deletion followed by an…
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: Percona Server 5.5.10 (Release Candidate)
April 4, 2011 By 4 Comments
…timestamp_always. (Oleg Tsarev) Old system variable slow_query_log_microseconds_timestamp was renamed to slow_query_log_timestamp… (Yasufumi Kinoshita) Old system variable innodb_auto_lru_dump was renamed to …Kinoshita) Bug Fixes Bug #724674 – Ported an updated version of the original implementation …
Post: To UUID or not to UUID ?
March 13, 2007 By 28 Comments
… buffer. The most efficient approach here is not to use auto_increment but use certain partitioned sequences, for example you can… considered best for parallel insert/updates) has pretty much table level locks when it comes to auto_increment columns, which is however… random they are – there is timestamp based part in UUID which has similar properties to auto_increment and which could be used…
Post: Identifying the load with the help of pt-query-digest and Percona Server
December 29, 2011 By 3 Comments
…_sent: 1 Rows_examined: 655360 use test; SET timestamp=1325145746; select count(*) from auto_inc; Compare that to Percona Server with log…_wait: 0.000000 # InnoDB_pages_distinct: 973 SET timestamp=1325146286; select count(*) from auto_inc; Note that logging all queries in this….1956 2.4% 89 0.0022 1.00 0.01 UPDATE wp_options # 7 0x7AEDF19FDD3A33F1 0.1381 1.7% 909 0…
Post: Statistics of InnoDB tables and indexes available in xtrabackup
September 14, 2009 By 6 Comments
…) unsigned NOT NULL, `message_published` timestamp NOT NULL default CURRENT_TIMESTAMP, `kind` enum(‘link’,'img’) NOT NULL…` (`from_message_id`,`link_id`) ) ENGINE=InnoDB AUTO_INCREMENT=26141165 DEFAULT CHARSET=utf8; And … as table is really mostly inserted in, updates and deletes are rare). And let’s…
Post: Announcing Percona Server for MySQL version 5.5.29-30.0
February 26, 2013 By Leave a Comment
…server could crash when executing an INSERT or UPDATE statement containing BLOB values for a compressed table… was displayed incorrectly when slow_query_log_timestamp_precision variable was set to microseconds. Bug fixed … master needs to have more than one auto-increment table and the slave needs to …
Post: Debugging problems with row based replication
May 6, 2010 By 12 Comments
… TABLE `t1` ( `c1` int(11) NOT NULL AUTO_INCREMENT, PRIMARY KEY (`c1`) ) ENGINE=InnoDB; Query… exec_time=0 error_code=0 SET TIMESTAMP=1273174976/*!*/; BEGIN /*!*/; # at 340782 # at 340823 #…_log_pos 340718 Update_rows: table id 15 flags: STMT_END_F ### UPDATE repl.t1 ### WHERE ### @…
Post: Percona Toolkit Webinar followup Q&A
December 19, 2012 By 1 Comment
…slow.log. As mentioned during the webinar, the tool auto detects the log type so typically you will …printed after one capture is selected from the timestamp list (the timestamp list is the view you get when …few tables, in rows that probably won’t be updated short term), or if the data set size, …
