lp:~gryp/mysql-utilities/mysql-utilities

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

403. By Kenny Gryp on 2014-02-04

--sanitize-objects fix:

When a table has 0 rows, AUTO_INCREMENT might just not be displayed, resulting in a diff.

I decided to completely filter out AUTO_INCREMENT=[0-9]*

402. By Kenny Gryp on 2014-02-04

added --sanitize-objects.

Had to do this because diffs where shown with AUTO_INCREMENT and different amount of secondary keys (alter was suggested if the diff was a ',')

401. By Nelson Goncalves <email address hidden> on 2013-11-26

Release-1.3.6 testing

This patch fixes the result files for the following MUT tests:
rpl_admin_gtid_demote_master_repo_file,
rpl_admin_gtid_demote_master_repo_file_req_pass and
rpl_admin_gtid_demote_master_repo_table

400. By Israel Gomez on 2013-11-26

Release-1.3.6 preparation

Added changes to CHANGES.txt file.

399. By Nelson Goncalves <email address hidden> on 2013-11-26

Release-1.3.6 testing

This patch fixes an issue with mysqlfrm on Windows and it also fixes
the frm_reader_default MUT test.

398. By Israel Gomez on 2013-11-26

Release-1.3.6 testing

More changes to mac OSX package name, this patch removes the python
version from the name.

397. By Nelson Goncalves <email address hidden> on 2013-11-25

Release-1.3.6 testing

This patch fixes the following MUT tests:
audit_log_admin, audit_log_grep, check_rpl_parameters, check_gtid_version
check_rpl_errors, export_gtid, audit_log_admin_errors, clone_server_errors
connection_values, copy_db_errors and frm_reader_errors.

396. By Israel Gomez on 2013-11-25

Release-1.3.6 testing

This patch fixes the mac OSX package name, which was missing the
platform name and platform version. Also removes the '-1' from the
commercial msi package name.

v2

395. By Paulo Jesus on 2013-11-25

BUG#14725390 : multithreaded copy, export, import

This patch fixes regression issues introduced in failover and rpl_admin by the
previous patch for this bug. More specifically, error handling for replication
commands has been corrected and a commit is issued before enabling/disabling
the binary logging in order to close any active transaction (that would lead
to an error when executing the command). Other small adjustments were also
made to few rpl_admin test to run properly.

394. By Paulo Jesus on 2013-11-22

BUG#14725390 : multithreaded copy, export, import

The mysqldbexport, mysqldbimport and mysqldbcopy utilities are single
threaded, not taking advantages of concurrent executions to export, import and
copy multiple databases or tables (on multi-core systems). This patch adds
multiprocessing capabilities to those utilities in order to improve their
performance. Other optimizations were also made to avoid repeated processing
(e.g., remove duplicated privileges check) and reuse created object, reducing
the waste of CPU time.

Follows the summary of multiprocessing changes and performance improvement for
each utility.

mysqldbexport:

- Multiprocessing by database for non POSIX systems (Windows) and by table for
  POSIX systems, using the new --multiprocess option.
- New --output-file option was added to store the export results instead of
  using the standard output which can be very slow (up to 10x slower). Now,
  export results are always sent to a file (even if temporary) and only sent
  to the stdout at the end if needed.

mysqldbimport:

- Multiprocessing by file (independently of the operating systems), using the
  new --multiprocess option.
- Perform only a single COMMIT at the end of importing each file, by default.
  A new --autocommit option was added to allow each statement to be committed
  upon its execution.
- Improve the bulk insert feature (support SQL statements). If the
  --bulk-insert option is enabled, then all INSERT statements are parsed and
  their data aggregated (if possible) in order to be executed as a single
  query.
- A new --max-bulk-insert option was added to control the maximum size of the
  bulk insert, in order to avoid broken pipe errors. When the max number of
  insert is reached a new bulk is created.

mysqldbcopy:
- Multiprocessing by database for non POSIX systems (Windows) and by table for
  POSIX systems, using the new --multiprocess option.
- Remove/disable previous thread feature.

Some additional fixes and improvements were also made to the code. For
example: fix position of database lock for export; improve output of database
export with the --file-per-table option, fix execution of SET
FOREIGN_KEY_CHECKS to import data ensuring that statements are executed in the
same order they appear in the imported files; improve method exec_query() and
call method with appropriate options to avoid unnecessary commits; move
get_copy_lock() to dbexport module to remove circular import issue.

MUT tests were added and existing one changed for regression.