… cold buffer pool. Then the query is tested again without restarting the database. The first test is described as the cold… the second as the hot test. The database software is restarted after the hot test. All OS caches are dropped at… filesystem level. The InnoDB indexes were built using ALTER TABLE fast index creation (merge sort). For the MyISAM tests I used…
Post: MySQL 5.6 - InnoDB Memcached Plugin as a caching layer
March 29, 2013 By 10 Comments
…) option used in production as a caching layer. While very fast, one major potential shortcoming of memcached is that it is… overall warmup time when the entire cache is cleared (think restarting a memcache node). This is where a persistent cache can…
Post: Percona Server Fast-Restart White Paper Posted
January 10, 2011 By 2 Comments
… implementation and benefits of Percona Server’s fast-restart capabilities. Briefly, after shutting down and restarting or rebooting the server, it can be…, but you still get terrible I/O performance so MySQL restarts take an eternity. Read the white paper for the details…
Post: Enabling/Disabling query log without server restart in MySQL 5.0
September 13, 2007 By 13 Comments
…. Unfortunately you can’t switch it on and off without restarting server until MySQL 5.0. What can you do in… overhead and save disk space which can be consumed very fast otherwise. Of course it does not remove all logging overhead…
Post: MySQL 5.6: Improvements in the Nutshell
January 27, 2013 By 16 Comments
… LIMIT N – Persistent Statistics for Innodb – Improvements to Innodb Compression – Fast Page Checksums (CRC32) – 4K and 8K Page sizes for Innodb… – GET DIAGNOSTICS Operational Improvements – Separate Tablespaces for Innodb Undo Logs – Fast Restart – Preloading Innodb Buffer Pool – Online DDL – Import/Export for Partitioned…
Comment: Percona Server Fast-Restart White Paper Posted
January 12, 2011 By 2 Comments
How does this compare with the fast InnoDB recovery in the recently GA’d MySQL 5.5? In what versions of Percona does the fast restart exist?
Post: Percona Server 5.1.49-rel12.0
September 15, 2010 By 6 Comments
… result in a significant decrease in warmup time after MySQL restarts. Starting with this release, we will also provide special builds… storing the buffer pool in a shared memory segment between restarts of the server. (Yasufumi Kinoshita) Option syslog was added to…_flush_log_at_trx_commit. (Yasufumi Kinoshita) innodb_fast_index_creation – Allows disabling of fast index creation. (Yasufumi Kinoshita) innodb_use_sys…
Post: Recovery deleted ibdata1
August 10, 2012 By 9 Comments
… reason to monitor existence of these files! But after the restart InnoDB will detect that there is neither system table space…, but as long as MySQL isn’t restarted it is possible to recover database fast. Let me illustrate how. Let’s simulate…:/var/lib/mysql# And restart MySQL: root@localhost:/var/lib/mysql# /etc/init.d/mysql restart After the restart all InnoDB tables are…
Post: Replication of MEMORY (HEAP) Tables
October 15, 2010 By 7 Comments
… you can do ? Use Innodb Table Instead Innodb is quite fast when it fits in memory so for most applications this… same cron jobs MASTER runs to refresh this table periodically. Restart Slaves Carefully I would not use this as long term…; run SLAVE STOP; dump all your memory tables using MySQLDump; Restart the MySQL As planned; Load Dumped tables; run SLAVE START…
Comment: Mystery Performance Variance with MySQL Restarts
February 28, 2013 By 18 Comments
Does the computed statistics change when restarting MySQL? Because after a restart, the slow schema becomes fast and one that was fast becomes slow.
