May 23, 2012

Post: Future InnoDB File Formats

Looking into InnoDB docs I found list of names of future InnoDB file formats: Antelope, Barracuda, Cheetah, Dragon, Elk, Fox, Gazelle, Hornet, Impala, Jaguar, …

Comment: Future InnoDB File Formats

:) At the google reader: Future InnoDB File Formats from Planet MySQL author: Peter Zaitsev At the Planet Mysql: Future InnoDB File Formats posted by Peter Zaitsev…’s very strange, becouse atom show correct author name: Vadim of this post.

Post: Multiple purge threads in Percona Server 5.1.56 and MySQL 5.6.2

…=O_DIRECT innodb_max_dirty_pages_pct=80 innodb_file_format=barracuda innodb_file_per_table max_connections=2000 table_cache=2000 Percona… is likely to receive a lot of tuning in the future. In fact, as of the time of this writing, the code is already… dirty change and by no means a replacement to proper future 5.6 tuning. MySQL 5.6.2 Results With Purge…

Post: How Percona does a MySQL Performance Audit

… this stage. Is it the current performance, future performance, scalability, ability to recover from disasters? … more than my.cnf files. In fact my.cnf files are usually one of the smallest levers … … snip … Then I format the second set of values up beside the first set for ease of reference (an …

Post: How to estimate time it takes Innodb to Recover ?

files from last checkpoint time it looks at records and checks if these are already applied to the pages (Innodb log format…interval This is mainly controlled by size of log files as Innodb needs to flush database pages … be done in the background. In the future to increase recovery time even more I …

Post: Testing the Group Commit Fix

…), and here are the results of my testing of the new Group Commit in…. All scripts, raw results and config files are available on our launchpad results … sync_binlog=1 or in tabular format: Threads Nofix Group Commit fix 1 …may run that benchmark sometime in the future. UPDATE 14-Jul-2011 By requests …

Post: INSERT INTO ... SELECT Performance with Innodb tables.

… which other locks will be relaxed in future versions and how it would affect your … to delete file after it is loaded back (it has to be done outside of MySQL …no 180 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 30; hex 306338386465646233353863643936633930363962373361353736383261…