…MySQL…innodb_thread_sleep_delayblogpercona.commanual Innodb_truncated_status_writesblogpercona.commanual innodb_use_native_aioblogpercona.commanual innodb_use_sys_mallocblogpercona.commanual innodb_versionblogpercona.commanual innodb_write…
Post: Heikki Tuuri answers to Innodb questions, Part II
November 4, 2007 By 13 Comments
… amount of concurrent writes to about 6 tables, what version of Innodb/MySQL would you recommend…a bit slow it down. Plus there were bunch of micro optimizations in Innodb in 5…write buffering efficiently. Q30: Question about using solid state disks for storing ib_log* files; I know that innodb writes…
Post: Heikki Tuuri Innodb answers - Part I
October 26, 2007 By 17 Comments
… of MySQL process. Q20: We’ve migrated to using INNODB so that it operates 100% out of memory. This way every write is… which slows down throughput. If we could control the checkpointing rate we could use an 8G write ahead log and tell innodb to… do not think so. Sergei Golubchik serialized the MySQL binlog write and the InnoDB log flush with a mutex in 5.1, to…
Post: The relationship between Innodb Log checkpointing and dirty Buffer pool pages
February 17, 2012 By 5 Comments
…was an optimization for slow drives: if you can sequentially write all the …about Innodb log checkpointing and what does it tell us? mysql> SHOW ENGINE INNODB STATUS\G — …writes to the transaction log if you set this too high. innodb_write_io_threads: Controls how many threads will have writes…
Post: Tuning for heavy writing workloads
October 14, 2009 By 9 Comments
…mysql-5.1.39 + XtraDB-1.0.4-current) innodb_io_capacity = 4000 innodb_support_xa = false innodb_file_per_table = true innodb_buffer_pool_size = 16G innodb_read_io_threads = 8 innodb_write…
Post: Multiple purge threads in Percona Server 5.1.56 and MySQL 5.6.2
May 3, 2011 By 13 Comments
…MySQL 5.1 this is done by the master InnoDB thread. Since then, InnoDB has been moving towards the parallelized purge: in MySQL… In fact, as of the time of this writing, the code is already different in the trunk…. change are not effective enough: they only slow the growth of the history list. But, …
Post: Modeling MySQL Capacity by Measuring Resource Consumptions
March 8, 2011 By 1 Comment
… our estimates. If we’re running Innodb with MySQL we can use Innodb_data_reads , Innodb_data_writes, Innodb_os_log_fsyncs for your disk IO… CPU. With Percona Server, enabled full query logging and log_slow_verbosity=full you can also get great amount of related… 0 0 0 0 0 0 # String: # Databases # Hosts localhost # InnoDB trxID 3BBF3B55 (1/0%), 3BBF3B5A (1/0%)… 1753695 more # Last…
Post: What's required to tune MySQL?
July 27, 2011 By 4 Comments
… configuring the InnoDB buffer pool size or log file size, and not using InnoDB. If your … of MySQL installations don’t suffer from the variety and severity of problems we write about here. Examples include what happens when you have query cache contention, DNS problems, or very slow…
Post: Reasons for MySQL Replication Lag
July 29, 2011 By 6 Comments
…cache in write-through mode which can cause serve performance degradation. Configuration Changes Have you changed MySQL configuration …_binlog=1, enabling log_slave_updates, setting innodb_flush_log_at_trx_commit=1. Also …-digest (Percona Server marks Slave Thread in slow query log so it is easy to …
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
… or whatever other data I need, and write something instructional to the client about it. …that there are InnoDB tables whose .frm files exist but have been dropped from InnoDB, for example. (…logging and additional information in the slow query log output. The stock MySQL server’s limitation of …
