…Created_tmp_disk_tablesblogpercona.commanual Created_tmp_filesblogpercona.commanual Created_tmp_tablesblogpercona.commanual datadirblogpercona.commanual date_formatblogpercona.commanual datetime…
Post: When is MIN(DATE) != MIN(DATE) ?
September 4, 2012 By 5 Comments
…: CREATE TABLE foo ( id INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY, uid INT UNSIGNED NOT NULL, update_time DATETIME NOT NULL, …. INDEX… to force MySQL to use a different index. Imagine our surprise when we tried a FORCE INDEX on (bar) or an IGNORE INDEX(uid) and…. I created a table with a similar structure: CREATE TABLE `foo` ( `i` int(11) NOT NULL AUTO_INCREMENT, `update_date` datetime NOT NULL…
Post: Benchmarking single-row insert performance on Amazon EC2
May 16, 2012 By 17 Comments
…query cache on write heavy workload. OK, so that was all about the configuration of the EC2 instance and MySQL. Now as…the table with secondary indexes is as follows: CREATE TABLE `purchases_index` ( `transactionid` int(11) NOT NULL AUTO_INCREMENT, `dateandtime` datetime DEFAULT NULL, `cashregisterid…
Comment: COUNT(*) vs COUNT(col)
April 25, 2007 By 45 Comments
…index: mysql> show create table wp_comments\G *************************** 1. row *************************** Table: wp_comments Create Table: CREATE TABLE `…datetime NOT NULL default ’0000-00-00 00:00:00′, `comment_date_gmt` datetime… sec) mysql> btw, if there is a smaller secondary index on the table…
Comment: How to find wrong indexing with glance view
March 8, 2010 By 27 Comments
…) not null, order_date datetime not null, last_updated timestamp not null default current_timestamp on update current_timestamp, …20 operators. 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 operator_id You…
Post: Logging Foreign Key errors
September 27, 2012 By Leave a Comment
…- Create the table First we create the table where we are going to store the information: CREATE TABLE foreign_key_errors ( ts datetime NOT… “employees” (“emp_no”) ON DELETE CASCADE The index in the foreign key in table is “PRIMARY” See http://dev.mysql.com/doc/refman… by an index that was referenced by the FK, a PRIMARY KEY. So, the command that causes the error was: mysql> ALTER…
Comment: Real-Life Use Case for "Barracuda" InnoDB File Format
April 24, 2008 By 11 Comments
…`created_at` datetime DEFAULT NULL, `updated_at` datetime DEFAULT NULL, `query_count` int(11) DEFAULT ’0′, `short_html` text, PRIMARY KEY (`id`), KEY `index_document_queries_on_word_document_id` (`word_document_id`) ) ENGINE=InnoDB mysql> show table status like ‘…
Post: Copying InnoDB tables between servers
July 31, 2009 By 11 Comments
…Now on remote server you have to run MySQL server ®…create empty table with the same table definition as on old servers: CREATE DATABASE “testimport”; USE “testimport” CREATE… NULL, `ol_delivery_d` datetime default NULL, `ol_quantity` tinyint…. InnoDB: import: 2 indexes are detected. InnoDB: Progress …
