June 19, 2013

Post: XtraDB storage engine release 1.0.3-5

… to MySQL 5.1.34 removed rw_lock patch, so we now use Google’s rw_locks fix crash after upgrade 5.1.31… several binary packages. XtraDB is compatible with existing InnoDB tables (unless you used innodb_extra_undoslots) and we are going to keep…

Comment: Returning to InnoDB scalability

…_mutex | srv0start.c | 1 | 0 | 0 | 0 | 0 | 0 | | &srv_innodb_monitor_mutex | srv0srv.c | 57877 | 0 | 0 | 0 | 0 | 0… | 1329851104 | 2160576205 | 459450 | 389068 | 0 | | &rw_lock_list_mutex | sync0sync.c | 138309 | 0 | 0 | 0 | 0 | 0 | | rw_lock_mutexes | | 395971608584 | 222851003 | 305839693 | 411527…

Comment: Returning to InnoDB scalability

…_mutex | srv0start.c | 8 | 0 | 0 | 0 | 0 | 0 | | &srv_innodb_monitor_mutex | srv0srv.c | 5757 | 0 | 0 | 0 | 0 | 0… | 207890633 | 619535690 | 235717 | 196481 | 0 | | &rw_lock_list_mutex | sync0sync.c | 131581 | 0 | 0 | 0 | 0 | 0 | | rw_lock_mutexes | | 40258012646 | 50506378 | 140215245 | 317633…

Comment: xtrabackup-1.2

…) InnoDB: The InnoDB memory heap is disabled InnoDB: Mutexes and rw_locks use InnoDB‘s own implementation InnoDB: Warning: innodb_file_io_threads is deprecated. Please use innodb_read_io_threads and innodb_write…

Comment: Modeling InnoDB Scalability on Multi-Core Servers

…:43 InnoDB: The InnoDB memory heap is disabled 120131 16:00:43 InnoDB: Mutexes and rw_locks use GCC atomic builtins 120131 16:00:43 InnoDB: Compressed tables use zlib 1.2.3 120131 16:00:43 InnoDB…:44 [ERROR] Aborting 120131 16:00:44 InnoDB: Starting shutdown… 120131 16:00:49 InnoDB: Shutdown completed; log sequence number 1604009568 120131…

Comment: Yasufumi Kinoshita joins Percona

… several patches to improve InnoDB‘s scalability and has tracked down a serious bug in InnoDB-5.0.30 rw-lock implementation. To Kevin Burton I would like to assure that Innobase/Oracle has 8 developers working on InnoDB… quite a lot of time handling the bug reports on InnoDB and InnoDB Plugin: http://bugs.mysql.com/search.php?search_for…

Post: XtraDB storage engine release 1.0.3-4 codename Sakura

… replication, innodb_overwrite_relay_log_info patch now included in the release fix assertions for UNIV_DEBUG new fix for rw_lock patch Percona XtraDB 1.0.3-4 (Sakura) available in source and several binary packages. XtraDB is compatible with existing InnoDB tables (unless you used innodb_extra_undoslots) and we are going to keep…

Comment: XtraDB storage engine release 1.0.3-5

Percona rocks! I am thrilled that you switched to the Google rw-lock patch because that is in the InnoDB plugin and you can add value elsewhere. Is XtraDB derived from the InnoDB plugin?

Post: Development plans

… of them. My favorite one is – make InnoDB files .ibd (one created with –innodb-file-per-table=1) movable from one server… to integrate is Google’s smp-fix or Yasufumi’s rw-locks (we are going to test both before) On this page…

Comment: DROP TABLE and stalls: Lazy Drop Table in Percona Server and the new fixes in MySQL

… pool mutex is the bottleneck? Have you collected ‘show engine innodb mutex’ output to verify which mutex is the hottest one… in MySQL 5.6. We have introduced an array of rw-locks to control access to the buffer pool pages. For workloads…