ChangeLog 53.8 KB
Newer Older
1 2 3 4 5 6 7 8 9 10 11 12
2010-03-31	The InnoDB Team

	* mysql-test/innodb_bug51920.test, mysql-test/innodb_bug51920.result,
	srv/srv0srv.c:
	Fix Bug#51920 InnoDB connections in row lock wait ignore KILL
	until lock wait timeout

2010-03-31	The InnoDB Team

	* mysql-test/innodb_bug38231.test:
	Remove non-determinism in the test case.

13 14 15
2010-03-18	The InnoDB Team

	* CMakeLists.txt:
vdimov's avatar
vdimov committed
16
	Fix Bug#52102 InnoDB Plugin shows performance drop compared to
vdimov's avatar
vdimov committed
17
	InnoDB (Windows)
18

19 20 21 22
2010-03-18	The InnoDB Team

	* buf0buf.ic:
	When comparing the time of the first access to a block against
vdimov's avatar
vdimov committed
23 24
	innodb_old_blocks_time, use 32-bit arithmetics. The comparison was
	incorrect on 64-bit systems.
25

26 27 28 29 30 31 32
2010-03-11	The InnoDB Team

	* buf0buf.h, buf0buf.ic:
	Fix and clarify the latching of some buf_block_t members.
	Note that check_index_page_at_flush is not protected by any mutex.
	Note and assert that lock_hash_val is protected by the rw-latch.

33 34 35
2010-03-10	The InnoDB Team

	* trx/trx0sys.c:
vdimov's avatar
vdimov committed
36
	Fix Bug#51653 outdated reference to set-variable
37 38 39 40 41

2010-03-10	The InnoDB Team

	* handler/ha_innodb.cc, mysql-test/innodb_bug21704.result,
	mysql-test/innodb_bug47621.result, mysql-test/innodb_bug47621.test:
vdimov's avatar
vdimov committed
42 43
	Fix Bug#47621 MySQL and InnoDB data dictionaries will become out of
	sync when renaming columns
44

45 46 47
2010-03-10	The InnoDB Team

	* handler/ha_innodb.cc:
vdimov's avatar
vdimov committed
48
	Fix Bug#51356 Many Valgrind errors in error messages
49 50 51 52 53 54
	with concurrent DDL

2010-03-10	The InnoDB Team

	* handler/ha_innodb.cc, handler/handler0alter.cc,
	mysql-test/innodb_bug51378.result, mysql-test/innodb_bug51378.test:
vdimov's avatar
vdimov committed
55
	Fix Bug#51378 Init 'ref_length' to correct value, in case an out
56 57
	of bound MySQL primary_key

58 59 60 61
2010-03-10	The InnoDB Team

	* log/log0recv.c:
	Remove a bogus assertion about page numbers exceeding 0x90000000
vdimov's avatar
vdimov committed
62
	in the redo log. Abort when encountering a corrupted redo log
63 64
	record, unless innodb_force_recovery is set.

65 66 67 68 69 70
2010-03-09	The InnoDB Team

	* handler/ha_innodb.cc:
	Make SHOW ENGINE INNODB MUTEX STATUS display SUM(os_waits)
	for the buffer pool block mutexes and locks.

71 72 73 74 75
2010-03-08	The InnoDB Team

	* fil/fil0fil.c:
	Fix ALTER TABLE ... IMPORT TABLESPACE of compressed tables.

marko's avatar
marko committed
76 77 78 79 80 81
2010-03-03	The InnoDB Team

	* handler/handler0alter.cc, innodb-index.result, innodb-index.test,
	innodb.result, innodb.test:
	Disallow a duplicate index name when creating an index.

inaam's avatar
inaam committed
82 83 84
2010-02-11	The InnoDB Team

	* include/mem0mem.h, include/mem0mem.ic, mem/mem0mem.c:
vdimov's avatar
vdimov committed
85
	Fix Bug#49535 Available memory check slows down crash
inaam's avatar
inaam committed
86 87
	recovery tens of times

88 89 90
2010-02-09	The InnoDB Team

	* buf/buf0buf.c:
vdimov's avatar
vdimov committed
91
	Fix Bug#38901 InnoDB logs error repeatedly when trying to load
92 93
	page into buffer pool

94 95 96 97 98 99
2010-02-09	The InnoDB Team

	* srv/srv0srv.c:
	Let the master thread sleep if the amount of work to be done is
	calibrated as taking less than a second.

100 101 102 103 104 105 106 107 108
2010-02-04	The InnoDB Team

	* btr/btr0btr.c, btr/btr0cur.c, btr/btr0pcur.c, buf/buf0buf.c,
	include/btr0btr.h, include/btr0cur.h, include/btr0pcur.h,
	include/btr0pcur.ic, include/buf0buf.h, row/row0ins.c, row/row0sel.c:
	Pass the file name and line number of the caller of the
	b-tree cursor functions to the buffer pool requests, in order
	to make the latch diagnostics more accurate.

109 110 111 112 113 114
2010-02-03	The InnoDB Team

	* lock/lock0lock.c:
	Fix Bug#49001 SHOW INNODB STATUS deadlock info incorrect
	when deadlock detection aborts

115 116 117 118 119 120
2010-02-03	The InnoDB Team

	* buf/buf0lru.c:
	Fix Bug#35077 Very slow DROP TABLE (ALTER TABLE, OPTIMIZE TABLE)
	on compressed tables

121 122 123 124 125
2010-02-03	The InnoDB Team

	* handler/ha_innodb.cc, include/row0mysql.h, row/row0mysql.c:
	Clean up CHECK TABLE error handling.

126 127 128 129 130 131 132 133 134
2010-02-01	The InnoDB Team

	* handler/ha_innodb.cc, mysql-test/innodb-autoinc.test,
	mysql-test/innodb-autoinc.result,
	mysql-test/innodb-autoinc-44030.test,
	mysql-test/innodb-autoinc-44030.result:
	Fix Bug#49497 Error 1467 (ER_AUTOINC_READ_FAILED) on inserting
	a negative value

135 136 137 138 139 140 141
2010-01-27	The InnoDB Team

	* include/row0mysql.h, log/log0recv.c, row/row0mysql.c:
	Drop temporary tables at startup.
	This addresses the third aspect of
	Bug#41609 Crash recovery does not work for InnoDB temporary tables.

142 143 144 145 146 147
2010-01-21	The InnoDB Team

	* buf/buf0buf.c:
	Do not merge buffered inserts to compressed pages before
	the redo log has been applied in crash recovery.

148 149 150 151
2010-01-13	The InnoDB Team

	* row/row0sel.c:
	On the READ UNCOMMITTED isolation level, do not attempt to access
vdimov's avatar
vdimov committed
152
	a clustered index record that has been marked for deletion. The
153 154 155
	built-in InnoDB in MySQL 5.1 and earlier would attempt to retrieve
	a previous version of the record in this case.

156 157 158 159 160 161 162
2010-01-13	The InnoDB Team

	* buf/buf0buf.c:
	When disabling the adaptive hash index, check the block state
	before checking block->is_hashed, because the latter may be
	uninitialized right after server startup.

163 164 165
2010-01-12	The InnoDB Team

	* handler/ha_innodb.cc, handler/ha_innodb.h:
vdimov's avatar
vdimov committed
166
	Fix Bug#46193 crash when accessing tables after enabling
167 168 169 170 171 172 173 174
	innodb_force_recovery option

2010-01-12	The InnoDB Team

	* row/row0mysql.c:
	Fix Bug#49238 Creating/Dropping a temporary table while at 1023
	transactions will cause assert.

175 176
2009-12-02	The InnoDB Team

177 178
	* srv/srv0start.c:
	Display the zlib version number at startup.
179 180
	InnoDB compressed tables use zlib, and the implementation depends
	on the zlib function compressBound(), whose definition was slightly
vdimov's avatar
vdimov committed
181
	changed in zlib version 1.2.3.1 in 2006. MySQL bundles zlib 1.2.3
182 183
	from 2005, but some installations use a more recent zlib.

184 185 186 187 188 189 190 191 192 193
2009-11-30	The InnoDB Team

	* dict/dict0crea.c, dict/dict0mem.c, dict/dict0load.c,
	dict/dict0boot.c, fil/fil0fil.c, handler/ha_innodb.cc,
	include/dict0mem.h, row/row0mysql.c:
	Fix the bogus warning messages for non-existing temporary
	tables that were reported in
	Bug#41609 Crash recovery does not work for InnoDB temporary tables.
	The actual crash recovery bug was corrected on 2009-04-29.

194 195 196 197
2009-11-27	The InnoDB Team

	InnoDB Plugin 1.0.6 released

vasil's avatar
vasil committed
198 199 200 201 202 203 204
2009-11-20	The InnoDB Team

	* handler/ha_innodb.cc:
	Add a workaround to prevent a crash due to Bug#45961 DDL on
	partitioned innodb tables leaves data dictionary in an inconsistent
	state

205 206 207 208 209 210 211 212 213 214 215 216
2009-11-19	The InnoDB Team

	* btr/btr0btr.c:
	Fix Bug#48469 when innodb tablespace is configured too small, crash
	and corruption!

2009-11-19	The InnoDB Team

	* data/data0type.c:
	Fix Bug#48526 Data type for float and double is incorrectly reported
	in InnoDB table monitor

vasil's avatar
vasil committed
217 218 219 220 221
2009-11-19	The InnoDB Team

	* CMakeLists.txt:
	Fix Bug#48317 cannot build innodb as static library

222 223 224 225 226 227
2009-11-18	The InnoDB Team

	* handler/handler0alter.cc:
	Fix Bug#48782 On lock wait timeout, CREATE INDEX (creating primary key)
	attempts DROP TABLE

vasil's avatar
vasil committed
228 229 230 231 232 233 234 235 236
2009-11-17	The InnoDB Team

	* handler/ha_innodb.cc, mysql-test/innodb.result,
	mysql-test/innodb.test, mysql-test/innodb_bug44369.result,
	mysql-test/innodb_bug44369.test, mysql-test/patches/innodb-index.diff,
	row/row0mysql.c:
	Report duplicate table names to the client connection, not to the
	error log.

237 238
2009-11-12	The InnoDB Team

