~drizzle-trunk/drizzle/development : changes

~drizzle-trunk/drizzle/development » Changes from revision 1819.9.71

Rev	Summary	Authors	Date
1819.9.70	modified join_nested EXPLAIN output due to innodb stats chan... modified join_nested EXPLAIN output due to innodb stats changes	Stewart Smith	14 years ago
1819.9.69	make myisam.basic test actually use MyISAM everywhere. make myisam.basic test actually use MyISAM everywhere.	Stewart Smith	14 years ago
1819.9.68	fix func_in test result due to changed innodb statistics fix func_in test result due to changed innodb statistics	Stewart Smith	14 years ago
1819.9.67	update endspace test - now with --sorted_result update endspace test - now with --sorted_result	Stewart Smith	14 years ago
1819.9.66	EXPLAIN in test result changes due to modified InnoDB stats EXPLAIN in test result changes due to modified InnoDB stats	Stewart Smith	14 years ago
1819.9.65	build fix for data_dictionary now that innobase uses real ui... build fix for data_dictionary now that innobase uses real uint64	Stewart Smith	14 years ago
1819.9.64	merge update-innobase-1.1.1 branch (incl fixes for trunk) merge update-innobase-1.1.1 branch (incl fixes for trunk)	Stewart Smith	14 years ago
1819.9.63	fix innodb result file for changed index stats and remove in... fix innodb result file for changed index stats and remove innodb_gis test (not needed on drizzle - no GIS types)	Stewart Smith	14 years ago
1819.9.62	Merge Revision revid:jimmy.yang@oracle.com-20100817081924-i5... Merge Revision revid:jimmy.yang@oracle.com-20100817081924-i5vfwmvsszboeb0o from MySQL InnoDB Original revid:jimmy.yang@oracle.com-20100817081924-i5vfwmvsszboeb0o Original Authors: Jimmy Yang <jimmy.yang@oracle.com> Original commit message: Fix bug #53496 Use Lock_time in slow query log output for InnoDB row lock wait time. Including the InnoDB lock time in the exiting "Lock_time" output.	Jimmy Yang	14 years ago
1819.9.61	update test result due to better innodb stats: better EXPLAI... update test result due to better innodb stats: better EXPLAIn output	Stewart Smith	14 years ago
1819.9.60	fix innodb_mysql test result due to updated index stats fix innodb_mysql test result due to updated index stats	Stewart Smith	14 years ago
1819.9.59	Merge Revision revid:vasil.dimov@oracle.com-20100817062433-r... Merge Revision revid:vasil.dimov@oracle.com-20100817062433-rt4140mywoux0b1e from MySQL InnoDB Original revid:vasil.dimov@oracle.com-20100817062433-rt4140mywoux0b1e Original Authors: Vasil Dimov <vasil.dimov@oracle.com> Original commit message: Adjust innodb_gis.result This is a followup to vasil.dimov@oracle.com-20100816142329-yimenbuktd416z1a which improved the sampling algorithm.	Vasil Dimov	14 years ago
1819.9.58	Merge Revision revid:vasil.dimov@oracle.com-20100816142329-y... Merge Revision revid:vasil.dimov@oracle.com-20100816142329-yimenbuktd416z1a from MySQL InnoDB Original revid:vasil.dimov@oracle.com-20100816142329-yimenbuktd416z1a Original Authors: Vasil Dimov <vasil.dimov@oracle.com> Original commit message: Fix Bug#53761 RANGE estimation for matched rows may be 200 times different Improve the range estimation algorithm. Previously: For a given level the algo knows the number of pages in the requested range and the n With this change: Same idea, but peek a few (10) of the intermediate pages to get a better estimate of In the bug report one of the examples has a btree with a snippet of the leaf level li page1(899 records), page2(1 record), page3(1 record), page4(1 record) so when trying to estimate, the previous algo, assumed there are average (899+1)/2=45 Fix Bug#53761 RANGE estimation for matched rows may be 200 times different Improve the range estimation algorithm. Previously: For a given level the algo knows the number of pages in the requested range and the number of records on the leftmost and the rightmost page. Then it assumes all pages in between contain the average between the two border pages and multiplies this average number by the number of intermediate pages. With this change: Same idea, but peek a few (10) of the intermediate pages to get a better estimate of the average number of records per page. If there are less than 10 intermediate pages then all of them will be scanned and the result will be precise, not an estimation. In the bug report one of the examples has a btree with a snippet of the leaf level like this: page1(899 records), page2(1 record), page3(1 record), page4(1 record) so when trying to estimate, the previous algo, assumed there are average (899+1)/2=450 records per page which went terribly wrong. With this change page2 and page3 will be read and the exact number of records will be returned. Approved by: Sunny (rb://401)	Vasil Dimov	14 years ago
1819.9.57	Merge Revision revid:inaam.rana@oracle.com-20100813161459-94... Merge Revision revid:inaam.rana@oracle.com-20100813161459-94a6xdimw3g965bz from MySQL InnoDB Original revid:inaam.rana@oracle.com-20100813161459-94a6xdimw3g965bz Original Authors: Inaam Rana <inaam.rana@oracle.com> Original commit message: Undo changes to innodb_strict_mode that went in by mistake in r3149	Inaam Rana	14 years ago
1819.9.56	Merge Revision revid:marko.makela@oracle.com-20100810102248-... Merge Revision revid:marko.makela@oracle.com-20100810102248-xrdjie2de4r9h3ed from MySQL InnoDB Original revid:marko.makela@oracle.com-20100810102248-xrdjie2de4r9h3ed Original Authors: Marko Mäkelä <marko.makela@oracle.com> Original commit message: Bug#54914: InnoDB: performance drop with innodb_change_buffering=all Reduce ibuf_mutex and ibuf_pessimistic_insert_mutex contention further. Protect ibuf->empty by the insert buffer root page latch, not ibuf_mutex. ibuf_tree_root_get(): Assert that ibuf_mutex is owned by the caller. Assert that the stamped page number is correct. Assert that ibuf->empty agrees with the root page. ibuf_size_update(): Do not update ibuf->empty. ibuf_init_at_db_start(): Update ibuf->empty while holding the root page latch. ibuf_add_free_page(): Return TRUE/FALSE instead of DB_SUCCESS/DB_STRONG_FAIL. ibuf_remove_free_page(): Release ibuf_pessimistic_insert_mutex as early as possible. ibuf_contract_ext(): Rely on a dirty read of ibuf->empty, unless the server is being shut down. Never acquire ibuf_mutex. Eliminate n_stored. ibuf_contract_after_insert(): Never acquire ibuf_mutex. Perform dirty reads of ibuf->size and ibuf->max_size. ibuf_insert_low(): Only acquire ibuf_mutex for mode==BTR_MODIFY_TREE. Perform dirty reads of ibuf->size and ibuf->max_size. Update ibuf->empty while holding the root page latch. ibuf_delete_rec(): Update ibuf->empty while holding the root page latch. ibuf_is_empty(): Release ibuf_mutex earlier.	Marko Mäkelä	14 years ago
1819.9.55	Merge Revision revid:marko.makela@oracle.com-20100809085837-... Merge Revision revid:marko.makela@oracle.com-20100809085837-s1nfx6gjf7l6ttab from MySQL InnoDB Original revid:marko.makela@oracle.com-20100809085837-s1nfx6gjf7l6ttab Original Authors: Marko Mäkelä <marko.makela@oracle.com> Original commit message: Reduce the ibuf_mutex hold time. This does not fix the update regression in Bug #54914, but it does speed up the execution for innodb_change_buffering=inserts. ibuf_add_ops(), ibuf_merge_or_delete_for_page(), ibuf_delete_for_discarded_space(): Use atomic built-ins instead of ibuf_mutex, when available. ibuf_add_free_page(), ibuf_remove_free_page(), ibuf_contract_ext(): Release ibuf_mutex earlier. ibuf_free_excess_pages(): Release ibuf_mutex before a conditional branch. ibuf_insert_low(): Release ibuf_mutex before a conditional branch. Create ibuf_entry before re-acquiring ibuf_mutex. Simplify a loop to reduce code footprint. Release ibuf_mutex before mtr_commit() [btr_pcur_close()]. ibuf_is_empty(): Release ibuf_mutex before mtr_commit().	Marko Mäkelä	14 years ago
1819.9.54	Merge Revision revid:calvin.sun@oracle.com-20100803061203-v3... Merge Revision revid:calvin.sun@oracle.com-20100803061203-v35h8tde0gvf2qmx from MySQL InnoDB Original revid:calvin.sun@oracle.com-20100803061203-v35h8tde0gvf2qmx Original Authors: Calvin Sun <calvin.sun@oracle.com> Original commit message: Bug #54702: revert the default of innodb_strict_mode to false.	Calvin Sun	14 years ago
1819.9.53	Merge Revision revid:inaam.rana@oracle.com-20100805150905-eg... Merge Revision revid:inaam.rana@oracle.com-20100805150905-egfos37tprx6mmfu from MySQL InnoDB Original revid:inaam.rana@oracle.com-20100805150905-egfos37tprx6mmfu Original Authors: Inaam Rana <inaam.rana@oracle.com> Original commit message: Currently we do a full validation of AHI whenever check tables is called on any table. This patch fixes this by only doing this full check in debug versions. bug#55716 rb://423 approved by: Marko	Inaam Rana	14 years ago
1819.9.52	Merge Revision revid:inaam.rana@oracle.com-20100730143916-uc... Merge Revision revid:inaam.rana@oracle.com-20100730143916-uch6xe702dbu8oqb from MySQL InnoDB Original revid:inaam.rana@oracle.com-20100730143916-uch6xe702dbu8oqb Original Authors: Inaam Rana <inaam.rana@oracle.com> Original commit message: When the caller of buf_flush_list() provides us with the number of pages that it wants to flush then we should honor that value as in not going beyond that in our eagerness to flush the neighbors of the selected victim.	Inaam Rana	14 years ago
1819.9.51	Merge Revision revid:marko.makela@oracle.com-20100629131219-... Merge Revision revid:marko.makela@oracle.com-20100629131219-pjbkpk5rsqztmw27 from MySQL InnoDB Original revid:marko.makela@oracle.com-20100629131219-pjbkpk5rsqztmw27 Original Authors: Marko Mäkelä <marko.makela@oracle.com> Original commit message: ChangeLog entry for Bug #54408	Marko Mäkelä	14 years ago

Older »