… patches is: show_patches.patch microslow_innodb.patch userstatv2.patch microsec_process.patch innodb_io_patches.patch mirror_binlog.patch mysqld_safe_syslog.patch innodb_locks_held.patch innodb_show_bp.patch innodb_check_fragmentation.patch innodb_io_pattern.patch innodb_fsync_source.patch innodb…
Post: The performance effects of new patches
September 9, 2008 By 14 Comments
… storage. main common settings innodb_buffer_pool_size = 2048M innodb_thread_concurrency = 0 innodb_max_dirty_pages_pct = 70 innodb_flush_method = O_DIRECT… patches. Then, how the patches contribute to the improvements in this case. split_buf_pool_mutex_fixed_optimistic_safe.patch The patch splits global InnoDB… test uses “innodb_file_io_threads = 34″ (But, it is redundant value…) control_flush_and_merge_and_read.patch This patch makes more…
Post: The new cool MySQL patch has landed! Check your queries performance!
October 31, 2007 By 16 Comments
… does not include those of InnoDB, which are always global and shared by all the threads. The patch gives you the opportunity to see those values for a given query. # InnoDB_IO_r_ops: 19 InnoDB_IO_r_bytes: 311296 InnoDB…_passes: 0 # No InnoDB statistics available for this query SELECT COUNT(1) FROM t2; Important note: Although the patch was tested and…
Post: Introducing percona-patches for 5.1
February 9, 2010 By 21 Comments
… the patches to 5.1. To refresh, the most interesting patches are: Performance patches for InnoDB ®. Although many patches are present in XtraDB / InnoDB-plugin… locks Diagnostic patches. – We provide much more statistics in slow.log, i.e. execution plan, InnoDB timing, profiling info – Userstat patch Different patches to…
Post: MySQL Users Conference - Innodb
May 9, 2007 By 6 Comments
… other areas in Innodb than buffer-pool which had it locking relaxed in latest MySQL 5.0 Hopefully the patches he has… so many MySQL patches so we can call patched version GoogleSQL. Among them there are number of patches to make Innodb IO scheduling more aggressive which is important for serious IO subsystems. Many Innodb IO settings were…
Post: Improving InnoDB recovery time
July 7, 2009 By 12 Comments
… running threads. MySQL params are: innodb_buffer_pool_size=16G innodb_log_files_in_group=3 innodb_log_file_size=512M So let…, scratched his head and made new patch for InnoDB. With this patch mysqld starts: 090707 19:00:01 InnoDB: Database was not shut down…-xtradb/recovery-speed-hack/ tree. The patch by itself is quite small, I would ask InnoDB experts to review it: http://bazaar…
Post: Limiting InnoDB Data Dictionary
February 11, 2009 By 13 Comments
… can download it there http://mysqlperformanceblog.com/files/patches/innodb_dict_size_limit_standalone.patch. Currently patch is on testing stage, but later will be included into our releases. To limit memory we introduce new variable innodb…
Post: Heikki Tuuri Innodb answers - Part I
October 26, 2007 By 19 Comments
… drives. Google has Patches which let you to try it out. Q14: Are there any plans to fix Innodb so it unlocks… way InnoDB does the buffer pool flush. I think Yasufumi Kinoshita talked at Users’ Conference 2007 about his patch that makes InnoDB‘s…. Latest patches of Yasufumi Kinoshita attained very nice scaling up to 8 or 16 cores. These patches are not in the official InnoDB…
Post: Helgrinding MySQL with InnoDB for Synchronisation Errors, Fun and Profit
November 24, 2011 By 2 Comments
… DBQP. For 5.1: mtr-helgrind-51.patch For 5.5: mtr-helgrind-55.patch Now let’s see what kind of… version (pre-5.1.61) and a single test, innodb_plugin.innodb_bug53674. The test is chosen for no particular reason except… (srv0start.c:1514) ==9090== by 0x6B48855: innobase_init(void*) (ha_innodb.cc:2284) ==9090== by 0x712F17: ha_initialize_handlerton(st_plugin…
Post: MySQL 5.0, 5.1 and Innodb Plugin CPU Efficiency
December 3, 2008 By 15 Comments
… this workload. To isolate effect of this patch we only use this patch not full patch set in testing. MySQL 5.1 is… execution path. Another thing to note – if you’re using Innodb Plugin consider using new Barracuda format, though do this only… testing as this format will not be recognized by older Innodb versions. Note: These are completely CPU bound test conditions, data…
