Merge lp:~hrvojem/percona-server/bug1057031-5.1 into lp:percona-server/5.1

Proposed by Hrvoje Matijakovic
Status: Merged
Approved by: Stewart Smith
Approved revision: no longer in the source branch.
Merged at revision: 508
Proposed branch: lp:~hrvojem/percona-server/bug1057031-5.1
Merge into: lp:percona-server/5.1
Diff against target: 753 lines (+55/-181)
36 files modified
doc/source/development.rst (+4/-4)
doc/source/diagnostics/innodb_deadlock_count.rst (+1/-1)
doc/source/diagnostics/mysql_syslog.rst (+1/-1)
doc/source/diagnostics/process_list.rst (+0/-25)
doc/source/diagnostics/response_time_distribution.rst (+3/-3)
doc/source/diagnostics/show_engines.rst (+1/-1)
doc/source/diagnostics/slow_extended.rst (+2/-14)
doc/source/flexibility/buff_read_ahead_area.rst (+1/-1)
doc/source/flexibility/innodb_fast_shutdown.rst (+1/-1)
doc/source/flexibility/log_warnings_suppress.rst (+3/-33)
doc/source/flexibility/mysql_remove_eol_carret.rst (+1/-1)
doc/source/flexibility/mysqlbinlog_change_db.rst (+1/-1)
doc/source/flexibility/replication_skip_single_statement.rst (+1/-1)
doc/source/index.rst (+1/-2)
doc/source/installation.rst (+1/-1)
doc/source/management/changed_page_tracking.rst (+1/-1)
doc/source/management/innodb_buffer_pool_shm.rst (+3/-3)
doc/source/management/innodb_expand_import.rst (+3/-22)
doc/source/management/innodb_extended_fast_index_creation.rst (+1/-1)
doc/source/management/innodb_fast_index_creation.rst (+2/-2)
doc/source/management/innodb_fast_index_renaming.rst (+0/-38)
doc/source/management/innodb_lru_dump_restore.rst (+1/-1)
doc/source/management/sql_no_fcache.rst (+1/-1)
doc/source/management/udf_maatkit.rst (+1/-1)
doc/source/performance/handlersocket.rst (+1/-1)
doc/source/performance/innodb_doublewrite_path.rst (+3/-3)
doc/source/performance/innodb_lazy_drop_table.rst (+3/-3)
doc/source/performance/innodb_purge_thread.rst (+2/-2)
doc/source/performance/remove_fcntl_excessive_calls.rst (+1/-1)
doc/source/release-notes/Percona-Server-5.1.50-rel12.1.rst (+1/-1)
doc/source/reliability/crash_resistant_replication.rst (+1/-1)
doc/source/reliability/error_pad.rst (+1/-1)
doc/source/reliability/log_connection_error.rst (+1/-1)
doc/source/reliability/show_slave_status_nolock.rst (+1/-2)
doc/source/scalability/innodb_extra_rseg.rst (+3/-3)
doc/source/scalability/innodb_io.rst (+2/-2)
To merge this branch: bzr merge lp:~hrvojem/percona-server/bug1057031-5.1
Reviewer Review Type Date Requested Status
Stewart Smith (community) Approve
Review via email: mp+139694@code.launchpad.net
To post a comment you must log in.
Revision history for this message
Stewart Smith (stewart) :
review: Approve

Preview Diff

