| Commit message (Collapse) | Author | Age | Files | Lines |
|\ |
|
| |\
| | |
| | |
| | | |
into hundin.mysql.fi:/home/marko/mysql-4.1
|
| | | |
|
| | |
| | |
| | |
| | |
| | |
| | | |
innobase_shutdown_for_mysql(): Do very fast shutdown
only if srv_fast_shutdown==2, not if srv_fast_shutdown!=0
(Bug #9673)
|
| | |
| | |
| | |
| | | |
after recovery.
|
|\ \ \
| |/ / |
|
| | |
| | |
| | |
| | | |
InnoDB wrongly complained in the .err log that MySQL is trying to drop a non-existent table, if tablespace ran out (Bug #10607)
|
| | | |
|
|\ \ \
| |/ / |
|
| |\ \
| | | |
| | | |
| | | | |
into hundin.mysql.fi:/home/marko/mysql-4.1
|
| | | |
| | | |
| | | |
| | | | |
of active transactions, if necessary and possible. (Bug #5436)
|
|\ \ \ \
| |/ / /
| | | |
| | | | |
into hundin.mysql.fi:/home/heikki/mysql-5.0
|
| |/ /
| | |
| | |
| | | |
Fix a problem in crash recovery of .ibd files on Windows if the user used lower_case_table_names=0 or 2; the directory scan in crash recovery forgot to put all paths to lower case, so that the tablespace name would be consistent with the internal data dictionary of InnoDB; remember that InnoDB puts internally all database names and table names to lower case on Windows, regardless of the value of lower_case_table_names
|
| | |
| | |
| | |
| | | |
Backported from 5.0.3.
|
| | |
| | |
| | |
| | |
| | |
| | |
| | |
| | |
| | | |
default "1":
most InnoDB threads are not terminated properly and the buffer pool is not flushed
to disk. Still no committed transaction is lost as we flush the logs to disk.
InnoDB does crash recovery at startup after this shutdown.
Using this shutdown in testsuite (mysql-test-run --mysqld=--innodb_fast_shutdown=2) saved 3 minutes (13% of total time).
|
|\ \ \
| |/ /
| | |
| | | |
into hundin.mysql.fi:/home/heikki/mysql-5.0
|
| | |
| | |
| | |
| | | |
Add fault tolerance in the scan of .ibd files at a crash recovery; formerly a single failure of readdir_get_next caused the rest of the directory to be skipped
|
|\ \ \
| |/ / |
|
| | |
| | |
| | |
| | | |
At the shutdown, write the latest lsn only to the first pages of the ibdata files of the system tablespace, NOT to the .ibd files; writing to tens of thousands .ibd files can take minutes
|
| | |
| | |
| | |
| | | |
Do not test the value of err if the lock operation was skipped because innodb_logs_unsafe_for_binlog was TRUE; though this did not cause any bugs visible to the user, because err is inited to DB_SUCCESS at the start of the function row_search_for_mysql()
|
|\ \ \
| | | |
| | | |
| | | | |
into mysql.com:/usr/local/home/marty/MySQL/mysql-5.0
|
| |\ \ \
| | |/ / |
|
| | | |
| | | |
| | | |
| | | | |
if foreign_key_checks=0. (Bug #9802)
|
| | | |
| | | |
| | | |
| | | | |
Fix the patch of Jan to optimize next-key locking in searches of type 'primary key >= some value'
|
|/ / /
| | |
| | |
| | | |
not produce phantom (bug #9354).
|
|\ \ \
| |/ /
| | |
| | |
| | |
| | | |
Gluh's SESSION/GLOBAL for @variables fix in sql_yacc.yy and
Bar's well_formed_len() changes in ndb code
did not make it and should be re-applied manually
|
| | |
| | |
| | |
| | |
| | |
| | |
| | |
| | | |
between two server instances at server shutdown/startup.
This conflict on advisory locks appears to be the result of a bug
in the operating system; these locks should be released when the
files are closed, but somehow that does not always happen
immediately in Linux. (Bug #9381)
|
| | |
| | |
| | |
| | | |
Add diagnostic code to track assertion failure in ut_a(cursor->old_stored == BTR_PCUR_OLD_STORED); the failure happened in OPTIMIZE TABLE, and in 4.0.24 in some other context
|
|\ \ \
| |/ / |
|
| | |
| | |
| | |
| | | |
Add a note that ENUM in new tables cannot reference ENUM in old tables, in FOREIGN KEY constraints
|
| | | |
|
| | |
| | |
| | |
| | | |
Fix Bug #9526 in 5.0: MySQL ENUM and SET columns are internally actually unsigned integer types; we must take care that old tables still treat ENUM and SET (incorrectly) as a character string, while new created tables treat it correctly as an unsigned integer
|
|\ \ \
| | | |
| | | |
| | | | |
into serg.mylan:/usr/home/serg/Abk/mysql-5.0
|
| |\ \ \
| | |/ /
| | | |
| | | | |
into hundin.mysql.fi:/home/heikki/mysql-5.0
|
| | | |
| | | |
| | | |
| | | | |
If MySQL wrote to its binlog, but for some reason trx->update_undo and trx->insert_undo were NULL in InnoDB, then trx->commit_lsn was garbage, and InnoDB could assert in the log flush of trx_commit_complete_for_mysql() (Bug #9277)
|
| | |\ \
| | | |/ |
|
| | | |
| | | |
| | | |
| | | | |
If MySQL wrote to its binlog, but for some reason trx->update_undo and trx->insert_undo were NULL in InnoDB, then trx->commit_lsn was garbage, and InnoDB could assert in the log flush of trx_commit_complete_for_mysql() (Bug #9277)
|
|\ \ \ \
| |/ / /
|/| | |
| | | | |
into serg.mylan:/usr/home/serg/Abk/mysql-5.0
|
| |\ \ \ |
|
| | |\ \ \ |
|
| | | | | |
| | | | | |
| | | | | |
| | | | | |
| | | | | | |
protect prepare-...-commit with a mutex to ensure that commits in binlog and in the innodb have the same order
store binlog position with the commit
|
| | | | | |
| | | | | |
| | | | | |
| | | | | | |
The missing DATA_BINARY_TYPE in BLOBs created with < 4.0.14 does not cause any harm, because there were no indexes on such BLOBs
|
| | | | | |
| | | | | |
| | | | | |
| | | | | | |
Change the sorting order of TEXT columns in InnoDB: pad with spaces at the end in comparisons; we MUST UPDATE the MySQL MANUAL to warn about the need to rebuild tables (also MyISAM) in certain cases in an upgrade to 5.0.3; TODO: study what complications the missing DATA_BINARY_TYPE flag in InnoDB < 4.0.14 causes: we would compare then also BLOBs with space padding, not just TEXT
|
| | | | | |
| | | | | |
| | | | | |
| | | | | | |
Revert the change to the space padding of BLOB and TEXT in comparisons; we cannot change the sorting order, because that would make old tables to appear corrupt; better to change LIKE 'a%' processing in MySQL, so that the lower end of the search interval would be 'a', not 'a '
|
|/ / / / /
| | | | |
| | | | |
| | | | | |
Fix that 'a' LIKE 'a%' was not true for an InnoDB BLOB or TEXT type column prefix index search: InnoDB assumed that the BLOB and TEXT should not be padded with space in comparisons; this bug is also in 4.1; it may have worked in 4.1 because MySQL may have asked there for strings >= 'a', while in 5.0 it asks for strings >= 'a '
|
|/ / / /
| | | |
| | | |
| | | | |
Allow also long VARCHARs to be stored externally, not just BLOBs; fixes a bug reported by Trudy Pelzer; needs more testing
|
| | | |
| | | |
| | | |
| | | |
| | | |
| | | |
| | | |
| | | | |
Fix a crash in a simple search with a key: the dtype->len of a true VARCHAR is the payload maximum len in bytes: it does not include the 2 bytes MySQL uses to store the string length
ha_innodb.cc:
Fix a crash in true VARCHARs in test-innodb: we passed a wrong pointer to the column conversion in an UPDATE
rowid_order_innodb.result, ps_3innodb.result, innodb.result, endspace.result:
Edit InnoDB test results to reflect the arrival of true VARCHARs
|
| | | |
| | | |
| | | |
| | | |
| | | | |
DATA_VARMYSQL so remove unnecessary condition.
|
| | | | |
|
|/ / /
| | |
| | |
| | | |
InnoDB true VARCHAR
|