… the InnoDB buffer pool in memory between restarts of MySQL servers. This can result in a significant decrease in warmup time after MySQL restarts… by time interval. (Oleg Tsarev) innodb_buffer_pool_shm_key – Allows storing the buffer pool in a shared memory segment between restarts of…
Post: Can't Create Thread: Errno 11 (A Tale of Two Ulimits)
February 4, 2013 By 12 Comments
… time by SysV initscripts are not affected by changes to these limits files.[1] Conversely, it also means that once you restart… if you don’t restart your MySQL server very often, this issue could go undetected for a long time. To illustrate, we… MySQL server with a very large InnoDB buffer pool, having to bounce mysqld a second time could mean further minutes or hours…
Post: Can MySQL temporary tables be made safe for statement-based replication?
May 26, 2008 By 8 Comments
… create an InnoDB temporary table and use it only within one transaction, and then if the slave crashes and restarts, it’ll… hold the transaction, which this time will insert data from the temporary table into a non-temporary InnoDB table: master > delimiter // master… MySQL, because the logging of stored procedures has changed over time. If just the CALL statement had been logged, I think…
Post: Test Drive of Solid
September 22, 2006 By 5 Comments
… solidDB for MySQL Beta 3 so I decided now is time to take a bit closer look on new transactional engine… timeout exceeded; try restarting transaction So as we can see Solid does not have instant deadlock detection as Innodb and have to… 1213 (40001): Deadlock found when trying to get lock; try restarting transaction Error message is obviously wrong in this case. It…
Post: Updated msl (microslow) patch, installation walk-through!
April 20, 2008 By 17 Comments
… you will need to restart MySQL. You can obviously choose the most convenient time, there is no rush. The restart can take as little as few seconds, however it will depend on many factors such as storage engines used (InnoDB will… your slow log. For example to have microsecond query timing and InnoDB statistics you would need to set this option to â…
Post: How to Monitor MySQL with Percona's Nagios Plugins
February 22, 2012 By 11 Comments
… file, and it won’t be deleted until the server restarts, so the problem remains undetected while it becomes more and… inconvenient times. The pmp-check-mysql-file-privs plugin checks whether MySQL owns every file and directory within its data directory. InnoDB… other, should only be used judiciously. The server has been restarted recently. It is surprising how often a server crashes, perhaps…
Post: MySQL Crash Recovery
July 30, 2006 By 30 Comments
… failure handling scenarios. Cold Start – If you restart MySQL server its caches (key_buffer, innodb_buffer_pool, query_cache,table_cache) are… later” message, but also – warmup takes longer time on extreme load. Innodb statistics – Unlike MyISAM Innodb does not store index cardinality in tables…
Post: XtraDB feature: save / restore buffer pool
January 20, 2010 By 20 Comments
… RAM, with allocated InnoDB buffer_pool 26GB or more. When you do restart of server, it may take long time to populate cache… wait possible long time on InnoDB recovery (we have the patch for that too, in that post you can see InnoDB recovery took… InnoDB files). First run (xtradb cold) I made just after restart and ran it for 1h. After that I saved buffer_pool, restarted…
Post: Percona XtraDB Cluster - installation and setup webinar follow up Q&A
October 28, 2012 By 4 Comments
… despite the response time limitations. Even with parallel replication, the response time limits the number … specific recommandations for Zabbix, but general InnoDB tuning recommendations apply here, in large zabbix… decides to shut down, and somehow restarts because of this automatic process, it …
Post: Percona XtraDB Cluster reference architecture with HaProxy
June 20, 2012 By 63 Comments
…_updates innodb_locks_unsafe_for_binlog=1 innodb_autoinc_lock_mode=2 innodb_buffer_pool_size=400M innodb_…, but because of optimistic locking at commit time, rollbacks can happen if we have conflicting … after xinetd restart, and haproxy is ready to check MySQL via HTTP. # service xinetd restart If …