vasil's avatar
vasil committed
239 240
	* handler/ha_innodb.cc, include/db0err.h, row/row0merge.c,
	row/row0mysql.c:
241 242 243
	Allow CREATE INDEX to be interrupted.
	Also, when CHECK TABLE is interrupted, report ER_QUERY_INTERRUPTED.

vasil's avatar
vasil committed
244 245 246 247 248 249 250
2009-11-11	The InnoDB Team

	* handler/ha_innodb.cc, mysql-test/innodb_bug47167.result,
	mysql-test/innodb_bug47167.test, mysql-test/innodb_file_format.result:
	Fix Bug#47167 "set global innodb_file_format_check" cannot set value
	by User-Defined Variable

vasil's avatar
vasil committed
251 252 253 254 255 256
2009-11-11	The InnoDB Team

	* include/os0file.h, os/os0file.c:
	Fix Bug#3139 Mysql crashes: 'windows error 995' after several selects
	on a large DB

257 258 259 260 261 262 263
2009-11-04	The InnoDB Team

	* handler/ha_innodb.cc:
	Fix Bug#32430 'show innodb status' causes errors
	Invalid (old?) table or database name in logs

2009-11-02	The InnoDB Team
264 265 266 267 268 269 270 271 272 273 274 275 276 277 278

	* btr/btr0sea.c, buf/buf0buf.c, dict/dict0dict.c, fil/fil0fil.c,
	ibuf/ibuf0ibuf.c, include/btr0sea.h, include/dict0dict.h,
	include/fil0fil.h, include/ibuf0ibuf.h, include/lock0lock.h,
	include/log0log.h, include/log0recv.h, include/mem0mem.h,
	include/mem0pool.h, include/os0file.h, include/pars0pars.h,
	include/srv0srv.h, include/thr0loc.h, include/trx0i_s.h,
	include/trx0purge.h, include/trx0rseg.h, include/trx0sys.h,
	include/trx0undo.h, include/usr0sess.h, lock/lock0lock.c,
	log/log0log.c, log/log0recv.c, mem/mem0dbg.c, mem/mem0pool.c,
	os/os0file.c, os/os0sync.c, os/os0thread.c, pars/lexyy.c,
	pars/pars0lex.l, que/que0que.c, srv/srv0srv.c, srv/srv0start.c,
	sync/sync0arr.c, sync/sync0sync.c, thr/thr0loc.c, trx/trx0i_s.c,
	trx/trx0purge.c, trx/trx0rseg.c, trx/trx0sys.c, trx/trx0undo.c,
	usr/usr0sess.c, ut/ut0mem.c:
vdimov's avatar
vdimov committed
279 280
	Fix Bug#45992 innodb memory not freed after shutdown
	Fix Bug#46656 InnoDB plugin: memory leaks (Valgrind)
281

282 283
2009-10-29	The InnoDB Team

vasil's avatar
vasil committed
284 285 286 287 288 289 290 291 292 293 294 295 296 297 298 299 300 301 302 303 304 305 306 307 308
	* handler/ha_innodb.cc, mysql-test/innodb-autoinc.result,
	mysql-test/innodb-autoinc.test:
	Fix Bug#47125 auto_increment start value is ignored if an index is
	created and engine=innodb

2009-10-29	The InnoDB Team

	* handler/ha_innodb.cc, mysql-test/innodb_bug47777.result,
	mysql-test/innodb_bug47777.test:
	Fix Bug#47777 innodb dies with spatial pk: Failing assertion: buf <=
	original_buf + buf_len

2009-10-29	The InnoDB Team

	* handler/ha_innodb.cc:
	Fix Bug#38996 Race condition in ANALYZE TABLE

2009-10-29	The InnoDB Team

	* handler/ha_innodb.cc:
	Fix bug#42383: Can't create table 'test.bug39438'

2009-10-29	The InnoDB Team

	* os/os0proc.c:
309 310
	Fix Bug#48237 Error handling in os_mem_alloc_large appears to
	be incorrect
vasil's avatar
vasil committed
311 312 313 314

2009-10-29	The InnoDB Team

	* buf/buf0buf.c, buf/buf0lru.c, include/buf0buf.h, include/buf0buf.ic:
315 316 317
	Fix corruption of the buf_pool->LRU_old list and improve debug
	assertions.

vasil's avatar
vasil committed
318 319 320 321 322 323
2009-10-28	The InnoDB Team

	* srv/srv0start.c:
	Fix Bug#41490 After enlargement of InnoDB page size, the error message
	become inaccurate

324 325 326 327 328 329 330
2009-10-26	The InnoDB Team

	* row/row0ins.c:
	When allocating a data tuple, zero out the system fields in order
	to avoid Valgrind warnings about uninitialized fields in
	dtuple_validate().

vasil's avatar
vasil committed
331 332 333 334 335 336 337
2009-10-22	The InnoDB Team

	* handler/ha_innodb.cc, mysql-test/innodb-zip.result,
	mysql-test/innodb-zip.test, mysql-test/innodb_bug44369.result,
	mysql-test/innodb_bug44369.test:
	Fix Bug#47233 Innodb calls push_warning(MYSQL_ERROR::WARN_LEVEL_ERROR)

vasil's avatar
vasil committed
338 339 340 341 342 343
2009-10-19	The InnoDB Team

	* mysql-test/innodb_information_schema.test:
	Fix Bug#47808 innodb_information_schema.test fails when run under
	valgrind

vasil's avatar
vasil committed
344 345 346 347 348 349
2009-10-15	The InnoDB Team

	* include/page0page.ic:
	Fix Bug#47058 Failure to compile innodb_plugin on solaris 10u7 + spro
	cc/CC 5.10

350 351 352 353 354 355
2009-10-13	The InnoDB Team

	* buf/buf0flu.c:
	Call fsync() on datafiles after a batch of pages is written to disk
	even when skip_innodb_doublewrite is set.

vasil's avatar
vasil committed
356 357 358 359 360 361 362 363 364 365 366 367
2009-10-05	The InnoDB Team

	* buf/buf0buf.c:
	Do not invalidate buffer pool while an LRU batch is active. Added code
	to buf_pool_invalidate() to wait for the running batches to finish.

2009-10-01	The InnoDB Team

	* handler/ha_innodb.cc:
	Fix Bug#47763 typo in error message: Failed to open table %s after %lu
	attemtps.

368 369 370
2009-10-01	The InnoDB Team

	* fsp/fsp0fsp.c, row/row0merge.c:
vasil's avatar
vasil committed
371
	Clean up after a crash during DROP INDEX. When InnoDB crashes
372
	while dropping an index, ensure that the index will be completely
vasil's avatar
vasil committed
373
	dropped during crash recovery. The MySQL .frm file may still
374 375 376
	contain the dropped index, but there is little that we can do
	about it.

377 378 379 380 381 382 383
2009-09-28	The InnoDB Team

	* handler/ha_innodb.cc:
	When a secondary index exists in the MySQL .frm file but not in
	the InnoDB data dictionary, return an error instead of letting an
	assertion fail in index_read.

384 385
2009-09-28	The InnoDB Team

vasil's avatar
vasil committed
386 387 388
	* btr/btr0btr.c, buf/buf0buf.c, include/page0page.h,
	include/page0zip.h, page/page0cur.c, page/page0page.c,
	page/page0zip.c:
389
	Do not write to PAGE_INDEX_ID when restoring an uncompressed page
vasil's avatar
vasil committed
390 391
	after a compression failure. The field should only be written
	when creating a B-tree page. This fix addresses a race condition
392 393
	in a debug assertion.

394 395 396 397
2009-09-28	The InnoDB Team

	* fil/fil0fil.c:
	Try to prevent the reuse of tablespace identifiers after InnoDB
vasil's avatar
vasil committed
398
	has crashed during table creation. Also, refuse to start if files
399 400
	with duplicate tablespace identifiers are encountered.

vasil's avatar
vasil committed
401 402 403 404 405 406
2009-09-25	The InnoDB Team

	* include/os0file.h, os/os0file.c:
	Fix Bug#47055 unconditional exit(1) on ERROR_WORKING_SET_QUOTA
	1453 (0x5AD) for InnoDB backend

vasil's avatar
vasil committed
407 408 409 410 411 412 413 414 415 416 417 418 419 420
2009-09-19	The InnoDB Team

	* handler/ha_innodb.cc, mysql-test/innodb-consistent-master.opt,
	mysql-test/innodb-consistent.result,
	mysql-test/innodb-consistent.test:
	Fix Bug#37232 Innodb might get too many read locks for DML with
	repeatable-read

2009-09-19	The InnoDB Team

	* fsp/fsp0fsp.c:
	Fix Bug#31183 Tablespace full problems not reported in error log,
	error message unclear

421 422 423
2009-09-17	The InnoDB Team

	* mysql-test/innodb-zip.result, mysql-test/innodb-zip.test:
vasil's avatar
vasil committed
424
	Make the test pass with zlib 1.2.3.3. Apparently, the definition
425 426
	of compressBound() has changed between zlib versions, and the
	maximum record size of a table with 1K compressed page size has
vasil's avatar
vasil committed
427 428 429
	been reduced by one byte. This is an arbitrary test. In practical
	applications, for good write performance, the compressed page size
	should be chosen to be bigger than the absolute minimum.
430

vasil's avatar
vasil committed
431 432 433 434 435 436 437 438 439 440 441 442 443 444 445 446 447 448 449
2009-09-16	The InnoDB Team

	* handler/ha_innodb.cc:
	Fix Bug#46256 drop table with unknown collation crashes innodb

2009-09-16	The InnoDB Team

	* dict/dict0dict.c, handler/ha_innodb.cc,
	mysql-test/innodb_bug44369.result, mysql-test/innodb_bug44369.test,
	row/row0mysql.c:
	Fix Bug#44369 InnoDB: Does not uniformly disallow disallowed column
	names

2009-09-16	The InnoDB Team

	* handler/ha_innodb.cc, include/db0err.h,
	mysql-test/innodb_bug46000.result, mysql-test/innodb_bug46000.test:
	Fix Bug#46000 using index called GEN_CLUST_INDEX crashes server

