~mysql/mysql-server/mysql-5.1 : changes

~mysql/mysql-server/mysql-5.1 » Changes from revision 3606

From Revision 3606 to 3587

Rev	Summary	Authors	Date
3606	Disable the prefetch code in the InnoDB internal SQL parser. Disable the prefetch code in the InnoDB internal SQL parser. This change is a followup to vasil.dimov@oracle.com-20110907145810-v98kldmho23vhhic 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)	Vasil Dimov	2011-09-09
3605	Bug#12948130 UNNECESSARY X-LOCKING OF ADAPTIVE HASH INDEX (B... 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	Marko Mäkelä	2011-09-08
3604	Bug#11766591 59733: POSSIBLE DEADLOCK WHEN BUFFERED CHANGES ... 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.	Marko Mäkelä	2011-09-08
3603	Use cursors for seeking records in SYS_FOREIGN and SYS_INDEX... 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	Vasil Dimov	2011-09-07
3602	Bug#11765888 58898: MYSQL_INSTALL_DB: NOT ALL OPTIONS DOCUME... Bug#11765888 58898: MYSQL_INSTALL_DB: NOT ALL OPTIONS DOCUMENTED (EG: --DEFAULTS-FILE ) Updating help message in scripts/mysql_install_db.pl.in file.	Nirbhay Choubey	2011-09-06
3601	Removing a stray line, went into the last push. Removing a stray line, went into the last push.	Nirbhay Choubey	2011-09-06
3600	Bug#11765888 58898: MYSQL_INSTALL_DB: NOT ALL OPTIONS DOCUME... 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).	Nirbhay Choubey	2011-09-06
3599	Bug #12950803 62294: BUF_BUDDY_RELOCATE CALLS GETTIMEOFDAY .... 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	Marko Mäkelä	2011-09-06
3598	Bug#12547647 UPDATE LOGGING COULD EXCEED LOG PAGE SIZE - tak... 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 marko.makela@oracle.com-20110829081642-z0w992a0mrc62s6w 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 marko.makela@oracle.com-20110901184804-2901f6qmuro3jas8. 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	Marko Mäkelä	2011-09-06
3597	merge from 5.1-mtr merge from 5.1-mtr	Bjorn Munch	2011-08-30
3596	local merge local merge	Tor Didriksen	2011-08-30
3595	Bug#12856915 VALGRIND FAILURE IN FILESORT/CREATE_SORT_INDEX Bug#12856915 VALGRIND FAILURE IN FILESORT/CREATE_SORT_INDEX Post-push fix: The functions write_keys() and find_all_keys() may have a slightly different function signature, depending on compiler/platform/flags.	Tor Didriksen	2011-08-30
3594	BUG#12911710 - VALGRIND FAILURE IN ROW-DEBUG:PERFSCHEMA.SOCK... BUG#12911710 - VALGRIND FAILURE IN ROW-DEBUG:PERFSCHEMA.SOCKET_SUMMARY_BY_INSTANCE_FUNC Converting the number zero to binary and back yielded the number zero, but with no digits, i.e. zero precision. This made the multiply algorithm go haywire in various ways.	Tor Didriksen	2011-08-29
3593	local merge local merge	Tor Didriksen	2011-08-29
3592	Bug#12856915 VALGRIND FAILURE IN FILESORT/CREATE_SORT_INDEX Bug#12856915 VALGRIND FAILURE IN FILESORT/CREATE_SORT_INDEX Suppress the known warnings generated by filesort(). The real fix belongs to worklog 1509: Pack values of non-sorted fields in the sort buffer (which is basically the same issue, but in an optimization context: We are writing the entire sort buffer to disk, including un-used space for varchar columns.)	Tor Didriksen	2011-08-25
3591	BUG#11878104: FIXES OF BUG 11752963 - 44312 TO BACKPORT TO M... BUG#11878104: FIXES OF BUG 11752963 - 44312 TO BACKPORT TO MYSQL-5.1 Background: Backporting fix for BUG 11752963 to Mysql5.1 branch. Problem: Fix of bug 11752963 was only available for trunk and 5.5 branch. Partial fix has been pushed to 5.1 branch as well. Fix: backporting the fixes of bug 11752963 to 5.1 branch. 1. Made all major changes to make 5.1 branch in line with 5.5 and the trunk. 2. skipped the partial patch that was already applied to the 5.1 branch.	Rohit Kalhans	2011-08-26
3590	Merge. Merge.	Sergey Vojtovich	2011-08-24
3589	Bug #11766591 59733: POSSIBLE DEADLOCK WHEN BUFFERED CHANGE... Bug #11766591 59733: POSSIBLE DEADLOCK WHEN BUFFERED CHANGES ARE TO BE DISCARDED The fix in revision id marko.makela@oracle.com-20110815091143-h3zbvm0pv8ni3qql introduced a false UNIV_SYNC_DEBUG alarm. Relax the assertion.	Marko Mäkelä	2011-08-22
3588	Merge bug fix to main. Merge bug fix to main.	Joerg Bruehe	2011-08-19
3587	2nd fix for Bug #55713 innochecksum is NOT built with large... 2nd fix for Bug #55713 innochecksum is NOT built with large file support enabled	hery.ramilison at or...	2011-08-16

Older »