summaryrefslogtreecommitdiff
path: root/innobase
Commit message (Collapse)AuthorAgeFilesLines
* row0ins.c:heikki@hundin.mysql.fi2004-01-141-16/+0
| | | | Fix bug: FOREIGN KEY ... ON UPDATE/DELETE NO ACTION must check the foreign key constraint, not ignore it. Peter Gulutzan said that NO ACTION should check the constraint as deferred, at the end of the SQL statement, while RESTRICT should check it immediately. Since we do not have defered constraints in InnoDB, this bug fix makes InnoDB to check NO ACTION constraints immediately, like it checks RESTRICT constraints.
* buf0lru.c:heikki@hundin.mysql.fi2004-01-071-8/+12
| | | | Start InnoDB Monitor if 80 % of the buffer pool occupied by adaptive has or lock heaps; do not print the same warning more than 1 time
* trx0sys.c:heikki@hundin.mysql.fi2004-01-061-1/+1
| | | | DO NOT MERGE TO 4.1: forgot to change this in the previous push
* trx0sys.c:heikki@hundin.mysql.fi2004-01-061-1/+1
| | | | DO NOT MERGE TO 4.1: charset changes can cause problems in a downgrade 4.1.1 -> 4.0.18
* trx0sys.c, srv0start.c, ibuf0ibuf.c, trx0sys.h, srv0srv.h:heikki@hundin.mysql.fi2004-01-065-1/+140
| | | | DO NOT MERGE TO 4.1: add code for automatic downgrade 4.1.1 -> 4.0 if the user has not created multiple tablespaces yet
* log0log.c:heikki@hundin.mysql.fi2003-12-231-1/+12
| | | | Do not assert in log0log.c, line 856 if ib_logfiles are too small for innodb_thread_concurrency. Instead, print instructions how to adjust my.cnf and call exit(1).
* btr0cur.c, row0umod.c:heikki@hundin.mysql.fi2003-12-134-22/+109
| | | | | | | | Fix bug: if one updated a secondary index column so that its alphabetical value did not change (e.g., abc -> aBc) and rolled back the update, InnoDB failed to return the value in the secondary index to its original value row0upd.h: Correct typing error sync0sync.ic: Remove inadvertently pushed sync debug code
* row0upd.h, row0upd.c:heikki@hundin.mysql.fi2003-12-122-6/+4
| | | | Remove wrong debug assertion and comment
* Many files:heikki@hundin.mysql.fi2003-12-129-118/+181
| | | | Fix assertion failure on line 713 of row0upd.c if there is a column prefix index and the last characters in the prefix are spaces: do not assume that the length of alphabetically equal strings is the same; fix a buglet which could cause InnoDB to think that a secondary index record was not locked though it had been updated in a way which did not alpahabetically change its value, e.g., abc -> aBc
* row0sel.c:heikki@hundin.mysql.fi2003-10-281-2/+8
| | | | If innodb_force_recovery >= 5, do not try to fetch an old version of a clustered index record: this reduces crashes when dumping tables from a corrupt database
* os0file.c:heikki@hundin.mysql.fi2003-10-191-0/+4
| | | | Check that writes to data files always happen in to addresses divisible by 16 kB, and the chunk size is also divisible by 16 kB; a user reported 2 corrupt pages from Linux-2.4.20 where an index page seemed displaced
* os0file.c:heikki@hundin.mysql.fi2003-10-191-1/+5
| | | | Check that writes to data files always happen in to addresses divisible by 16 kB, and the chunk size is also divisible by 16 kB; a user reported 2 corrupt pages from Linux-2.4.20 where an index page seemed displaced
* thr0loc.c, srv0start.c, srv0srv.c, srv0srv.h, os0thread.h, ha_innodb.cc:heikki@hundin.mysql.fi2003-10-175-11/+39
| | | | Backport from 4.1: reduce InnoDB memory consumption if buf pool < 8 MB
* row0mysql.c:heikki@hundin.mysql.fi2003-10-061-6/+2
| | | | Remove unintentional changes in previous push
* row0mysql.c:heikki@hundin.mysql.fi2003-10-061-5/+27
| | | | Fix bug: if one used the rename trick of ibman section 15.1 to recover a temp table, InnoDB asserted because it tried to lock the data dictionary twice
* row0sel.c:heikki@hundin.mysql.fi2003-09-121-2/+3
| | | | Fix buglets in previous push
* row0sel.c:heikki@hundin.mysql.fi2003-09-121-16/+12
| | | | Fix bug: if a primary key contains more than one column, then MySQL seems to do fetch next even for a unique search condition: this in turn caused unnecessary locking which did not agree what the InnoDB manual promised
* Windows fix to avoid VC++ 6.0 compiler bug, which prevents compilation when ↵greg@mysql.com2003-09-041-2/+31
| | | | function calls are present inside an expanded inline function
* btr0btr.c:heikki@hundin.mysql.fi2003-08-282-2/+16
| | | | | | Fix bug: if the user created a prefix column key on a fixed length char column, then InnoDB claimed in CHECK TABLE that the table is corrupt dict0dict.c: Fix bug 1151: if the user created a prefix column primary key on a fixed length char column, then InnoDB crashed in a simple SELECT
* os0file.c:heikki@hundin.mysql.fi2003-08-241-6/+1
| | | | strerror() does not work in Windows
* log0log.c:heikki@hundin.mysql.fi2003-08-011-1/+1
| | | | Fix assertion failure reported by Alex Kiernan when we compile with the SUN Forte Developer 7 C 5.4 compiler
* dict0dict.c:heikki@hundin.mysql.fi2003-07-301-3/+6
| | | | Fix bug introduced in 4.0.13 and reported by Emic: if a CREATE TABLE ended in a comment, a memory overrun could happen
* srv0srv.c, os0file.c, log0recv.h, log0log.h, fil0fil.h, fsp0fsp.c, fil0fil.c:heikki@hundin.mysql.fi2003-07-2511-15/+253
| | | | | | | | | | Merge trx0trx.c: Print more info about a trx in SHOW INNODB status; try to find the bug reported by Plaxo buf0buf.c: Check that page log sequence numbers are not in the future log0recv.c, log0log.c: Fixed a bug: if you used big BLOBs, and your log files were relatively small, InnoDB could in a big BLOB operation temporarily write over the log produced AFTER the latest checkpoint. If InnoDB would crash at that moment, then the crash recovery would fail, because InnoDB would not be able to scan the log even up to the latest checkpoint. Starting from this version, InnoDB tries to ensure the latest checkpoint is young enough. If that is not possible, InnoDB prints a warning to the .err log
* btr0cur.c:heikki@hundin.mysql.fi2003-07-221-0/+4
| | | | Fix bug: if there was a 'record too long' error in an insert, InnoDB forgot to free reserved file space extents; they were only freed in mysqld restart
* btr0cur.c:heikki@hundin.mysql.fi2003-07-221-14/+14
| | | | Fix an error in the previous push
* btr0cur.c:heikki@hundin.mysql.fi2003-07-221-20/+22
| | | | Fix bug reported by Dyego Souza do Carmo: if a row becomes too long, > 8000 bytes, in an update, then InnoDB simply removes the clustered index record and does not report of table handler error 139
* srv0srv.c:heikki@hundin.mysql.fi2003-07-131-1/+24
| | | | Put back a 50 millisecond sleep in too high concurrency situations which I removed in the previous push; count also such sleeping threads to the InnoDB queue in SHOW INNODB STATUS
* srv0srv.c:heikki@hundin.mysql.fi2003-07-131-25/+20
| | | | Fix a benign bug introduced in 4.0.14: InnoDB could complain 'Error: trying to declare trx to enter InnoDB' if several threads tried to init the auto-inc counter for the same table at the same time; in theory, the bug could even lead to a hang of the server, but that shuld be extremely improbable
* srv0start.c, srv0srv.h, os0file.h, os0file.c:heikki@hundin.mysql.fi2003-07-134-32/+96
| | | | Allow also O_DIRECT as innodb_flush_method; it only affects writing to data files
* trx0trx.c:heikki@hundin.mysql.fi2003-07-081-0/+4
| | | | A cosmetic change: set trx id to zero at creation so that SHOW INNODB STATUS does not print a random value for the id of a transaction object for which the transaction has never been started yet (for example, running SHOW INNODB STATUS as the first command from a mysql prompt printed a random id for the trx object associated with the session itself running the SHOW INNODB STATUS command)
* row0mysql.c:heikki@hundin.mysql.fi2003-07-061-1/+2
| | | | Fix performance bug: if there were thousands of tables, DROP TABLE could take as much as a second CPU time
* srv0srv.c:heikki@hundin.mysql.fi2003-07-062-14/+26
| | | | | | In background loop run purge to completion before doing other background operations: it does not make sense to flush buffer pool pages if they are soon modified again by purge trx0purge.c: Increase purge_sys->n_pages_handled for every undo log we purge, even if that log would be only a hundred bytes: that way we get the purge batches of 20 pages to set a fresh purge view (limit) more often, and we can reduce the number of old row versions purge has to look at when it decides if it can remove some delete-marked index record
* Many files:heikki@hundin.mysql.fi2003-07-038-17/+92
| | | | | | Remove potential starvation of a full log buffer flush: only flush up to the lsn which was the largest at the time when we requested the full log buffer flush os0sync.h, os0sync.c: Fix a bug in os_event on Unix: even though we signaled the event, some threads could continue waiting if the event became nonsignaled quickly again; this made group commit less efficient than it should be
* trx0trx.c:heikki@hundin.mysql.fi2003-07-031-31/+67
| | | | Fix bug: group commit still did not work when we had MySQL binlogging on
* lock0lock.c:heikki@hundin.mysql.fi2003-07-031-10/+0
| | | | Remove outdated comment and the corresponding assertion in debug version code
* sync0sync.c:heikki@hundin.mysql.fi2003-07-021-1/+1
| | | | Make execution with UNIV_SYNC_DEBUG faster
* lock0lock.c:heikki@hundin.mysql.fi2003-07-021-19/+8
| | | | Fix a latching order violation in the previous (2003-06-15) push: could lead to a hang on the btr0sea.c semaphore
* dict0dict.h, dict0dict.c, ha_innodb.cc:heikki@hundin.mysql.fi2003-06-222-0/+50
| | | | In ORDER BY MySQL seems to set the key read flag also in the case where the primary key contains only a prefix of a column - not the whole column; to prevent potential bugs retrieve the whole column if the index contains a prefix of it
* page0page.c:heikki@hundin.mysql.fi2003-06-191-5/+16
| | | | Track an assertion failure reported on the mailing list June 18th, 2003
* row0vers.c:heikki@hundin.mysql.fi2003-06-181-0/+1
| | | | Add forgotten mutex_enter()
* row0vers.c:heikki@hundin.mysql.fi2003-06-181-0/+2
| | | | Add forgotten mtr_commit()
* row0sel.c, row0ins.c:heikki@hundin.mysql.fi2003-06-182-6/+16
| | | | Fix error in previous push
* row0vers.c, row0sel.c, row0ins.c:heikki@hundin.mysql.fi2003-06-183-54/+88
| | | | Fix bug: InnoDB could print that it cannot find a clustered index record if an update undo, purge, and a consistent read coincided, in rare cases it might also have returned a wrong row in a query
* row0mysql.c, dict0dict.ic:heikki@hundin.mysql.fi2003-06-163-4/+12
| | | | | | Cleanup ha_innodb.cc, data0type.h: Make sure non-latin1 users can downgrade from 4.0.14 to an earlier version if they have not created DATA_BLOB column prefix indexes
* Many files:heikki@hundin.mysql.fi2003-06-1565-662/+1824
| | | | Merge InnoDB-4.0.14: SAVEPOINT now implemented; InnoDB now accepts also column prefix keys; crashing bug in ON UPDATE CASCADE fixed; page checksum formula fixed
* Merge bk-internal.mysql.com:/home/bk/mysql-4.0monty@narttu.mysql.fi2003-06-041-0/+4
|\ | | | | | | into narttu.mysql.fi:/my/mysql-4.0
| * Added [mysqld-base-version] as a default group for the mysqld servermonty@narttu.mysql.fi2003-06-041-0/+4
| | | | | | | | Portability fix for Windows 64
* | os0sync.c:heikki@hundin.mysql.fi2003-06-021-4/+21
| | | | | | | | Do not try to reserve os_sync_mutex in shutdown after it has been freed
* | com0shm.c:heikki@hundin.mysql.fi2003-06-021-3/+6
| | | | | | | | Removed auto event creation because it is not needed in any MySQL/InnoDB code
* | os0file.c:heikki@hundin.mysql.fi2003-06-021-18/+24
| | | | | | | | Put back Monty's patch which the previous push accidentally erased: print also operation type in os_file_handle_error()
View Lorry Controller Status