450 451 452 453 454 455
2009-09-02	The InnoDB Team

	* include/lock0lock.h, include/row0mysql.h, lock/lock0lock.c,
	row/row0mysql.c:
	Fix a regression introduced by the fix for MySQL bug#26316. We check
	whether a transaction holds any AUTOINC locks before we acquire
vasil's avatar
vasil committed
456
	the kernel mutex and release those locks.
457

458 459 460 461 462 463
2009-08-27	The InnoDB Team

	* dict/dict0dict.c, include/dict0dict.h,
	mysql-test/innodb_bug44571.result, mysql-test/innodb_bug44571.test:
	Fix Bug#44571 InnoDB Plugin crashes on ADD INDEX

464 465 466 467
2009-08-27	The InnoDB Team

	* row/row0merge.c:
	Fix a bug in the merge sort that can corrupt indexes in fast index
vasil's avatar
vasil committed
468
	creation. Add some consistency checks. Check that the number of
469 470
	records remains constant in every merge sort pass.

471 472
2009-08-27	The InnoDB Team

vasil's avatar
vasil committed
473 474 475
	* buf/buf0buf.c, buf/buf0lru.c, buf/buf0rea.c, handler/ha_innodb.cc,
	include/buf0buf.h, include/buf0buf.ic, include/buf0lru.h,
	include/ut0ut.h, ut/ut0ut.c:
476
	Make it possible to tune the buffer pool LRU eviction policy to be
vasil's avatar
vasil committed
477
	more resistant against index scans. Introduce the settable global
478
	variables innodb_old_blocks_pct and innodb_old_blocks_time for
vasil's avatar
vasil committed
479
	controlling the buffer pool eviction policy. The parameter
480
	innodb_old_blocks_pct (5..95) controls the desired amount of "old"
vasil's avatar
vasil committed
481 482
	blocks in the LRU list. The default is 37, corresponding to the
	old fixed ratio of 3/8. Each time a block is accessed, it will be
483 484
	moved to the "new" blocks if its first access was at least
	innodb_old_blocks_time milliseconds ago (default 0, meaning every
vasil's avatar
vasil committed
485
	block). The idea is that in index scans, blocks will be accessed
486
	a few times within innodb_old_blocks_time, and they will remain in
vasil's avatar
vasil committed
487 488 489 490
	the "old" section of the LRU list. Thus, when innodb_old_blocks_time
	is nonzero, blocks retrieved for one-time index scans will be more
	likely candidates for eviction than blocks that are accessed in
	random patterns.
491

492 493
2009-08-26	The InnoDB Team

494
	* handler/ha_innodb.cc, os/os0file.c:
495 496 497
	Fix Bug#42885 buf_read_ahead_random, buf_read_ahead_linear counters,
	thread wakeups

498 499 500
2009-08-20	The InnoDB Team

	* lock/lock0lock.c:
vasil's avatar
vasil committed
501 502
	Fix Bug#46650 Innodb assertion autoinc_lock == lock in
	lock_table_remove_low on INSERT SELECT
503

504 505 506 507
2009-08-13	The InnoDB Team

	* handler/handler0alter.cc:
	Fix Bug#46657 InnoDB plugin: invalid read in index_merge_innodb test
vasil's avatar
vasil committed
508
	(Valgrind)
509

vasil's avatar
vasil committed
510
2009-08-11	The InnoDB Team
vasil's avatar
vasil committed
511 512 513

	InnoDB Plugin 1.0.4 released

514 515
2009-07-20	The InnoDB Team

vasil's avatar
vasil committed
516 517
	* buf/buf0rea.c, handler/ha_innodb.cc, include/srv0srv.h,
	srv/srv0srv.c:
518 519 520 521 522
	Change the read ahead parameter name to innodb_read_ahead_threshold.
	Change the meaning of this parameter to signify the number of pages
	that must be sequentially accessed for InnoDB to trigger a readahead
	request.

vasil's avatar
vasil committed
523 524 525 526 527
2009-07-20	The InnoDB Team

	* handler/ha_innodb.cc:
	Fix Bug#39802 On Windows, 32-bit time_t should be enforced

528 529 530 531
2009-07-16	The InnoDB Team

	* include/univ.i:
	Support inlining of functions and prefetch with Sun Studio.
vasil's avatar
vasil committed
532 533
	These changes are based on contribution from Sun Microsystems Inc.
	under a BSD license.
534

vasil's avatar
vasil committed
535 536 537 538 539 540 541 542 543 544 545 546
2009-07-14	The InnoDB Team

	* fil/fil0fil.c:
	Fix Bug#45814 URL reference in InnoDB server errors needs adjusting to
	match documentation

2009-07-14	The InnoDB Team

	* handler/ha_innodb.cc, mysql-test/innodb_bug21704.result,
	mysql-test/innodb_bug21704.test:
	Fix Bug#21704 Renaming column does not update FK definition

vasil's avatar
vasil committed
547 548 549 550 551 552 553
2009-07-10	The InnoDB Team

	* handler/ha_innodb.cc, srv/srv0srv.c:
	Change the defaults for
	innodb_sync_spin_loops: 20 -> 30
	innodb_spin_wait_delay: 5 -> 6

554 555
2009-07-08	The InnoDB Team

vasil's avatar
vasil committed
556 557 558
	* buf/buf0flu.c, handler/ha_innodb.cc, include/buf0flu.h,
	include/log0log.h, include/log0log.ic, include/srv0srv.h,
	srv/srv0srv.c:
559 560 561 562 563 564 565 566
	Implement the adaptive flushing of dirty pages, which uses
	a heuristics based flushing rate of dirty pages to avoid IO
	bursts at checkpoint. Expose new configure knob
	innodb_adaptive_flushing to control whether the new flushing
	algorithm should be used.

2009-07-07	The InnoDB Team

vasil's avatar
vasil committed
567 568
	* handler/ha_innodb.cc, include/srv0srv.h, log/log0log.c,
	srv/srv0srv.c:
569 570 571 572 573 574
	Implement IO capacity tuning. Expose new configure knob
	innodb_io_capacity to control the master threads IO rate. The
	ibuf merge is also changed from synchronous to asynchronous.
	These changes are based on contribution from Google Inc.
	under a BSD license.

vasil's avatar
vasil committed
575 576 577 578 579 580
2009-07-02	The InnoDB Team

	* include/ut0ut.h, plug.in, ut/ut0ut.c:
	Use the PAUSE instruction inside the spinloop if it is available,
	Thanks to Mikael Ronstrom <mikael@mysql.com>.

581 582 583 584 585 586 587
2009-06-29	The InnoDB Team

	* handler/ha_innodb.cc, mysql-test/innodb_file_format.test,
	mysql-test/innodb_file_format.result:
	Do not crash on SET GLOBAL innodb_file_format=DEFAULT
	or SET GLOBAL innodb_file_format_check=DEFAULT.

588 589 590 591 592 593
2009-06-29	The InnoDB Team

	* buf/buf0buf.c, buf/buf0rea.c, lock/lock0lock.c:
	Tolerate missing tablespaces during crash recovery and when
	printing information on locks.

594 595 596 597 598 599 600
2009-06-29	The InnoDB Team

	* buf/buf0buf.c:
	Fix a race condition when reading buf_fix_count.
	Currently, it is not being protected by the buffer pool mutex,
	but by the block mutex.

601 602 603 604
2009-06-29	The InnoDB Team

	* handler/handler0alter.cc:
	Start the user transaction prebuilt->trx if it was not started
vasil's avatar
vasil committed
605
	before adding or dropping an index. Without this fix, the
606 607
	table could be locked outside an active transaction.

608 609
2009-06-25	The InnoDB Team

vasil's avatar
vasil committed
610
	* handler/ha_innodb.cc, mysql-test/innodb_bug42101.test,
611 612 613 614 615 616
	mysql-test/innodb_bug42101.result,
	mysql-test/innodb_bug42101-nonzero.test,
	mysql-test/innodb_bug42101-nonzero.result:
	Fix Bug#45749 Race condition in SET GLOBAL
	innodb_commit_concurrency=DEFAULT

617 618 619 620 621
2009-06-25	The InnoDB Team

	* dict/dict0dict.c:
	When an index column cannot be found in the table during index
	creation, display additional diagnostic before an assertion failure.
vdimov's avatar
vdimov committed
622
	This does NOT fix Bug#44571 InnoDB Plugin crashes on ADD INDEX,
623 624
	but it helps understand the reason of the crash.

625 626 627 628 629
2009-06-17	The InnoDB Team

	* row/row0merge.c:
	Fix Bug#45426 UNIV_DEBUG build cause assertion error at CREATE INDEX

vasil's avatar
vasil committed
630 631 632 633 634 635 636 637 638 639 640 641 642 643
2009-06-17	The InnoDB Team

	* mysql-test/innodb_bug45357.result, mysql-test/innodb_bug45357.test,
	row/row0mysql.c:
	Fix Bug#45357 5.1.35 crashes with Failing assertion: index->type &
	DICT_CLUSTERED

2009-06-17	The InnoDB Team

	* handler/ha_innodb.cc, mysql-test/innodb-autoinc.result,
	mysql-test/innodb-autoinc.test:
	Fix Bug#44030 Error: (1500) Couldn't read the MAX(ID) autoinc value
	from the index (PRIMARY)

vasil's avatar
vasil committed
644 645 646 647 648 649 650 651 652 653 654 655 656 657 658 659
2009-06-11	The InnoDB Team

	* handler/ha_innodb.cc, mysql-test/innodb.result, srv/srv0srv.c:
	Change the following defaults:
	max_dirty_pages_pct: from 90 to 75, max allowed from 100 to 99
	additional_mem_pool_size: from 1 to 8 MB
	buffer_pool_size: from 8 to 128 MB
	log_buffer_size: from 1 to 8 MB
	read_io_threads/write_io_threads: from 1 to 4

2009-06-09	The InnoDB Team

	* handler/ha_innodb.cc, include/trx0trx.h, trx/trx0trx.c:
	Enable Group Commit functionality that was broken in 5.0 when
	distributed transactions were introduced.

vasil's avatar
vasil committed
660 661 662 663 664 665 666 667 668
2009-06-05	The InnoDB Team

	* handler/ha_innodb.cc, include/os0file.h, include/srv0srv.h,
	os/os0file.c, srv/srv0srv.c, srv/srv0start.c:
	Enable functionality to have multiple background IO helper threads.
	Expose new configure knobs innodb_read_io_threads and
	innodb_write_io_threads and deprecate innodb_file_io_threads (this
	parameter was relevant only on windows). Internally this allows
	multiple segments for read and write IO request arrays where one
