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 XtraDB Storage Engine: a Drop-in Replacement for Standard InnoDB
December 16, 2008 By 25 Comments
… InnoDB, so you can use it as a drop-in replacement in your current environment. It is designed to scale better….com/mysql/5.1.30/source/percona-xtradb-1.0.2-1.tar.gz * as binaries, percona xtradb is compiled in into MySQL-5.1.30 RPMS * as separated shared library, to use as drop-in plugin for existing MySQL-5.1…
Post: How to recover deleted rows from an InnoDB Tablespace
February 20, 2012 By 3 Comments
… import it in our database: mysql (employees) > LOAD DATA INFILE ‘/root/recovery-tool/data/salaries.recovery’ REPLACE INTO TABLE `salaries` FIELDS TERMINATED BY….01 sec) Records: 3 Deleted: 0 Skipped: 0 Warnings: 0 mysql (employees) > select * from salaries where emp_no=10008; +——–+——–+————+————+ | emp_no…
Post: Announcing Percona Live MySQL Conference and Expo 2012
August 9, 2011 By 11 Comments
…, with thousands of attendees and an up-front investment well into the six figures, is a whole different undertaking. And although… the MySQL ecosystem, they cannot — cannot — replace the traditional MySQL conference and expo. The “and expo” is crucial here — the O’Reilly MySQL conference…
Post: Percona's Commitments to MySQL Users
November 5, 2010 By 10 Comments
… from Monty, David, Marten and many others to develop it into the world’s leading open-source database. Much of their… slowdowns over the last few years. This era is over. MySQL has never progressed so rapidly towards better features, better performance… is an enhanced drop-in replacement for MySQL, for those whose needs are not met by the official MySQL server from Oracle. It…
Post: MySQL-Memcached or NOSQL Tokyo Tyrant - part 1
October 15, 2009 By 16 Comments
All to often people force themselves into using a database like MySQL with no thought into whether if its the best solution to…. All to often people force themselves into using a database like MySQL with no thought into whether if its the best solution to… based primary key B.) Update data from that row and replace the stored contents on disk C.) Use the data from…
Post: A workaround for the performance problems of TEMPTABLE views
May 19, 2010 By 7 Comments
… set (1.64 sec) You can see that MySQL is accessing millions of rows: mysql> explain select * from v2 where c1 = 100….76 sec) Now to the actual workaround. MySQL won’t merge query filters into the view definition, but we can modify the… value in the params table. Place parameters into the params table using the REPLACE statement: mysql> replace into params (`view_name`, `param1_val`, `connection_id…
Post: A quest for the full InnoDB status
October 31, 2008 By 4 Comments
… deal by intentionally creating a new tiny deadlock which will replace the previous one in the output thus reducing the space… InnoDB to write the full status output into innodb_status.
Post: Avoiding auto-increment holes on InnoDB with INSERT IGNORE
November 29, 2011 By 7 Comments
… assigns the new value to the column. Prior to MySQL 5.1.22 InnoDB used a method to access … are even worse with long running queries like INSERT INTO table1 … SELECT … FROM table2. In version 5.1.22… query like a single-row or multi-row INSERT/REPLACE uses a light-weight mutex instead of a table …
Post: Quick comparison of MyISAM, Infobright, and MonetDB
September 29, 2009 By 30 Comments
… forget that Infobright is not just a storage engine plugged into MySQL. It’s a complete server with a different optimizer, etc… underlying language. An abstracted front-end is a great idea; MySQL abstracts the storage backend, but why not do both? Last… has CTEs, although not recursive ones. (No, there is no REPLACE, and there is no INSERT/ON DUPLICATE KEY UPDATE.) I…
