MySQL Server

lp:~mysql/mysql-server/mysql-5.1

Created by Daniel Fischer on 2008-05-28 and last modified on 2011-10-10

This branch may be out of date, because Launchpad has not been able to access it since 2011-09-10.

This is the old MySQL 5.1 mainline branch and is currently not actively maintained. Please see https://code.launchpad.net/~mysql/mysql-server/5.1 for the maintained branch.

Get this branch:: bzr branch lp:~mysql/mysql-server/mysql-5.1

Branch merges

1 branch proposed for merging into this one.

Medium

Invalid

Link a bug report

Related blueprints

Branch information

Owner:: Oracle/MySQL Engineering

Project:: MySQL Server

Status:: Merged

Location:: <private server>

Last mirrored:: 2011-09-10

Next mirror:: Disabled

Updating branch...

Launchpad is processing new changes to this branch which will be available in a few minutes. Reload to see the changes.

Recent revisions

3606. By Vasil Dimov on 2011-09-09

Disable the prefetch code in the InnoDB internal SQL parser.

This change is a followup to
<email address hidden>
which triggered the usage of the prefetch and valgrind tests spat lots of
warnings.

The prefetch code will be removed.

Discussed with: Marko (over IM)

3605. By Marko Mäkelä <email address hidden> on 2011-09-08

Bug#12948130 UNNECESSARY X-LOCKING OF ADAPTIVE HASH INDEX (BTR_SEARCH_LATCH)

InnoDB acquires an x-latch on btr_search_latch for certain in-place updates
that do affect the adaptive hash index. These operations do not really need
to be protected by the btr_search_latch:

* updating DB_TRX_ID
* updating DB_ROLL_PTR
* updating PAGE_MAX_TRX_ID
* updating the delete-mark flag

rb:750 approved by Sunny Bains

3604. By Marko Mäkelä <email address hidden> on 2011-09-08

Bug#11766591 59733: POSSIBLE DEADLOCK WHEN BUFFERED CHANGES ARE DISCARDED

Tweak the faulty UNIV_SYNC_DEBUG diagnostics a little bit more.

ibuf_add_free_page(): Lower the latching order of the newly allocated page
only after acquiring the ibuf_mutex.

3603. By Vasil Dimov on 2011-09-07

Use cursors for seeking records in SYS_FOREIGN and SYS_INDEXES from
DROP_TABLE_PROC().

With this change I observe a speedup from 6.2s to 0.1s when executing
DROP_TABLE_PROC() during DROP TABLE with 512 foreign keys, like what
is being done in innodb_bug56143.test

This fixes "Bug#11765460 DROP TABLE USES INEFFICIENT METHODS TO REMOVE
FKS/INDEXES FROM INNODB SYS TABLES"

Reviewed by: Marko

3602. By Nirbhay Choubey <email address hidden> on 2011-09-06

Bug#11765888 58898: MYSQL_INSTALL_DB: NOT ALL OPTIONS DOCUMENTED
(EG: --DEFAULTS-FILE )

Updating help message in scripts/mysql_install_db.pl.in file.

3601. By Nirbhay Choubey <email address hidden> on 2011-09-06

Removing a stray line, went into the last push.

3600. By Nirbhay Choubey <email address hidden> on 2011-09-06

Bug#11765888 58898: MYSQL_INSTALL_DB: NOT ALL OPTIONS DOCUMENTED
(EG: --DEFAULTS-FILE )

Added help message for the missing options (--no-defaults,
--defaults-file and --defaults-extra-file).

3599. By Marko Mäkelä <email address hidden> on 2011-09-06

Bug #12950803 62294: BUF_BUDDY_RELOCATE CALLS GETTIMEOFDAY ...

buf_buddy_relocate(): The ut_time_us() function is needed for
statistics, calculating the total time spent on relocating blocks.
Until now, we invoked ut_time_us() every time buf_buddy_relocate() was
called. Fix: Only call ut_time_us() when the block can be relocated.
After this fix, the reported relocated_usec will no longer include the
time for the page_hash lookup and for acquiring the block mutex.

Approved by Sunny Bains on IM

3598. By Marko Mäkelä <email address hidden> on 2011-09-06

Bug#12547647 UPDATE LOGGING COULD EXCEED LOG PAGE SIZE - take 2

The original fix was accidentally pushed to mysql-5.1 after the 5.1.59
clone-off in bzr revision id
<email address hidden> with thne fix
of Bug#12704861 Corruption after a crash during BLOB update.
It was pushed separately to mysql-5.5 in bzr revision id
<email address hidden>.

trx_undo_report_row_operation(): If the page for which the undo log
was too big was empty, commit and start the mini-transaction before
acquiring the rollback segment mutex and freeing the undo page. This
is necessary, because the mini-transaction may be holding lower-order
latches in the levels SYNC_FSP and SYNC_FSP_PAGE.

trx_undo_erase_page_end(): Erase also empty pages, because
trx_undo_report_row_operation() needs to commit the mini-transaction
before freeing the empty page.

rb:756 approved by Sunny Bains

3597. By Bjorn Munch on 2011-08-30

merge from 5.1-mtr