calvin's avatar
calvin committed
669
	thread works on one segment.
vasil's avatar
vasil committed
670

vasil's avatar
vasil committed
671 672 673 674 675 676 677 678
2009-06-05	The InnoDB Team

	* buf/buf0lru.c, buf/buf0rea.c, handler/ha_innodb.cc,
	include/srv0srv.h, srv/srv0srv.c:
	Fix a bug in linear read ahead:
	  1) Take into account access pattern when deciding whether or not to
	    do linear read ahead.
	  2) Expose a knob innodb_read_ahead_factor = [0-64] default (8),
calvin's avatar
calvin committed
679
	    dynamic, global to control linear read ahead behavior. This is the
vasil's avatar
vasil committed
680 681 682 683 684 685 686
	    value of the number of pages that InnoDB will tolerate within a
	    64 page extent even if they are accessed out of order or have
	    not been accessed at all. This number (which varies from 0 to 64)
	    is indicative of the slack that we have when deciding about linear
	    readahead.
	  3) Disable random read ahead. Keep the code for now.

687 688 689 690 691 692 693
2009-06-03	The InnoDB Team

	* dict/dict0dict.c, mysql-test/t/innodb_mysql.test,
	mysql-test/r/innodb_mysql.result:
	Fix Bug#39793 Foreign keys not constructed when column
	has a '#' in a comment or default value

marko's avatar
marko committed
694 695 696 697
2009-05-27	The InnoDB Team

	* Doxyfile:
	Allow the extraction of documentation from the code base with the
vasil's avatar
vasil committed
698
	Doxygen tool. Convert and add many (but not yet all) comments to
marko's avatar
marko committed
699 700
	Doxygen format.

701 702 703 704 705 706 707 708
2009-05-19	The InnoDB Team

	* btr/btr0btr.c, btr/btr0cur.c, lock/lock0lock.c,
	include/page0page.ic, include/lock0lock.h, include/dict0dict.h,
	include/page0page.h, include/dict0dict.ic, ibuf/ibuf0ibuf.c,
	page/page0zip.c, page/page0page.c:
	Write updates of PAGE_MAX_TRX_ID to the redo log and add debug
	assertions for checking that PAGE_MAX_TRX_ID is valid on leaf
vasil's avatar
vasil committed
709
	pages of secondary indexes and the insert buffer B-tree. This bug
710 711 712
	could cause failures in secondary index lookups in consistent
	reads right after crash recovery.

713 714 715 716 717 718
2009-05-18	The InnoDB Team

	* btr/btr0cur.c:
	Correctly estimate the space needed on the compressed page when
	performing an update by delete-and-insert.

vasil's avatar
vasil committed
719 720 721 722 723 724 725 726 727 728
2009-05-14	The InnoDB Team

	* handler/ha_innodb.cc, include/srv0srv.h,
	mysql-test/innodb_bug42101-nonzero-master.opt,
	mysql-test/innodb_bug42101-nonzero.result,
	mysql-test/innodb_bug42101-nonzero.test,
	mysql-test/innodb_bug42101.result, mysql-test/innodb_bug42101.test,
	srv/srv0srv.c:
	Fix Bug#42101 Race condition in innodb_commit_concurrency

vasil's avatar
vasil committed
729 730 731 732 733 734
2009-05-13	The InnoDB Team

	* dict/dict0dict.c:
	Fix Bug#44320 InnoDB: missing DB_ROLL_PTR in Table Monitor COLUMNS
	output

735 736 737 738 739 740
2009-04-29	The InnoDB Team

	* fil/fil0fil.c, include/fil0fil.h, include/mtr0mtr.h,
	log/log0recv.c:
	Fix Bug#41609 Crash recovery does not work for InnoDB temporary tables

741 742 743 744
2009-04-23	The InnoDB Team

	* row/row0mysql.c:
	When scanning indexes, report in the error log any error codes
vasil's avatar
vasil committed
745
	returned by the search function. These error codes will still be
746 747
	ignored in CHECK TABLE.

748 749
2009-04-23	The InnoDB Team

750
	* include/trx0types.h:
751 752 753
	Define the logical type names trx_id_t, roll_ptr_t, and undo_no_t
	and use them in place of dulint everywhere.

vasil's avatar
vasil committed
754 755 756 757 758
2009-04-18	The InnoDB Team

	* handler/ha_innodb.cc, include/pars0pars.h:
	Fix Bug#29125 Windows Server X64: so many compiler warnings

759 760
2009-04-16	The InnoDB Team

761
	* include/univ.i:
762 763 764
	Define REFMAN as the base URL of the MySQL Reference Manual and
	use the macro in all diagnostic output.

vasil's avatar
vasil committed
765 766 767 768 769 770 771 772
2009-04-16	The InnoDB Team

	* CMakeLists.txt, include/os0sync.h, include/sync0sync.h,
	include/sync0sync.ic, include/univ.i, srv/srv0start.c,
	sync/sync0sync.c:
	Use the Windows Interlocked functions for atomic memory
	access.

vasil's avatar
vasil committed
773 774 775 776 777 778 779 780 781 782 783 784 785 786 787 788
2009-04-15	The InnoDB Team

	* mysql-test/innodb.result, mysql-test/innodb.test:
	Fix Bug#43309 Test main.innodb can't be run twice

2009-04-14	The InnoDB Team

	* CMakeLists.txt, handler/win_delay_loader.cc,
	win-plugin/win-plugin.diff:
	Remove statically linked libraries from MySQL (zlib and strings).

2009-04-11	The InnoDB Team

	* CMakeLists.txt, win-plugin/README, win-plugin/win-plugin.diff:
	Rewrite CMakeLists.txt.

vasil's avatar
vasil committed
789 790 791 792 793 794 795 796
2009-04-07	The InnoDB Team

	* include/os0sync.h, include/sync0rw.ic, include/sync0sync.h,
	include/sync0sync.ic, include/univ.i, plug.in, srv/srv0srv.c,
	srv/srv0start.c, sync/sync0arr.c, sync/sync0sync.c:
	Enable atomics on Solaris (using the libc functions as defined in
	atomic.h) if GCC atomic builtins are not present.

797
2009-04-07	The InnoDB Team
vasil's avatar
vasil committed
798

799 800
	* btr/btr0btr.c, dict/dict0dict.c, ibuf/ibuf0ibuf.c,
	include/data0data.h, include/data0data.ic, include/data0type.h,
vasil's avatar
vasil committed
801 802
	include/data0type.ic, include/dict0dict.h, include/dict0dict.ic,
	include/rem0rec.ic, mysql-test/innodb.result, mysql-test/innodb.test,
803 804 805 806
	pars/pars0pars.c, rem/rem0rec.c, row/row0upd.c:
	Fix Bug#44032 In ROW_FORMAT=REDUNDANT, update UTF-8 CHAR
	to/from NULL is not in-place

vasil's avatar
vasil committed
807 808 809 810 811 812
2009-04-07	The InnoDB Team

	* page/page0cur.c:
	Fix Bug#43660 SHOW INDEXES/ANALYZE does NOT update cardinality for
	indexes of InnoDB table

813 814 815 816
2009-04-06	The InnoDB Team

	* handler/ha_innodb.cc:
	Make the parameter innodb_change_buffering settable by the
vasil's avatar
vasil committed
817
	configuration file or mysqld command line options. Before this
818 819
	fix, the initial value specified for this parameter was ignored.

820 821 822 823 824
2009-04-06	The InnoDB Team

	* sync/sync0rw.c:
	Avoid a bogus failure in UNIV_SYNC_DEBUG diagnostics.

vasil's avatar
vasil committed
825 826 827 828 829 830
2009-04-02	The InnoDB Team

	* handler/ha_innodb.cc, include/srv0srv.h, srv/srv0srv.c:
	Add new parameter innodb_spin_wait_delay to set the maximum delay
	between polling for a spin lock.

831 832 833
2009-04-02	The InnoDB Team

	* dict/dict0crea.c, handler/ha_innodb.cc, handler/ha_innodb.h,
vasil's avatar
vasil committed
834 835 836
	include/dict0mem.h, include/row0merge.h, include/row0mysql.h,
	mysql-test/innodb-index.result, mysql-test/innodb-index.test,
	row/row0merge.c, row/row0sel.c:
837 838 839
	In consistent reads, refuse to use newly created indexes that may
	lack history.

vasil's avatar
vasil committed
840 841 842 843 844 845 846 847
2009-03-25	The InnoDB Team

	* buf/buf0buf.c, handler/ha_innodb.cc, include/buf0buf.h:
	In SHOW ENGINE INNODB MUTEX do not show the status of block->mutex,
	block->lock, block->lock->mutex (if applicable) and all mutexes and
	rw-locks for which number of os-waits are zero because this can
	be overwhelming particularly when the buffer pool is very large.

848 849 850
2009-03-20	The InnoDB Team

	* buf/buf0buf.c, include/log0recv.h, log/log0recv.c:
851
	Remove the compile-time constant parameters of
852
	recv_recover_page(), recv_scan_log_recs(), and recv_sys_init().
853

854 855 856 857 858
2009-03-20	The InnoDB Team

	* data/data0type.c, handler/ha_innodb.cc, include/ha_prototypes.h:
	Declare innobase_get_at_most_n_mbchars() in ha_prototypes.h.

859 860 861 862 863
2009-03-20	The InnoDB Team

	* fil/fil0fil.h, fil/fil0fil.c, srv/srv0start.c:
	Add the parameter hash_size to fil_init().

864 865 866 867 868
2009-03-20	The InnoDB Team

	* fil/fil0fil.c:
	Refer to fil_system directly, not via local variables.

869 870 871 872 873 874
2009-03-20	The InnoDB Team

	* page/page0page.c:
	In page_validate(), always report the space id, page number and
	the name of the index when corruption is noticed.

875 876 877 878 879 880
2009-03-20	The InnoDB Team

	* include/log0log.h, include/log0log.ic, log/log0log.c:
	Add in/out comments or const qualifiers to some function
	parameters as appropriate.

