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

Proposed by Hrvoje Matijakovic on 2012-03-09
Status: Merged
Approved by: Alexey Kopytov on 2012-03-12
Approved revision: 222
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) 2012-03-09 Approve on 2012-03-12
Review via email: mp+96756@code.launchpad.net
To post a comment you must log in.
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).

Alexey Kopytov (akopytov) :
review: Needs Fixing
Alexey Kopytov (akopytov) :
review: Approve

Preview Diff

[H/L] Next/Prev Comment, [J/K] Next/Prev File, [N/P] Next/Prev Hunk
1=== modified file 'doc/source/diagnostics/misc_info_schema_tables.rst'
2--- doc/source/diagnostics/misc_info_schema_tables.rst 2011-10-07 23:38:41 +0000
3+++ doc/source/diagnostics/misc_info_schema_tables.rst 2012-03-12 08:07:19 +0000
4@@ -4,7 +4,7 @@
5 Misc. INFORMATION_SCHEMA Tables
6 =================================
7
8-This page lists the ``INFORMATION_SCHEMA`` tables added to standard |MySQL| by |Percona Server| that don``t exist elsewhere in the documentation.
9+This page lists the ``INFORMATION_SCHEMA`` tables added to standard |MySQL| by |Percona Server| that don't exist elsewhere in the documentation.
10
11 Compressed pages in |InnoDB| tables
12 ===================================
13@@ -93,13 +93,15 @@
14 :column TRX_MYSQL_THREAD_ID: Thread id
15 :column TRX_QUERY: SQL query being executed
16
17-This 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.
18+This 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.
19
20 This table was introduced by the |InnoDB| plugin and you can find the full documentation here.
21
22 Temporary tables
23 ================
24
25+ 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.
26+
27 .. table:: INFORMATION_SCHEMA.GLOBAL_TEMPORARY_TABLES
28
29 :column SESSION_ID: |MySQL| connection id
30
31=== modified file 'doc/source/scalability/innodb_io_55.rst'
32--- doc/source/scalability/innodb_io_55.rst 2012-02-24 09:51:35 +0000
33+++ doc/source/scalability/innodb_io_55.rst 2012-03-12 08:07:19 +0000
34@@ -219,6 +219,22 @@
35
36 If ``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.
37
38+.. variable:: innodb_log_file_size
39+
40+ :version 5.5.8-20.0: Introduced
41+ :cli: Yes
42+ :conf: Yes
43+ :scope: Global
44+ :dyn: No
45+ :type: Numeric
46+ :default: 5242880
47+ :range: 1048576 .. 4294967295
48+
49+In upstream |MySQL| the limit for the combined size of log files must be less than 4GB. But in Percona Server it is:
50+ * 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.
51+ * 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).
52+
53+
54 Status Variables
55 ----------------
56

Subscribers

People subscribed via source and target branches