I have not found at a first glance an answer on obvious question, can it be replacement for InnoDB based application? What redevelopment does it require?
Post: How to recover table structure from InnoDB dictionary
April 22, 2013 By 4 Comments
…_parser generates mysql>LOAD DATA INFILE ‘/path/to/SYS_FIELDS’ REPLACE INTO TABLE `SYS_FIELDS` FIELDS TERMINATED BY ‘\t’ OPTIONALLY ENCLOSED…
Comment: Testing the Micron P320h
April 17, 2013 By 7 Comments
… box with a kernel panic – so the developers may have replaced one issue with another. DISCLAIMER: I have not attempted to…
Comment: Using Flexviews - part two, change data capture
April 13, 2013 By 26 Comments
… the message: “Restarting FlexCDC!” In function “process_rows” you should replace : unset($the_row['fv$gsn']); with: unset($the_row[‘fv…
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…
Post: Understanding the maximum number of columns in a MySQL table
April 8, 2013 By 5 Comments
…); } Which is curiously gone from MySQL 5.6, it’s replaced by the following set of defines #define DATA_N_SYS…
Comment: MySQL 5.6 - InnoDB Memcached Plugin as a caching layer
April 1, 2013 By 10 Comments
… of this post as I was looking at drop in replacements (both in terms of functionality and code).
Post: MySQL 5.6 - InnoDB Memcached Plugin as a caching layer
March 29, 2013 By 10 Comments
… showed 27% increase over InnoDB fetch (~.09 ms/op) This replaced $cache->load() with $db->query(“SELECT * FROM memcached.container WHERE…
Post: MySQL 5.6 Compatible Percona Toolkit 2.2 Released
March 25, 2013 By 2 Comments
…, changes, and improvements make this a great new series. It replaces the 2.1 series for which we plan to do…
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…
