… Innodb data file extension – Non-Recursive Deadlock Detection – Faster Locking Primitives – Improved Innodb Thread Concurrency – Multiple background Purge Threads – Improved Purge lag… Logs – SHA256 hashing with Salt for Authentication – Use obfuscated password storage for command line tools – …
Post: Percona Server 5.1.49-rel12.0
September 15, 2010 By 6 Comments
…cache_mutex – Provides a new thread state – “Waiting on query …innodb_flush_log_at_trx_commit. (Yasufumi Kinoshita) innodb_fast_index_creation – Allows disabling of fast index creation. (Yasufumi Kinoshita) innodb_use…purge delay defined by innodb_max_purge_lag by removing the requirement that purge…
Post: Shard-Query EC2 images available
May 11, 2011 By 2 Comments
…innodb-open-files=1000 innodb_fast_checksum innodb-purge-threads=1 innodb-read-ahead=linear innodb-read-ahead-threshold=8 innodb-read-io-threads=16 innodb-recovery-stats innodb…
Comment: MySQL on Amazon RDS part 2: Determining Peak Throughput
March 28, 2011 By 4 Comments
…innodb_support_xa ON innodb_sync_spin_loops 30 innodb_table_locks ON innodb_thread_concurrency 0 innodb_thread_sleep_delay 10000 innodb_use_sys_malloc ON innodb…
Comment: MySQL Replication vs DRBD Battles
May 1, 2008 By 12 Comments
… IO from insert buffer + pending IO for purge thread). When the max is exceeded the…parallelism or concurrency (multiple threads or multiple IOs pending) in InnoDB crash recovery code? The…used on the master, byte for byte equivalent). This was done using the same replication protocol — the IO thread…
Post: When does Innodb Start Transaction ?
January 11, 2011 By 9 Comments
…no 23727, OS thread id 139753656395520 MySQL thread id 112, query id 411 localhost root show innodb status Trx read… repeatable-read mode as it will require innodb not to purge any old row versions from start of…at the time of transaction start you can use “START TRANSACTION WITH CONSISTENT SNAPSHOT” …
Post: Percona-XtraDB-9.1: released and new coming features
March 17, 2010 By 14 Comments
…was returned by query, was temporary table used, was it disk table or in-memory…IO path Improved rollback segment scalability Separate purge thread Limited size of data dictionary in …buffer_pool Transactional replication Show internal InnoDB data dictionary Show InnoDB locking/io profiling in slow….
Post: Recovering Innodb table Corruption
July 4, 2008 By 22 Comments
… with innodb_force_recovery=1 080704 0:22:53 InnoDB: Assertion failure in thread 1158060352 in file btr/btr0btr.c line 3235 InnoDB: Failing… from simple Innodb Table Corruption. In more complex cases you may need to use higher innodb_force_recovery modes to block purging activity, insert…
Comment: Multiple purge threads in Percona Server 5.1.56 and MySQL 5.6.2
May 3, 2011 By 13 Comments
Dimitri, innodb_max_purge_lag can indeed be good for uniform workloads this is not always the case. Consider for example using mysqldump… history size to be cleaned up eventually, which requires multiple purge threads for IO bound processing.
Comment: Percona Server vs MySQL on Intel 320 SSD
February 23, 2012 By 21 Comments
… server dirty page flushing respects the innodb_io_capacity setting, Percona server flushing doesn’t. Set innodb_io_capacity too low and…% of the InnoDB log file space used, while Percona server won’t. You’ll also normally benefit from setting innodb_purge_threads to 1 and, if doing lots of multithreading, setting innodb_buffer_pool_instances to 8…
