MySQL 5.1 (fork)
From Wikitech
(Difference between revisions)
| Line 1: | Line 1: | ||
| + | {{old}} | ||
| + | This is documentation for 5.1-wm build that is still running on db24 and db30, new builds are based off facebook tree | ||
| + | |||
| + | |||
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. | ||
Latest revision as of 14:51, 24 October 2010
This is documentation for 5.1-wm build that is still running on db24 and db30, new builds are based off facebook tree
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"
