… key decisions were even made outside of Percona’s control. The sessions, for example, were selected by a committee of independent MySQL… who use MySQL in production systems and know how to operate it and develop against it. These are the people who are uniquely qualified to talk about how MySQL works in practice. Sponsors will have an…
Post: Best kept MySQLDump Secret
March 23, 2012 By 11 Comments
… missing from the backup if you use this technique ? The problem comes from the fact how MySQL‘s Transactions work with DDL…=@OLD_SQL_MODE */; /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */; /*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */; /*!40101 SET CHARACTER_SET_CLIENT…
Post: Eventual Consistency in MySQL
November 18, 2011 By 8 Comments
…keys and foreign keys. If the REFERENCED_* columns are non-null, it’s a foreign key. mysql> SELECT * FROM INFORMATION_SCHEMA.KEY…use the same SQL queries for quality control: mysql> CREATE TABLE test.MY_KEY_COLUMN_USAGE LIKE INFORMATION_SCHEMA.KEY_COLUMN_USAGE; mysql…, POSITION_IN_UNIQUE_CONSTRAINT = …
Post: Avoiding auto-increment holes on InnoDB with INSERT IGNORE
November 29, 2011 By 7 Comments
…. Prior to MySQL 5.1.22 InnoDB used a method to access that counter values called “Traditional”. This one uses a special table…, `name` int(11) DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `uniqname` (`name`) ) ENGINE=InnoDB; Insert a value using a LEFT OUTER JOIN: insert into…) NOT NULL AUTO_INCREMENT, `name` int(11) DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `uniqname` (`name`) ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET…
Post: Using any general purpose computer as a special purpose SIMD computer
May 16, 2011 By 6 Comments
… the word. 6) determine the number of unique words. This is not projected, but you… as run by the native database interface (MySQL): mysql> select word, md5(word), md5(reverse(word)), … auto_increment primary key, prime_number bigint ); spread this over as many machines as necessary using the method…
Post: Ultimate MySQL variable and status reference list
January 8, 2011 By 4 Comments
…MySQL…key_cache_age_thresholdblogpercona.commanual key_cache_block_sizeblogpercona.commanual key_cache_division_limitblogpercona.commanual Key_read_requestsblogpercona.commanual Key_readsblogpercona.commanual Key_write_requestsblogpercona.commanual Key…unique…
Post: High-Performance Click Analysis with MySQL
December 22, 2008 By 13 Comments
…’t use GUIDs. Which brings me to my next point: Use InnoDB Assuming that you will use the stock MySQL server…should define the primary key as (day, ad). Don’t use an auto-increment primary key, and don’t … you actually have as many rows as you have unique ads per day. Viewed this way, suddenly …
Post: Percona Server 5.1.59-13.0
October 16, 2011 By Leave a Comment
…-optimize-keys should ignore foreign key constrains. #859078 (Alexey Kopytov). After adding an index using Fast Index… –innodb-optimize-keys did not work correctly with tables where the first UNIQUE key on non-… of a PRIMARY KEY. #851674 (Alexey Kopytov). Backported fix for MySQL bug #53761 (Wrong …
Post: Percona Server 5.5.16-22.0
October 16, 2011 By 2 Comments
…from the Percona Software Repositories). Based on MySQL 5.5.16, including all the …innodb-optimize-keys should ignore foreign key constrains. #859078 (Alexey Kopytov). After adding an index using Fast Index… –innodb-optimize-keys did not work correctly with tables where the first UNIQUE key on non-…
Post: Shard-Query turbo charges Infobright community edition (ICE)
May 6, 2011 By 22 Comments
…: create table dim_airport( airport_id int auto_increment primary key, unique key(airport_code) ) as select Origin as `airport_code`, OriginCityName as… RAID array was used as the underlying storage for the virtual machines. Baseline: The MySQL command line client was used to execute the…
