…Table Structure The table structure of the table with no secondary indexes is as follows: CREATE TABLE `purchases_noindex` ( `transactionid` int(11) NOT NULL AUTO_INCREMENT…
Post: AUTO_INCREMENT and MERGE TABLES
September 11, 2008 By Leave a Comment
…table does not even stores auto_increment value (and of course does it without any warnings) Neither setting auto_increment value for underlying MyISAM tables works: mysql> alter table a1 auto_increment…
Post: Efficient Boolean value storage for Innodb Tables
April 23, 2008 By 6 Comments
… 1970324836974591 Index_length: 1024 Data_free: 0 Auto_increment: NULL Create_time: 2008-04-24 …for MyISAM and Innodb tables, however it is not as convenient to work with. Using NULL as one of flag values…set (0.22 sec) Should you go and change all flags to use this approach ? I do not think so – for…
Post: Hacking to make ALTER TABLE online for certain changes
October 29, 2007 By 26 Comments
…a nutshell, all you have to do is create another table with desired table structure and switch .frm table definition files. For safety, I’d… in set (0.00 sec) mysql> INSERT INTO `huge_table` (text) VALUES (‘test’); ERROR 1062 (23000): Duplicate entry ’0′ for key 1 Unfortunately, adding auto_increment…
Post: STOP: DELETE IGNORE on Tables with Foreign Keys Can Break Replication
February 2, 2012 By 1 Comment
…table t1 – both columns have identical set of rows for simplicity. CREATE TABLE `t1` ( `t1_c1` int(10) unsigned NOT NULL AUTO_INCREMENT…for int in {1..2000}; do ./master/use test -e “insert into t1 values…
Post: Long PRIMARY KEY for Innodb tables
October 3, 2006 By 8 Comments
… primary key with value distribution far from sequential. For one of the…the database: CREATE TABLE `imagecache` ( `url` varchar(255) character set latin1 NOT NULL default…key – why did not I use auto_increment id in this case ? I…all table data in leafs anyway. Top level pages can get a bit larger for…
Post: Dynamic row format for MEMORY tables
September 6, 2011 By 3 Comments
…engine. This is true for all MySQL versions, including …to set the data block size at CREATE TABLE time,…for both row formats. (Speaking very strictly, the VM Peak value…For that we modify the default sysbench schema to be the following: CREATE TABLE sbtest (id INT(10) UNSIGNED NOT NULL AUTO_INCREMENT…
Post: MySQL Users Conference - Innodb
May 9, 2007 By 6 Comments
…table. This was born same as bunch of others due to statement level MySQL Replication which among other requirements, needs all auto-increment values…for cases when number of rows in auto-increment batch insert is not known as we do not have to allocate sequential auto increment values…
Post: Statement based replication with Stored Functions, Triggers and Events
December 16, 2011 By 3 Comments
…AUTO INCREMENTAL VALUES In order to have the same auto incremental values on master and slaves the actual used auto incremental value…auto incremental value: #111214 21:54:06 server id 1 end_log_pos 203 Intvar SET…
Post: Enum Fields VS Varchar VS Int + Joined table: What is Faster?
January 24, 2008 By 27 Comments
… integer value and having value mapping done on application level. So, first of all, a few words about our data set we’ve used for this benchmark. We have 4 tables: 1) Table with ENUM: CREATE TABLE cities_enum ( id int(10) unsigned NOT NULL auto_increment…
