Merge lp:~hrvojem/percona-xtradb-cluster/doc-loaddata-limit into lp:~percona-dev/percona-xtradb-cluster/5.5.20

Proposed by Hrvoje Matijakovic on 2012-04-04
Status: Merged
Approved by: Hrvoje Matijakovic on 2012-04-24
Approved revision: 3752
Merge reported by: Hrvoje Matijakovic
Merged at revision: not available
Proposed branch: lp:~hrvojem/percona-xtradb-cluster/doc-loaddata-limit
Merge into: lp:~percona-dev/percona-xtradb-cluster/5.5.20
Diff against target: 12 lines (+1/-1)
1 file modified
doc/source/limitation.rst (+1/-1)
To merge this branch: bzr merge lp:~hrvojem/percona-xtradb-cluster/doc-loaddata-limit
Reviewer Review Type Date Requested Status
Vadim Tkachenko 2012-04-04 Pending
Review via email: mp+100800@code.launchpad.net
To post a comment you must log in.

Preview Diff

[H/L] Next/Prev Comment, [J/K] Next/Prev File, [N/P] Next/Prev Hunk
1=== modified file 'doc/source/limitation.rst'
2--- doc/source/limitation.rst 2012-02-04 01:22:23 +0000
3+++ doc/source/limitation.rst 2012-04-04 14:20:39 +0000
4@@ -14,7 +14,7 @@
5
6 - Query log cannot be directed to table. If you enable query logging, you must forward the log to a file: log_output = FILE. Use general_log and general_log_file to choose query logging and the log file name.
7
8- - Maximum allowed transaction size is defined by wsrep_max_ws_rows and wsrep_max_ws_size. Anything bigger (e.g. huge LOAD DATA) will be rejected.
9+ - Maximum allowed transaction size is defined by wsrep_max_ws_rows and wsrep_max_ws_size. LOAD DATA INFILE processing will commit every 10K rows. So large transactions due to LOAD DATA will be split to series of small transactions.
10
11 - Due to cluster level optimistic concurrency control, transaction issuing COMMIT may still be aborted at that stage. There can be two transactions writing to same rows and committing in separate XtraDB Cluster nodes, and only one of the them can successfully commit. The failing one will be aborted. For cluster level aborts, XtraDB Cluster gives back deadlock error code:
12 (Error: 1213 SQLSTATE: 40001 (ER_LOCK_DEADLOCK)).

Subscribers

People subscribed via source and target branches