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

Proposed by Hrvoje Matijakovic on 2012-09-14
Status: Merged
Approved by: Laurynas Biveinis on 2012-09-25
Approved revision: 478
Merged at revision: 482
Proposed branch: lp:~hrvojem/percona-server/bug1034305-5.1
Merge into: lp:percona-server/5.1
Diff against target: 136 lines (+56/-29)
4 files modified
doc/source/diagnostics/slow_extended.rst (+33/-11)
doc/source/installation/apt_repo.rst (+7/-9)
doc/source/installation/yum_repo.rst (+9/-6)
doc/source/performance/innodb_thread_concurrency_timer_based.rst (+7/-3)
To merge this branch: bzr merge lp:~hrvojem/percona-server/bug1034305-5.1
Reviewer Review Type Date Requested Status
Laurynas Biveinis (community) 2012-09-14 Approve on 2012-09-25
Review via email: mp+124424@code.launchpad.net
To post a comment you must log in.

The optimizer_fix documention is void of any actual description.

review: Needs Fixing
Alexey Kopytov (akopytov) wrote :

Let's remove optimizer_fix and wait for someone to scream? In the extremely unlikely case someone is actually using it, we can put it back after getting some explanations.

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/slow_extended.rst'
2--- doc/source/diagnostics/slow_extended.rst 2012-05-29 18:31:23 +0000
3+++ doc/source/diagnostics/slow_extended.rst 2012-09-17 07:39:21 +0000
4@@ -284,20 +284,42 @@
5
6 # User@Host: mailboxer[mailboxer] @ [192.168.10.165]
7 # Thread_id: 11167745 Schema: board
8- # QC_Hit: No Full_scan: No Full_join: No Tmp_table: Yes Disk_tmp_table: No
9- # Filesort: Yes Disk_filesort: No Merge_passes: 0
10- # Query_time: 0.000659 Lock_time: 0.000070 Rows_sent: 0 Rows_examined: 30 Rows_affected: 0 Rows_read: 30
11- # innodb_IO_r_ops: 1 innodb_IO_r_bytes: 16384 innodb_IO_r_wait: 0.028487
12- # innodb_rec_lock_wait: 0.000000 innodb_queue_wait: 0.000000
13- # innodb_pages_distinct: 5
14- select count(distinct author_id) from art87.article87 force index (forum_id) where forum_id = 240215 and thread_id = ``710575``
15+ # Query_time: 1.009400 Lock_time: 0.000190 Rows_sent: 4 Rows_examined: 1543719 Rows_affected: 0 Rows_read: 4
16+ # Bytes_sent: 278 Tmp_tables: 0 Tmp_disk_tables: 0 Tmp_table_sizes: 0
17+ # InnoDB_trx_id: 1500
18+ # QC_Hit: No Full_scan: Yes Full_join: No Tmp_table: No Tmp_table_on_disk: No
19+ # Filesort: No Filesort_on_disk: No Merge_passes: 0
20+ # InnoDB_IO_r_ops: 6415 InnoDB_IO_r_bytes: 105103360 InnoDB_IO_r_wait: 0.001279
21+ # InnoDB_rec_lock_wait: 0.000000 InnoDB_queue_wait: 0.000000
22+ # InnoDB_pages_distinct: 6430
23+ SET timestamp=1346844943;
24+ SELECT id,title,production_year FROM title WHERE title = 'Bambi';
25
26 Another example (:variable:`log_slow_verbosity` ``=profiling``): ::
27
28- # Query_time: 4.555235 Lock_time: 0.000000 Rows_sent: 1 Rows_examined: 0 Rows_affected: 0 Rows_read: 1
29- # Profile_starting: 4.554799 Profile_starting_cpu: 0.000000 Profile_checking_permissions: 0.000095 Profile_checking_permissions_cpu: 0.000000 Profile_Opening_tables: 0.000088 Profile_Opening_tables_cpu: 0.000000 Profile_init: 0.000056 Profile_init_cpu: 0.000000 Profile_optimizing: 0.000046 Profile_optimizing_cpu: 0.000000 Profile_executing: 0.000098 Profile_executing_cpu: 0.000000 Profile_end: 0.000049 Profile_end_cpu: 0.000000 Profile_query_end: 0.000045 Profile_query_end_cpu: 0.000000 Profile_freeing_items: 0.000084 Profile_freeing_items_cpu: 0.000000 Profile_logging_slow_query: 0.000045 Profile_logging_slow_query_cpu: 0.000000
30- # Profile_total: 4.555405 Profile_total_cpu: 0.000000
31- insert into teee4 select * from teee4 limit 10000000;
32+ # Query_time: 0.962742 Lock_time: 0.000202 Rows_sent: 4 Rows_examined: 1543719 Rows_affected: 0 Rows_read: 4
33+ # Bytes_sent: 278 Tmp_tables: 0 Tmp_disk_tables: 0 Tmp_table_sizes: 0
34+ # Profile_starting: 0.000030 Profile_starting_cpu: 0.000028 Profile_Waiting_for_query_cache_lock: 0.000003
35+ Profile_Waiting_for_query_cache_lock_cpu: 0.000003 Profile_Waiting_on_query_cache_mutex: 0.000003
36+ Profile_Waiting_on_query_cache_mutex_cpu: 0.000003 Profile_checking_query_cache_for_query: 0.000076
37+ Profile_checking_query_cache_for_query_cpu: 0.000076 Profile_checking_permissions: 0.000011
38+ Profile_checking_permissions_cpu: 0.000011 Profile_Opening_tables: 0.000078 Profile_Opening_tables_cpu: 0.000078
39+ Profile_System_lock: 0.000022 Profile_System_lock_cpu: 0.000022 Profile_Waiting_for_query_cache_lock: 0.000003
40+ Profile_Waiting_for_query_cache_lock_cpu: 0.000002 Profile_Waiting_on_query_cache_mutex: 0.000054
41+ Profile_Waiting_on_query_cache_mutex_cpu: 0.000054 Profile_init: 0.000039 Profile_init_cpu: 0.000040
42+ Profile_optimizing: 0.000015 Profile_optimizing_cpu: 0.000014 Profile_statistics: 0.000021 Profile_statistics_cpu: 0.000021
43+ Profile_preparing: 0.000020 Profile_preparing_cpu: 0.000020 Profile_executing: 0.000003 Profile_executing_cpu: 0.000003
44+ Profile_Sending_data: 0.962324 Profile_Sending_data_cpu: 0.961526 Profile_end: 0.000006 Profile_end_cpu: 0.000005
45+ Profile_query_end: 0.000004 Profile_query_end_cpu: 0.000004 Profile_closing_tables: 0.000008 Profile_closing_tables_cpu: 0.000008
46+ Profile_freeing_items: 0.000007 Profile_freeing_items_cpu: 0.000007 Profile_Waiting_for_query_cache_lock: 0.000000
47+ Profile_Waiting_for_query_cache_lock_cpu: 0.000001 Profile_Waiting_on_query_cache_mutex: 0.000001
48+ Profile_Waiting_on_query_cache_mutex_cpu: 0.000001 Profile_freeing_items: 0.000017 Profile_freeing_items_cpu: 0.000016
49+ Profile_Waiting_for_query_cache_lock: 0.000001 Profile_Waiting_for_query_cache_lock_cpu: 0.000001
50+ Profile_Waiting_on_query_cache_mutex: 0.000000 Profile_Waiting_on_query_cache_mutex_cpu: 0.000001
51+ Profile_freeing_items: 0.000001 Profile_freeing_items_cpu: 0.000001 Profile_storing_result_in_query_cache: 0.000002
52+ Profile_storing_result_in_query_cache_cpu: 0.000002 Profile_logging_slow_query: 0.000001 Profile_logging_slow_query_cpu: 0.000001
53+ # Profile_total: 0.962751 Profile_total_cpu: 0.961950
54+ # InnoDB_trx_id: 1700
55
56 Connection and Schema Identifier
57 --------------------------------
58
59=== modified file 'doc/source/installation/apt_repo.rst'
60--- doc/source/installation/apt_repo.rst 2012-05-29 17:18:20 +0000
61+++ doc/source/installation/apt_repo.rst 2012-09-17 07:39:21 +0000
62@@ -42,15 +42,13 @@
63 * 11.10 (oneiric)
64 * 12.04LTS (precise)
65
66-
67-Release Candidate Repository
68-============================
69-
70-To subscribe to the release candidate repository, add two lines to the :file:`/etc/apt/sources.list` file, again replacing ``VERSION`` with your server's release version: ::
71-
72- deb http://repo.percona.com/apt-rc VERSION main
73- deb-src http://repo.percona.com/apt-rc VERSION main
74-
75+Percona `apt` Experimental repository
76+=====================================
77+
78+Percona offers fresh beta builds from the experimental repository. To enable it add the following lines to your :file:`/etc/apt/sources.list` , replacing ``VERSION`` with the name of your distribution: ::
79+
80+ deb http://repo.percona.com/apt VERSION main experimental
81+ deb-src http://repo.percona.com/apt VERSION main experimental
82
83 Apt-Pinning the packages
84 ========================
85
86=== modified file 'doc/source/installation/yum_repo.rst'
87--- doc/source/installation/yum_repo.rst 2012-01-09 04:33:49 +0000
88+++ doc/source/installation/yum_repo.rst 2012-09-17 07:39:21 +0000
89@@ -73,9 +73,12 @@
90
91 * *Amazon Linux AMI* (works the same as *CentOS* 5)
92
93-Release Candidate Repository
94-============================
95-
96-To subscribe to the release candidate repository, install the release candidate (RC) *RPM*: ::
97-
98- rpm -Uhv http://www.percona.com/downloads/percona-release/percona-rc-0.0-2.x86_64.rpm
99+Percona `yum` Experimental repository
100+=====================================
101+
102+Percona offers fresh beta builds from the experimental repository. To subscribe to the experimental repository, install the experimental *RPM*: ::
103+
104+ rpm -Uhv http://repo.percona.com/testing/centos/6/os/noarch/percona-testing-0.0-1.noarch.rpm
105+
106+.. note::
107+ This repository works for both RHEL/CentOS 5 and RHEL/CentOS 6
108
109=== modified file 'doc/source/performance/innodb_thread_concurrency_timer_based.rst'
110--- doc/source/performance/innodb_thread_concurrency_timer_based.rst 2011-10-07 00:55:06 +0000
111+++ doc/source/performance/innodb_thread_concurrency_timer_based.rst 2012-09-17 07:39:21 +0000
112@@ -4,6 +4,8 @@
113 InnoDB timer-based Concurrency Throttling
114 ===========================================
115
116+If the variable :variable:`innodb_thread_concurrency_timer_based` has been set to ``TRUE``, lock-free timer-based |InnoDB| method of handling thread concurrency will be used instead of original mutex-based method.
117+
118 System Variables
119 ================
120
121@@ -11,10 +13,12 @@
122
123 :cli: Yes
124 :conf: Yes
125- :scope:
126- :dyn:
127+ :scope: Global
128+ :dyn: No
129 :vartype: BOOL
130 :default: FALSE
131 :range: TRUE/FALSE
132
133-Use |InnoDB| timer based concurrency throttling.
134+.. note::
135+ This feature depends on atomic op builtins being available.
136+

Subscribers

People subscribed via source and target branches