May 26, 2012

Post: Improved InnoDB rw_lock patch

There is patch from Google to improve SMP performance , but for some workloads … also results with Yasufumi’s rw_locks (http://bugs.mysql.com/bug.php?id=26442) ThreadsStandard InnoDBGoogle smpfixYasufumi rw_lock 19700.2810601.969432.44… for other workloads new rw_locks show results comparable with Google’s smpfix, so we will include innodb_rw_lock into our next -percona…

Post: Percona build7 with latest patches

…_process.patch | Adds INFOMATION_SCHEMA.PROCESSLIST with TIME_MS column | 1.0 | Percona | GPL | | | innodb_locks_held.patch | Add locks held, remove locked records in…_fixed_optimistic_safe.patch | InnoDB patch to fix buffer pool scalability | 1.0 | Yasufumi Kinoshita | BSD | | | innodb_rw_lock.patch | Fix of InnoDB rw_locks | 1.0…

Post: MySQL Binaries Percona build10

…_process.patch | Adds INFOMATION_SCHEMA.PROCESSLIST with TIME_MS column | 1.0 | Percona | GPL | | | innodb_locks_held.patch | Add locks held, remove locked records in…_fixed_optimistic_safe.patch | InnoDB patch to fix buffer pool scalability | 1.0 | Yasufumi Kinoshita | BSD | | | innodb_rw_lock.patch | Fix of InnoDB rw_locks | 1.0…

Post: 5.0.87-build20 Percona binaries

patches. Comparing to the previous release it has following new features: The build is based on MySQL-5.0.87 innodb_rw_lock.patch… group. For support, commercial and sponsorship inquiries contact Percona. innodb_rw_lock.patch

Post: XtraDB storage engine release 1.0.3-5

…: move to MySQL 5.1.34 removed rw_lock patch, so we now use Google’s rw_locks fix crash after upgrade 5.1.31… features requests for new engine and ready to accept community patches. You can monitor Percona’s current tasks and further plans…

Comment: Percona build7 with latest patches

…_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_show_hashed_memory.patch split_buf_pool_mutex_fixed_optimistic_safe.patch innodb_rw_lock.patch

Post: Introducing percona-patches for 5.1

…-write locks Diagnostic patches. – We provide much more statistics in slow.log, i.e. execution plan, InnoDB timing, profiling info – Userstat patch Different patches… hits problems in InnoDB rw-lock implementations and in buffer_pool mutex contention, which alredy fixed in percona-patches ( and in XtraDB and…

Post: MySQL 5.0, 5.1 and Innodb Plugin CPU Efficiency

… see there is some gain for MySQL from read-write lock split patch (found in Percona Builds) though it is not very… this workload. To isolate effect of this patch we only use this patch not full patch set in testing. MySQL 5.1 is… it is hard to say anything about CPU efficiency. The RW-Lock patch is best in this case. It shows increased performance while…

Post: XtraDB storage engine release 1.0.3-4 codename Sakura

…_overwrite_relay_log_info patch now included in the release fix assertions for UNIV_DEBUG new fix for rw_lock patch Percona XtraDB 1… features requests for new engine and ready to accept community patches. You can monitor Percona’s current tasks and further plans…

Comment: Improved InnoDB rw_lock patch

… Yasufumi for his innodb_rw_lock patch. I was close to loosing my trust in FreeBSD before applying the patch. Running our 7G InnoDB… 8core Box we had severe context-switching problems without the patch. After applying it it works like a charm. Close to…