…tables used to have. As the side effect of this – if you’re using auto_increment columns inserting into Merge Table and in the last table…
Post: Ultimate MySQL variable and status reference list
January 8, 2011 By 4 Comments
…MySQL manual, especially the option and variable reference table…auto_increment_incrementblogpercona.commanual auto_increment…
Post: MySQL Users Conference - Innodb
May 9, 2007 By 6 Comments
… scans and large range scans. We surely should benchmark this aspect separately. Improved Auto Increment handling Yet another known Innodb problem is table locks… same table. This was born same as bunch of others due to statement level MySQL Replication which among other requirements, needs all auto-increment… provided will be merged soon if not we should test them and make binaries with them available. With current MySQL 5.0 I…
Post: High-Performance Click Analysis with MySQL
December 22, 2008 By 13 Comments
… data sets are very expensive. If MySQL supported sort-merge or hash joins, you’d have other …tables and taking downtime, I would not use MyISAM for anything but read-only tables when things get big. And… (day, ad). Don’t use an auto-increment primary key, and don’t put ad first. If …
Post: Recovering Innodb table Corruption
July 4, 2008 By 19 Comments
…MySQL with Innodb tables and you’ve got crappy hardware, driver bug, kernel bug, unlucky power failure or some rare MySQL bug and…mysql> CREATE TABLE `test2` ( -> `c` char(255) DEFAULT NULL, -> `id` int(10) unsigned NOT NULL AUTO_INCREMENT… activity, insert buffer merge or recovery from transactional…
Post: Improved InnoDB fast index creation
November 6, 2011 By 4 Comments
…. Let’s start with a table containing 4 million rows and one secondary key: mysql> CREATE TABLE t(id INT AUTO_INCREMENT PRIMARY KEY, c FLOAT… inserted in the correct order into sequentially allocated pages after merge-sorting. So besides optimizing DDL directly, expand_fast_index_creation…
Post: A workaround for the performance problems of TEMPTABLE views
May 19, 2010 By 7 Comments
… temporary table and many more rows may be accessed than otherwise would had the filter been merged …mysql> show create table t2\G *************************** 1. row *************************** Table: t2 Create Table: CREATE TABLE `t2` ( `c1` int(11) DEFAULT NULL, `c2` int(11) NOT NULL AUTO_INCREMENT…
Comment: Spreading .ibd files across multiple disks; the optimization that isn't
December 26, 2010 By 22 Comments
… shell, move the directory to SSD and create a symlink to the directory — cd /var/lib/mysql — cp -p fast_disk /mnt… a VIEW (using the MERGE algorithm) which simulates a database ‘SYNONYM’: create table the_db.trx1(c1 int auto_increment, c2 int, c3 int, primary key(c1))engine=innodb; create table the_db.trx2(c4 int auto_increment…
