… If we are to translate this to databases, we could replace “static file” with a “simple select”, and “dynamic page” with…-joins. Needless to say, there are many variables to take into account (size of data set, usage of persistent connection) – and…
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 … be the following – REPLACE INTO existed forever, at least since MySQL 3.22 and was a way to do replace faster and what… with REPLACE was – many people tried to use it like update accessing previous column value, for example doing something like REPLACE INTO tbl…
Comment: INSERT ON DUPLICATE KEY UPDATE and REPLACE INTO
January 22, 2007 By 15 Comments
The two statements have different impact for INNODb table. The REPLACE INTO acts as DELETE/INSERT for duplicates. The INSERT ON DUPLIACTE… CASCADE”, the REPLACE INTO will delete the child record too. I will use INSERT ON DUPLICATE rather than the REPLACE INTO for the above…
Post: A workaround for the performance problems of TEMPTABLE views
May 19, 2010 By 7 Comments
… view which uses the MERGE algorithm can merge filter conditions into the view query itself. This has significant performance advantages over… value in the params table. Place parameters into the params table using the REPLACE statement: mysql> replace into params (`view_name`, `param1_val`, `connection…
Comment: INSERT ON DUPLICATE KEY UPDATE and REPLACE INTO
January 22, 2007 By 15 Comments
….00 sec) Records: 2 Duplicates: 0 Warnings: 0 mysql> insert into c values (1,1), (2,2); Query OK, 2 rows… | | 2 | 2 | +—-+——+ 2 rows in set (0.00 sec) mysql> replace into p values (1,10); Query OK, 2 rows affected (0… (0.00 sec) — We lost the child #1. mysql> insert into p (id, notid) values (2,20) on duplicate key update…
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…-1.tar.gz * as binaries, percona xtradb is compiled in into MySQL-5.1.30 RPMS * as separated shared library, to…
Comment: INSERT ON DUPLICATE KEY UPDATE and REPLACE INTO
June 23, 2010 By 15 Comments
… INTO person (name, social_security_number) VALUES (‘Alice’, 123456); INSERT INTO person (name, social_security_number) VALUES (‘Bob’, 787878); REPLACE INTO person…
Post: How to recover deleted rows from an InnoDB Tablespace
February 20, 2012 By 3 Comments
… those deleted rows from the ibd file and import them into the database. The time between the deletion of rows and… (employees) > LOAD DATA INFILE ‘/root/recovery-tool/data/salaries.recovery’ REPLACE INTO TABLE `salaries` FIELDS TERMINATED BY ‘\t’ OPTIONALLY ENCLOSED BY ‘”‘ LINES…
Comment: Sharing an auto_increment value across multiple MySQL tables
October 4, 2010 By 9 Comments
http://code.flickr.com/blog/2010/02/08/ticket-servers-distributed-unique-primary-keys-on-the-cheap/ Flickr’s ticket servers use REPLACE INTO and LAST_INSERT_ID to do this same thing.
Comment: INSERT ON DUPLICATE KEY UPDATE and summary counters.
August 23, 2010 By 46 Comments
well, i definetly using INSERT ON DUPLICATE KEY UPDATE rather than REPLACE INTO it’s for performance and code reading
