Merge lp:~hrvojem/percona-server/bug949030-5.5 into lp:percona-server/5.5

Proposed by Hrvoje Matijakovic
Status: Merged
Approved by: Alexey Kopytov
Approved revision: no longer in the source branch.
Merged at revision: 222
Proposed branch: lp:~hrvojem/percona-server/bug949030-5.5
Merge into: lp:percona-server/5.5
Diff against target: 55 lines (+20/-2)
2 files modified
doc/source/diagnostics/misc_info_schema_tables.rst (+4/-2)
doc/source/scalability/innodb_io_55.rst (+16/-0)
To merge this branch: bzr merge lp:~hrvojem/percona-server/bug949030-5.5
Reviewer Review Type Date Requested Status
Alexey Kopytov (community) Approve
Review via email: mp+96756@code.launchpad.net
To post a comment you must log in.
Revision history for this message
Alexey Kopytov (akopytov) wrote :

INFORMATION_SCHEMA.GLOBAL_TEMPORARY_TABLES also shows internal temporary tables created by ALTER TABLES (but not those created to process complex queries).

Revision history for this message
Alexey Kopytov (akopytov) :
review: Needs Fixing
Revision history for this message
Alexey Kopytov (akopytov) :
review: Approve

Preview Diff

[H/L] Next/Prev Comment, [J/K] Next/Prev File, [N/P] Next/Prev Hunk
=== modified file 'doc/source/diagnostics/misc_info_schema_tables.rst'
--- doc/source/diagnostics/misc_info_schema_tables.rst 2011-10-07 23:38:41 +0000
+++ doc/source/diagnostics/misc_info_schema_tables.rst 2012-03-12 08:07:19 +0000
@@ -4,7 +4,7 @@
4 Misc. INFORMATION_SCHEMA Tables4 Misc. INFORMATION_SCHEMA Tables
5=================================5=================================
66
7This page lists the ``INFORMATION_SCHEMA`` tables added to standard |MySQL| by |Percona Server| that don``t exist elsewhere in the documentation.7This page lists the ``INFORMATION_SCHEMA`` tables added to standard |MySQL| by |Percona Server| that don't exist elsewhere in the documentation.
88
9Compressed pages in |InnoDB| tables9Compressed pages in |InnoDB| tables
10===================================10===================================
@@ -93,13 +93,15 @@
93 :column TRX_MYSQL_THREAD_ID: Thread id93 :column TRX_MYSQL_THREAD_ID: Thread id
94 :column TRX_QUERY: SQL query being executed94 :column TRX_QUERY: SQL query being executed
9595
96This table holds information on every transaction running in the |InnoDB| kernel. Contrary to the output of SHOW |InnoDB| STATUS, it doesn``t show information on idle transactions.96This table holds information on every transaction running in the |InnoDB| kernel. Contrary to the output of SHOW |InnoDB| STATUS, it doesn't show information on idle transactions.
9797
98This table was introduced by the |InnoDB| plugin and you can find the full documentation here.98This table was introduced by the |InnoDB| plugin and you can find the full documentation here.
9999
100Temporary tables100Temporary tables
101================101================
102102
103 Only the temporary tables that were explicitly created with `CREATE TEMPORARY TABLE` or `ALTER TABLE` are shown, and not the ones created to process complex queries.
104
103.. table:: INFORMATION_SCHEMA.GLOBAL_TEMPORARY_TABLES105.. table:: INFORMATION_SCHEMA.GLOBAL_TEMPORARY_TABLES
104106
105 :column SESSION_ID: |MySQL| connection id107 :column SESSION_ID: |MySQL| connection id
106108
=== modified file 'doc/source/scalability/innodb_io_55.rst'
--- doc/source/scalability/innodb_io_55.rst 2012-02-24 09:51:35 +0000
+++ doc/source/scalability/innodb_io_55.rst 2012-03-12 08:07:19 +0000
@@ -219,6 +219,22 @@
219219
220If ``innodb_use_global_flush_log_at_trx_commit=1`` (True), the user session will use the current value of ``innodb_flush_log_at_trx_commit``, and the user cannot reset the value of the global variable using a ``SET`` command.220If ``innodb_use_global_flush_log_at_trx_commit=1`` (True), the user session will use the current value of ``innodb_flush_log_at_trx_commit``, and the user cannot reset the value of the global variable using a ``SET`` command.
221221
222.. variable:: innodb_log_file_size
223
224 :version 5.5.8-20.0: Introduced
225 :cli: Yes
226 :conf: Yes
227 :scope: Global
228 :dyn: No
229 :type: Numeric
230 :default: 5242880
231 :range: 1048576 .. 4294967295
232
233In upstream |MySQL| the limit for the combined size of log files must be less than 4GB. But in Percona Server it is:
234 * on 32-bit systems: individual log file limit is 4 GB and total log file size limit is 4 GB, i.e. the same as in the upstream server.
235 * on 64-bit systems: both individual log files and total log file size are practically unlimited (the limit is 2^63 - 1 bytes which is 8+ million TB).
236
237
222Status Variables238Status Variables
223----------------239----------------
224240

Subscribers

People subscribed via source and target branches