881 882 883 884 885 886 887 888 889
2009-03-20	The InnoDB Team

	* dict/dict0boot.c, dict/dict0dict.c, fsp/fsp0fsp.c,
	include/dict0dict.h, include/srv0srv.h, srv/srv0srv.c,
	page/page0page.c:
	Replace srv_sys->dummy_ind1 and srv_sys->dummy_ind2 with
	dict_ind_redundant and dict_ind_compact, which are
	initialized by dict_init().

vasil's avatar
vasil committed
890
2009-03-11	The InnoDB Team
vasil's avatar
vasil committed
891 892 893

	InnoDB Plugin 1.0.3 released

vasil's avatar
vasil committed
894 895 896 897 898 899
2009-03-05	The InnoDB Team

	* handler/ha_innodb.cc, mysql-test/innodb-autoinc.result,
	mysql-test/innodb-autoinc.test:
	Fix Bug#43203 Overflow from auto incrementing causes server segv

vasil's avatar
vasil committed
900 901 902 903 904 905
2009-02-25	The InnoDB Team

	* handler/ha_innodb.cc, mysql-test/innodb-autoinc.result,
	mysql-test/innodb-autoinc.test:
	Fix Bug#42714 AUTO_INCREMENT errors in 5.1.31

906
2009-02-23	The InnoDB Team
vasil's avatar
vasil committed
907

908 909 910
	* btr/btr0cur.c:
	Fix Bug#43043 Crash on BLOB delete operation

911 912 913 914 915
2009-02-20	The InnoDB Team

	* handler/ha_innodb.cc:
	Make innodb_use_sys_malloc=ON the default.

vasil's avatar
vasil committed
916 917 918 919 920 921
2009-02-20	The InnoDB Team

	* handler/ha_innodb.cc, mysql-test/innodb-autoinc.result,
	mysql-test/innodb-autoinc.test:
	Fix Bug#42400 InnoDB autoinc code can't handle floating-point columns

922 923
2009-02-18	The InnoDB Team

vasil's avatar
vasil committed
924
	* include/ut0mem.h, os/os0proc.c, ut/ut0mem.c:
925
	Protect ut_total_allocated_memory with ut_list_mutex in
vasil's avatar
vasil committed
926 927 928 929 930
	os_mem_alloc_large() and os_mem_free_large(). The lack of this mutex
	protection could cause an assertion failure during fast index
	creation. Also, add UNIV_MEM_ALLOC and UNIV_MEM_FREE instrumentation
	to os_mem_alloc_large() and os_mem_free_large(), so that Valgrind can
	detect more errors.
931

932 933 934
2009-02-11	The InnoDB Team

	* handler/ha_innodb.cc:
vasil's avatar
vasil committed
935 936 937
	Make innodb_thread_concurrency=0 the default. The old default value
	was 8. A non-zero setting may be useful when InnoDB is showing severe
	scalability problems under multiple concurrent connections.
938

939 940
2009-02-10	The InnoDB Team

vasil's avatar
vasil committed
941
	* handler/ha_innodb.cc, handler/ha_innodb.h:
942 943
	Fix Bug#41676 Table names are case insensitive in locking

944 945
2009-02-10	The InnoDB Team

vasil's avatar
vasil committed
946
	* mem/mem0dbg.c, mem/mem0mem.c, mem/mem0pool.c:
947
	When innodb_use_sys_malloc is set, ignore
vasil's avatar
vasil committed
948 949
	innodb_additional_mem_pool_size, because nothing will be allocated
	from mem_comm_pool.
950

951 952 953
2009-02-10	The InnoDB Team

	* ut/ut0mem.c:
vasil's avatar
vasil committed
954 955 956 957 958
	Map ut_malloc_low(), ut_realloc(), and ut_free() directly to malloc(),
	realloc(), and free() when innodb_use_sys_malloc is set. As a side
	effect, ut_total_allocated_memory ("Total memory allocated" in the
	"BUFFER POOL AND MEMORY" section of SHOW ENGINE INNODB STATUS) will
	exclude any memory allocated by these functions when
959 960 961 962 963
	innodb_use_sys_malloc is set.

2009-02-10	The InnoDB Team

	* btr/btr0cur.c, btr/btr0sea.c, buf/buf0buf.c, handler/ha_innodb.cc,
vasil's avatar
vasil committed
964 965 966 967
	include/buf0buf.ic, include/os0sync.h, include/srv0srv.h,
	include/sync0rw.h, include/sync0rw.ic, include/sync0sync.h,
	include/sync0sync.ic, include/univ.i, row/row0sel.c, srv/srv0srv.c,
	srv/srv0start.c, sync/sync0arr.c, sync/sync0rw.c, sync/sync0sync.c:
968 969
	On those platforms that support it, implement the synchronization
	primitives of InnoDB mutexes and read/write locks with GCC atomic
vasil's avatar
vasil committed
970 971 972
	builtins instead of Pthreads mutexes and InnoDB mutexes. These changes
	are based on a patch supplied by Mark Callaghan of Google under a BSD
	license.
973

vasil's avatar
vasil committed
974 975 976 977 978 979
2009-01-30	The InnoDB Team

	* btr/btr0cur.c, btr/btr0sea.c, buf/buf0buf.c, handler/ha_innodb.cc,
	include/btr0sea.h, include/buf0buf.h, include/sync0sync.h,
	sync/sync0sync.c:
	Make the configuration parameter innodb_adaptive_hash_index dynamic,
980
	so that it can be changed at runtime.
vasil's avatar
vasil committed
981

982 983
2009-01-29	The InnoDB Team

vasil's avatar
vasil committed
984 985
	* handler/ha_innodb.cc, ibuf/ibuf0ibuf.c, include/ibuf0ibuf.h,
	include/ibuf0ibuf.ic:
986
	Implement the settable global variable innodb_change_buffering,
vasil's avatar
vasil committed
987
	with the allowed values 'none' and 'inserts'. The default value
988 989 990
	'inserts' enables the buffering of inserts to non-unique secondary
	index trees when the B-tree leaf page is not in the buffer pool.

991 992 993
2009-01-27	The InnoDB Team

	* buf/buf0lru.c:
vasil's avatar
vasil committed
994 995 996 997 998
	Fix a race condition in buf_LRU_invalidate_tablespace(): The
	compressed page size (zip_size) was read while the block descriptor
	was no longer protected by a mutex. This could lead to corruption
	when a table is dropped on a busy system that contains compressed
	tables.
999

1000 1001
2009-01-26	The InnoDB Team

vasil's avatar
vasil committed
1002 1003 1004 1005 1006 1007 1008
	* btr/btr0sea.c, buf/buf0buf.c, include/buf0buf.h, include/buf0buf.ic,
	include/mtr0log.ic, include/row0upd.ic, mtr/mtr0mtr.c:
	Implement buf_block_align() with pointer arithmetics, as it is in the
	built-in InnoDB distributed with MySQL. Do not acquire the buffer pool
	mutex before buf_block_align(). This removes a scalability bottleneck
	in the adaptive hash index lookup. In CHECK TABLE, check that
	buf_pool->page_hash is consistent with buf_block_align().
1009

1010 1011 1012 1013 1014
2009-01-23	The InnoDB Team

	* btr/btr0sea.c:
	Fix Bug#42279 Race condition in btr_search_drop_page_hash_when_freed()

1015 1016
2009-01-23	The InnoDB Team

vasil's avatar
vasil committed
1017
	* buf/buf0buf.c, include/buf0buf.h:
1018 1019
	Remove the unused mode BUF_GET_NOWAIT of buf_page_get_gen()

vasil's avatar
vasil committed
1020 1021 1022 1023 1024 1025 1026 1027 1028 1029
2009-01-20	The InnoDB Team

	* include/rem0rec.h, include/rem0rec.ic:
	Fix Bug#41571 MySQL segfaults after innodb recovery

2009-01-20	The InnoDB Team

	* lock/lock0lock.c:
	Fix Bug#42152 Race condition in lock_is_table_exclusive()

vasil's avatar
vasil committed
1030 1031 1032 1033 1034 1035 1036 1037 1038 1039 1040
2009-01-14	The InnoDB Team

	* include/trx0roll.h, trx/trx0roll.c, trx/trx0trx.c:
	Fix Bug#38187 Error 153 when creating savepoints

2009-01-14	The InnoDB Team

	* dict/dict0load.c:
	Fix Bug#42075 dict_load_indexes failure in dict_load_table will
	corrupt the dictionary cache

1041 1042
2009-01-13	The InnoDB Team

vasil's avatar
vasil committed
1043 1044 1045 1046
	* buf/buf0buddy.c, dict/dict0dict.c, dict/dict0mem.c, fil/fil0fil.c,
	ha/ha0storage.c, handler/ha_innodb.cc, handler/win_delay_loader.cc,
	include/buf0buf.ic, include/dict0dict.ic, include/hash0hash.h,
	thr/thr0loc.c, trx/trx0i_s.c:
1047 1048 1049 1050
	Add the parameter ASSERTION to HASH_SEARCH() macro, and use it for
	light validation of the traversed items in hash table lookups when
	UNIV_DEBUG is enabled.

1051 1052
2009-01-09	The InnoDB Team

vasil's avatar
vasil committed
1053
	* buf/buf0flu.c, include/buf0flu.h, include/buf0flu.ic:
1054 1055 1056 1057 1058 1059
	Remove unused code from the functions
	buf_flush_insert_into_flush_list() and
	buf_flush_insert_sorted_into_flush_list().

2009-01-09	The InnoDB Team

vasil's avatar
vasil committed
1060 1061 1062
	* buf/buf0flu.c:
	Simplify the functions buf_flush_try_page() and buf_flush_batch(). Add
	debug assertions and an explanation to buf_flush_write_block_low().
1063

vasil's avatar
vasil committed
1064 1065 1066
2009-01-07	The InnoDB Team

	* row/row0merge.c:
vasil's avatar
vasil committed
1067
	Fix a bug in recovery when dropping temporary indexes.
vasil's avatar
vasil committed
1068 1069 1070 1071 1072 1073 1074 1075 1076 1077 1078 1079