[H/L] Next/Prev Comment, [J/K] Next/Prev File, [N/P] Next/Prev Hunk
=== modified file 'doc/source/development.rst'
--- doc/source/development.rst 2012-01-27 11:37:42 +0000
+++ doc/source/development.rst 2012-12-13 13:30:28 +0000
@@ -19,7 +19,7 @@
1919
20Overview20Overview
21~~~~~~~~21~~~~~~~~
22At Percona we use `Bazaar <http://www.bazaar-vcs.org>`_ for source22At Percona we use `Bazaar <http://bazaar.canonical.com/en/>`_ for source
23control and `launchpad <http://www.launchpad.net>`_ for both23control and `launchpad <http://www.launchpad.net>`_ for both
24code hosting and release management.24code hosting and release management.
2525
@@ -205,7 +205,7 @@
205Percona Xtrabackup205Percona Xtrabackup
206~~~~~~~~~~~~~~~~~~206~~~~~~~~~~~~~~~~~~
207207
208`<http://jenkins.percona.com/view/Percona%20Xtrabackup/>`_208`<http://jenkins.percona.com/view/XtraBackup/>`_
209209
210We currently build both xtrabackup 1.6 and xtrabackup trunk (will become 1.7).210We currently build both xtrabackup 1.6 and xtrabackup trunk (will become 1.7).
211211
@@ -221,14 +221,14 @@
221Percona Server 5.1221Percona Server 5.1
222------------------222------------------
223223
224`<http://jenkins.percona.com/view/Percona%20Server%205.1/>`_224`<http://jenkins.percona.com/view/PS%205.1/>`_
225225
226We have trunk and param jobs. We also have a valgrind job that will run after a successful trunk build.226We have trunk and param jobs. We also have a valgrind job that will run after a successful trunk build.
227227
228Percona Server 5.5228Percona Server 5.5
229------------------229------------------
230230
231`<http://jenkins.percona.com/view/Percona%20Server%205.5/>`_231`<http://jenkins.percona.com/view/PS%205.5/>`_
232232
233Similar to 5.1, but for PS5.5 instead.233Similar to 5.1, but for PS5.5 instead.
234234
235235
=== modified file 'doc/source/diagnostics/innodb_deadlock_count.rst'
--- doc/source/diagnostics/innodb_deadlock_count.rst 2011-10-07 00:55:06 +0000
+++ doc/source/diagnostics/innodb_deadlock_count.rst 2012-12-13 13:30:28 +0000
@@ -36,7 +36,7 @@
36Version Specific Information36Version Specific Information
37============================37============================
3838
39 * 5.1.47-11.0:39 * :rn:`5.1.47-rel11.1`:
40 Full functionality available.40 Full functionality available.
4141
42Status Variables42Status Variables
4343
=== modified file 'doc/source/diagnostics/mysql_syslog.rst'
--- doc/source/diagnostics/mysql_syslog.rst 2012-05-29 18:31:23 +0000
+++ doc/source/diagnostics/mysql_syslog.rst 2012-12-13 13:30:28 +0000
@@ -10,7 +10,7 @@
10Version Specific Information10Version Specific Information
11============================11============================
1212
13 * 5.1.49-12.0:13 * :rn:`5.1.49-rel12.0`:
14 Full functionality available.14 Full functionality available.
1515
16Other Information16Other Information
1717
=== modified file 'doc/source/diagnostics/process_list.rst'
--- doc/source/diagnostics/process_list.rst 2011-10-07 00:55:06 +0000
+++ doc/source/diagnostics/process_list.rst 2012-12-13 13:30:28 +0000
@@ -6,29 +6,6 @@
66
7This page describes Percona changes to both the standard |MySQL| ``SHOW PROCESSLIST`` command and the standard |MySQL| ``INFORMATION_SCHEMA`` table ``PROCESSLIST``.7This page describes Percona changes to both the standard |MySQL| ``SHOW PROCESSLIST`` command and the standard |MySQL| ``INFORMATION_SCHEMA`` table ``PROCESSLIST``.
88
9The changes that have been made as of version 5.5 of the server are:
10
11 * ``SHOW PROCESSLIST`` command:
12
13 * added columns ``ROWS_EXAMINED``, ``ROWS_SENT``, and ``ROWS_READ``
14
15 * ``PROCESSLIST`` table:
16
17 * added columns ``TIME_MS``, ``ROWS_EXAMINED``, ``ROWS_SENT``, and ``ROWS_READ``
18
19Version Specific Information
20============================
21
22 * 5.0.91-22:
23
24 * Added column ``TIME_MS`` to table ``PROCESSLIST``.
25
26 * 5.5.10-20.1:
27
28 * Added columns ``ROWS_EXAMINED``, ``ROWS_SENT``, and ``ROWS_READ`` to ``SHOW PROCESSLIST`` command.
29
30 * Added columns ``ROWS_EXAMINED``, ``ROWS_SENT``, and ``ROWS_READ`` to table ``PROCESSLIST``.
31
32INFORMATION_SCHEMA Tables9INFORMATION_SCHEMA Tables
33=========================10=========================
3411
@@ -48,8 +25,6 @@
48 :column ROWS_EXAMINED: The number of rows examined by the statement being executed.25 :column ROWS_EXAMINED: The number of rows examined by the statement being executed.
49 :column ROWS_SENT: The number of rows sent by the statement being executed.26 :column ROWS_SENT: The number of rows sent by the statement being executed.
50 :column ROWS_READ: The number of rows read by the statement being executed.27 :column ROWS_READ: The number of rows read by the statement being executed.
51 :version 5.0.91-22: Added column ``TIME_MS``
52 :version 5.5.10-20.1: Added columns ``ROWS_EXAMINED``, ``ROWS_SENT``, and ``ROWS_READ``
5328
5429
55Example Output30Example Output
5631
=== modified file 'doc/source/diagnostics/response_time_distribution.rst'
--- doc/source/diagnostics/response_time_distribution.rst 2012-12-10 14:01:11 +0000
+++ doc/source/diagnostics/response_time_distribution.rst 2012-12-13 13:30:28 +0000
@@ -193,10 +193,10 @@
193Version Specific Information193Version Specific Information
194============================194============================
195195
196 * 5.1.49-12.0:196 * :rn:`5.1.49-rel12.0`:
197 Full functionality available.197 Full functionality available.
198198
199 * 5.1.53-12.4:199 * :rn:`5.1.53-12.4`:
200 Introduced :variable:`have_response_time_distribution`.200 Introduced :variable:`have_response_time_distribution`.
201201
202System Variables202System Variables
@@ -232,7 +232,7 @@
232232
233.. variable:: enable_query_response_time_stats233.. variable:: enable_query_response_time_stats
234234
235 :version 5.1.49-12.0: Introduced.235 :version 5.1.49-rel12.0: Introduced.
236 :cli: Yes236 :cli: Yes
237 :conf: Yes237 :conf: Yes
238 :scope: Global238 :scope: Global
239239
=== modified file 'doc/source/diagnostics/show_engines.rst'
--- doc/source/diagnostics/show_engines.rst 2011-10-07 00:55:06 +0000
+++ doc/source/diagnostics/show_engines.rst 2012-12-13 13:30:28 +0000
@@ -29,7 +29,7 @@
29Version-Specific Information29Version-Specific Information
30============================30============================
3131
32 * 5.1.49-12.0:32 * :rn:`5.1.49-rel12.0`:
33 Full functionality available.33 Full functionality available.
3434
35Other Information35Other Information
3636
=== modified file 'doc/source/diagnostics/slow_extended.rst'
--- doc/source/diagnostics/slow_extended.rst 2012-09-17 07:36:57 +0000
+++ doc/source/diagnostics/slow_extended.rst 2012-12-13 13:30:28 +0000
@@ -8,20 +8,12 @@
88
9The ability to log queries with microsecond precision is essential for measuring the work the |MySQL| server performs. The standard slow query log in |MySQL| 5.0 has only 1-second granularity, which is too coarse for all but the slowest queries. |MySQL| 5.1 has microsecond resolution, but does not have the extra information about query execution that is included in the |Percona Server|.9The ability to log queries with microsecond precision is essential for measuring the work the |MySQL| server performs. The standard slow query log in |MySQL| 5.0 has only 1-second granularity, which is too coarse for all but the slowest queries. |MySQL| 5.1 has microsecond resolution, but does not have the extra information about query execution that is included in the |Percona Server|.
1010
11You can use *Percona Toolkit* 's ''mk-query-digest'' tool to aggregate similar queries together and report on those that consume the most execution time.11You can use *Percona Toolkit*'s ''pt-query-digest'' tool to aggregate similar queries together and report on those that consume the most execution time.
1212
1313
14Version Specific Information14Version Specific Information
15============================15============================
1616
17 * ``4.1.x``:
18
19 * Limited functionality available: only microsecond resolution, no added statistics.
20
21 * ``5.0.x``:
22
23 * Full functionality available.
24
25 * ``5.1.x``:17 * ``5.1.x``:
2618
27 * Microsecond resolution included in official |MySQL| server; this feature adds statistics.19 * Microsecond resolution included in official |MySQL| server; this feature adds statistics.
@@ -34,7 +26,7 @@
3426
35 * Full functionality of :variable:`use_global_log_slow_control` available.27 * Full functionality of :variable:`use_global_log_slow_control` available.
3628
37 * Fixed :bug:`600684` - :variable:`log_slow_verbosity` ``=iInnodb`` doesn't work on slave (statement-based replication)29 * Fixed :bug:`600684` - :variable:`log_slow_verbosity` ``=Innodb`` doesn't work on slave (statement-based replication)
3830
39 * :rn:`5.1.53-11.7`:31 * :rn:`5.1.53-11.7`:
4032
@@ -134,16 +126,12 @@
134126
135If ``TRUE``, a timestamp is printed on every slow log record. Multiple records may have the same time.127If ``TRUE``, a timestamp is printed on every slow log record. Multiple records may have the same time.
136128
137**NOTE:** This variable has been renamed to :variable:`slow_query_log_timestamp_always` since :rn:`5.5.10-20.1`.
138
139
140.. variable:: log_slow_verbosity129.. variable:: log_slow_verbosity
141130
142 :cli: Yes131 :cli: Yes
143 :conf: Yes132 :conf: Yes
144 :scope: Global, session133 :scope: Global, session
145 :dyn: Yes134 :dyn: Yes
146 :version 5.5.8-20.0: Added ``profiling`` and ``profiling_use_getrusage``
147135
148Specifies how much information to include in your slow log. The value is a comma-delimited string, and can contain any combination of the following values:136Specifies how much information to include in your slow log. The value is a comma-delimited string, and can contain any combination of the following values:
149137
150138
=== modified file 'doc/source/flexibility/buff_read_ahead_area.rst'
--- doc/source/flexibility/buff_read_ahead_area.rst 2012-06-13 10:52:23 +0000
+++ doc/source/flexibility/buff_read_ahead_area.rst 2012-12-13 13:30:28 +0000
@@ -18,7 +18,7 @@
18Version Specific Information18Version Specific Information
19============================19============================
2020
21 * :rn:`5.1.47-12.0` :21 * :rn:`5.1.49-rel12.0` :
22 Full functionality available.22 Full functionality available.
2323
24Other Information24Other Information
2525
=== modified file 'doc/source/flexibility/innodb_fast_shutdown.rst'
--- doc/source/flexibility/innodb_fast_shutdown.rst 2011-10-07 00:55:06 +0000
+++ doc/source/flexibility/innodb_fast_shutdown.rst 2012-12-13 13:30:28 +0000
@@ -15,7 +15,7 @@
15Version Specific Information15Version Specific Information
16============================16============================
1717
18 * 5.1.52-12.3:18 * :rn:`5.1.52-12.3`
19 Full functionality available.19 Full functionality available.
2020
21Other Information21Other Information
2222
=== modified file 'doc/source/flexibility/log_warnings_suppress.rst'
--- doc/source/flexibility/log_warnings_suppress.rst 2011-10-07 00:55:06 +0000
+++ doc/source/flexibility/log_warnings_suppress.rst 2012-12-13 13:30:28 +0000
@@ -10,22 +10,15 @@
10Version Specific Information10Version Specific Information
11============================11============================
1212
13 * 5.1.47-11.0: 13 * :rn:`5.1.47-rel11.1`
14 System variable :variable:`suppress_log_warning_1592` introduced.14 System variable :variable:`suppress_log_warning_1592` introduced.
1515
16 * 5.5.8-20.0:
17 System variable :variable:`suppress_log_warning_1592` replaced by :variable:`log_warnings_silence`.
18
19 * 5.5.10-20.1:
20 Renamed variable :variable:`log_warnings_silence` to :variable:`log_warnings_suppress`.
21
22System Variables16System Variables
23================17================
2418
25.. variable:: suppress_log_warning_159219.. variable:: suppress_log_warning_1592
2620
27 :version 5.1.47-11.0: Introduced.21 :version 5.1.47-rel11.1: Introduced.
28 :version 5.5.8-20.0: Deleted.
29 :cli: Yes22 :cli: Yes
30 :conf: Yes23 :conf: Yes
31 :scope: Global24 :scope: Global
@@ -46,33 +39,10 @@
4639
47 090213 16:58:54 [Warning] Statement is not safe to log in statement format.40 090213 16:58:54 [Warning] Statement is not safe to log in statement format.
4841
49This variable was obsoleted, beginning in release :rn:`5.5.8-20.0`. It still exists in versions :rn:`5.1.47-11.0` to :rn:`5.1.54-12.5`.
50
51.. variable:: log_warnings_suppress
52
53 :version 5.5.8-20.0: Introduced.
54 :version 5.5.10-20.1: Renamed.
55 :cli: Yes
56 :conf: Yes
57 :scope: Global
58 :dyn: Yes
59 :vartype: SET
60 :default: ``(empty string)``
61 :range: ``(empty string)``, ``1592``
62
63This variable was added in beta release ``5.5.8-20.0`` as :variable:`log_warnings_silence` and renamed in release 5.5.10-20.1.
64
65It is intended to provide a more general mechanism for disabling warnings than existed previously with variable suppress_log_warning_1592.
66
67When set to the empty string, no warnings are disabled. When set to ``1592``, warning #1592 messages (unsafe statement for binary logging) are suppressed.
68
69In the future, the ability to optionally disable additional warnings may also be added.
70
71
72Related Reading42Related Reading
73===============43===============
7444
75 * `MySQL bug 42851 <http://bugs.mysql.com/bug.php?id=42851>`_45 * `MySQL bug #42851 <http://bugs.mysql.com/bug.php?id=42851>`_
7646
77 * `MySQL InnoDB replication <http://dev.mysql.com/doc/refman/5.1/en/innodb-and-mysql-replication.html>`_47 * `MySQL InnoDB replication <http://dev.mysql.com/doc/refman/5.1/en/innodb-and-mysql-replication.html>`_
7848
7949
=== modified file 'doc/source/flexibility/mysql_remove_eol_carret.rst'
--- doc/source/flexibility/mysql_remove_eol_carret.rst 2011-10-07 00:55:06 +0000
+++ doc/source/flexibility/mysql_remove_eol_carret.rst 2012-12-13 13:30:28 +0000
@@ -14,7 +14,7 @@
14Version Specific Information14Version Specific Information
15============================15============================
1616
17 * 5.1.50-12.1:17 * :rn:`5.1.50-rel12.1`
18 Full functionality.18 Full functionality.
1919
20Client Command Line Parameter20Client Command Line Parameter
2121
=== modified file 'doc/source/flexibility/mysqlbinlog_change_db.rst'
--- doc/source/flexibility/mysqlbinlog_change_db.rst 2012-05-17 11:21:21 +0000
+++ doc/source/flexibility/mysqlbinlog_change_db.rst 2012-12-13 13:30:28 +0000
@@ -66,7 +66,7 @@
66Version Specific Information66Version Specific Information
67============================67============================
6868
69 * 5.1.62-13.369 * :rn:`5.1.62-13.3`
70 Full functionality.70 Full functionality.
7171
72Client Command Line Parameter72Client Command Line Parameter
7373
=== modified file 'doc/source/flexibility/replication_skip_single_statement.rst'
--- doc/source/flexibility/replication_skip_single_statement.rst 2011-10-07 00:55:06 +0000
+++ doc/source/flexibility/replication_skip_single_statement.rst 2012-12-13 13:30:28 +0000
@@ -25,7 +25,7 @@
25Version Specific Information25Version Specific Information
26============================26============================
2727
28 * 5.1.49-12.0:28 * :rn:`5.1.49-rel12.0`
29 Full functionality released.29 Full functionality released.
3030
31System Variables31System Variables
3232
=== modified file 'doc/source/index.rst'
--- doc/source/index.rst 2012-12-10 14:01:11 +0000
+++ doc/source/index.rst 2012-12-13 13:30:28 +0000
@@ -103,7 +103,7 @@
103 reliability/log_connection_error103 reliability/log_connection_error
104 reliability/error_pad104 reliability/error_pad
105 reliability/innodb_corrupt_table_action105 reliability/innodb_corrupt_table_action
106 reliability/innodb_recovery_update_relay_log106 reliability/crash_resistant_replication
107 reliability/show_slave_status_nolock107 reliability/show_slave_status_nolock
108108
109Management Improvements109Management Improvements
@@ -120,7 +120,6 @@
120 management/innodb_lru_dump_restore120 management/innodb_lru_dump_restore
121 management/innodb_fast_index_creation121 management/innodb_fast_index_creation
122 management/innodb_extended_fast_index_creation122 management/innodb_extended_fast_index_creation
123 management/innodb_fast_index_renaming
124 management/sql_no_fcache123 management/sql_no_fcache
125 management/udf_maatkit124 management/udf_maatkit
126 management/innodb_fake_changes125 management/innodb_fake_changes
127126
=== modified file 'doc/source/installation.rst'
--- doc/source/installation.rst 2012-01-09 04:30:56 +0000
+++ doc/source/installation.rst 2012-12-13 13:30:28 +0000
@@ -170,7 +170,7 @@
170 Installing |Percona Server| from the Bazaar Source Tree170 Installing |Percona Server| from the Bazaar Source Tree
171========================================================171========================================================
172172
173Percona uses the `Bazaar <http://www.bazaar-vcs.org>`_ revision173Percona uses the `Bazaar <http://bazaar.canonical.com/en/>`_ revision
174control system for development. To build the latest Percona Server174control system for development. To build the latest Percona Server
175from the source tree you will need Bazaar installed on your system.175from the source tree you will need Bazaar installed on your system.
176176
177177
=== modified file 'doc/source/management/changed_page_tracking.rst'
--- doc/source/management/changed_page_tracking.rst 2012-09-03 09:31:43 +0000
+++ doc/source/management/changed_page_tracking.rst 2012-12-13 13:30:28 +0000
@@ -35,7 +35,7 @@
35.. variable:: innodb_track_changed_pages35.. variable:: innodb_track_changed_pages
3636
37 :version 5.1.65-14.0: Variable introduced37 :version 5.1.65-14.0: Variable introduced
38 :cli: No38 :cli: Yes
39 :conf: Yes39 :conf: Yes
40 :scope: Global40 :scope: Global
41 :dyn: No41 :dyn: No
4242
=== modified file 'doc/source/management/innodb_buffer_pool_shm.rst'
--- doc/source/management/innodb_buffer_pool_shm.rst 2011-10-07 00:55:06 +0000
+++ doc/source/management/innodb_buffer_pool_shm.rst 2012-12-13 13:30:28 +0000
@@ -17,12 +17,12 @@
17Version Specific Information17Version Specific Information
18============================18============================
1919
20 * 5.1.49-12.0:20 * :rn:`5.1.49-rel12.0`
21 Feature introduced.21 Feature introduced.
2222
23 * 5.1.50-12.1:23 * :rn:`5.1.50-rel12.1`
24 System variable :variable:`innodb_buffer_pool_shm_checksum` added.24 System variable :variable:`innodb_buffer_pool_shm_checksum` added.
2525
26 * 5.1.58-12.9:26 * :rn:`5.1.58-12.9`
27 Feature removed, as LRU Dump/Restore is less invasive, more27 Feature removed, as LRU Dump/Restore is less invasive, more
28 reliable and a better solution.28 reliable and a better solution.
2929
=== modified file 'doc/source/management/innodb_expand_import.rst'
--- doc/source/management/innodb_expand_import.rst 2012-06-13 10:52:23 +0000
+++ doc/source/management/innodb_expand_import.rst 2012-12-13 13:30:28 +0000
@@ -74,15 +74,15 @@
74Version Specific Information74Version Specific Information
75============================75============================
7676
77 * 5.5.10-20.1:77 * :rn:`5.1.50-rel12.1`
78 Renamed variable :variable:`innodb_expand_import` to :variable:`innodb_import_table_from_xtrabackup`.78 Introduced variable :variable:`innodb_expand_import`.
7979
80System Variables80System Variables
81================81================
8282
83.. variable:: innodb_expand_import83.. variable:: innodb_expand_import
8484
85 :version 5.5.10-20.1: Renamed.85 :version 5.1.50-rel12.1: Introduced
86 :cli: Yes86 :cli: Yes
87 :conf: Yes87 :conf: Yes
88 :scope: Global88 :scope: Global
@@ -93,25 +93,6 @@
9393
94If set to 1, ``.ibd`` file is converted (``space id``, ``index id``, etc.) with index information in ``.exp`` file during the import process (``ALTER TABLE ... IMPORT TABLESPACE`` command).94If set to 1, ``.ibd`` file is converted (``space id``, ``index id``, etc.) with index information in ``.exp`` file during the import process (``ALTER TABLE ... IMPORT TABLESPACE`` command).
9595
96 This variable was renamed to :variable:`innodb_import_table_from_xtrabackup`, beginning in release 5.5.10-20.1. It still exists as :variable:`innodb_expand_import` in versions prior to that.
97
98
99.. variable:: innodb_import_table_from_xtrabackup
100
101 :version 5.5.10-20.1: Introduced.
102 :cli: Yes
103 :conf: Yes
104 :scope: Global
105 :dyn: Yes
106 :vartype: ULONG
107 :default: 0
108 :range: 0-1
109
110If set to 1, ``.ibd`` file is converted (``space id``, ``index id``, etc.) with index information in .exp file during the import process (``ALTER TABLE ... IMPORT TABLESPACE`` command).
111
112 This variable was added in release 5.5.10-20.1. Prior to that, it was named :variable:`innodb_expand_import`, which still exists in earlier versions.
113
114
115.. Other Information96.. Other Information
11697
11798
11899
=== modified file 'doc/source/management/innodb_extended_fast_index_creation.rst'
--- doc/source/management/innodb_extended_fast_index_creation.rst 2012-01-30 16:43:47 +0000
+++ doc/source/management/innodb_extended_fast_index_creation.rst 2012-12-13 13:30:28 +0000
@@ -58,7 +58,7 @@
58Version Specific Information58Version Specific Information
59============================59============================
6060
61 * 5.1.59-13.0 61 * :rn:`5.1.59-13.0`:
62 Variable :variable:`expand_fast_index_creation` implemented.62 Variable :variable:`expand_fast_index_creation` implemented.
63 This variable controls whether fast index creation optimizations made by Perocna are used.63 This variable controls whether fast index creation optimizations made by Perocna are used.
6464
6565
=== modified file 'doc/source/management/innodb_fast_index_creation.rst'
--- doc/source/management/innodb_fast_index_creation.rst 2012-07-12 08:48:23 +0000
+++ doc/source/management/innodb_fast_index_creation.rst 2012-12-13 13:30:28 +0000
@@ -23,10 +23,10 @@
23Version Specific Information23Version Specific Information
24============================24============================
2525
26 * 5.1.49-12.0: 26 * :rn:`5.1.49-rel12.0`:
27 Variable :variable:`fast_index_creation` implemented.27 Variable :variable:`fast_index_creation` implemented.
2828
29 * 5.1.56-12.7, 5.5.11-21.2:29 * :rn:`5.1.56-12.7`:
30 Expanded the applicability of fast index creation to :command:`mysqldump`, ``ALTER TABLE``, and ``OPTIMIZE TABLE``.30 Expanded the applicability of fast index creation to :command:`mysqldump`, ``ALTER TABLE``, and ``OPTIMIZE TABLE``.
3131
3232
3333
=== removed file 'doc/source/management/innodb_fast_index_renaming.rst'
--- doc/source/management/innodb_fast_index_renaming.rst 2011-10-07 00:55:06 +0000
+++ doc/source/management/innodb_fast_index_renaming.rst 1970-01-01 00:00:00 +0000
@@ -1,38 +0,0 @@
1.. _innodb_fast_index_renaming:
2
3=====================
4 Fast Index Renaming
5=====================
6
7This feature provides a way to have a fast (online) way to rename an index without rebuilding the whole table. It does this by adding a ``RENAME INDEX`` clause to the ``ALTER TABLE`` statement: ::
8
9 ALTER TABLE ... RENAME INDEX xxx TO yyy;
10
11Several limitations exist:
12
13 * The ``RENAME INDEX`` clause cannot be used with any other type of clause. If it is, an error message is displayed and an error code returned.
14
15 * The ``RENAME INDEX`` clause can only be used when MyISAM or XtraDB is the storage engine. Otherwise, an error message will be displayed: ``wrong for the engine 'engine name'``.
16
17 * Use of a partitioned table is not allowed. If ``ALTER TABLE`` is applied to a partitioned table, an error will occur.
18
19 * If use of the ``RENAME INDEX`` clause results in an XtraDB error, an inconsistency between the index name in MySQL and Percona Server with XtraDB may occur.
20
21Errors like ``duplicate key name`` or ``key name not found`` are not caused by ``RENAME INDEX``. These errors occur before processing of the ``RENAME INDEX`` clause occurs. So they don't cause an inconsistency problem.
22
23An internally reserved InnoDB name (e.g., ``GEN_CLUST_INDEX``) cannot be used as an index name. If one is, an error is reported.
24
25If any error is returned by the ``ALTER TABLE`` command due to the ``RENAME INDEX`` clause, the best way to resolve the problem is to re-create the table.
26
27
28Version Specific Information
29============================
30
31 * 5.1.49-12.0:
32 Not yet released externally
33
34Error Codes
35===========
36
37 * ``error_er_wrong_usage``:
38 Incorrect usage of %s and %s
390
=== modified file 'doc/source/management/innodb_lru_dump_restore.rst'
--- doc/source/management/innodb_lru_dump_restore.rst 2012-12-10 14:01:11 +0000
+++ doc/source/management/innodb_lru_dump_restore.rst 2012-12-13 13:30:28 +0000
@@ -15,7 +15,7 @@
15Automatic Operation15Automatic Operation
16===================16===================
1717
18To perform dump/restore of the buffer pool automatically, set the :variable:`innodb_lru_dump_restore` configuration variable. A non-zero value for this variable causes the server to create a new thread at startup. This thread's first task is to read and sort the saved file, and then restore the LRU accordingly.18To perform dump/restore of the buffer pool automatically, set the :variable:`innodb_auto_lru_dump` configuration variable. A non-zero value for this variable causes the server to create a new thread at startup. This thread's first task is to read and sort the saved file, and then restore the LRU accordingly.
1919
20After finishing the restore operation, the thread switches into dump mode, to periodically dump the LRU. The period is specified by the configuration variable's value in seconds. For example, if you set the variable to 60, then the thread saves the LRU list once per minute.20After finishing the restore operation, the thread switches into dump mode, to periodically dump the LRU. The period is specified by the configuration variable's value in seconds. For example, if you set the variable to 60, then the thread saves the LRU list once per minute.
2121
2222
=== modified file 'doc/source/management/sql_no_fcache.rst'
--- doc/source/management/sql_no_fcache.rst 2011-10-07 00:55:06 +0000
+++ doc/source/management/sql_no_fcache.rst 2012-12-13 13:30:28 +0000
@@ -18,7 +18,7 @@
18Version-Specific Information18Version-Specific Information
19============================19============================
2020
21 * 5.1.49-12.0:21 * :rn:`5.1.49-rel12.0`:
22 Full functionality available.22 Full functionality available.
2323
24Other Information24Other Information
2525
=== modified file 'doc/source/management/udf_maatkit.rst'
--- doc/source/management/udf_maatkit.rst 2011-10-07 00:55:06 +0000
+++ doc/source/management/udf_maatkit.rst 2012-12-13 13:30:28 +0000
@@ -15,7 +15,7 @@
15Version Specific Information15Version Specific Information
16============================16============================
1717
18 * 5.1.53-12.4:18 * :rn:`5.1.53-12.4`:
19 Began distributing ``fnv_udf``, ``fnv1a_udf``, and ``murmur_udf``.19 Began distributing ``fnv_udf``, ``fnv1a_udf``, and ``murmur_udf``.
2020
21Other Information21Other Information
2222
=== modified file 'doc/source/performance/handlersocket.rst'
--- doc/source/performance/handlersocket.rst 2011-10-07 00:55:06 +0000
+++ doc/source/performance/handlersocket.rst 2012-12-13 13:30:28 +0000
@@ -19,7 +19,7 @@
19Version Specific Information19Version Specific Information
20============================20============================
2121
22 * 5.1.52-12.322 * :rn:`5.1.52-12.3`
23 Full functionality available.23 Full functionality available.
2424
25Other Information25Other Information
2626
=== modified file 'doc/source/performance/innodb_doublewrite_path.rst'
--- doc/source/performance/innodb_doublewrite_path.rst 2011-10-07 00:55:06 +0000
+++ doc/source/performance/innodb_doublewrite_path.rst 2012-12-13 13:30:28 +0000
@@ -50,16 +50,16 @@
5050
51Basically if you want to improve the I/O activity, you will put the doublewrite buffer on a different disk. But is it better on an SSD or a more traditional HDD? First you should note that pages are written in a circular fashion in the doublewrite buffer and only read on recovery. So the doublewrite buffer performs mostly sequential writes and a few sequential reads. Second HDDs are very good at sequential write if a write cache is enabled, which is not the case of SSDs. Therefore you should choose a fast HDD if you want to see performance benefits from this option. For instance, you could place the redo logs (also written in a sequential way) and the doublewrite buffer on the same disk.51Basically if you want to improve the I/O activity, you will put the doublewrite buffer on a different disk. But is it better on an SSD or a more traditional HDD? First you should note that pages are written in a circular fashion in the doublewrite buffer and only read on recovery. So the doublewrite buffer performs mostly sequential writes and a few sequential reads. Second HDDs are very good at sequential write if a write cache is enabled, which is not the case of SSDs. Therefore you should choose a fast HDD if you want to see performance benefits from this option. For instance, you could place the redo logs (also written in a sequential way) and the doublewrite buffer on the same disk.
5252
53Prior to release 5.1.53-12.4, it was necessary to recreate your database and |InnoDB| system files when a dedicated file to contain the doublewrite buffer was specified. Beginning with release 5.1.53-12.4, you no longer need to do this.53Prior to release :rn:`5.1.53-12.4`, it was necessary to recreate your database and |InnoDB| system files when a dedicated file to contain the doublewrite buffer was specified. Beginning with release 5.1.53-12.4, you no longer need to do this.
5454
5555
56Version Specific Information56Version Specific Information
57============================57============================
5858
59 * 5.1.47-11.0 59 * :rn:`5.1.47-rel11.1`
60 Full functionality available.60 Full functionality available.
6161
62 * 5.1.53-12.462 * :rn:`5.1.53-12.4`
63 Rebuild of database and system files no longer necessary.63 Rebuild of database and system files no longer necessary.
6464
65System Variables65System Variables
6666
=== modified file 'doc/source/performance/innodb_lazy_drop_table.rst'
--- doc/source/performance/innodb_lazy_drop_table.rst 2012-01-27 11:37:42 +0000
+++ doc/source/performance/innodb_lazy_drop_table.rst 2012-12-13 13:30:28 +0000
@@ -4,14 +4,14 @@
4Drop table performance4Drop table performance
5======================5======================
66
7When *innodb_file_per_table* is set to 1, doing a DROP TABLE can take a long time on servers with a large buffer pool, even on an empty |InnoDB| table. This is because InnoDB has to scan through the buffer pool to purge pages that belong to the corresponding tablespace. Furthermore, no other queries can start while that scan is in progress.7When :variable:`innodb_file_per_table` is set to 1, doing a ``DROP TABLE`` can take a long time on servers with a large buffer pool, even on an empty |InnoDB| table. This is because InnoDB has to scan through the buffer pool to purge pages that belong to the corresponding tablespace. Furthermore, no other queries can start while that scan is in progress.
88
9This feature allows you to do "background table drop".9This feature allows you to do "background table drop".
1010
11Version Specific Information11Version Specific Information
12============================12============================
1313
14 * 5.1.56-12-7 Feature added.14 * :rn:`5.1.56-12.7` Feature added.
1515
16System Variables16System Variables
17================17================
@@ -26,7 +26,7 @@
26 :default: FALSE26 :default: FALSE
27 :range: TRUE/FALSE27 :range: TRUE/FALSE
2828
29When this option is ON, XtraDB optimizes that process by only marking the pages corresponding to the tablespace being deleted. It defers the actual work of evicting those pages until it needs to find some free pages in the buffer pool.29When this option is ON, |XtraDB| optimizes that process by only marking the pages corresponding to the tablespace being deleted. It defers the actual work of evicting those pages until it needs to find some free pages in the buffer pool.
3030
31When this option is OFF, the usual behavior for dropping tables is in effect.31When this option is OFF, the usual behavior for dropping tables is in effect.
3232
3333
=== modified file 'doc/source/performance/innodb_purge_thread.rst'
--- doc/source/performance/innodb_purge_thread.rst 2011-10-07 00:55:06 +0000
+++ doc/source/performance/innodb_purge_thread.rst 2012-12-13 13:30:28 +0000
@@ -61,6 +61,6 @@
6161
62 * `Tuning for heavy writing workloads <http://www.mysqlperformanceblog.com/2009/10/14/tuning-for-heavy-writing-workloads/>`_62 * `Tuning for heavy writing workloads <http://www.mysqlperformanceblog.com/2009/10/14/tuning-for-heavy-writing-workloads/>`_
6363
64 * `Reasons for run-away main |InnoDB| tablespace <http://www.mysqlperformanceblog.com/2009/10/14/tuning-for-heavy-writing-workloads/>`_64 * `Reasons for run-away main InnoDB tablespace <http://www.mysqlperformanceblog.com/2010/06/10/reasons-for-run-away-main-innodb-tablespace/>`_
6565
66 * `Purge thread spiral of death <http://www.mysqlperformanceblog.com/2009/10/14/tuning-for-heavy-writing-workloads/>`_66 * `Purge thread spiral of death <http://www.mysqlperformanceblog.com/2010/06/10/purge-thread-spira-of-death/>`_
6767
=== modified file 'doc/source/performance/remove_fcntl_excessive_calls.rst'
--- doc/source/performance/remove_fcntl_excessive_calls.rst 2012-10-19 10:36:02 +0000
+++ doc/source/performance/remove_fcntl_excessive_calls.rst 2012-12-13 13:30:28 +0000
@@ -20,7 +20,7 @@
20Version Specific Information20Version Specific Information
21============================21============================
2222
23 * :rn:`5.1.49-12.0`: 23 * :rn:`5.1.49-rel12.0`:
24 Feature implemented 24 Feature implemented
25 * :rn:`5.1.55-12.6`: 25 * :rn:`5.1.55-12.6`:
26 Feature updated26 Feature updated
2727
=== modified file 'doc/source/release-notes/Percona-Server-5.1.50-rel12.1.rst'
--- doc/source/release-notes/Percona-Server-5.1.50-rel12.1.rst 2012-10-13 08:58:19 +0000
+++ doc/source/release-notes/Percona-Server-5.1.50-rel12.1.rst 2012-12-13 13:30:28 +0000
@@ -17,7 +17,7 @@
1717
18 * :ref:`innodb_buffer_pool_shm` - Implemented option :variable:`innodb_buffer_pool_shm_checksum`; when enabled, shared memory buffer pool is checksum validated. Bugs fixed: :bug:`643724`, :bug:`649408`, and :bug:`649393`. (*Yasufumi Kinoshita*)18 * :ref:`innodb_buffer_pool_shm` - Implemented option :variable:`innodb_buffer_pool_shm_checksum`; when enabled, shared memory buffer pool is checksum validated. Bugs fixed: :bug:`643724`, :bug:`649408`, and :bug:`649393`. (*Yasufumi Kinoshita*)
1919
20 * :ref:`innodb_expand_import_page` - Implemented more exact checking to avoid corruption of the ``.ibd`` file using :variable:`innodb_expand_export`. (*Yasufumi Kinoshita*)20 * :ref:`innodb_expand_import_page` - Implemented more exact checking to avoid corruption of the ``.ibd`` file using :variable:`innodb_expand_import`. (*Yasufumi Kinoshita*)
2121
22 * :ref:`mysql_remove_eol_carret` - Implemented a |MySQL| client option to handle end-of-line in BLOB fields differently. Bug fixed: :bug:`625066`. (*Sasha Pachev*)22 * :ref:`mysql_remove_eol_carret` - Implemented a |MySQL| client option to handle end-of-line in BLOB fields differently. Bug fixed: :bug:`625066`. (*Sasha Pachev*)
2323
2424
=== renamed file 'doc/source/reliability/innodb_recovery_update_relay_log.rst' => 'doc/source/reliability/crash_resistant_replication.rst'
--- doc/source/reliability/innodb_recovery_update_relay_log.rst 2012-06-13 10:52:23 +0000
+++ doc/source/reliability/crash_resistant_replication.rst 2012-12-13 13:30:28 +0000
@@ -59,7 +59,7 @@
5959
60.. variable:: innodb_overwrite_relay_log_info60.. variable:: innodb_overwrite_relay_log_info
6161
62 :version 5.5.10-20.1: Renamed.62 :version 1.0.3-4: Introduced
63 :cli: Yes63 :cli: Yes
64 :conf: Yes64 :conf: Yes
65 :scope: Global65 :scope: Global
6666
=== modified file 'doc/source/reliability/error_pad.rst'
--- doc/source/reliability/error_pad.rst 2011-10-07 00:55:06 +0000
+++ doc/source/reliability/error_pad.rst 2012-12-13 13:30:28 +0000
@@ -51,5 +51,5 @@
51Version-Specific Information51Version-Specific Information
52============================52============================
5353
54 * 5.1.49-12.0:54 * :rn:`5.1.49-rel12.0`
55 Full functionality available.55 Full functionality available.
5656
=== modified file 'doc/source/reliability/log_connection_error.rst'
--- doc/source/reliability/log_connection_error.rst 2011-10-07 00:55:06 +0000
+++ doc/source/reliability/log_connection_error.rst 2012-12-13 13:30:28 +0000
@@ -10,5 +10,5 @@
10Version-Specific Information10Version-Specific Information
11============================11============================
1212
13 * 5.1.49-12.0:13 * :rn:`5.1.49-rel12.0`
14 Full functionality available.14 Full functionality available.
1515
=== modified file 'doc/source/reliability/show_slave_status_nolock.rst'
--- doc/source/reliability/show_slave_status_nolock.rst 2012-09-03 09:31:43 +0000
+++ doc/source/reliability/show_slave_status_nolock.rst 2012-12-13 13:30:28 +0000
@@ -21,5 +21,4 @@
21Version Specific Information21Version Specific Information
22============================22============================
2323
24 * 5.1.52-12.3:24 * :rn:`5.1.52-12.3` - Introduced
25 Currently only the source code is distributed; the feature is not included in binaries.
2625
=== modified file 'doc/source/scalability/innodb_extra_rseg.rst'
--- doc/source/scalability/innodb_extra_rseg.rst 2012-05-29 17:18:20 +0000
+++ doc/source/scalability/innodb_extra_rseg.rst 2012-12-13 13:30:28 +0000
@@ -10,7 +10,9 @@
1010
11Some write-intensive workloads on boxes with many CPUs have scalability problems. The contention is caused by the rollback segment, which is single: all transactions are serialized when needing to access the segment. With this feature you can now create and use multiple segments (up to 256).11Some write-intensive workloads on boxes with many CPUs have scalability problems. The contention is caused by the rollback segment, which is single: all transactions are serialized when needing to access the segment. With this feature you can now create and use multiple segments (up to 256).
1212
13**NOTE**: This feature is incompatible with |InnoDB|. As long as a single rollback segment is used, there is no problem; the database can still be used by both |XtraDB| and |InnoDB|. However, creating multiple rollback segments will cause an internal format change to the system tablespace. Once multiple segments have been created, the database will no longer be compatible with |InnoDB|.13.. note::
14
15 This feature is incompatible with |InnoDB|. As long as a single rollback segment is used, there is no problem; the database can still be used by both |XtraDB| and |InnoDB|. However, creating multiple rollback segments will cause an internal format change to the system tablespace. Once multiple segments have been created, the database will no longer be compatible with |InnoDB|.
1416
1517
16System Variables18System Variables
@@ -40,8 +42,6 @@
4042
41The result should be the number of extra segments + 1 (as a default single segment always exists).43The result should be the number of extra segments + 1 (as a default single segment always exists).
4244
43 This variable has been removed from |Percona Server| 5.5.11-20.2 because an equivalent variable, ``innodb_rollback_segment``, has been implemented in |MySQL| 5.5.
44
4545
46``INFORMATION_SCHEMA`` Tables46``INFORMATION_SCHEMA`` Tables
47=============================47=============================
4848
=== modified file 'doc/source/scalability/innodb_io.rst'
--- doc/source/scalability/innodb_io.rst 2012-10-05 10:57:57 +0000
+++ doc/source/scalability/innodb_io.rst 2012-12-13 13:30:28 +0000
@@ -36,7 +36,7 @@
3636
37.. variable:: innodb_adaptive_checkpoint37.. variable:: innodb_adaptive_checkpoint
3838
39 :version: 5.1.54-12.5 Added 39 :version 5.1.54-12.5: Added
40 :cli: Yes40 :cli: Yes
41 :conf: Yes41 :conf: Yes
42 :scope: Global42 :scope: Global
@@ -109,7 +109,7 @@
109109
110.. variable:: innodb_flush_log_at_trx_commit_session110.. variable:: innodb_flush_log_at_trx_commit_session
111111
112 :version: 5.1.49-13 Added112 :version 5.1.49-rel11.3: Added
113 :cli: Yes113 :cli: Yes
114 :conf: Yes114 :conf: Yes
115 :scope: Global115 :scope: Global

Subscribers

People subscribed via source and target branches