Merge lp:~hrvojem/percona-server/rn-5.5.27-28.0 into lp:percona-server/5.5
- rn-5.5.27-28.0
- Merge into 5.5
Proposed by
Hrvoje Matijakovic
Status: | Merged |
---|---|
Approved by: | Laurynas Biveinis |
Approved revision: | no longer in the source branch. |
Merged at revision: | 291 |
Proposed branch: | lp:~hrvojem/percona-server/rn-5.5.27-28.0 |
Merge into: | lp:percona-server/5.5 |
Diff against target: |
526 lines (+309/-52) 11 files modified
doc/source/conf.py (+1/-1) doc/source/diagnostics/index_info_schema_tables.rst (+1/-0) doc/source/diagnostics/misc_info_schema_tables.rst (+16/-0) doc/source/diagnostics/user_stats.rst (+6/-6) doc/source/index.rst (+3/-1) doc/source/management/expanded_program_option_modifiers.rst (+128/-0) doc/source/management/innodb_expanded_fast_index_creation.rst (+9/-9) doc/source/management/innodb_fast_index_creation.rst (+18/-0) doc/source/management/utility_user.rst (+86/-0) doc/source/percona-theme/layout.html (+3/-35) doc/source/release-notes/Percona-Server-5.5.27-28.0.rst (+38/-0) |
To merge this branch: | bzr merge lp:~hrvojem/percona-server/rn-5.5.27-28.0 |
Related bugs: | |
Related blueprints: |
Document the utility user feature
(Undefined)
|
Reviewer | Review Type | Date Requested | Status |
---|---|---|---|
Laurynas Biveinis (community) | Approve | ||
Review via email:
|
Commit message
Description of the change
To post a comment you must log in.
Revision history for this message
![](/+icing/build/overlay/assets/skins/sam/images/close.gif)
Laurynas Biveinis (laurynas-biveinis) wrote : | # |
review:
Needs Fixing
Revision history for this message
![](/+icing/build/overlay/assets/skins/sam/images/close.gif)
Laurynas Biveinis (laurynas-biveinis) : | # |
review:
Approve
Preview Diff
[H/L] Next/Prev Comment, [J/K] Next/Prev File, [N/P] Next/Prev Hunk
1 | === modified file 'doc/source/conf.py' |
2 | --- doc/source/conf.py 2012-07-18 08:43:52 +0000 |
3 | +++ doc/source/conf.py 2012-08-22 15:04:31 +0000 |
4 | @@ -54,7 +54,7 @@ |
5 | # The short X.Y version. |
6 | version = '5.5' |
7 | # The full version, including alpha/beta/rc tags. |
8 | -release = '5.5.25a-27.1' |
9 | +release = '5.5.27-28.0' |
10 | |
11 | # The language for content autogenerated by Sphinx. Refer to documentation |
12 | # for a list of supported languages. |
13 | |
14 | === modified file 'doc/source/diagnostics/index_info_schema_tables.rst' |
15 | --- doc/source/diagnostics/index_info_schema_tables.rst 2011-10-07 23:38:41 +0000 |
16 | +++ doc/source/diagnostics/index_info_schema_tables.rst 2012-08-22 15:04:31 +0000 |
17 | @@ -34,4 +34,5 @@ |
18 | |
19 | * :table:`TEMPORARY_TABLES` |
20 | |
21 | + * :table:`INNODB_UNDO_LOGS` |
22 | |
23 | |
24 | === modified file 'doc/source/diagnostics/misc_info_schema_tables.rst' |
25 | --- doc/source/diagnostics/misc_info_schema_tables.rst 2012-03-12 08:04:08 +0000 |
26 | +++ doc/source/diagnostics/misc_info_schema_tables.rst 2012-08-22 15:04:31 +0000 |
27 | @@ -133,3 +133,19 @@ |
28 | :column UPDATE_TIME: Date and time of the latest update of the temporary table |
29 | |
30 | This table holds information on the temporary tables existing for the running connection. |
31 | + |
32 | +InnoDB Undo Logs |
33 | +================ |
34 | + |
35 | +This table holds the undo segment information. |
36 | + |
37 | +.. table:: INFORMATION_SCHEMA.INNODB_UNDO_LOGS |
38 | + |
39 | + :column trx_id: Transaction ID |
40 | + :column rseg_id: Rollback segment ID |
41 | + :column useg_id: Undo segment ID |
42 | + :column type: Segment type |
43 | + :column state: Segment state |
44 | + :column size: Segment size |
45 | + |
46 | +Each row represents an individual undo segment and contains information about which rollback segment the undo segment is currently owned by, which transaction is currently using the undo segment, and other size and type information for the undo segment. This information is 'live' and calculated for each query of the table. |
47 | |
48 | === modified file 'doc/source/diagnostics/user_stats.rst' |
49 | --- doc/source/diagnostics/user_stats.rst 2012-05-21 16:25:24 +0000 |
50 | +++ doc/source/diagnostics/user_stats.rst 2012-08-22 15:04:31 +0000 |
51 | @@ -15,7 +15,7 @@ |
52 | * :rn:`5.5.10-20.1`: |
53 | Renamed variable :variable:`userstat_running` to :variable:`userstat`. |
54 | * :rn:`5.5.24-26.0`: |
55 | - TOTAL_CONNECTIONS_SSL column has been added to CLIENT_STATISTICS, THREAD_STATISTICS and USER_STATISTICS tables |
56 | + TOTAL_SSL_CONNECTIONS column has been added to CLIENT_STATISTICS, THREAD_STATISTICS and USER_STATISTICS tables |
57 | |
58 | Other Information |
59 | ================= |
60 | @@ -66,7 +66,7 @@ |
61 | :column LOST_CONNECTIONS: The number of this client's connections that were terminated uncleanly. |
62 | :column ACCESS_DENIED: The number of times this client's connections issued commands that were denied. |
63 | :column EMPTY_QUERIES: The number of times this client's connections sent empty queries to the server. |
64 | - :column TOTAL_CONNECTIONS_SSL: The number of times this client's connections connected using SSL to the server. |
65 | + :column TOTAL_SSL_CONNECTIONS: The number of times this client's connections connected using SSL to the server. |
66 | |
67 | |
68 | This table holds statistics about client connections. The Percona version of the feature restricts this table's visibility to users who have the ``SUPER`` or ``PROCESS`` privilege. |
69 | @@ -96,7 +96,7 @@ |
70 | LOST_CONNECTIONS: 0 |
71 | ACCESS_DENIED: 0 |
72 | EMPTY_QUERIES: 0 |
73 | - TOTAL_CONNECTIONS_SSL: 0 |
74 | + TOTAL_SSL_CONNECTIONS: 0 |
75 | |
76 | |
77 | .. table:: INFORMATION_SCHEMA.INDEX_STATISTICS |
78 | @@ -166,7 +166,7 @@ |
79 | :column LOST_CONNECTIONS: int(21) |
80 | :column ACCESS_DENIED: int(21) |
81 | :column EMPTY_QUERIES: int(21) |
82 | - :column TOTAL_CONNECTIONS_SSL: int(21) |
83 | + :column TOTAL_SSL_CONNECTIONS: int(21) |
84 | |
85 | .. table:: INFORMATION_SCHEMA.USER_STATISTICS |
86 | |
87 | @@ -191,7 +191,7 @@ |
88 | :column LOST_CONNECTIONS: The number of this user's connections that were terminated uncleanly. |
89 | :column ACCESS_DENIED: The number of times this user's connections issued commands that were denied. |
90 | :column EMPTY_QUERIES: The number of times this user's connections sent empty queries to the server. |
91 | - :column TOTAL_CONNECTIONS_SSL: The number of times this user's connections connected using SSL to the server. |
92 | + :column TOTAL_SSL_CONNECTIONS: The number of times this user's connections connected using SSL to the server. |
93 | |
94 | This table contains information about user activity. The |Percona| version of the patch restricts this table's visibility to users who have the ``SUPER`` or ``PROCESS`` privilege. |
95 | |
96 | @@ -222,7 +222,7 @@ |
97 | LOST_CONNECTIONS: 0 |
98 | ACCESS_DENIED: 0 |
99 | EMPTY_QUERIES: 0 |
100 | - TOTAL_CONNECTIONS_SSL: 0 |
101 | + TOTAL_SSL_CONNECTIONS: 0 |
102 | |
103 | |
104 | Commands Provided |
105 | |
106 | === modified file 'doc/source/index.rst' |
107 | --- doc/source/index.rst 2012-07-24 12:10:45 +0000 |
108 | +++ doc/source/index.rst 2012-08-22 15:04:31 +0000 |
109 | @@ -116,13 +116,15 @@ |
110 | management/innodb_expand_import |
111 | management/innodb_lru_dump_restore |
112 | management/innodb_fast_index_creation |
113 | - management/innodb_extended_fast_index_creation |
114 | + management/innodb_expanded_fast_index_creation |
115 | management/sql_no_fcache |
116 | management/udf_maatkit |
117 | management/innodb_fake_changes |
118 | management/innodb_kill_idle_trx |
119 | management/enforce_engine |
120 | + management/utility_user |
121 | management/secure_file_priv_extended |
122 | + management/expanded_program_option_modifiers |
123 | |
124 | Diagnostics Improvements |
125 | ======================== |
126 | |
127 | === added file 'doc/source/management/expanded_program_option_modifiers.rst' |
128 | --- doc/source/management/expanded_program_option_modifiers.rst 1970-01-01 00:00:00 +0000 |
129 | +++ doc/source/management/expanded_program_option_modifiers.rst 2012-08-22 15:04:31 +0000 |
130 | @@ -0,0 +1,128 @@ |
131 | +.. _expanded_option_modifiers: |
132 | + |
133 | +================================= |
134 | +Expanded Program Option Modifiers |
135 | +================================= |
136 | + |
137 | +|MySQL| has the concept of `options modifiers <http://dev.mysql.com/doc/refman/5.5/en/option-modifiers.html>`_ which is a simple way to modify either the way that |MySQL| interprets an option or the way the option behaves. Option modifiers are used by simply prepending the name of the modifier and a dash "-" before the actual configuration option name. For example specifying --maximum-query_cache_size=4M on the mysqld commad line or specifying maximum-query_cache_size=4M in the :file:`my.cnf` will prevent any client from setting the :variable:`query_cache_size` value larger than 4MB. |
138 | + |
139 | +Currently MySQL supports five existing option modifiers: |
140 | + * disable: disables or ignores option_name. |
141 | + * enable: enables option_name. |
142 | + * loose: mysqld will not exit with an error if it does not recognize option_name, but instead it will issue only a warning. |
143 | + * maximum: indicates that a client can not set the value of option_name greater than the limit specified. If the client does attempt to set the value of option_name greater than the limit, the option_name will simply be set to the defined limit. |
144 | + * skip: skips or ignores option_name. |
145 | + |
146 | +In order to offer more control over option visibility, access and range limits, the following new option modifiers have been added by |Percona Server|: |
147 | + * minimum [minimum-<option_name>=<value>] indicates that clients can not set the value of option_name to less than the limit specified. If the client does attempt to set the value of option_name lesser than the limit, the option_name will simply be set to the defined limit. |
148 | + * hidden [hidden-<option_name>=<TRUE/FALSE>] indicates that clients can not see or modify the value of option_name. |
149 | + * readonly [readonly-<option_name>=<TRUE/FALSE>] indicates that clients can see the value of option_name but can not modify the value. |
150 | + |
151 | + |
152 | +Version Specific Information |
153 | +============================ |
154 | + |
155 | + * :rn:`5.5.27-28.0` |
156 | + Expanded program option modifiers implemented |
157 | + |
158 | +Examples |
159 | +======== |
160 | + |
161 | +Adding the following option to the :file:`my.cnf` will set the minimum limit on :variable:`query_cache_size` :: |
162 | + |
163 | + minimum-query_cache_size = 4M |
164 | + |
165 | +Trying to set up bigger value will work correctly, but if we try to set it up with smaller than the limit, defined minimum limit will be used and warning (1292) will be issued: |
166 | + |
167 | +Initial :variable:`query_cache_size` size: |
168 | + |
169 | +.. code-block:: mysql |
170 | + |
171 | + mysql> show variables like 'query_cache_size'; |
172 | + +------------------+---------+ |
173 | + | Variable_name | Value | |
174 | + +------------------+---------+ |
175 | + | query_cache_size | 8388608 | |
176 | + +------------------+---------+ |
177 | + 1 row in set (0.00 sec) |
178 | + |
179 | +Setting up bigger value: |
180 | + |
181 | +.. code-block:: mysql |
182 | + |
183 | + mysql> set global query_cache_size=16777216; |
184 | + Query OK, 0 rows affected (0.00 sec) |
185 | + |
186 | + mysql> show variables like 'query_cache_size'; |
187 | + +------------------+----------+ |
188 | + | Variable_name | Value | |
189 | + +------------------+----------+ |
190 | + | query_cache_size | 16777216 | |
191 | + +------------------+----------+ |
192 | + 1 row in set (0.00 sec) |
193 | + |
194 | +Setting up smaller value: |
195 | + |
196 | +.. code-block:: mysql |
197 | + |
198 | + mysql> set global query_cache_size=1048576; |
199 | + Query OK, 0 rows affected, 1 warning (0.00 sec) |
200 | + |
201 | + mysql> show warnings; |
202 | + +---------+------+-------------------------------------------------------+ |
203 | + | Level | Code | Message | |
204 | + +---------+------+-------------------------------------------------------+ |
205 | + | Warning | 1292 | Truncated incorrect query_cache_size value: '1048576' | |
206 | + +---------+------+-------------------------------------------------------+ |
207 | + 1 row in set (0.00 sec) |
208 | + |
209 | + mysql> show variables like 'query_cache_size'; |
210 | + +------------------+---------+ |
211 | + | Variable_name | Value | |
212 | + +------------------+---------+ |
213 | + | query_cache_size | 4194304 | |
214 | + +------------------+---------+ |
215 | + 1 row in set (0.00 sec) |
216 | + |
217 | + |
218 | +Adding following option to :file:`my.cnf` will make :variable:`query_cache_size` hidden. :: |
219 | + |
220 | + hidden-query_cache_size=1 |
221 | + |
222 | +.. code-block:: mysql |
223 | + |
224 | + mysql> show variables like 'query_cache%'; |
225 | + +------------------------------+---------+ |
226 | + | Variable_name | Value | |
227 | + +------------------------------+---------+ |
228 | + | query_cache_limit | 1048576 | |
229 | + | query_cache_min_res_unit | 4096 | |
230 | + | query_cache_strip_comments | OFF | |
231 | + | query_cache_type | ON | |
232 | + | query_cache_wlock_invalidate | OFF | |
233 | + +------------------------------+---------+ |
234 | + 5 rows in set (0.00 sec) |
235 | + |
236 | +Adding following option to :file:`my.cnf` will make :variable:`query_cache_size` read-only :: |
237 | + |
238 | + readonly-query_cache_size=1 |
239 | + |
240 | +Trying to change the variable value will result in error: |
241 | + |
242 | +.. code-block:: mysql |
243 | + |
244 | + mysql> show variables like 'query_cache%'; |
245 | + +------------------------------+---------+ |
246 | + | Variable_name | Value | |
247 | + +------------------------------+---------+ |
248 | + | query_cache_limit | 1048576 | |
249 | + | query_cache_min_res_unit | 4096 | |
250 | + | query_cache_size | 8388608 | |
251 | + | query_cache_strip_comments | OFF | |
252 | + | query_cache_type | ON | |
253 | + | query_cache_wlock_invalidate | OFF | |
254 | + +------------------------------+---------+ |
255 | + 6 rows in set (0.00 sec) |
256 | + |
257 | + mysql> set global query_cache_size=16777216; |
258 | + ERROR 1238 (HY000): Variable 'query_cache_size' is a read only variable |
259 | |
260 | === renamed file 'doc/source/management/innodb_extended_fast_index_creation.rst' => 'doc/source/management/innodb_expanded_fast_index_creation.rst' |
261 | --- doc/source/management/innodb_extended_fast_index_creation.rst 2012-01-30 16:36:39 +0000 |
262 | +++ doc/source/management/innodb_expanded_fast_index_creation.rst 2012-08-22 15:04:31 +0000 |
263 | @@ -1,12 +1,12 @@ |
264 | -.. _extended_innodb_fast_index_creation: |
265 | - |
266 | -============================ |
267 | -Extended Fast Index Creation |
268 | -============================ |
269 | - |
270 | -Percona has implemented several changes related to |MySQL|'s fast index creation feature. This feature extends the ``ALTER TABLE`` command by adding a new clause that provides online index renaming capability, that is renaming indexes without rebuilding the whole table. |
271 | - |
272 | -Enabling Extended Fast Index Creation |
273 | +.. _expanded_innodb_fast_index_creation: |
274 | + |
275 | +============================ |
276 | +Expanded Fast Index Creation |
277 | +============================ |
278 | + |
279 | +Percona has implemented several changes related to |MySQL|'s fast index creation feature. This feature expands the ``ALTER TABLE`` command by adding a new clause that provides online index renaming capability, that is renaming indexes without rebuilding the whole table. |
280 | + |
281 | +Enabling Expanded Fast Index Creation |
282 | ===================================== |
283 | |
284 | Fast index creation was implemented in |MySQL| as a way to speed up the process of adding or dropping indexes on tables with many rows. However, cases have been found in which fast index creation creates an inconsistency between |MySQL| and |InnoDB| data dictionaries. |
285 | |
286 | === modified file 'doc/source/management/innodb_fast_index_creation.rst' |
287 | --- doc/source/management/innodb_fast_index_creation.rst 2012-07-06 08:04:01 +0000 |
288 | +++ doc/source/management/innodb_fast_index_creation.rst 2012-08-22 15:04:31 +0000 |
289 | @@ -14,6 +14,11 @@ |
290 | This feature implements a session variable that disables fast index creation. This causes indexes to be created in the way they were created before fast index creation was implemented. While this is slower, it avoids the problem of data dictionary inconsistency between |MySQL| and |InnoDB|. |
291 | |
292 | |
293 | +Tunable buffer size for fast index creation |
294 | +=========================================== |
295 | + |
296 | +|Percona Server| supports tunable buffer size for fast index creation in |InnoDB|. This value was calculated based on the merge block size (which was hardcoded to 1 MB) and the minimum index record size. By adding the session variable :variable:`innodb_merge_sort_block_size` block size that is used in the merge sort can now be adjusted for better performance. |
297 | + |
298 | |
299 | Version Specific Information |
300 | ============================ |
301 | @@ -24,6 +29,8 @@ |
302 | * 5.5.11-21.2: |
303 | Expanded the applicability of fast index creation to :command:`mysqldump`, ``ALTER TABLE``, and ``OPTIMIZE TABLE``. |
304 | |
305 | + * 5.5.27-28.0 |
306 | + Variable :variable:`innodb_merge_sort_block_size` implemented. |
307 | |
308 | System Variables |
309 | ================ |
310 | @@ -38,8 +45,19 @@ |
311 | :default: ON |
312 | :range: ON/OFF |
313 | |
314 | +.. variable:: innodb_merge_sort_block_size |
315 | + |
316 | + :cli: Yes |
317 | + :conf: Yes |
318 | + :scope: Global |
319 | + :dyn: Yes |
320 | + :vartype: ULONG |
321 | + :default: 1048576 (1M) |
322 | + :range: 1048576 - 1073741824 (1G) |
323 | |
324 | Other Reading |
325 | ============= |
326 | |
327 | * `Thinking about running OPTIMIZE on your InnoDB Table? Stop! <http://www.mysqlperformanceblog.com/2010/12/09/thinking-about-running-optimize-on-your-innodb-table-stop/>`_ |
328 | + |
329 | + * `Building Indexes by Sorting In Innodb <http://www.mysqlperformanceblog.com/2012/06/19/building-indexes-by-sorting-in-innodb-aka-fast-index-creation/>`_ |
330 | |
331 | === added file 'doc/source/management/utility_user.rst' |
332 | --- doc/source/management/utility_user.rst 1970-01-01 00:00:00 +0000 |
333 | +++ doc/source/management/utility_user.rst 2012-08-22 15:04:31 +0000 |
334 | @@ -0,0 +1,86 @@ |
335 | +.. _psaas_utility_user: |
336 | + |
337 | +============== |
338 | + Utility user |
339 | +============== |
340 | + |
341 | +|Percona Server| has implemented ability to have a |MySQL| user who has system access to do administrative tasks but limited access to user schema. This feature is especially useful to those operating |MySQL| As A Service. |
342 | + |
343 | +This user has a mixed and special scope of abilities and protection: |
344 | + |
345 | + * Utility user will not appear in the mysql.user table and can not be modified by any other user, including root. |
346 | + |
347 | + * Utility user will not appear in USER_STATISTICS, CLIENT_STATISTICS or THREAD_STATISTICS tables. |
348 | + |
349 | + * Utility user's queries may appear in the general and slow logs. |
350 | + |
351 | + * Utility user doesn't have the ability create, modify, delete or see any schemas or data not specified (except for information_schema). |
352 | + |
353 | + * Utility user may modify all visible, non read-only system variables (see :ref:`expanded_option_modifiers` functionality). |
354 | + |
355 | + * Utility user may see, create, modify and delete other system users only if given access to the mysql schema. |
356 | + |
357 | + * Regular users may be granted proxy rights to the utility user but any attempt to impersonate the utility user will fail. The utility user may not be granted proxy rights on any regular user. For example running: GRANT PROXY ON utility_user TO regular_user; will not fail, but any actual attempt to impersonate as the utility user will fail. Running: `GRANT PROXY ON regular_user TO utility_user;` will fail when utility_user is an exact match or is more specific than than the utility user specified. |
358 | + |
359 | +When the server starts, it will note in the log output that the utility user exists and the schemas that it has access to. |
360 | + |
361 | +In order to have the ability for a special type of MySQL user, which will have a very limited and special amount of control over the system and can not be see or modified by any other user including the root user, three new options have been added. |
362 | + |
363 | +Option :variable:`utility_user` specifies the user which the system will create and recognize as the utility user. The host in the utility user specification follows conventions described in the `MySQL manual <http://dev.mysql.com/doc/refman/5.5/en/connection-access.html>`_, i.e. it allows wildcards and IP masks. Anonymous user names are not permitted to be used for the utility user name. |
364 | + |
365 | +This user must not be an exact match to any other user that exists in the mysql.user table. If the server detects that the user specified with this option exactly matches any user within the mysql.user table on start up, the server will report an error and shut down gracefully. If host name wildcards are used and a more specific user specification is identified on start up, the server will report a warning and continue. |
366 | + |
367 | + Example: :option:`--utility_user` =frank@% and frank@localhost exists within the mysql.user table. |
368 | + |
369 | +If a client attempts to create a MySQL user that matches this user specification exactly or if host name wildcards are used for the utility user and the user being created has the same name and a more specific host, the creation attempt will fail with an error. |
370 | + |
371 | + Example: :option:`--utility_user` =frank@% and CREATE USER 'frank@localhost'; |
372 | + |
373 | +As a result of these requirements, it is strongly recommended that a very unique user name and reasonably specific host be used and that any script or tools test that they are running within the correct user by executing 'SELECT CURRENT_USER()' and comparing the result against the known utility user. |
374 | + |
375 | +Option :variable:`utility_user_password` specifies the password for the utility user and MUST be specified or the server will shut down gracefully with an error. |
376 | + |
377 | + Example: :option:`--utility_user_password` =`Passw0rD`; |
378 | + |
379 | +Option :variable:`utility_user_schema_access` specifies the name(s) of the schema(s) that the utility user will have access to read write and modify. If a particular schema named here does not exist on start up it will be ignored. If a schema by the name of any of those listed in this option is created after the server is started, the utility user will have full access to it. |
380 | + |
381 | + Example: :option:`--utility_user_schema_access` =schema1,schema2,schema3 ; |
382 | + |
383 | +System Variables |
384 | +================ |
385 | + |
386 | +.. variable:: utility_user |
387 | + |
388 | + :version 5.5.27-28.0: Implemented |
389 | + :cli: No |
390 | + :conf: utility_user=<user@host> |
391 | + :scope: Global |
392 | + :dyn: No |
393 | + :vartype: String |
394 | + :default: NULL |
395 | + |
396 | +Specifies a MySQL user that will be added to the internal list of users and recognized as the utility user. |
397 | + |
398 | +.. variable:: utility_user_password |
399 | + |
400 | + :version 5.5.27-28.0: Implemented |
401 | + :cli: No |
402 | + :conf: utility_user_password=<password> |
403 | + :scope: Global |
404 | + :dyn: No |
405 | + :vartype: String |
406 | + :default: NULL |
407 | + |
408 | +Specifies the password required for the utility user. |
409 | + |
410 | +.. variable:: utility_user_schema_access |
411 | + |
412 | + :version 5.5.27-28.0: Implemented |
413 | + :cli: No |
414 | + :conf: utility_user_schema_access=<schema>,<schema>,<schema> |
415 | + :scope: Global |
416 | + :dyn: No |
417 | + :vartype: String |
418 | + :default: NULL |
419 | + |
420 | +Specifies the schemas that the utility user has access to in a comma delimited list. |
421 | |
422 | === modified file 'doc/source/percona-theme/layout.html' |
423 | --- doc/source/percona-theme/layout.html 2012-07-18 06:25:14 +0000 |
424 | +++ doc/source/percona-theme/layout.html 2012-08-22 15:04:31 +0000 |
425 | @@ -214,7 +214,7 @@ |
426 | <div class="searchlink"><a onmouseover="SEARCH.Open()"><img id="searchlink-anchor" src="http://s2.percona.com/ui-search.png" alt="" /></a></div> |
427 | <span class="inv"><![CDATA[<noindex>]]></span> |
428 | <div class="navicontainer"><div class="navi"> |
429 | - <span id="navilink-span-about-us" ><a id="navilink-a-about-us" href="/about-us/">About Us</a></span><span id="navilink-span-mysql-consulting" ><a id="navilink-a-mysql-consulting" href="/mysql-consulting/">Consulting</a></span><span id="navilink-span-support" ><a id="navilink-a-support" href="/mysql-support/">Support</a></span><span id="navilink-span-training" ><a id="navilink-a-training" href="/training/">Training</a></span><span id="navilink-span-development" ><a id="navilink-a-development" href="/development/">Development</a></span><span id="navilink-span-software" ><a id="navilink-a-software" href="/software/">Software</a></span><span id="navilink-span-events" ><a id="navilink-a-events" href="/live/">Events</a></span><span id="navilink-span-contact" ><a id="navilink-a-contact" href="/contact/">Contact Us</a></span> |
430 | + |
431 | </div></div> |
432 | |
433 | <span class="inv"><![CDATA[</noindex>]]></span> |
434 | @@ -329,39 +329,7 @@ |
435 | {%- endblock %} |
436 | <span class="inv"><!--[CDATA[<noindex-->]]></span> |
437 | <div id="submenus"> |
438 | - <div class="navi-dropdown" id="navi-dropdown-about-us"> |
439 | - <div class="navi-dropdown-header-l"><!-- //--></div> |
440 | - <div class="navi-dropdown-content"><div class="item"><a href="/about-us/our-mission/">Our Mission</a></div><div class="item"><a href="/about-us/why-percona/">Why Percona?</a></div><div class="item"><a href="/about-us/procedures/">Coordinating with Percona</a></div><div class="item"><a href="/about-us/customers/">Customers</a></div><div class="item"><a href="/webinars/">Webinars</a></div><div class="item"><a href="/about-us/mysql-case-studies/">MySQL Case Studies</a></div><div class="item"><a href="/about-us/our-team/">Our Team</a></div><div class="item"><a href="/about-us/books/">Our Books</a></div><div class="item"><a href="/about-us/blogs/">Our Blogs</a></div><div class="item"><a href="/about-us/mysql-white-papers/">MySQL White Papers</a></div><div class="item"><a href="/about-us/conferences/">Conferences</a></div><div class="item"><a href="/about-us/presentations/">Presentations</a></div><div class="item"><a href="/about-us/newsletters/">Newsletters</a></div><div class="item"><a href="/about-us/pressreleases/">Press Releases</a></div><div class="item"><a href="/about-us/careers/">Careers</a></div> </div> |
441 | - <div class="navi-dropdown-footer"><!-- //--></div> |
442 | - </div><div class="navi-dropdown" id="navi-dropdown-mysql-consulting"> |
443 | - <div class="navi-dropdown-header-l"><!-- //--></div> |
444 | - <div class="navi-dropdown-content"><div class="item"><a href="/mysql-consulting/overview/">MySQL Consulting Overview</a></div><div class="item"><a href="/mysql-consulting/prices/">MySQL Consulting Prices</a></div><div class="item"><a href="/mysql-consulting/architecture/">MySQL Architecture & Design</a></div><div class="item"><a href="/mysql-consulting/mysql-backups/">MySQL Backups</a></div><div class="item"><a href="/mysql-consulting/cloud-computing/">MySQL Cloud Solutions</a></div><div class="item"><a href="/mysql-consulting/cluster/">MySQL Cluster Consulting</a></div><div class="item"><a href="/mysql-consulting/data-warehousing/">MySQL Data Warehousing</a></div><div class="item"><a href="/mysql-consulting/data-recovery/">MySQL Data Recovery</a></div><div class="item"><a href="/mysql-consulting/high-availability/">MySQL High Availability</a></div><div class="item"><a href="/mysql-consulting/mysql-monitoring-graphing/">MySQL Monitoring & Graphing</a></div><div class="item"><a href="/mysql-consulting/mysql-onsite-consulting/">MySQL Onsite Consulting</a></div><div class="item"><a href="/mysql-consulting/performance-audit/">MySQL Performance Audit</a></div><div class="item"><a href="/mysql-consulting/remote-dba/">MySQL Remote DBA</a></div><div class="item"><a href="/mysql-consulting/mysql-replication/">MySQL Replication</a></div><div class="item"><a href="/mysql-consulting/upgrade/">MySQL Version Upgrades</a></div><div class="item"><a href="/mysql-consulting/24x7-emergency/">Emergency 24×7 Consulting</a></div><div class="item"><a href="/mysql-consulting/migration/">Migration to MySQL</a></div><div class="item"><a href="/drizzle-consulting/">Drizzle Consulting</a></div><div class="item"><a href="/mysql-consulting/sphinx/">Sphinx Consulting</a></div><div class="item"><a href="/mysql-consulting/drbd/">DRBD Consulting</a></div><div class="item"><a href="/mysql-consulting/memcached/">Memcached Consulting</a></div><div class="item"><a href="/mysql-consulting/other-services/">Other Consulting Services</a></div> </div> |
445 | - <div class="navi-dropdown-footer"><!-- //--></div> |
446 | - </div><div class="navi-dropdown" id="navi-dropdown-support"> |
447 | - <div class="navi-dropdown-header-l"><!-- //--></div> |
448 | - <div class="navi-dropdown-content"><div class="item"><a href="/mysql-support/">MySQL Support Overview</a></div><div class="item"><a href="/prices/mysql-support/">MySQL Support Prices</a></div><div class="item"><a href="/mysql-support/policies/">MySQL Support Policies</a></div><div class="item"><a href="/mysql-support/consulting-vs-support/">Consulting vs. Support</a></div><div class="item"><a href="https://customers.percona.com">Customer Portal Login</a></div> </div> |
449 | - <div class="navi-dropdown-footer"><!-- //--></div> |
450 | - </div><div class="navi-dropdown" id="navi-dropdown-training"> |
451 | - <div class="navi-dropdown-header-l"><!-- //--></div> |
452 | - <div class="navi-dropdown-content"><div class="item"><a href="/training/">MySQL Training Overview</a></div><div class="item"><a href="/prices/training/">MySQL Training Prices</a></div><div class="item"><a href="/training/classes/dba/">MySQL DBA Training</a></div><div class="item"><a href="/training/classes/developers/">MySQL Developer Training</a></div><div class="item"><a href="/training/classes/operations/">MySQL Operations Training</a></div><div class="item"><a href="/training/classes/innodb/">InnoDB & XtraDB Training</a></div><div class="item"><a href="/training/classes/custom-onsite/">Custom Onsite Training</a></div> </div> |
453 | - <div class="navi-dropdown-footer"><!-- //--></div> |
454 | - </div><div class="navi-dropdown" id="navi-dropdown-development"> |
455 | - <div class="navi-dropdown-header-l"><!-- //--></div> |
456 | - <div class="navi-dropdown-content"><div class="item"><a href="/development/mysql/">MySQL Development Overview</a></div><div class="item"><a href="/development/prices/">Custom Development Prices</a></div><div class="item"><a href="/development/maintenance/">MySQL Support Overview</a></div><div class="item"><a href="/development/benchmarking/">Custom Product Evaluation</a></div><div class="item"><a href="/development/maatkit/">Custom Maatkit Development</a></div><div class="item"><a href="/development/custom-tools/">Custom Tools Development</a></div> </div> |
457 | - <div class="navi-dropdown-footer"><!-- //--></div> |
458 | - </div><div class="navi-dropdown" id="navi-dropdown-software"> |
459 | - <div class="navi-dropdown-header-l"><!-- //--></div> |
460 | - <div class="navi-dropdown-content"><div class="item"><a href="/software/">Percona Software for MySQL</a></div><div class="item"><a href="/software/percona-server/">Percona Server with XtraDB</a></div><div class="item"><a href="/software/percona-xtradb-cluster/">Percona XtraDB Cluster</a></div><div class="item"><a href="/software/percona-xtrabackup/">Percona XtraBackup</a></div><div class="item"><a href="/software/mysql-innodb-data-recovery-tools/">Data Recovery Toolkit</a></div><div class="item"><a href="/software/percona-xtradb/">Percona XtraDB</a></div><div class="item"><a href="/software/percona-toolkit/">Percona Toolkit</a></div><div class="item"><a href="/software/percona-monitoring-plugins/">Percona Monitoring Plugins</a></div><div class="item"><a href="/prices/software/">Software Prices</a></div><div class="item"><a href="/downloads/">Downloads</a></div><div class="item"><a href="/software/repositories/">Repositories</a></div><div class="item"><a href="/software/documentation/">Documentation</a></div><div class="item"><a href="http://forum.percona.com">Forum</a></div><div class="item"><a href="http://groups.google.com/group/percona-discussion">Google Discussion</a></div><div class="item"><a href="https://launchpad.net/percona-server">Launchpad</a></div> </div> |
461 | - <div class="navi-dropdown-footer"><!-- //--></div> |
462 | - </div><div class="navi-dropdown" id="navi-dropdown-events"> |
463 | - <div class="navi-dropdown-header-r"><!-- //--></div> |
464 | - <div class="navi-dropdown-content"><div class="item"><a href="/live/nyc-2012/">New York 2012</a></div><div class="item"><a href="/live/london-2012/">London 2012</a></div><div class="item"><a href="/live/mysql-conference-2013/">MySQL Conference & Expo 2013</a></div><div class="item"><a href="/live/mysql-conference-2012/">MySQL Conference & Expo 2012</a></div><div class="item"><a href="/live/">Previous Percona Live Events</a></div> </div> |
465 | - <div class="navi-dropdown-footer"><!-- //--></div> |
466 | - </div><div class="navi-dropdown" id="navi-dropdown-contact"> |
467 | - <div class="navi-dropdown-header-r"><!-- //--></div> |
468 | - <div class="navi-dropdown-content"><div class="item"><a href="/contact/24x7-emergency/">24×7 Emergency</a></div><div class="item"><a href="/contact/sales/">Sales & General Inquiries</a></div><div class="item"><a href="/contact/billing/">Billing Inquiries</a></div><div class="item"><a href="https://customers.percona.com">Customer Portal Login</a></div><div class="item"><a href="/contact/phone-directory/">Phone Directory</a></div><div class="item"><a href="/subscribe/">Subscribe to Newsletter</a></div> </div> |
469 | - <div class="navi-dropdown-footer"><!-- //--></div> |
470 | - </div> |
471 | + |
472 | <div id="search-dropdown" class="search-dropdown"> |
473 | <div class="search-dropdown-header"><!-- //--></div> |
474 | <div class="search-dropdown-content"> |
475 | @@ -383,7 +351,7 @@ |
476 | <!-- /GA //--> |
477 | <!-- NAVI //--> |
478 | <script type="text/javascript">//<![CDATA[ |
479 | -var navi = [{id:"about-us", direction: "l"},{id:"mysql-consulting", direction: "l"},{id:"support", direction: "l"},{id:"training", direction: "l"},{id:"development", direction: "l"},{id:"software", direction: "l"},{id:"events", direction: "r"},{id:"contact", direction: "r"}]; |
480 | +var navi = []; |
481 | for(var i = 0, c = navi.length; i < c; i++) { |
482 | window.jQuery('#navilink-a-' + navi[i].id).bind('mouseover',{id: navi[i].id, direction:navi[i].direction}, function(e) { NAVI.Open(e.data.id, e.data.direction); } ); |
483 | } |
484 | |
485 | === added file 'doc/source/release-notes/Percona-Server-5.5.27-28.0.rst' |
486 | --- doc/source/release-notes/Percona-Server-5.5.27-28.0.rst 1970-01-01 00:00:00 +0000 |
487 | +++ doc/source/release-notes/Percona-Server-5.5.27-28.0.rst 2012-08-22 15:04:31 +0000 |
488 | @@ -0,0 +1,38 @@ |
489 | +.. rn:: 5.5.27-28.0 |
490 | + |
491 | +=============================== |
492 | + |Percona Server| 5.5.27-28.0 |
493 | +=============================== |
494 | + |
495 | +Percona is glad to announce the release of |Percona Server| 5.5.27-28.0 on August 23rd, 2012 (Downloads are available `here <http://www.percona.com/downloads/Percona-Server-5.5/Percona-Server-5.5.27-28.0/>`_ and from the `Percona Software Repositories <http://www.percona.com/docs/wiki/repositories:start>`_). |
496 | + |
497 | +Based on `MySQL 5.5.27 <http://dev.mysql.com/doc/refman/5.5/en/news-5-5-27.html>`_, including all the bug fixes in it, |Percona Server| 5.5.27-28.0 is now the current stable release in the 5.5 series. All of |Percona|'s software is open-source and free, all the details of the release can be found in the `5.5.27-28.0 milestone at Launchpad <https://launchpad.net/percona-server/+milestone/5.5.27-28.0>`_. |
498 | + |
499 | +Bug fix for bug :bug:`1007268` has been targeted for the next |Percona Server| release. Workaround for this bug exists and it's setting up the :variable:`innodb_lazy_drop_table` to 1. |
500 | + |
501 | +New Features |
502 | +============ |
503 | + |
504 | + * |Percona Server| supports tunable buffer size for fast index creation in |InnoDB|. This value was calculated based on the merge block size (which was hardcoded to 1 MB) and the minimum index record size. By adding the session variable :variable:`innodb_merge_sort_block_size` block size that is used in the merge sort can now be adjusted for better performance. |
505 | + |
506 | + * |Percona Server| has implemented ability to have a MySQL :ref:`psaas_utility_user` who has system access to do administrative tasks but limited access to user schema. This feature is especially useful to those operating MySQL As A Service. |
507 | + |
508 | + * New :ref:`expanded_option_modifiers` have been added to allow access control to system variables. |
509 | + |
510 | + * New table :table:`INNODB_UNDO_LOGS` has been added to allow access to undo segment information. Each row represents an individual undo segment and contains information about which rollback segment the undo segment is currently owned by, which transaction is currently using the undo segment, and other size and type information for the undo segment. This information is 'live' and calculated for each query of the table. |
511 | + |
512 | +Bug Fixes |
513 | +========= |
514 | + |
515 | + * Fixed incorrect merge of MySQL bug `#61188 <http://bugs.mysql.com/bug.php?id=61188>`_ fix which caused server to freeze with "has waited at buf0buf.c line 2529 for XXX seconds the semaphore" errors. This regression was introduced in |Percona Server| 5.5.23-25.3. Bug fixed :bug:`1026926` (*Stewart Smith*). |
516 | + |
517 | + * Fixed regression introduced in |Percona Server| 5.5.23-25.3 when merging the upstream fix for MySQL bug `#64284 <http://bugs.mysql.com/bug.php?id=64284>`_. Bug fixed :bug:`1015109` (*Stewart Smith*). |
518 | + |
519 | + * Fixed the upstream MySQL bug `#66301 <http://bugs.mysql.com/bug.php?id=66301>`_. Concurrent INSERT ... ON DUPLICATE KEY UPDATE statements on a table with an AUTO_INCREMENT column could result in spurious duplicate key errors (and, as a result, lost data due to some rows being updated rather than inserted) with the default value of innodb_autoinc_lock_mode=1. Bug fixed :bug:`1035225` (*Alexey Kopytov*). |
520 | + |
521 | + * Removed error log warnings that occured after enabling :variable:`innodb_use_sys_stats_table` and before ANALYZE TABLE is run for each table. Bug fixed :bug:`890623` (*Alexey Kopytov*). |
522 | + |
523 | + * Removed the unneeded lrusort.py script. The server now does this sorting automatically and has done for some time. Bug fixed :bug:`882653` (*Stewart Smith*). |
524 | + |
525 | + * Fixed the malformed CHANGE MASTER query in the output of ``mysqldump`` with :option:`--include-master-host-port` option. Bug fixed :bug:`1013432` (*Stewart Smith*). |
526 | + |
"...greater than value, the value of option_name will simply be set
to value." Too many "values". Likewise for minimum. Rename the
minumum/maximum "value" to something else.
Please "show warnings" output to the minimum value violation
example too.
Bug https:/ /bugs.launchpad .net/bugs/ 592377 is missing from the RN.
It should be added to the new features section.
For bugs 1026926 and 1015109 please say which version the
regression was introduced in.
For bug 1035225, please mention that this is MySQL and not Percona
Server specific bug, add the upstream bug link.
For bug 890623, more user-friendly description would be "Removed use_sys_ stats_table and before ANALYZE TABLE is run for each
error log warnings that occured after enabling
innodb_
table" or similar.
For bug 1013432, "Fixed the malformed CHANGE MASTER query in the
output of mysqldump..."