…to reduce the time between checks which can prevent XtraBackup failures that are caused by the log records in the transactional log…in the innobackupex error output. Bug fixed #1157225. When building from source innodb56 target didn’t have an option to disable…
Post: Heikki Tuuri Innodb answers - Part I
October 26, 2007 By 19 Comments
…in most cases. If you are not seeing ‘thread thrashing’ (lots of threads waiting for semaphores in SHOW INNODB STATUS), you can try to disable…InnoDB‘s log must have the transactions in the same order, for a recovery based on MySQL’s binlog to…
Post: How to load large files safely into InnoDB with LOAD DATA INFILE
July 3, 2008 By 29 Comments
… binary log. While this is generally a fast way to load data (especially if you disable unique…InnoDB loads the file, it creates one big transaction with a lot of undo log entries. This has a lot of costs. To… were small). But how to do this without splitting the file? The answer lies in the Unix fifo…
Post: MySQL 4 to MySQL 5 Upgrade performance regressions
June 6, 2007 By 8 Comments
… ideas how to make XA to work with group commit why would not you keep old working code path if XA is disabled ? Many… have to have innodb_flush_logs_at_trx_commit=1 so transactions are truly durable. You have to have log-bin enabled to get replication or point in….1 Disable Binary Logging This allows to get group commit back but obviously you loose point in time recovery and replication. Use innodb_flush_log_at…
Post: SSD, XFS, LVM, fsync, write cache, barrier and lost transactions
March 2, 2009 By 32 Comments
…innodb_file_per_table=1 innodb_log_buffer_size=8M innodb_log_files_in_group=2 innodb_log_file_size=256M innodb_thread_concurrency=0 innodb_flush_log…transactions. So in final conclusion: 1. Intel SSD X25E is NOT reliable in default mode 2. To have durability we need to disable…
Post: INSERT INTO ... SELECT Performance with Innodb tables.
July 12, 2006 By 22 Comments
…use innodb_locks_unsafe_for_binlog option with caution. Note disabling binary logs is not enough to trigger relaxed locks. You have to set innodb_…locks to cause the problems. To complete this article I should show how wait caused by this statement will look in SHOW INNODB STATUS: —TRANSACTION 0…
Post: MySQL 5.5.8 - in search of stability
January 3, 2011 By 11 Comments
…Transactions per 10 seconds. dirty page – This graph will contain the percentage of dirty pages in the InnoDB…in innodb_log_file corresponds to changed pages in the buffer pool. You can compute this value as Log…
Post: InnoDB's gap locks
March 27, 2012 By 15 Comments
…to other sessions. How to troubleshoot gap locks? Is possible to detect those gap locks using SHOW ENGINE INNODB STATUS: —TRANSACTION…in your transactions affecting the concurrency and the performance you can disable them in two different ways: 1- Change the ISOLATION level to READ COMMITTED. In…
Post: Optimizing InnoDB for creating 30,000 tables (and nothing else)
December 22, 2011 By 5 Comments
…to the libeatmydata performance. I also want to disable syncing of the FRM file to disk and set log flushing to… So how fast is InnoDB under all of this? Am I hitting a fundamental limitation in InnoDB? Well… operation in a single transaction. So if instead of setting flush_method and flush_log_…
Post: Choosing innodb_buffer_pool_size
November 3, 2007 By 39 Comments
…logs, or relay logs, Innodb Transactional Logs also like to be cached otherwise OS will need to do reads to serve writes to these log files as IO to the log…in case of unexpected connection spike. Plus not all kernels work quite well with swap disabled…
