… case innodb shutdown and startup both took long i.e. 7 mins each 130514 7:57:39 InnoDB: Starting shutdown… 130514 8:04:26 InnoDB: Shutdown completed; log sequence number 4 3582590782 130514 8:04:26 [Note] /usr/sbin/mysqld: Shutdown…
Post: Virident vCache vs. FlashCache: Part 2
May 17, 2013 By 3 Comments
… = 128M innodb_flush_log_at_trx_commit = 1 innodb_log_file_size = 1G innodb_log_files_in_group = 2 innodb_purge_threads = 1 innodb_fast_shutdown = 1 #not innodb options (fixed) back…
Post: More on MySQL transaction descriptors optimization
April 26, 2013 By Leave a Comment
… –forced-shutdown=1 –max-time=120 –max-requests=0 –percentile=99 –mysql-user=root –mysql-db=sbtest8t1M –mysql-table-engine=INNODB –mysql… –forced-shutdown=1 –max-time=120 –max-requests=0 –percentile=99 –mysql-user=root –mysql-db=sbtest8t1M –mysql-table-engine=INNODB –mysql…
Post: How long Innodb Shutdown may take
September 2, 2010 By 9 Comments
… with Innodb tables to shut down ? It can be quite a while. In default configuration innodb_fast_shutdown=ON the main job Innodb has to do to complete shutdown is flushing dirty buffers. The… drive. Baron has written a nice post how to decrease innodb shutdown time which you may want to read on this topic.
Post: How to decrease InnoDB shutdown times
April 15, 2009 By 20 Comments
… even slower in stock InnoDB than the shutdown process, for a variety of reasons. One way to decrease the shutdown time is to pre-flush the dirty pages, like this: mysql> set global innodb_max_dirty_pages… zero.) Once it’s pretty low, you can perform the shutdown and there’ll be a lot less unfinished work to…
Post: Copying InnoDB tables between servers
July 31, 2009 By 11 Comments
… going to do it online, no needs to lock or shutdown server. To export table you need XtraBackup, and you can… followings. xtrabackup: innodb_data_home_dir = ./ xtrabackup: innodb_data_file_path = ibdata1:10M:autoextend xtrabackup: innodb_log_group_home_dir = ./ xtrabackup: innodb_log_files… completed 090730 23:23:35 InnoDB: Rollback of non-prepared transactions completed 090730 23:25:32 InnoDB: Shutdown completed; log sequence number 3…
Comment: Modeling InnoDB Scalability on Multi-Core Servers
January 31, 2012 By 11 Comments
… ‘innodb-adaptive-hash-partitions=8′ 120131 16:00:44 [ERROR] Aborting 120131 16:00:44 InnoDB: Starting shutdown… 120131 16:00:49 InnoDB: Shutdown completed; log sequence number 1604009568 120131 16:00:49 [Note] /usr/local/mysql/bin/mysqld: Shutdown…
Post: Impossible - possible, moving InnoDB tables between servers
June 8, 2009 By 9 Comments
… here – just can copy InnoDB tables in fully non-blocking mode, you do not need to shutdown neither source nor destination server (if destination server runs XtraDB). In short, process looks like (ah, yes you also need innodb… need to shutdown instance with innodb_fast_shutdown=1 (done in xtrabackup –prepare –export call). The more complex problem was that InnoDB stores pointers…
Post: How to recover a single InnoDB table from a Full Backup
January 25, 2012 By 10 Comments
…. That is, shutting down with innodb_fast_shutdown=0. We’ll use XtraBackup to avoid the server shutdown. You must not drop, truncate or alter the schema of the table after the backup has been taken. The variable innodb… –export option runs a recovery process on the backup with innodb_fast_shutdown=0 and therefore merging all the insert buffers. # innobackupex…
Comment: How long Innodb Shutdown may take
September 2, 2010 By 9 Comments
I have a somewhat tangential topic about InnoDB shutdown. I have a number of servers which in the somewhat …. MySQL on these servers takes a very long time to shutdown. Recently we “kill -9″ an instance long after it should… crash recovery. Is there any good way to know when InnoDB is shutdown when MySQL is not yet?
