… does not need to read any bitmap files. Bug fixed #1184427. Query to the INNODB_CHANGED_PAGES table would cause server to stop… warning is now returned if a bitmap file I/O error occurs after an INNODB_CHANGED_PAGES query started returning data to indicate… cause small tablespaces to expand too fast around 500KB tablespace size. Bug fixed #1169494. Fixed the RPM package dependencies issues. Bug…
Post: Percona Server 5.1.69-14.7 now available: A drop in replacement for MySQL
June 10, 2013 By 4 Comments
… to the INNODB_CHANGED_PAGES table would cause server to stop with an I/O error if a bitmap file in the middle… warning is now returned if a bitmap file I/O error occurs after an INNODB_CHANGED_PAGES query started returning data to indicate… a zero-size bitmap file at the right moment would make server stop with an I/O error if changed page tracking is…
Post: Implementing SchemaSpy in your MySQL environment
June 4, 2013 By 2 Comments
… on crontab so that schema changes are automatically picked up. Nice, …INCREMENT, PRIMARY KEY (`parent_id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 CREATE TABLE `child_A`… files come in to play Creating a Metadata File The format of the metadata file…level overview of the table sizes and an easy way to…
Post: Virident vCache vs. FlashCache: Part 2
May 17, 2013 By 3 Comments
…innodb options innodb_file_format = barracuda innodb_buffer_pool_size = 4G innodb_file_per_table = true innodb_data_file_path = ibdata1:100M innodb_flush_method = O_DIRECT innodb_log_buffer_size = 128M innodb…
Post: How to change innodb_log_file_size safely
July 9, 2011 By 17 Comments
… you need to change MySQL’s innodb_log_file_size parameter (see How to calculate a good InnoDB log file size), you can’t just change the parameter in the my.cnf file…
Post: Choosing proper innodb_log_file_size
July 3, 2006 By 12 Comments
… you’re doing significant amount of writes to Innodb tables decent size of innodb_log_file_size is important for MySQL Performance. However setting it… on recovery and why large innodb_log_file_size slows down recovery. During startup after crash Innodb scans log files to find log records which… changes from which already made it to the database. Unlike “redo” phase “undo” phase can’t be reduced by sizing your log files…
Post: Real-Life Use Case for "Barracuda" InnoDB File Format
April 23, 2008 By 11 Comments
… using new InnoDB file format but in this post I’d like to share some real-life example how compression in InnoDB plugin… various innodb parameters (including page size changes) but at the end of the day server was dying of I/O load because dataset size… really happy with these changes and we’re really glad to have such a nice tool as new InnoDB plugin which now…
Post: InnoDB page size
June 4, 2006 By 4 Comments
… maybe you know InnoDB uses hard page size 16Kb for datafiles and for buffer pool. However this size can be changed if you need it for your workload. go to file innobase/include/univ.i, lines: /* The universal page size…
Post: InnoDB Flushing: Theory and solutions
April 4, 2011 By 23 Comments
… most important parameters for InnoDB performance are innodb_buffer_pool_size and innodb_log_file_size. InnoDB works with data in memory, and all changes to data are… 0 and innodb_log_file_size. Point 0 means there are no modified pages. Checkpoint_age can’t grow past innodb_log_file_size, as that… 7/8 of innodb_log_file_size, and the “async” point is at about 6/8 = 3/4 of innodb_log_file_size. So, there is…
Post: SHOW INNODB STATUS walk through
July 17, 2006 By 40 Comments
…however can be adjusted by innodb_file_io_threads variable. For…size 1, free list len 887, seg size 889, is not empty Ibuf for space 0: size 1, free list len 887, seg size…Innodb uses fuzzy checkpointing so this line hold log sequence, all changes up to which has been flushed from buffer pool. Changes…
