…. Bug fixed #1175447. Query to the INNODB_CHANGED_PAGES table would cause server to stop with an I/O error if a… name components in a bitmap file name could stop the server starting if the innodb_data_home_dir variable didn’t have… would make server stop with an I/O error if changed page tracking is enabled. Bug fixed #1184517. The INNODB_CHANGED_PAGES…
Post: Percona Server 5.1.69-14.7 now available: A drop in replacement for MySQL
June 10, 2013 By 3 Comments
Post: Percona Server 5.6.11-60.3 first Release Candidate now available
June 3, 2013 By 3 Comments
… objects are now allocated calling calloc() directly instead of using InnoDB heap allocation. This may improve write performance for high levels… name components in a bitmap file name could stop the server starting if the innodb_data_home_dir variable didn’t have…. Bug fixed #1184427. Query to the INNODB_CHANGED_PAGES table would cause server to stop with an I/O error if a…
Post: MySQL 5.6 - InnoDB Memcached Plugin as a caching layer
March 29, 2013 By 10 Comments
… code for this benchmark: // Identical config/code for memcached vs InnoDB $frontendOpts = array( ‘caching’ => true, ‘lifetime’ => 3600, ‘automatic_serialization’ => true ); $memcacheOpts… remote server (stop/start memcached, stop/start plugin). As expected, there is a slowdown for write operations when using the InnoDB version. But…, here are the relative differences: InnoDB store operation was 280% higher (~1.73 ms/op) InnoDB fetch operation was 20% higher (~.06…
Post: Percona Server 5.5.30-30.2 rerelease fixes non-restart issue
April 24, 2013 By Leave a Comment
… from restarting following an upgrade — instead, the server would remain stopped after the upgrade was completed regardless of its state before… upstream bug #49169. This also provides much better scalability in InnoDB high-concurrent workloads. Bugs fixed #1131189 (Alexey Kopytov). In the… #1041981 (Alexey Bychko). Fixed the upstream bug #68197 that caused InnoDB to misclassify internal read operations as synchronous when they were…
Post: The relationship between Innodb Log checkpointing and dirty Buffer pool pages
February 17, 2012 By 10 Comments
… down the to the tablespace. If Innodb stops (read: crashes) with dirty buffer pool pages, Innodb recovery must be done to rebuild the… newest, and simultaneously listed from least effective to most effective: innodb_max_dirty_pages_pct: This attempts to keep the percentage…/or use the global tablespaces) *cough ext3 cough*. innodb_adaptive_flushing: An Innodb plugin/5.5 setting that tries to be smarter…
Post: How to recover deleted rows from an InnoDB Tablespace
February 20, 2012 By 4 Comments
… table “salaries”. After the “accidental” deletion of rows you should stop MySQL, take a copy of the salaries.ibd and start…) > select i.INDEX_ID, i.NAME FROM INNODB_SYS_INDEXES as i INNER JOIN INNODB_SYS_TABLES as t USING(TABLE_ID… the error log. mysql (employees) > CREATE TABLE innodb_table_monitor (id int) ENGINE=InnoDB; TABLE: name employees/salaries, id 18, flags 1…
Post: Benchmarks of new innodb_flush_neighbor_pages
January 17, 2012 By 8 Comments
…”). In this post I however will focus on innodb_flush_neighbor_pages. By default InnoDB flushes so named neighbor pages, which really… as possible in singe sequential write. So we added new innodb_flush_neighbor_pages=cont method, with it, only really sequential… solving it. Which, I believe, is still better than complete stop for significant amount of time. The raw results, scripts and…
Post: Thinking about running OPTIMIZE on your Innodb Table ? Stop!
December 9, 2010 By 18 Comments
… lot better fill factor. The problem is…. OPTIMIZE TABLE for Innodb tables does not get advantage of it for whatever reason…(64) DEFAULT NULL, PRIMARY KEY (`id`), KEY `c` (`c`) ) ENGINE=InnoDB AUTO_INCREMENT=12582913 DEFAULT CHARSET=latin1 mysql> select * from a… indexes for some time. Note though nothing stops you from using LOCK TABLES on Innodb table to ensure there is not ton…
Post: STOP: DELETE IGNORE on Tables with Foreign Keys Can Break Replication
February 2, 2012 By 1 Comment
…) unsigned NOT NULL AUTO_INCREMENT, PRIMARY KEY (`t1_c1`) ) ENGINE=InnoDB; CREATE TABLE `t2` ( `t2_c1` int(10) unsigned NOT NULL… (`t2_c1`) REFERENCES `t1` (`t1_c1`) ON UPDATE CASCADE ) ENGINE=InnoDB; [revin@forge rsandbox_5_5_17]$ for int in {1… mentioned behavior on 5.1 and 5.5, MySQL will stop deleting rows if it encounters constraint errors. To demonstrate on…
Post: Heikki Tuuri Innodb answers - Part I
October 26, 2007 By 19 Comments
… may not see a “free space” in Innodb tablespace to grow significantly. Q6: Does Innodb policy replacement algorithm takes into account page… MySQL 5.1 Q15: How frequently does Innodb fuzzy checkpointing is activated HT: InnoDB flushes about 128 dirty pages per flush. That… of TLB cache misses. huge pages along however do not stop IO pressure and OS may swap out not buffer pool…
