… assisted Zend to introduce Zend DBi as a drop-in replacement for MySQL on the IBM i platform. Zend approached us… for IBM i. It’s a 100% compatible drop-in replacement. Everything works on Zend DBi just as it works on…
Comment: How to recover a single InnoDB table from a Full Backup
March 22, 2012 By 7 Comments
… –target-dir=/mnt/mysql/export ALTER TABLE data DISCARD TABLESPACE; # replace ibd with the export files SET GLOBAL innodb_import_table…
Comment: Performance problem with Innodb and DROP TABLE
March 16, 2012 By 23 Comments
Repls, Yes. You’re completely right. Yet code is written in a way it scans the code and replaces the table and change of this behavior is not as trivial as it may look
Post: Announcing Percona XtraBackup 1.9.1
February 27, 2012 By 9 Comments
… caching) stream several compressed files at once. tar4ibd functionality is replaced by functionality in the xtrabackup binary itself. The xbstream utility…
Comment: Introducing new type of benchmark
February 26, 2012 By 16 Comments
… If we are to translate this to databases, we could replace “static file” with a “simple select”, and “dynamic page” with…
Post: INSERT ON DUPLICATE KEY UPDATE and REPLACE INTO
January 18, 2007 By 15 Comments
… use LOCK TABLES but it is not efficient. The reason REPLACE could be efficient for ISAM and MyISAM, especially for fixed length rows is – it could perform row replacement without reading old data first, and of course because you… update accessing previous column value, for example doing something like REPLACE INTO tbl (col1) VALUES (col1+10);. Instead of acting as…
Post: Captcha is replaced
October 20, 2009 By 18 Comments
After many complains we removed captcha in comments and replaced to Anti-Captcha ( http://wordpress.org/extend/plugins/anti-captcha/). Now you need enabled JavaScript in your browser to post comments.
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…
Post: UDF -vs- MySQL Stored Function
September 6, 2010 By 6 Comments
… could have written it as an SQL statement: mysql> select REPLACE( REPLACE( REPLACE( REPLACE( REPLACE( REPLACE( REPLACE( REPLACE( REPLACE( REPLACE( REPLACE( REPLACE( REPLACE( REPLACE( REPLACE( REPLACE( LOWER(author), ‘aa’, ‘a’), ‘bb’, ‘b’), ‘cc’, ‘c’), ‘dd’, ‘d…’), ‘rr’, ‘r’), ‘ss’, ‘s’), ‘tt’, ‘t’), ‘vv’, ‘v’), ‘zz’, ‘z’), REPLACE( REPLACE( REPLACE( REPLACE( REPLACE( REPLACE( REPLACE( REPLACE( REPLACE( REPLACE( REPLACE( REPLACE( REPLACE( REPLACE( REPLACE( REPLACE( LOWER(title), ‘aa’, ‘a’), ‘bb’, ‘b’), ‘cc’, ‘c’), ‘dd’, ‘d…
Post: How reliable RAID really is
June 30, 2006 By 11 Comments
… megaraid) controller. Dell was prompt to ship replacement hard drive and drive was replaced. This should be happy end of the story… drive down because yet another hard drive got bad block. Replaced hard drive was “failed” because it could not be rebuilt…. So my first advice would be – Run consistency check before replacing hard drive with predicted failure to minimize chance of double…
