… have “no cache”, “FlashCache”, “vCache with no time-based flushing”, and “vCache with time-based flushing.” As the images demonstrate, the no…-init=on –report-interval=1 –rand-type=pareto \ –forced-shutdown=1 –max-time=7200 –max-requests=0 –percentile=95 \ –mysql-user=root…_files_in_group = 2 innodb_purge_threads = 1 innodb_fast_shutdown = 1 #not innodb options (fixed) back_log = 50 wait_timeout…
Post: More on MySQL transaction descriptors optimization
April 26, 2013 By Leave a Comment
…-init=on –report-interval=1 –rand-type=uniform –forced-shutdown=1 –max-time=120 –max-requests=0 –percentile=99 –mysql-user=root…-init=on –report-interval=1 –rand-type=uniform –forced-shutdown=1 –max-time=120 –max-requests=0 –percentile=99 –mysql-user=root…
Post: Percona XtraDB Cluster for MySQL and encrypted Galera replication
May 3, 2013 By 2 Comments
… we are creating a certificate with a very long expiration time. If you use the default expiration of 1 year, your… no need for SST in this case: each node was shutdown cleanly, and brought back up cleanly. As soon as the…
Post: How to decrease InnoDB shutdown times
April 15, 2009 By 20 Comments
Sometimes a MySQL server running InnoDB takes a long time to shut down. The usual culprit is flushing dirty pages … in stock InnoDB than the shutdown process, for a variety of reasons. One way to decrease the shutdown time is to pre-flush… zero.) Once it’s pretty low, you can perform the shutdown and there’ll be a lot less unfinished work to…
Post: How long Innodb Shutdown may take
September 2, 2010 By 9 Comments
…. In default configuration innodb_fast_shutdown=ON the main job Innodb has to do to complete shutdown is flushing dirty buffers. The… scenario though it is quite common in practice to see shutdown time of about 1min per GB of buffer pool per hard…. Baron has written a nice post how to decrease innodb shutdown time which you may want to read on this topic.
Post: Faster Point In Time Recovery with LVM2 Snaphots and Binary Logs
February 23, 2012 By 3 Comments
… 1 end_log_pos 336797275 Query thread_id=47 exec_time=1 error_code=0 SET TIMESTAMP=1329980395/*!*/; DROP TABLE `salaries….d/mysql start Starting MySQL (Percona Server) [ OK ] You should shutdown MySQL first, then unmount the logical volume holding the MySQL…. Also, you cannot test restore your snapshots – they are one time use! However, if you can tolerate the extra IO overhead…
Post: Profiling MySQL Memory Usage With Valgrind Massif
January 9, 2013 By 3 Comments
… a drop-in replacement for your current mysqld (i.e. shutdown, mv mysqld mysqld.old, cp /debug_bin_path/mysqld ./mysqld… you’re all set with debug symbols, shutdown your mysqld server using your standard shutdown procedure, and then re-start it manually… some time (for example, if you have experienced memory increase over time). Once you’ve done that, shutdown mysqld (again using your normal shutdown…
Comment: Pitfalls of converting to InnoDB
March 8, 2007 By 16 Comments
…Another PHP script attempting to insert takes 50 seconds to time-out with a “1205 – Lock wait timeout exceeded; try …); $this->transaction_in_progress = true; register_shutdown_function(array($this, “__shutdown_check”)); } public function __shutdown_check() { if ($this->transaction_in_progress) { $…
Comment: How to decrease InnoDB shutdown times
April 16, 2009 By 20 Comments
… really shutting down my server any faster in wall clock time? Without setting the max_dirty_pages flag to zero, say… 1 minute for the shutdown? Seems like it might make the shutdown *command* take less time, but the actual elapsed time from the moment you decide to shut down the server to the time…
Post: How to recover a single InnoDB table from a Full Backup
January 25, 2012 By 10 Comments
… is, shutting down with innodb_fast_shutdown=0. We’ll use XtraBackup to avoid the server shutdown. You must not drop, truncate… runs a recovery process on the backup with innodb_fast_shutdown=0 and therefore merging all the insert buffers. # innobackupex –defaults… is where we are going to save a lot of time and some headaches 
Instead of recovering all the InnoDB data…