2009-01-07	The InnoDB Team

	* handler/ha_innodb.cc, handler/ha_innodb.h, handler/handler0alter.cc:
	Fix Bug#41680 calls to trx_allocate_for_mysql are not consistent

2009-01-07	The InnoDB Team

	* mysql-test/innodb_bug41904.result, mysql-test/innodb_bug41904.test,
	row/row0merge.c:
	Fix Bug#41904 create unique index problem

1080 1081
2009-01-02	The InnoDB Team

vasil's avatar
vasil committed
1082
	* handler/ha_innodb.cc, include/srv0srv.h, mem/mem0pool.c,
1083 1084
	mysql-test/innodb-use-sys-malloc-master.opt,
	mysql-test/innodb-use-sys-malloc.result,
vasil's avatar
vasil committed
1085 1086 1087 1088 1089 1090
	mysql-test/innodb-use-sys-malloc.test, srv/srv0srv.c, srv/srv0start.c:
	Implement the configuration parameter innodb_use_sys_malloc (false by
	default), for disabling InnoDB's internal memory allocator and using
	system malloc/free instead. The "BUFFER POOL AND MEMORY" section of
	SHOW ENGINE INNODB STATUS will report "in additional pool allocated
	allocated 0" when innodb_use_sys_malloc is set.
1091 1092 1093 1094

2008-12-30	The InnoDB Team

	* btr/btr0btr.c:
vasil's avatar
vasil committed
1095 1096 1097 1098 1099 1100
	When setting the PAGE_LEVEL of a compressed B-tree page from or to 0,
	compress the page at the same time. This is necessary, because the
	column information stored on the compressed page will differ between
	leaf and non-leaf pages. Leaf pages are identified by PAGE_LEVEL=0.
	This bug can make InnoDB crash when all rows of a compressed table are
	deleted.
1101

1102 1103
2008-12-17	The InnoDB Team

vasil's avatar
vasil committed
1104 1105 1106 1107 1108 1109
	* include/row0sel.h, include/row0upd.h, pars/pars0pars.c,
	row/row0mysql.c, row/row0sel.c, row/row0upd.c:
	Remove update-in-place select from the internal SQL interpreter. It
	was only used for updating the InnoDB internal data dictionary when
	renaming or dropping tables. It could have caused deadlocks when
	acquiring latches on insert buffer bitmap pages.
1110

1111 1112
2008-12-17	The InnoDB Team

vasil's avatar
vasil committed
1113 1114 1115 1116 1117
	* btr/btr0sea.c, buf/buf0buf.c, buf/buf0lru.c, ha/ha0ha.c,
	ha/hash0hash.c, include/buf0buf.h, include/ha0ha.h, include/ha0ha.ic,
	include/hash0hash.h, include/univ.i:
	Introduce the preprocessor symbol UNIV_AHI_DEBUG for enabling adaptive
	hash index debugging independently of UNIV_DEBUG.
1118

1119 1120 1121
2008-12-16	The InnoDB Team

	* btr/btr0cur.c:
vasil's avatar
vasil committed
1122 1123 1124
	Do not update the free bits in the insert buffer bitmap when inserting
	or deleting from the insert buffer B-tree. Assert that records in the
	insert buffer B-tree are never updated.
1125 1126 1127

2008-12-12	The InnoDB Team

vasil's avatar
vasil committed
1128 1129 1130
	* buf/buf0buf.c, fil/fil0fil.c, fsp/fsp0fsp.c, ibuf/ibuf0ibuf.c,
	include/fil0fil.h, include/ibuf0ibuf.h, include/ibuf0ibuf.ic,
	include/ibuf0types.h:
1131 1132 1133 1134 1135 1136 1137 1138 1139 1140
	Clean up the insert buffer subsystem so that only one insert
	buffer B-tree exists.
	Originally, there were provisions in InnoDB for multiple insert
	buffer B-trees, apparently one for each tablespace.
	When Heikki Tuuri implemented multiple InnoDB tablespaces in
	MySQL/InnoDB 4.1, he made the insert buffer live only in the
	system tablespace (space 0) but left the provisions in the code.

2008-12-11	The InnoDB Team

vasil's avatar
vasil committed
1141 1142 1143 1144
	* include/srv0srv.h, os/os0proc.c, srv/srv0srv.c:
	Fix the issue that the InnoDB plugin fails if innodb_buffer_pool_size
	is defined bigger than 4096M on 64-bit Windows. This bug should not
	have affected other 64-bit systems.
1145 1146 1147 1148 1149 1150 1151 1152 1153

2008-12-09	The InnoDB Team

	* handler/ha_innodb.cc:
	Fix Bug#40386 Not flushing query cache after truncate.

2008-12-09	The InnoDB Team

	* handler/ha_innodb.cc, srv/srv0srv.c, trx/trx0trx.c:
vasil's avatar
vasil committed
1154
	Fix Bug#40760 "set global innodb_thread_concurrency = 0;" is not safe
1155 1156 1157

2008-12-04	The InnoDB Team

vasil's avatar
vasil committed
1158 1159
	* handler/ha_innodb.cc, handler/mysql_addons.cc,
	include/mysql_addons.h, trx/trx0i_s.c, win-plugin/win-plugin.diff:
1160 1161 1162 1163 1164
	Remove dependencies to MySQL internals (defining MYSQL_SERVER).

2008-12-02	The InnoDB Team

	* page/page0cur.c:
vasil's avatar
vasil committed
1165 1166 1167 1168
	When allocating space for a record from the free list of previously
	purged records, zero out the DB_TRX_ID and DB_ROLL_PTR of the purged
	record if the new record would not overwrite these fields. This fixes
	a harmless content mismatch reported by page_zip_validate().
1169

vasil's avatar
vasil committed
1170 1171 1172
2008-12-02	The InnoDB Team

	* row/row0merge.c:
vasil's avatar
vasil committed
1173 1174 1175
	Replace the WHILE 1 with WHILE 1=1 in the SQL procedure, so that the
	loop will actually be entered and temporary indexes be dropped during
	crash recovery.
vasil's avatar
vasil committed
1176

vasil's avatar
vasil committed
1177 1178 1179 1180
2008-12-01	The InnoDB Team

	InnoDB Plugin 1.0.2 released

1181
2008-10-31	The InnoDB Team
vasil's avatar
vasil committed
1182 1183 1184 1185 1186

	* dict/dict0mem.c, include/dict0mem.h, include/lock0lock.h,
	include/row0mysql.h, include/trx0trx.h, include/univ.i,
	include/ut0vec.h, include/ut0vec.ic, lock/lock0lock.c,
	row/row0mysql.c, trx/trx0trx.c:
1187 1188 1189
	Fix Bug#26316 Triggers create duplicate entries on auto-increment
	columns

vasil's avatar
vasil committed
1190 1191 1192 1193 1194 1195 1196
2008-10-30	The InnoDB Team

	* handler/ha_innodb.cc, handler/handler0vars.h,
	handler/win_delay_loader.cc, mysql-test/innodb_bug40360.result,
	mysql-test/innodb_bug40360.test:
	Fix Bug#40360 Binlog related errors with binlog off

vasil's avatar
vasil committed
1197 1198 1199 1200 1201 1202 1203 1204 1205 1206
2008-10-29	The InnoDB Team

	* include/data0type.ic:
	Fix Bug#40369 dtype_get_sql_null_size() returns 0 or 1, not the size

2008-10-29	The InnoDB Team

	* handler/ha_innodb.cc, include/srv0srv.h, srv/srv0srv.c:
	Fix Bug#38189 innodb_stats_on_metadata missing

