lp:~mdcallag/maria/mysql-5.6-leveldb

Branch merges

Propose for merging

No branches dependent on this one.

Related source package recipes

No recipes using this branch. (?)

Create packaging recipe

Related snap packages

Related bugs

Related blueprints

4874. By Mark Callaghan on 2014-07-09

fake support for UNIQUE indexes. They can be created for RocksDB but won't be enforced.

4873. By Mark Callaghan on 2014-07-03

Port to RocksDB. Let LevelDB engine be optional.

4872. By Sergey Petrunia on 2013-05-16

MDEV-4201: LevelDB Storage Engine MS2
- Add @@leveldb_max_row_locks variable, limit # of locks a transaction may hold

4871. By Sergey Petrunia on 2013-05-16

Use my_malloc, not malloc (we use my_free)

4870. By Sergey Petrunia on 2013-05-15

Better comments

4869. By Sergey Petrunia on 2013-05-04

Merge LevelDB SE with mysql-5.6.11

4868. By Marko Mäkelä <email address hidden> on 2013-04-05

Merge from mysql-5.6 to the 5.6.11 release clone.
------------------------------------------------------------
revno: 5006
revision-id: <email address hidden>
parent: <email address hidden>
committer: Marko Mäkelä <email address hidden>
branch nick: mysql-5.6
timestamp: Wed 2013-04-03 15:47:30 +0300
message:
  Fix regression Bug#16544143 ENABLE PARTIAL ROLLBACK DURING ONLINE ALTER TABLE

  row_log_allocate(): Initialize the added fields.

4867. By Marko Mäkelä <email address hidden> on 2013-04-05

Merge from mysql-5.6 to the 5.6.11 release clone.
------------------------------------------------------------
revno: 5004
revision-id: <email address hidden>
parent: <email address hidden>
committer: Marko Mäkelä <email address hidden>
branch nick: mysql-5.6
timestamp: Wed 2013-04-03 10:26:04 +0300
message:
  Bug#16544143 ENABLE PARTIAL ROLLBACK DURING ONLINE ALTER TABLE

  During table-copying online ALTER TABLE (such as ADD COLUMN, DROP
  COLUMN, ADD PRIMARY KEY, changing the ROW_FORMAT), we keep a log of
  concurrent INSERT and DELETE operations that modify the table data.
  Off-page columns (BLOBs) are not logged; instead, we just log the
  pointers as they are in the clustered index records.

  In order to avoid accessing stale BLOB pointers when applying the log,
  we used to suspend the purge of records that would free BLOBs, and keep
  track of user transactions that were rolled back.

  The bug is that a partial rollback is wrongly treated as a full
  rollback. That is, the remaining changes of a partially rolled back
  transaction (one that involved a statement rollback, or an explicit
  ROLLBACK TO SAVEPOINT) could be lost (rolled back) during the online
  ALTER TABLE.

  row_log_table_rollback(), row_log_t::trx_rb: Remove. We no longer keep
  track of transactions. We keep track of BLOB start pages instead.

  row_log_table_is_rollback(): Remove. The call in
  row_merge_insert_index_tuples() was made redundant in the fix of
  Bug#14712710 BOGUS DUPLICATE KEY ERROR DURING ONLINE ALTER TABLE
  (rb#1438) when row_merge_read_clustered_index() started to use
  REPEATABLE READ instead of READ UNCOMMITTED.

  row_log_t::blobs: A new member, a map from BLOB page numbers to byte
  offsets in the log. This keeps track of BLOBs freed and allocated during
  ALTER TABLE. If a previously freed BLOB page is allocated, the log apply
  must trust the BLOB page number starting from the log record of the new
  allocation.

  Example: A transaction inserted a BLOB starting at page 123. There was
  a partial rollback that undoes the insert, but the transaction remains
  active. So, we will insert (123,BLOB_FREED) to log->blobs.
  Later, another BLOB will be inserted at page 123, when log->tail.total=4567.
  We will replace the (123,BLOB_FREED) with (123,4567) in the log->blobs.
  The log record for inserting this BLOB would start at offset 4567.

  row_log_table_blob_free(), row_log_table_blob_alloc(): New functions,
  for updating row_log_t::blobs.

  row_log_table_close_func(), row_log_table_apply_op():
  Update the new field row_log_buf_t::total.

  row_log_table_delete(): Add the parameter 'bool purge', to specify
  whether to log BLOB prefixes for updating secondary indexes.
  The flag will be set during a partial or full rollback.

  row_log_table_apply_convert_mrec(): Before accessing any BLOB data,
  check row_log_t::blobs if it is safe to do so.

  row_purge_remove_clust_if_poss_low(), row_purge_remove_clust_if_poss(),
  row_purge_del_mark(), row_purge_upd_exist_or_extern(): Do not suspend
  the purge if it would free BLOBs during online ALTER TABLE. Rely on
  the row_log_t::blobs.

  rec_print_comp(): Display the BLOB pointer when truncating a column.

  rb#2203 approved by Jimmy Yang

4866. By Marko Mäkelä <email address hidden> on 2013-04-05

Merge from mysql-5.6 to the 5.6.11 release clone.
------------------------------------------------------------
revno: 5003
revision-id: <email address hidden>
parent: <email address hidden>
committer: Marko Mäkelä <email address hidden>
branch nick: mysql-5.6
timestamp: Wed 2013-04-03 10:18:33 +0300
message:
  Bug#16586355 CORRUPTION IN ONLINE ALTER TABLE...ADD PRIMARY KEY(A,B),
  CHANGE A ... AFTER B

  row_log_table_get_pk() assigned the column mapping to the wrong variable.
  Refactor it to make the logic easier to follow.

  row_log_table_get_pk_old_col(): Get the old table column corresponding
  to a new table column. Returns NULL if the column was added to the
  new table.

  row_log_table_get_pk_col(): Retrieve the column value from the old
  table record (and optionally BLOB pages).

  rb#2274 approved by Jimmy Yang

4865. By Marko Mäkelä <email address hidden> on 2013-03-26

Bug#16544336 INCONSISTENT ONLINE ADD PRIMARY KEY ON COLUMN PREFIX

row_log_table_get_pk(): Invoke dtype_get_at_most_n_mbchars()
to properly retrieve the column prefix.

This bug affected online ALTER TABLE...ADD PRIMARY KEY where the new
PRIMARY KEY included a column prefix.

When the definition of primary key is changed, we must identify both
the old and new PRIMARY KEY value of the row in the modification log.

The bug was that we failed to cut the column prefix, and log apply
would fail to find the row. This caused the log apply to skip DELETE
operations, either as part of ROW_T_DELETE or as part of ROW_T_UPDATE
(update can be treated as delete and insert).

rb#2245 approved by Kevin Lewis