…when it is the first time block is written to since snapshot was created. In this case single write is transformed to…to get consistent binary logs in the backup and you do not want query log and general logs anyway. However DO place Innodb Log Files… physical volume – it does not have to be same 15K …
Post: The tool I've been waiting for years
March 18, 2008 By 10 Comments
…to see what pages of file are cached in OS memory. This is really cool. When it comes to… it does not disturbs OS file cache by using mincore function to get pages …Innodb log files is practically uncached while other has about 1/3rd cached – this makes sense, perhaps second log file is being written…
Post: Helgrinding MySQL with InnoDB for Synchronisation Errors, Fun and Profit
November 24, 2011 By 2 Comments
…get an old value for quite some time after the store. Now of course it is extremely unfair to say about InnoDB…file_write (os0file.c:2172) ==9090== by 0x6B35B5E: fil_io (fil0fil.c:4432) ==9090== by 0x6B67EDA: log…
Comment: Disaster: MySQL 5.5 Flushing
September 19, 2011 By 27 Comments
…When NDB redo log file is full, it refuses to accept more transactions (returning error) until there is room again. When InnoDB log file is full, transactions get…written into the redo log. The time it takes to dump contents of the in-memory database to…
Post: MySQL Crash Recovery
July 30, 2006 By 30 Comments
…innodb_log_file_size and innodb…Innodb dictionary but .frm not created or not completely written. Partially written .frm files or .frm being unsync with internal Innodb dictionary may cause MySQL to…
Post: Connecting orphaned .ibd files
May 13, 2011 By 19 Comments
…file to another MySQL server. If you try to very often you’ll get an error in the log: InnoDB…written to every InnoDB page. An .ibd file can be huge, while ibdata1 is usually smaller. Thus, it is easier to modify space_id in InnoDB…
Post: MVCC: Transaction IDs, Log Sequence numbers and Snapshots
December 19, 2007 By 3 Comments
…Log Sequence Numbers correspond to given position in the log files and typically incremented for each log record. Innodb uses number of bytes ever written to the log files…
Post: Aligning IO on a hard disk RAID – the Theory
June 9, 2011 By 18 Comments
…InnoDB page You don’t need to do anything to align InnoDB pages – file system takes care of it (assuming you configure the file…to know these. Stripe unit size is the amount of data that will be written to single disk before skipping to…
Post: Paul McCullagh answers your questions about PBXT
November 20, 2009 By 2 Comments
…gets its own snapshot of the database. And write locks are not acquired when…written by the Writer to disk. It is also responsible for writing consistent snapshots of the index files to disk. The frequency of checkpoints, as with other engines like InnoDB, determines the recovery time. Does…
Post: High-Performance Click Analysis with MySQL
December 22, 2008 By 13 Comments
…when things get big. And even if it’s read-only, there’s still another reason to use InnoDB…file and import that with LOAD DATA INFILE. Keep those big fat log files…to parallelize. As you know, MySQL doesn’t do intra-query parallelization, so ETL jobs written to rely on SQL tend to get…
