… A “MySQL Network” commercial subscription product was announced in what later evolved into “MySQL Enterprise,” and MySQL …MySQL replacement). There is a lot of “MySQL Community” focused keynotes. Good coverage of MySQL Alternatives including keynotes for Drizzle and MariaDB. MySQL 5.5 replaced MySQL…
Post: Understanding the maximum number of columns in a MySQL table
April 8, 2013 By 5 Comments
… a separate UI for generating reports. This evolved into the SQL based MySQL, with MySQL 1.0 being released in 1995. The FoRM… comes into play around the maximum number of columns is this: /* Hack to avoid bugs with small static rows in MySQL */ reclength…_TO_BIG_ROW); } Which is curiously gone from MySQL 5.6, it’s replaced by the following set of defines #define DATA…
Post: How to recover table structure from InnoDB dictionary
April 22, 2013 By 4 Comments
… need the table id to find indexes of the table. mysql> select * from SYS_TABLES WHERE NAME=’sakila/actor’; +————–+—–+——–+——+——–+———+————–+——-+ | NAME | ID… dictionary tables into some MySQL server. Use LOAD DATA INFILE constraints_parser generates mysql>LOAD DATA INFILE ‘/path/to/SYS_FIELDS’ REPLACE INTO TABLE `SYS…
Post: Percona XtraBackup 2.0.7 for MySQL available for download
May 6, 2013 By 1 Comment
… the Buffer Pool in Percona Server. MySQL 5.6 buffer pool dump is copied into backup directory during the backup stage. During… #1166888. Package dependency has been changed from abstract mysql to real /usr/bin/mysql file, because rpm packages from Oracle no longer…_id from *.ibd.meta would lead to assertion. Fixed by replacing the assertion with the error message. Bug fixed #1112224. Fixed…
Post: trx descriptors: MySQL performance improvements in Percona Server 5.5.30-30.2
April 12, 2013 By 3 Comments
….2 significantly reduces the impact of the list scan by replacing it with more efficient operations. In a nutshell, it maintains… in MySQL 5.6 does not kick in. The default sysbench POINT_SELECT mode benchmark does PK lookup SELECT queries wrapped into regular (i.e. not marked as read-only) transactions. In this case MySQL 5.6 scalability goes…
Post: MySQL 5.6 - InnoDB Memcached Plugin as a caching layer
March 29, 2013 By 10 Comments
… nutshell, here is how one would start the memcached plugin: mysql> install plugin daemon_memcached soname ‘libmemcached.so’; In an effort…/cmd Keep in mind that the entire data set fits into the buffer pool, so there are no reads from disk… 20% higher (~.06 ms/op) MySQL Select showed 27% increase over InnoDB fetch (~.09 ms/op) This replaced $cache->load() with $db…
Post: MySQL 5.6 Compatible Percona Toolkit 2.2 Released
March 25, 2013 By 2 Comments
…, and improvements make this a great new series. It replaces the 2.1 series for which we plan … 2012, we introduced a feature called “version check” into most tools. It’s like a lot of …standard (http) connection. pt-stalk and pt-mysql-summary have built-in MySQL options No more “pt-stalk — -h db1…
Comment: MySQL Partitioning - can save you or kill you
April 30, 2013 By 45 Comments
…but there are generally other considerations to take into account. He also didn’t answer the ‘Insert’ …. 3. Insert on Duplicate Key (I dont do replace… ever)… if across partitions, will be slower, if…could easily be quicker on a partitioned table, as Mysql can fire off one thread per partition (at…
Post: INSERT ON DUPLICATE KEY UPDATE and REPLACE INTO
January 18, 2007 By 15 Comments
Jonathan Haddad writes about REPLACE INTO and INSERT ON DUPLICATE KEY UPDATE. Really, Why MySQL has both of these, especially both are non ANSI SQL extensions ? The story here seems to be the following – REPLACE INTO existed forever, at least since MySQL 3.22 and was a way to do replace faster and what is…
Post: Announcing Percona Server for MySQL 5.1.68 -14.5
March 15, 2013 By Leave a Comment
… Percona Server for MySQL A free, open-source solution, Percona Server for MySQL is an enhanced drop-in replacement for MySQL, offering breakthrough performance… in benchmarking, it is more stable and consistent. Our research into server internals and our Six-Sigma-like focus on quality…