vasil's avatar
vasil committed
1207 1208 1209 1210 1211 1212 1213 1214 1215
2008-10-28	The InnoDB Team

	* CMakeLists.txt, ha_innodb.def, handler/ha_innodb.cc,
	handler/handler0alter.cc, handler/handler0vars.h, handler/i_s.cc,
	handler/win_delay_loader.cc, win-plugin/*:
	Implemented the delayloading of externals for the plugin on Windows.
	This makes it possible to build a dynamic plugin (ha_innodb.dll) on
	Windows.

vasil's avatar
vasil committed
1216 1217 1218 1219 1220 1221
2008-10-27	The InnoDB Team

	* CMakeLists.txt:
	Fix Bug#19424 InnoDB: Possibly a memory overrun of the buffer being
	freed (64-bit Visual C)

1222 1223 1224 1225 1226 1227
2008-10-23	The InnoDB Team

	* ibuf/ibuf0ibuf.c:
	ibuf_delete_rec(): When the cursor to the insert buffer record
	cannot be restored, do not complain if the tablespace does not
	exist, because the insert buffer record may have been discarded by
vasil's avatar
vasil committed
1228
	some other thread. This bug has existed in MySQL/InnoDB since
1229
	version 4.1, when innodb_file_per_table was implemented.
1230
	This may fix Bug#27276 InnoDB Error: ibuf cursor restoration fails.
1231

vasil's avatar
vasil committed
1232 1233 1234 1235 1236 1237 1238 1239 1240 1241 1242 1243 1244 1245 1246 1247 1248
2008-10-22	The InnoDB Team

	* dict/dict0dict.c, dict/dict0mem.c, handler/ha_innodb.cc,
	handler/ha_innodb.h, include/dict0dict.h, include/dict0mem.h,
	row/row0mysql.c:
	Fix Bug#39830 Table autoinc value not updated on first insert
	Fix Bug#35498 Cannot get table test/table1 auto-inccounter value in
	::info
	Fix Bug#36411 "Failed to read auto-increment value from storage
	engine" in 5.1.24 auto-inc

2008-10-22	The InnoDB Team

	* handler/ha_innodb.cc, include/row0mysql.h, row/row0mysql.c:
	Fix Bug#40224 New AUTOINC changes mask reporting of deadlock/timeout
	errors

1249 1250
2008-10-16	The InnoDB Team

vasil's avatar
vasil committed
1251 1252
	* dict/dict0dict.c, mysql-test/innodb-index.result,
	mysql-test/innodb-index.test:
1253
	Skip the undo log size check when creating REDUNDANT and COMPACT
vasil's avatar
vasil committed
1254
	tables. In ROW_FORMAT=DYNAMIC and ROW_FORMAT=COMPRESSED, column
1255 1256
	prefix indexes require that prefixes of externally stored columns
	be written to the undo log. This may make the undo log record
vasil's avatar
vasil committed
1257 1258 1259
	bigger than the record on the B-tree page. The maximum size of an
	undo log record is the page size. That must be checked for, in
	dict_index_add_to_cache(). However, this restriction must not
1260 1261 1262 1263
	be enforced on REDUNDANT or COMPACT tables.

2008-10-15	The InnoDB Team

vasil's avatar
vasil committed
1264 1265
	* btr/btr0cur.c, include/btr0cur.h, row/row0ext.c, row/row0sel.c,
	row/row0upd.c:
1266 1267
	When the server crashes while freeing an externally stored column
	of a compressed table, the BTR_EXTERN_LEN field in the BLOB
vasil's avatar
vasil committed
1268 1269
	pointer will be written as 0. Tolerate this in the functions that
	deal with externally stored columns. This fixes problems after
1270 1271 1272 1273 1274 1275 1276
	crash recovery, in the rollback of incomplete transactions, and in
	the purge of delete-marked records.

2008-10-15	The InnoDB Team

	* btr/btr0btr.c, include/page0zip.h, page/page0zip.c, include/univ.i:
	When a B-tree node of a compressed table is split or merged, the
vasil's avatar
vasil committed
1277 1278
	compression may fail. In this case, the entire compressed page
	will be copied and the excess records will be deleted. However,
1279 1280
	page_zip_copy(), now renamed to page_zip_copy_recs(), copied too
	many fields in the page header, overwriting PAGE_BTR_SEG_LEAF and
vasil's avatar
vasil committed
1281 1282
	PAGE_BTR_SEG_TOP when splitting the B-tree root. This caused
	corruption of compressed tables. Furthermore, the lock table and
1283 1284 1285 1286 1287 1288 1289 1290 1291 1292
	the adaptive hash index would be corrupted, because we forgot to
	update them when invoking page_zip_copy_recs().

	Introduce the symbol UNIV_ZIP_DEBUG for triggering the copying of
	compressed pages more often, for debugging purposes.

2008-10-10	The InnoDB Team

	* handler/handler0alter.cc, include/row0merge.h, row/row0merge.c,
	row/row0mysql.c:
vasil's avatar
vasil committed
1293
	Fix some locking issues, mainly in fast index creation. The
1294 1295
	InnoDB data dictionary cache should be latched whenever a
	transaction is holding locks on any data dictionary tables.
vasil's avatar
vasil committed
1296
	Otherwise, lock waits or deadlocks could occur. Furthermore, the
1297 1298 1299 1300 1301 1302 1303 1304 1305 1306
	data dictionary transaction must be committed (and the locks
	released) before the data dictionary latch is released.

	ha_innobase::add_index(): Lock the data dictionary before renaming
	or dropping the created indexes, because neither operation will
	commit the data dictionary transaction.

	ha_innobase::final_drop_index(): Commit the transactions before
	unlocking the data dictionary.

vasil's avatar
vasil committed
1307 1308 1309 1310 1311 1312
2008-10-09	The InnoDB Team

	* buf/buf0lru.c:
	Fix Bug#39939 DROP TABLE/DISCARD TABLESPACE takes long time in
	buf_LRU_invalidate_tablespace()

1313 1314 1315
2008-10-08	The InnoDB Team

	* dict/dict0crea.c, trx/trx0roll.c, include/row0mysql.h,
vasil's avatar
vasil committed
1316 1317 1318 1319 1320 1321 1322 1323
	row/row0merge.c, row/row0mysql.c:
	When dropping a table, hold the data dictionary latch until the
	transaction has been committed. The data dictionary latch is
	supposed to prevent lock waits and deadlocks in the data
	dictionary tables. Due to this bug, DROP TABLE could cause a
	deadlock or hang. Note that because of Bug#33650 and Bug#39833,
	MySQL may also drop a (temporary) table when executing CREATE INDEX
	or ALTER TABLE ... ADD INDEX.
1324

vasil's avatar
vasil committed
1325 1326 1327 1328 1329 1330 1331 1332 1333 1334 1335 1336 1337 1338 1339 1340 1341 1342 1343 1344 1345
2008-10-04	The InnoDB Team

	* handler/ha_innodb.cc, mysql-test/innodb_bug39438-master.opt,
	mysql-test/innodb_bug39438.result, mysql-test/innodb_bug39438.test:
	Fix Bug#39438 Testcase for Bug#39436 crashes on 5.1 in
	fil_space_get_latch

2008-10-04	The InnoDB Team

	* include/lock0lock.h, lock/lock0lock.c,
	mysql-test/innodb_bug38231.result, mysql-test/innodb_bug38231.test,
	row/row0mysql.c:
	Fix Bug#38231 Innodb crash in lock_reset_all_on_table() on TRUNCATE +
	LOCK / UNLOCK

2008-10-04	The InnoDB Team

	* handler/ha_innodb.cc:
	Fix Bug#35498 Cannot get table test/table1 auto-inccounter value in
	::info

vasil's avatar
vasil committed
1346 1347 1348 1349 1350 1351
2008-10-04	The InnoDB Team

	* handler/ha_innodb.cc, handler/ha_innodb.h:
	Fix Bug#37788 InnoDB Plugin: AUTO_INCREMENT wrong for compressed
	tables

vasil's avatar
vasil committed
1352 1353 1354 1355 1356 1357
2008-10-04	The InnoDB Team

	* dict/dict0dict.c, handler/ha_innodb.cc, handler/ha_innodb.h,
	include/dict0dict.h, include/dict0mem.h, row/row0mysql.c:
	Fix Bug#39830 Table autoinc value not updated on first insert

1358 1359 1360 1361
2008-10-03	The InnoDB Team

	* mysql-test/innodb-index.test, mysql-test/innodb-index.result,
	mysql-test/innodb-timeout.test, mysql-test/innodb-timeout.result,
vasil's avatar
vasil committed
1362 1363
	srv/srv0srv.c, include/srv0srv.h, handler/ha_innodb.cc,
	include/ha_prototypes.h:
vasil's avatar
vasil committed
1364
	Fix Bug#36285 innodb_lock_wait_timeout is not dynamic, not per session
1365

1366 1367 1368 1369 1370 1371 1372
2008-09-19	The InnoDB Team

	* os/os0proc.c:
	Fix a memory leak on Windows. The memory leak was due to wrong
	parameters passed into VirtualFree() call. As the result, the
	call fails with Windows error 87.

1373 1374 1375
2008-09-17	The InnoDB Team

	* mysql-test/innodb.result, mysql-test/innodb-zip.result,
vasil's avatar
vasil committed
1376 1377 1378 1379
	mysql-test/innodb-zip.test, mysql-test/innodb.test, ibuf/ibuf0ibuf.c,
	dict/dict0crea.c, dict/dict0load.c, dict/dict0boot.c,
	include/dict0dict.h, include/trx0trx.h, dict/dict0dict.c,
	trx/trx0trx.c, include/ha_prototypes.h, handler/ha_innodb.cc:
1380 1381 1382
	When creating an index in innodb_strict_mode, check that the
	maximum record size will never exceed the B-tree page size limit.
	For uncompressed tables, there should always be enough space for
vasil's avatar
vasil committed
1383
	two records in an empty B-tree page. For compressed tables, there
1384 1385 1386 1387 1388
	should be enough space for storing two node pointer records or one
	data record in an empty page in uncompressed format.
	The purpose of this check is to guarantee that INSERT or UPDATE
	will never fail due to too big record size.

1389 1390 1391
2008-09-17	The InnoDB Team

	* btr/btr0cur.c, data/data0data.c, include/page0zip.h,
vasil's avatar
vasil committed
1392
	include/page0zip.ic, page/page0zip.c, mysql-test/innodb_bug36172.test:
1393 1394
	Prevent infinite B-tree page splits in compressed tables by
	ensuring that there will always be enough space for two node
vasil's avatar
vasil committed
1395 1396
	pointer records in an empty B-tree page. Also, require that at
	least one data record will fit in an empty compressed page. This
1397 1398
	will reduce the maximum size of records in compressed tables.

vasil's avatar
vasil committed
1399 1400 1401 1402 1403 1404 1405 1406 1407 1408 1409 1410 1411 1412 1413 1414 1415 1416 1417 1418 1419 1420 1421 1422 1423 1424 1425 1426 1427 1428 1429 1430 1431 1432 1433 1434 1435 1436 1437 1438 1439 1440 1441 1442 1443 1444 1445 1446 1447 1448 1449 1450 1451 1452 1453 1454 1455 1456 1457 1458 1459 1460 1461 1462 1463 1464 1465 1466 1467 1468 1469 1470 1471 1472 1473 1474 1475 1476 1477 1478 1479 1480 1481 1482 1483 1484 1485 1486 1487 1488 1489 1490 1491 1492 1493 1494 1495 1496 1497 1498 1499 1500 1501 1502 1503 1504 1505 1506 1507 1508 1509 1510 1511 1512 1513 1514 1515 1516 1517 1518 1519 1520 1521 1522 1523 1524 1525 1526 1527 1528 1529 1530 1531 1532 1533 1534 1535 1536 1537 1538 1539 1540 1541 1542 1543 1544 1545 1546 1547 1548 1549 1550 1551 1552 1553 1554 1555 1556 1557 1558 1559 1560 1561
2008-09-09	The InnoDB Team

	* mysql-test/innodb.result:
	Fix the failing innodb test by merging changes that MySQL made to
	that file (r2646.12.1 in MySQL BZR repository)

2008-09-09	The InnoDB Team

	* handler/ha_innodb.cc, mysql-test/innodb-autoinc.result,
	mysql-test/innodb-autoinc.test:
	Fix Bug#38839 auto increment does not work properly with InnoDB after
	update

2008-09-09	The InnoDB Team

	* dict/dict0dict.c, handler/handler0alter.cc, include/dict0dict.h,
	mysql-test/innodb-index.result, mysql-test/innodb-index.test:
	Fix Bug#38786 InnoDB plugin crashes on drop table/create table with FK

2008-08-21	The InnoDB Team

	* handler/ha_innodb.cc, include/ha_prototypes.h, row/row0sel.c:
	Fix Bug#37885 row_search_for_mysql may gap lock unnecessarily with SQL
	comments in query

2008-08-21	The InnoDB Team

	* handler/ha_innodb.cc:
	Fix Bug#38185 ha_innobase::info can hold locks even when called with
	HA_STATUS_NO_LOCK

2008-08-18	The InnoDB Team

	* buf/buf0buf.c, buf/buf0lru.c, include/buf0buf.ic, include/univ.i:
	Introduce UNIV_LRU_DEBUG for debugging the LRU buffer pool cache

2008-08-08	The InnoDB Team

	* buf/buf0lru.c, include/buf0buf.h:
	Fix two recovery bugs that could lead to a crash in debug builds with
	small buffer size

2008-08-07	The InnoDB Team

	* btr/btr0cur.c, handler/ha_innodb.cc, include/srv0srv.h,
	srv/srv0srv.c:
	Add a parameter innodb_stats_sample_pages to allow users to control
	the number of index dives when InnoDB estimates the cardinality of
	an index (ANALYZE TABLE, SHOW TABLE STATUS etc)

2008-08-07	The InnoDB Team

	* trx/trx0i_s.c:
	Fix a bug that would lead to a crash if a SELECT was issued from the
	INFORMATION_SCHEMA tables and there are rolling back transactions at
	the same time

2008-08-06	The InnoDB Team

	* btr/btr0btr.c, btr/btr0cur.c, ibuf/ibuf0ibuf.c, include/btr0cur.h,
	include/trx0roll.h, include/trx0types.h, row/row0purge.c,
	row/row0uins.c, row/row0umod.c, trx/trx0roll.c:
	In the rollback of incomplete transactions after crash recovery,
	tolerate clustered index records whose externally stored columns
	have not been written.

2008-07-30	The InnoDB Team

	* trx/trx0trx.c:
	Fixes a race in recovery where the recovery thread recovering a
	PREPARED trx and the background rollback thread can both try
	to free the trx after its status is set to COMMITTED_IN_MEMORY.

2008-07-29	The InnoDB Team

	* include/trx0rec.h, row/row0purge.c, row/row0vers.c, trx/trx0rec.c:
	Fix a BLOB corruption bug

2008-07-15	The InnoDB Team

	* btr/btr0sea.c, dict/dict0dict.c, include/btr0sea.h:
	Fixed a timing hole where a thread dropping an index can free the
	in-memory index struct while another thread is still using that
	structure to remove entries from adaptive hash index belonging
	to one of the pages that belongs to the index being dropped.

2008-07-04	The InnoDB Team

	* mysql-test/innodb-index.result:
	Fix the failing innodb-index test by adjusting the result to a new
	MySQL behavior (the change occured in BZR-r2667)

2008-07-03	The InnoDB Team

	* mysql-test/innodb-zip.result, mysql-test/innodb-zip.test:
	Remove the negative test cases that produce warnings

2008-07-02	The InnoDB Team

	* mysql-test/innodb-replace.result, mysql-test/innodb-index.test:
	Disable part of innodb-index test because MySQL changed its behavior
	and is not calling ::add_index() anymore when adding primary index on
	non-NULL column

2008-07-01	The InnoDB Team

	* mysql-test/innodb-replace.result, mysql-test/innodb-replace.test:
	Fix the failing innodb-replace test by merging changes that MySQL
	made to that file (r2659 in MySQL BZR repository)

2008-07-01	The InnoDB Team

	* lock/lock0lock.c:
	Fix Bug#36942 Performance problem in lock_get_n_rec_locks (SHOW INNODB
	STATUS)

2008-07-01	The InnoDB Team

	* ha/ha0ha.c:
	Fix Bug#36941 Performance problem in ha_print_info (SHOW INNODB
	STATUS)

2008-07-01	The InnoDB Team

	* handler/ha_innodb.cc, mysql-test/innodb-autoinc.result,
	mysql-test/innodb-autoinc.test:
	Fix Bug#37531 After truncate, auto_increment behaves incorrectly for
	InnoDB

2008-06-19	The InnoDB Team

	* handler/ha_innodb.cc:
	Rewrite the function innodb_plugin_init() to support parameters in
	different order (in static and dynamic InnoDB) and to support more
	parameters in the static InnoDB

2008-06-19	The InnoDB Team

	* handler/handler0alter.cc:
	Fix a bug in ::add_index() which set the transaction state to "active"
	but never restored it to the original value. This bug caused warnings
	to be printed by the rpl.rpl_ddl mysql-test.

2008-06-19	The InnoDB Team

	* mysql-test/patches:
	Add a directory which contains patches, which need to be applied to
	MySQL source in order to get some mysql-tests to succeed. The patches
	cannot be committed in MySQL repository because they are specific to
	the InnoDB plugin.

2008-06-19	The InnoDB Team

	* mysql-test/innodb-zip.result, mysql-test/innodb-zip.test,
	row/row0row.c:
	Fix an anomaly when updating a record with BLOB prefix

2008-06-18	The InnoDB Team

	* include/trx0sys.h, srv/srv0start.c, trx/trx0sys.c:
	Fix a bug in recovery which was a side effect of the file_format_check
	changes

vasil's avatar
vasil committed
1562 1563 1564 1565 1566 1567
2008-06-09	The InnoDB Team

	* mysql-test/innodb.result:
	Fix the failing innodb test by merging changes that MySQL made to that
	file

vasil's avatar
vasil committed
1568 1569 1570 1571 1572 1573 1574 1575 1576 1577 1578 1579 1580 1581 1582 1583 1584 1585 1586 1587 1588
2008-06-06	The InnoDB Team

	* buf/buf0buf.c, handler/ha_innodb.cc, include/buf0buf.h,
	include/srv0srv.h, srv/srv0srv.c:
	Fix Bug#36600 SHOW STATUS takes a lot of CPU in
	buf_get_latched_pages_number

	* handler/ha_innodb.cc, os/os0file.c:
	Fix Bug#11894 innodb_file_per_table crashes w/ Windows .sym symbolic
	link hack

	* include/ut0ut.h, srv/srv0srv.c, ut/ut0ut.c:
	Fix Bug#36819 ut_usectime does not handle errors from gettimeofday

	* handler/ha_innodb.cc:
	Fix Bug#35602 Failed to read auto-increment value from storage engine

	* srv/srv0start.c:
	Fix Bug#36149 Read buffer overflow in srv0start.c found during "make
	test"

vasil's avatar
vasil committed
1589 1590 1591 1592 1593 1594 1595 1596 1597 1598
2008-05-08	The InnoDB Team

	* btr/btr0btr.c, mysql-test/innodb_bug36172.result,
	mysql-test/innodb_bug36172.test:
	Fix Bug#36172 insert into compressed innodb table crashes

2008-05-08	The InnoDB Team

	InnoDB Plugin 1.0.1 released

vasil's avatar
vasil committed
1599 1600 1601 1602 1603 1604 1605 1606 1607 1608 1609 1610 1611 1612 1613 1614 1615 1616
2008-05-06	The InnoDB Team

	* handler/ha_innodb.cc, include/srv0srv.h, include/sync0sync.h,
	include/trx0sys.h, mysql-test/innodb-zip.result,
	mysql-test/innodb-zip.test, srv/srv0srv.c, srv/srv0start.c,
	sync/sync0sync.c, trx/trx0sys.c:
	Implement the system tablespace tagging

	* handler/ha_innodb.cc, handler/i_s.cc, include/univ.i,
	srv/srv0start.c:
	Add InnoDB version in INFORMATION_SCHEMA.PLUGINS.PLUGIN_VERSION,
	in the startup message and in a server variable innodb_version.

	* sync/sync0sync.c:
	Fix a bug in the sync debug code where a lock with level
	SYNC_LEVEL_VARYING would cause an assertion failure when a thread
	tried to release it.

vasil's avatar
vasil committed
1617 1618
2008-04-30	The InnoDB Team

vasil's avatar
vasil committed
1619 1620 1621 1622 1623 1624 1625 1626 1627 1628 1629
	* Makefile.am:
	Fix Bug#36434 ha_innodb.so is installed in the wrong directory

	* handler/ha_innodb.cc:
	Merge change from MySQL (Fix Bug#35406 5.1-opt crashes on select from
	I_S.REFERENTIAL_CONSTRAINTS):
	ChangeSet@1.2563, 2008-03-18 19:42:04+04:00, gluh@mysql.com +1 -0

	* scripts/install_innodb_plugins.sql:
	Added

vasil's avatar
vasil committed
1630 1631 1632 1633 1634 1635 1636 1637 1638 1639 1640 1641 1642 1643 1644 1645 1646 1647 1648 1649 1650 1651
	* mysql-test/innodb.result:
	Merge change from MySQL (this fixes the failing innodb test):
	ChangeSet@1.1810.3601.4, 2008-02-07 02:33:21+04:00

	* row/row0sel.c:
	Fix Bug#35226 RBR event crashes slave

	* handler/ha_innodb.cc:
	Change the fix for Bug#32440 to show bytes instead of kilobytes in
	INFORMATION_SCHEMA.TABLES.DATA_FREE

	* handler/ha_innodb.cc, mysql-test/innodb.result,
	mysql-test/innodb.test:
	Fix Bug#29507 TRUNCATE shows to many rows effected

	* handler/ha_innodb.cc, mysql-test/innodb.result,
	mysql-test/innodb.test:
	Fix Bug#35537 Innodb doesn't increment handler_update and
	handler_delete

2008-04-29	The InnoDB Team

vasil's avatar
vasil committed
1652
	* handler/i_s.cc, include/srv0start.h, srv/srv0start.c:
vasil's avatar
vasil committed
1653 1654 1655 1656 1657 1658 1659 1660 1661
	Fix Bug#36310 InnoDB plugin crash

2008-04-23	The InnoDB Team

	* mysql-test/innodb_bug36169.result, mysql-test/innodb_bug36169.test,
	row/row0mysql.c:
	Fix Bug#36169 create innodb compressed table with too large row size
	crashed

vasil's avatar
vasil committed
1662 1663 1664 1665
	* (outside the source tree):
	Fix Bug#36222 New InnoDB plugin 1.0 has wrong MKDIR_P defined in
	Makefile.in

vasil's avatar
vasil committed
1666 1667 1668
2008-04-15	The InnoDB Team

	InnoDB Plugin 1.0.0 released