MySQL 5.1 (fork)
From Wikitech
(Difference between revisions)
| Line 1: | Line 1: | ||
| − | Currently [https://code.launchpad.net/~wikimedia/sakila-server/mysql-5.1-wm new fork] is being rolled out, based on [https://code.launchpad.net/mysql-server/5.1 lp:mysql-server/5.1 tree] - with storage engine changes going into innodb_plugin engine. | + | Currently [https://code.launchpad.net/~wikimedia/sakila-server/mysql-5.1-wm new fork] is being rolled out, based on [https://code.launchpad.net/mysql-server/5.1 lp:mysql-server/5.1 tree] - with storage engine changes going into innodb_plugin engine. |
Included Percona patches (from http://bazaar.launchpad.net/~percona-dev/percona-xtradb/extensions-1.0/files): | Included Percona patches (from http://bazaar.launchpad.net/~percona-dev/percona-xtradb/extensions-1.0/files): | ||
* InnoDB-based replication positions | * InnoDB-based replication positions | ||
* Multiple purge threads | * Multiple purge threads | ||
| − | * | + | * Recovery performance: flushlist |
* LRU contention fixes | * LRU contention fixes | ||
Domas' changes: | Domas' changes: | ||
* Online settable checksums calculation | * Online settable checksums calculation | ||
| + | * Replication fixes (for 4.0-5.1 replication) (see http://mituzas.lt/2009/12/05/on-replication-compatibility/ ) | ||
| + | * Replication performance: hash building (see http://mituzas.lt/2009/12/08/crash-recovery-again/ ) | ||
| + | * Reordered INNODB STATUS with serious stuff at the top, increased output size | ||
| + | * Removed some deprecation warnings | ||
Wikimedia build params: | Wikimedia build params: | ||
Revision as of 23:18, 10 December 2009
Currently new fork is being rolled out, based on lp:mysql-server/5.1 tree - with storage engine changes going into innodb_plugin engine.
Included Percona patches (from http://bazaar.launchpad.net/~percona-dev/percona-xtradb/extensions-1.0/files):
- InnoDB-based replication positions
- Multiple purge threads
- Recovery performance: flushlist
- LRU contention fixes
Domas' changes:
- Online settable checksums calculation
- Replication fixes (for 4.0-5.1 replication) (see http://mituzas.lt/2009/12/05/on-replication-compatibility/ )
- Replication performance: hash building (see http://mituzas.lt/2009/12/08/crash-recovery-again/ )
- Reordered INNODB STATUS with serious stuff at the top, increased output size
- Removed some deprecation warnings
Wikimedia build params:
./configure --without-query-cache --without-geometry --with-plugins=innodb_plugin,blackhole \
--enable-assembler --with-charset=binary --with-extra-charsets=all --with-server-suffix=-wm \
--with-pstack --with-fast-mutexes --with-comment="Wikimedia Testing" --prefix=/usr/local/mysql-5.1-wm/ \
CFLAGS="-g -O3 -fno-omit-frame-pointer" CXXFLAGS="-g -O3 -fno-omit-frame-pointer" \
LDFLAGS="-fno-omit-frame-pointer"
