… NULL, last_name VARCHAR(45) NOT NULL, last_update TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, PRIMARY KEY (actor_id), KEY idx_actor_last_name… tool ibdconnect was tested on MySQL 5.1 on CentOS 5.6 x86_64. However it expected to work on all versions of MySQL/InnoDB.
Post: Recovery after DROP & CREATE
August 22, 2012 By 1 Comment
… NULL, -> last_name VARCHAR(45) NOT NULL, -> last_update TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, -> PRIMARY KEY (actor_id), -> KEY idx_actor…affected (0.56 sec) # ./page_parser -f /var/lib/mysql/ibdata1 # ./bin/constraints_parser.SYS_TABLES -4Df pages-…
Comment: How to find wrong indexing with glance view
March 8, 2010 By 27 Comments
…null, order_date datetime not null, last_updated timestamp not null default current_timestamp on update current_timestamp, foreign key(item_type_id) references item…MySQL will create the following indexes: unique index on order_id index on item_type_id index on locale_id index on currency_id index on…
Post: Long PRIMARY KEY for Innodb tables
October 3, 2006 By 8 Comments
… tinyint(3) unsigned NOT NULL default ’0′, `ts` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, PRIMARY KEY (`url`,`thumb_width`,`thumb_height`) ) ENGINE=… worries – checking/repairing large MyISAM tables in case of MySQL/System crash is painful and great to be avoided. …
Post: Timezone and pt-table-checksum
September 25, 2012 By 1 Comment
…CURRENT_TIMESTAMP. From the manual, here is how MySQL handles timezone locality with timestamp fields: Values for TIMESTAMP columns are converted from the current… still recalculates the checksums on the fly to get…PRIMARY`) WHERE (1=1) FOR UPDATE; When you update your session timezone (SET @@session…
Post: Joining on range? Wrong!
May 17, 2010 By 10 Comments
… we have proper indexes on all necessary columns! …timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP KEY `itm_prd_id__and__itm_order_timestamp` (`itm_prd_id`,`itm_order_timestamp…A very inefficient approach! MySQL was unable to …UPDATE items_ordered SET itm_order_date = DATE(itm_order_timestamp);…
Post: INSERT ON DUPLICATE KEY UPDATE and summary counters.
May 29, 2006 By 48 Comments
… … ON DUPLICATE KEY UPDATE is very powerful but often forgotten MySQL feature. It was introduced in MySQL 4.1 but I still …takes advantage of is TIMESTAMP field. By default first TIMESTAMP column will have its value automatically updated to current timestamp on insert and update. We actually could…
Post: Infinite Replication Loop
October 10, 2011 By 2 Comments
…timestamp included in the last executed sql statement. As some of them are looping, the timestamp…mysql.com/doc/refman/5.1/en/replication-options-slave.html#option_mysqld_log-slave-updates [4] http://dev.mysql…
Post: Ultimate MySQL variable and status reference list
January 8, 2011 By 4 Comments
…MySQL manual, especially the option and variable reference table. But just as frequently, I want to look up blog posts on…innodb_rollback_on_timeoutblogpercona.commanual Innodb_row_lock_current_waitsblogpercona…commanual unique_checksblogpercona.commanual updatable_views_with_limitblogpercona….
Post: Emulating global transaction ID with pt-heartbeat
November 4, 2011 By 6 Comments
…, because pt-heartbeat updates in server A… the server’s current binary log position,…timestamp. Here’s a sample of what you might see in a three-server replication chain. I’m using sandbox servers on my laptop to illustrate: mysql> select * from heartbeat\G ***************************…
