…MySQL using O_DIRECT to move data from sequentially written log files to the more write-costly spreaded/random innodb data file. Whatever, I stand corrected now, thank you 
You are…where…log file in…
Comment: Linux schedulers in tpcc like benchmark
January 31, 2009 By 19 Comments
Post: The new cool MySQL patch has landed! Check your queries performance!
October 31, 2007 By 16 Comments
… facts about the execution in the log file. # QC_Hit: No Full_…files. INNODB USAGE The final part are the InnoDB usage statistics. MySQL… SELECT DISTINCT c from sbtest where id between 501895 and 502895…in production or on any important system! The patch is available for MySQL Community 5.0.45 on Linux…
Post: The relationship between Innodb Log checkpointing and dirty Buffer pool pages
February 17, 2012 By 10 Comments
…in the transaction log. As I said before, dirty pages are flushed to disk in the background. The order in which they are…Linux native AIO. These can also be rendered useless by filesystems that don’t allow parallel writing to the same file…
Post: Heikki Tuuri answers to Innodb questions, Part II
November 4, 2007 By 13 Comments
…file in a log file group. My questions are: What is always being written to the first file in the log file…mysql processes drops rapidly when you increase the amount of system memory. We just deployed a new Linux/Mysql…
Post: Heikki Tuuri Innodb answers - Part I
October 26, 2007 By 19 Comments
…file address, then InnoDB schedules the read of all the 64 pages of the extent where the next index page in… MySQL. There are two solutions here. Memlock and O_DIRECT. Memlock is apparently unstable on Linux. O… Golubchik serialized the MySQL binlog write and the InnoDB log flush with a mutex in 5.1,…
Post: SHOW INNODB STATUS walk through
July 17, 2006 By 40 Comments
…MySQL thread id 30898, query id 100626 localhost root Updating update iz set pad=’a’ where i…from query executions are executed by threads running queries. On Unix/Linux you will always …in logs and not flushed from buffer pool so such log sequences can’t be overwritten in log files. By monitoring log…
Post: Updated msl (microslow) patch, installation walk-through!
April 20, 2008 By 17 Comments
…are ready to have the patched MySQL installed in the system. Locate where the original mysqld binary is with: (garfield:~/work/mysql…log file won’t be created. This is also the only option which you cannot change at runtime from MySQL…
Post: Aligning IO on a hard disk RAID – the Theory
June 9, 2011 By 18 Comments
… than stripe element; second – logs are actually written in 512 byte units (in Percona Server 5.1 and … 4k (page size) on Linux unless you are using HugePages). Some file systems let you set stripe … 501s –dataalignment 256k /dev/sdb1 You can check where physical extents will start (or check your …
Comment: How to estimate time it takes Innodb to Recover ?
June 25, 2008 By 7 Comments
…where 10b is master of 1a mysql> show master status; +————+———-+——————————————-+——————+ | File…log_file_size = 100M #innodb_log_buffer_size = 8M #innodb_flush_log_at_trx_commit = 1 #innodb_lock_wait_timeout = 50 Thanks in…
Comment: Database problems in MySQL/PHP Applications
November 6, 2006 By 13 Comments
…where the system runs mainly # MySQL. # # You can copy this file to # /etc/my.cnf to set global options, # mysql…log_file_size to 25 % of buffer pool size innodb_log_file_size = 1000M #innodb_log_buffer_size = 32M #innodb_flush_log…
