… the buffer pool is sized at 55G and I am using 4 buffer pool instances to reduce the contention caused by buffer pool… are concerned with write performance is using partitioning to reduce the size of the B+tree, having multiple buffer pool instances to reduce contention problems caused by buffer pool mutexes, using “estimate” checkpoint method…
Comment: How to change innodb_log_file_size safely
May 2, 2012 By 14 Comments
… file ./ib_logfile1 size to 5 MB InnoDB: Database physically writes the file full: wait… InnoDB: The log sequence number in…: Restoring possible half-written data pages from the doublewrite InnoDB: buffer… 120502 11:51:16 InnoDB: Started; log sequence number 119… | grep log_file # Set .._log_file_size to 25 % of buffer pool size innodb_log_file_size = 64M [root@tstlx1 mysql]#
Post: Load management Techniques for MySQL
May 6, 2012 By 3 Comments
… I would not use more than 4 parallel processes heavily writing to database. Introduce Throttling Sometimes even single process overloads system…
Comment: Benchmarking single-row insert performance on Amazon EC2
May 16, 2012 By 11 Comments
… rid of the secondary keys is simply because you are writing 4 times fewer B-tree values. The primary key and… to fill the B-tree pretty efficiently. With a 55GB buffer pool, we would expect the primary table to simply fit…
Comment: InnoDB thread concurrency
March 19, 2012 By 4 Comments
… io threads(4 are read, 4 are write) and a log thread and a insert buffer thread .just like follows: ——– FILE I… (thread id: 18578) state: waiting for completed aio requests (insert buffer thread) I/O thread 1 (thread id: 18579) state: waiting… 6 (thread id: 18584) state: waiting for completed aio requests (write thread) I/O thread 7 (thread id: 18585) state: waiting…
Post: Announcing Percona XtraBackup 1.9.1
February 27, 2012 By 9 Comments
… release (which was 1.6.5 at the time of writing). This beta adds some really exciting features and bug fixes…. For servers that support dump and restore of the XtraDB buffer pool (LRU), namely Percona Server, this will enable a server… your new slave will end up with a warmed up buffer pool to mimic that of the master. Streaming incremental backups…
Post: Innodb Double Write
August 4, 2006 By 23 Comments
… write buffer it is simply discarded, if it is inconsistent in the tablespace it is recovered from double write buffer. How much does double write buffer affect MySQL Performance ? Even though double write requires each page written twice its overhead is far less than double. Write to double write buffer…
Post: The relationship between Innodb Log checkpointing and dirty Buffer pool pages
February 17, 2012 By 5 Comments
…. Some basic facts Most of us know that writing into Innodb updates buffer pool pages in memory and records page operations in… and will block incoming writes until the space is available to continue (safely) writing in the log. Dirty Buffer Pool Pages On the other side, we have dirty buffers. These two numbers are relevant from the BUFFER…
Post: Heikki Tuuri answers to Innodb questions, Part II
November 4, 2007 By 13 Comments
…: Yes, if your ‘write working set’ fits in 16 GB. I mean, if the database buffer pool can buffer many writes to the same page, then fewer disk writes are needed. But if your write working set is… memory for write buffering efficiently. Q30: Question about using solid state disks for storing ib_log* files; I know that innodb writes files…
Post: Analyzing the distribution of InnoDB log file writes
July 16, 2010 By 5 Comments
… page isn’t in the OS buffer cache, then the write will cause a read-around write — the page will have to be… buffer size? The largest write above is just under 40k, which might seem to indicate that only 64k or so of log buffer… remember some complex behavior of how space in the buffer is reserved for writes. We could not quite recall what that is…
