Merge lp:~percona-dev/percona-server/5.1.54-fix-bug602047 into lp:percona-server/release-5.1.54-12
- 5.1.54-fix-bug602047
- Merge into 5.1.54
Proposed by
Yasufumi Kinoshita
Status: | Merged | ||||
---|---|---|---|---|---|
Merged at revision: | 195 | ||||
Proposed branch: | lp:~percona-dev/percona-server/5.1.54-fix-bug602047 | ||||
Merge into: | lp:percona-server/release-5.1.54-12 | ||||
Diff against target: |
525 lines (+62/-50) 16 files modified
innodb_adjust_defaults.patch (+4/-4) innodb_admin_command_base.patch (+1/-1) innodb_buffer_pool_shm.patch (+2/-2) innodb_extend_slow.patch (+4/-4) innodb_fast_checksum.patch (+2/-2) innodb_fast_shutdown.patch (+2/-2) innodb_files_extend.patch (+3/-3) innodb_fix_misc.patch (+1/-1) innodb_lru_dump_restore.patch (+2/-2) innodb_pass_corrupt_table.patch (+12/-12) innodb_purge_thread.patch (+2/-2) innodb_recovery_patches.patch (+2/-2) innodb_separate_doublewrite.patch (+2/-2) innodb_show_lock_name.patch (+4/-4) innodb_show_sys_tables.patch (+1/-1) innodb_stats.patch (+18/-6) |
||||
To merge this branch: | bzr merge lp:~percona-dev/percona-server/5.1.54-fix-bug602047 | ||||
Related bugs: |
|
Reviewer | Review Type | Date Requested | Status |
---|---|---|---|
Alexey Kopytov (community) | Approve | ||
Valentine Gostev (community) | qa | Approve | |
Percona developers | Pending | ||
Review via email: mp+48866@code.launchpad.net |
Commit message
Description of the change
To post a comment you must log in.
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
1 | === modified file 'innodb_adjust_defaults.patch' | |||
2 | --- innodb_adjust_defaults.patch 2010-12-16 11:35:26 +0000 | |||
3 | +++ innodb_adjust_defaults.patch 2011-02-08 02:15:10 +0000 | |||
4 | @@ -8,7 +8,7 @@ | |||
5 | 8 | diff -ruN a/storage/innodb_plugin/handler/ha_innodb.cc b/storage/innodb_plugin/handler/ha_innodb.cc | 8 | diff -ruN a/storage/innodb_plugin/handler/ha_innodb.cc b/storage/innodb_plugin/handler/ha_innodb.cc |
6 | 9 | --- a/storage/innodb_plugin/handler/ha_innodb.cc 2010-04-30 16:39:14.000000000 +0900 | 9 | --- a/storage/innodb_plugin/handler/ha_innodb.cc 2010-04-30 16:39:14.000000000 +0900 |
7 | 10 | +++ b/storage/innodb_plugin/handler/ha_innodb.cc 2010-04-30 16:43:26.000000000 +0900 | 10 | +++ b/storage/innodb_plugin/handler/ha_innodb.cc 2010-04-30 16:43:26.000000000 +0900 |
9 | 11 | @@ -11210,7 +11210,7 @@ | 11 | @@ -11215,7 +11215,7 @@ |
10 | 12 | static MYSQL_SYSVAR_ULONG(use_purge_thread, srv_use_purge_thread, | 12 | static MYSQL_SYSVAR_ULONG(use_purge_thread, srv_use_purge_thread, |
11 | 13 | PLUGIN_VAR_RQCMDARG | PLUGIN_VAR_READONLY, | 13 | PLUGIN_VAR_RQCMDARG | PLUGIN_VAR_READONLY, |
12 | 14 | "Number of purge devoted threads. #### over 1 is EXPERIMENTAL ####", | 14 | "Number of purge devoted threads. #### over 1 is EXPERIMENTAL ####", |
13 | @@ -17,7 +17,7 @@ | |||
14 | 17 | 17 | ||
15 | 18 | static MYSQL_SYSVAR_BOOL(overwrite_relay_log_info, innobase_overwrite_relay_log_info, | 18 | static MYSQL_SYSVAR_BOOL(overwrite_relay_log_info, innobase_overwrite_relay_log_info, |
16 | 19 | PLUGIN_VAR_NOCMDARG | PLUGIN_VAR_READONLY, | 19 | PLUGIN_VAR_NOCMDARG | PLUGIN_VAR_READONLY, |
18 | 20 | @@ -11310,7 +11310,7 @@ | 20 | @@ -11315,7 +11315,7 @@ |
19 | 21 | static MYSQL_SYSVAR_BOOL(adaptive_flushing, srv_adaptive_flushing, | 21 | static MYSQL_SYSVAR_BOOL(adaptive_flushing, srv_adaptive_flushing, |
20 | 22 | PLUGIN_VAR_NOCMDARG, | 22 | PLUGIN_VAR_NOCMDARG, |
21 | 23 | "Attempt flushing dirty pages to avoid IO bursts at checkpoints.", | 23 | "Attempt flushing dirty pages to avoid IO bursts at checkpoints.", |
22 | @@ -26,7 +26,7 @@ | |||
23 | 26 | 26 | ||
24 | 27 | static MYSQL_SYSVAR_ULONG(max_purge_lag, srv_max_purge_lag, | 27 | static MYSQL_SYSVAR_ULONG(max_purge_lag, srv_max_purge_lag, |
25 | 28 | PLUGIN_VAR_RQCMDARG, | 28 | PLUGIN_VAR_RQCMDARG, |
27 | 29 | @@ -11555,7 +11555,7 @@ | 29 | @@ -11560,7 +11560,7 @@ |
28 | 30 | static MYSQL_SYSVAR_ULONG(ibuf_active_contract, srv_ibuf_active_contract, | 30 | static MYSQL_SYSVAR_ULONG(ibuf_active_contract, srv_ibuf_active_contract, |
29 | 31 | PLUGIN_VAR_RQCMDARG, | 31 | PLUGIN_VAR_RQCMDARG, |
30 | 32 | "Enable/Disable active_contract of insert buffer. 0:disable 1:enable", | 32 | "Enable/Disable active_contract of insert buffer. 0:disable 1:enable", |
31 | @@ -35,7 +35,7 @@ | |||
32 | 35 | 35 | ||
33 | 36 | static MYSQL_SYSVAR_ULONG(ibuf_accel_rate, srv_ibuf_accel_rate, | 36 | static MYSQL_SYSVAR_ULONG(ibuf_accel_rate, srv_ibuf_accel_rate, |
34 | 37 | PLUGIN_VAR_RQCMDARG, | 37 | PLUGIN_VAR_RQCMDARG, |
36 | 38 | @@ -11635,8 +11635,8 @@ | 38 | @@ -11640,8 +11640,8 @@ |
37 | 39 | }; | 39 | }; |
38 | 40 | static MYSQL_SYSVAR_ENUM(adaptive_checkpoint, srv_adaptive_checkpoint, | 40 | static MYSQL_SYSVAR_ENUM(adaptive_checkpoint, srv_adaptive_checkpoint, |
39 | 41 | PLUGIN_VAR_RQCMDARG, | 41 | PLUGIN_VAR_RQCMDARG, |
40 | 42 | 42 | ||
41 | === modified file 'innodb_admin_command_base.patch' | |||
42 | --- innodb_admin_command_base.patch 2010-12-16 11:35:26 +0000 | |||
43 | +++ innodb_admin_command_base.patch 2011-02-08 02:15:10 +0000 | |||
44 | @@ -8,7 +8,7 @@ | |||
45 | 8 | diff -ruN a/storage/innodb_plugin/handler/ha_innodb.cc b/storage/innodb_plugin/handler/ha_innodb.cc | 8 | diff -ruN a/storage/innodb_plugin/handler/ha_innodb.cc b/storage/innodb_plugin/handler/ha_innodb.cc |
46 | 9 | --- a/storage/innodb_plugin/handler/ha_innodb.cc 2010-08-27 16:27:30.222410116 +0900 | 9 | --- a/storage/innodb_plugin/handler/ha_innodb.cc 2010-08-27 16:27:30.222410116 +0900 |
47 | 10 | +++ b/storage/innodb_plugin/handler/ha_innodb.cc 2010-08-27 16:27:44.073104773 +0900 | 10 | +++ b/storage/innodb_plugin/handler/ha_innodb.cc 2010-08-27 16:27:44.073104773 +0900 |
49 | 11 | @@ -11534,6 +11534,7 @@ | 11 | @@ -11539,6 +11539,7 @@ |
50 | 12 | i_s_innodb_cmpmem_reset, | 12 | i_s_innodb_cmpmem_reset, |
51 | 13 | i_s_innodb_table_stats, | 13 | i_s_innodb_table_stats, |
52 | 14 | i_s_innodb_index_stats, | 14 | i_s_innodb_index_stats, |
53 | 15 | 15 | ||
54 | === modified file 'innodb_buffer_pool_shm.patch' | |||
55 | --- innodb_buffer_pool_shm.patch 2010-12-16 11:35:26 +0000 | |||
56 | +++ innodb_buffer_pool_shm.patch 2011-02-08 02:15:10 +0000 | |||
57 | @@ -683,7 +683,7 @@ | |||
58 | 683 | 683 | ||
59 | 684 | #ifdef HAVE_LARGE_PAGES | 684 | #ifdef HAVE_LARGE_PAGES |
60 | 685 | if ((os_use_large_pages = (ibool) my_use_large_pages)) | 685 | if ((os_use_large_pages = (ibool) my_use_large_pages)) |
62 | 686 | @@ -11405,6 +11407,16 @@ | 686 | @@ -11410,6 +11412,16 @@ |
63 | 687 | "The size of the memory buffer InnoDB uses to cache data and indexes of its tables.", | 687 | "The size of the memory buffer InnoDB uses to cache data and indexes of its tables.", |
64 | 688 | NULL, NULL, 128*1024*1024L, 32*1024*1024L, LONGLONG_MAX, 1024*1024L); | 688 | NULL, NULL, 128*1024*1024L, 32*1024*1024L, LONGLONG_MAX, 1024*1024L); |
65 | 689 | 689 | ||
66 | @@ -700,7 +700,7 @@ | |||
67 | 700 | static MYSQL_SYSVAR_ULONG(commit_concurrency, innobase_commit_concurrency, | 700 | static MYSQL_SYSVAR_ULONG(commit_concurrency, innobase_commit_concurrency, |
68 | 701 | PLUGIN_VAR_RQCMDARG, | 701 | PLUGIN_VAR_RQCMDARG, |
69 | 702 | "Helps in performance tuning in heavily concurrent environments.", | 702 | "Helps in performance tuning in heavily concurrent environments.", |
71 | 703 | @@ -11680,6 +11692,8 @@ | 703 | @@ -11685,6 +11697,8 @@ |
72 | 704 | MYSQL_SYSVAR(additional_mem_pool_size), | 704 | MYSQL_SYSVAR(additional_mem_pool_size), |
73 | 705 | MYSQL_SYSVAR(autoextend_increment), | 705 | MYSQL_SYSVAR(autoextend_increment), |
74 | 706 | MYSQL_SYSVAR(buffer_pool_size), | 706 | MYSQL_SYSVAR(buffer_pool_size), |
75 | 707 | 707 | ||
76 | === modified file 'innodb_extend_slow.patch' | |||
77 | --- innodb_extend_slow.patch 2011-02-02 14:49:16 +0000 | |||
78 | +++ innodb_extend_slow.patch 2011-02-08 02:15:10 +0000 | |||
79 | @@ -428,7 +428,7 @@ | |||
80 | 428 | /*********************************************************************//** | 428 | /*********************************************************************//** |
81 | 429 | Construct ha_innobase handler. */ | 429 | Construct ha_innobase handler. */ |
82 | 430 | UNIV_INTERN | 430 | UNIV_INTERN |
84 | 431 | @@ -8940,6 +8976,25 @@ | 431 | @@ -8945,6 +8981,25 @@ |
85 | 432 | statement has ended */ | 432 | statement has ended */ |
86 | 433 | 433 | ||
87 | 434 | if (trx->n_mysql_tables_in_use == 0) { | 434 | if (trx->n_mysql_tables_in_use == 0) { |
88 | @@ -766,7 +766,7 @@ | |||
89 | 766 | 766 | ||
90 | 767 | if ((ulint)ret == n) { | 767 | if ((ulint)ret == n) { |
91 | 768 | 768 | ||
93 | 769 | @@ -3642,10 +3677,11 @@ | 769 | @@ -3642,10 +3676,11 @@ |
94 | 770 | (can be used to identify a completed | 770 | (can be used to identify a completed |
95 | 771 | aio operation); ignored if mode is | 771 | aio operation); ignored if mode is |
96 | 772 | OS_AIO_SYNC */ | 772 | OS_AIO_SYNC */ |
97 | @@ -779,7 +779,7 @@ | |||
98 | 779 | { | 779 | { |
99 | 780 | os_aio_array_t* array; | 780 | os_aio_array_t* array; |
100 | 781 | os_aio_slot_t* slot; | 781 | os_aio_slot_t* slot; |
102 | 782 | @@ -3687,8 +3723,8 @@ | 782 | @@ -3687,8 +3722,8 @@ |
103 | 783 | wait in the Windows case. */ | 783 | wait in the Windows case. */ |
104 | 784 | 784 | ||
105 | 785 | if (type == OS_FILE_READ) { | 785 | if (type == OS_FILE_READ) { |
106 | @@ -790,7 +790,7 @@ | |||
107 | 790 | } | 790 | } |
108 | 791 | 791 | ||
109 | 792 | ut_a(type == OS_FILE_WRITE); | 792 | ut_a(type == OS_FILE_WRITE); |
111 | 793 | @@ -3721,6 +3757,11 @@ | 793 | @@ -3721,6 +3756,11 @@ |
112 | 794 | ut_error; | 794 | ut_error; |
113 | 795 | } | 795 | } |
114 | 796 | 796 | ||
115 | 797 | 797 | ||
116 | === modified file 'innodb_fast_checksum.patch' | |||
117 | --- innodb_fast_checksum.patch 2010-12-16 11:35:26 +0000 | |||
118 | +++ innodb_fast_checksum.patch 2011-02-08 02:15:10 +0000 | |||
119 | @@ -178,7 +178,7 @@ | |||
120 | 178 | 178 | ||
121 | 179 | #ifdef HAVE_LARGE_PAGES | 179 | #ifdef HAVE_LARGE_PAGES |
122 | 180 | if ((os_use_large_pages = (ibool) my_use_large_pages)) | 180 | if ((os_use_large_pages = (ibool) my_use_large_pages)) |
124 | 181 | @@ -11105,6 +11107,15 @@ | 181 | @@ -11110,6 +11112,15 @@ |
125 | 182 | "Disable with --skip-innodb-checksums.", | 182 | "Disable with --skip-innodb-checksums.", |
126 | 183 | NULL, NULL, TRUE); | 183 | NULL, NULL, TRUE); |
127 | 184 | 184 | ||
128 | @@ -194,7 +194,7 @@ | |||
129 | 194 | static MYSQL_SYSVAR_STR(data_home_dir, innobase_data_home_dir, | 194 | static MYSQL_SYSVAR_STR(data_home_dir, innobase_data_home_dir, |
130 | 195 | PLUGIN_VAR_READONLY, | 195 | PLUGIN_VAR_READONLY, |
131 | 196 | "The common part for InnoDB table spaces.", | 196 | "The common part for InnoDB table spaces.", |
133 | 197 | @@ -11597,6 +11608,7 @@ | 197 | @@ -11602,6 +11613,7 @@ |
134 | 198 | MYSQL_SYSVAR(autoextend_increment), | 198 | MYSQL_SYSVAR(autoextend_increment), |
135 | 199 | MYSQL_SYSVAR(buffer_pool_size), | 199 | MYSQL_SYSVAR(buffer_pool_size), |
136 | 200 | MYSQL_SYSVAR(checksums), | 200 | MYSQL_SYSVAR(checksums), |
137 | 201 | 201 | ||
138 | === modified file 'innodb_fast_shutdown.patch' | |||
139 | --- innodb_fast_shutdown.patch 2010-12-13 11:43:12 +0000 | |||
140 | +++ innodb_fast_shutdown.patch 2011-02-08 02:15:10 +0000 | |||
141 | @@ -212,7 +212,7 @@ | |||
142 | 212 | 212 | ||
143 | 213 | if (srv_shutdown_state >= SRV_SHUTDOWN_CLEANUP) { | 213 | if (srv_shutdown_state >= SRV_SHUTDOWN_CLEANUP) { |
144 | 214 | goto exit_func; | 214 | goto exit_func; |
146 | 215 | @@ -2770,7 +2773,7 @@ | 215 | @@ -2773,7 +2776,7 @@ |
147 | 216 | if (!skip_sleep) { | 216 | if (!skip_sleep) { |
148 | 217 | if (next_itr_time > cur_time) { | 217 | if (next_itr_time > cur_time) { |
149 | 218 | 218 | ||
150 | @@ -221,7 +221,7 @@ | |||
151 | 221 | srv_main_sleeps++; | 221 | srv_main_sleeps++; |
152 | 222 | 222 | ||
153 | 223 | /* | 223 | /* |
155 | 224 | @@ -3476,9 +3479,10 @@ | 224 | @@ -3480,9 +3483,10 @@ |
156 | 225 | mutex_exit(&kernel_mutex); | 225 | mutex_exit(&kernel_mutex); |
157 | 226 | 226 | ||
158 | 227 | sleep_ms = 10; | 227 | sleep_ms = 10; |
159 | 228 | 228 | ||
160 | === modified file 'innodb_files_extend.patch' | |||
161 | --- innodb_files_extend.patch 2011-02-02 14:49:16 +0000 | |||
162 | +++ innodb_files_extend.patch 2011-02-08 02:15:10 +0000 | |||
163 | @@ -187,7 +187,7 @@ | |||
164 | 187 | #ifndef MYSQL_SERVER | 187 | #ifndef MYSQL_SERVER |
165 | 188 | innodb_overwrite_relay_log_info = FALSE; | 188 | innodb_overwrite_relay_log_info = FALSE; |
166 | 189 | #endif | 189 | #endif |
168 | 190 | @@ -7004,9 +7063,9 @@ | 190 | @@ -7009,9 +7068,9 @@ |
169 | 191 | | DICT_TF_COMPACT | 191 | | DICT_TF_COMPACT |
170 | 192 | | DICT_TF_FORMAT_ZIP | 192 | | DICT_TF_FORMAT_ZIP |
171 | 193 | << DICT_TF_FORMAT_SHIFT; | 193 | << DICT_TF_FORMAT_SHIFT; |
172 | @@ -200,7 +200,7 @@ | |||
173 | 200 | } | 200 | } |
174 | 201 | } | 201 | } |
175 | 202 | 202 | ||
177 | 203 | @@ -11116,6 +11175,16 @@ | 203 | @@ -11121,6 +11180,16 @@ |
178 | 204 | "#### Attention: The checksum is not compatible for normal or disabled version! ####", | 204 | "#### Attention: The checksum is not compatible for normal or disabled version! ####", |
179 | 205 | NULL, NULL, FALSE); | 205 | NULL, NULL, FALSE); |
180 | 206 | 206 | ||
181 | @@ -217,7 +217,7 @@ | |||
182 | 217 | static MYSQL_SYSVAR_STR(data_home_dir, innobase_data_home_dir, | 217 | static MYSQL_SYSVAR_STR(data_home_dir, innobase_data_home_dir, |
183 | 218 | PLUGIN_VAR_READONLY, | 218 | PLUGIN_VAR_READONLY, |
184 | 219 | "The common part for InnoDB table spaces.", | 219 | "The common part for InnoDB table spaces.", |
186 | 220 | @@ -11604,6 +11673,8 @@ | 220 | @@ -11609,6 +11678,8 @@ |
187 | 221 | NULL, NULL, 0, 0, 1, 0); | 221 | NULL, NULL, 0, 0, 1, 0); |
188 | 222 | 222 | ||
189 | 223 | static struct st_mysql_sys_var* innobase_system_variables[]= { | 223 | static struct st_mysql_sys_var* innobase_system_variables[]= { |
190 | 224 | 224 | ||
191 | === modified file 'innodb_fix_misc.patch' | |||
192 | --- innodb_fix_misc.patch 2011-02-02 14:49:16 +0000 | |||
193 | +++ innodb_fix_misc.patch 2011-02-08 02:15:10 +0000 | |||
194 | @@ -8,7 +8,7 @@ | |||
195 | 8 | diff -ruN a/storage/innodb_plugin/handler/ha_innodb.cc b/storage/innodb_plugin/handler/ha_innodb.cc | 8 | diff -ruN a/storage/innodb_plugin/handler/ha_innodb.cc b/storage/innodb_plugin/handler/ha_innodb.cc |
196 | 9 | --- a/storage/innodb_plugin/handler/ha_innodb.cc 2010-08-27 16:50:59.626327847 +0900 | 9 | --- a/storage/innodb_plugin/handler/ha_innodb.cc 2010-08-27 16:50:59.626327847 +0900 |
197 | 10 | +++ b/storage/innodb_plugin/handler/ha_innodb.cc 2010-08-27 16:55:20.281021252 +0900 | 10 | +++ b/storage/innodb_plugin/handler/ha_innodb.cc 2010-08-27 16:55:20.281021252 +0900 |
199 | 11 | @@ -11770,7 +11770,7 @@ | 11 | @@ -11775,7 +11775,7 @@ |
200 | 12 | &innobase_storage_engine, | 12 | &innobase_storage_engine, |
201 | 13 | innobase_hton_name, | 13 | innobase_hton_name, |
202 | 14 | "Innobase Oy", | 14 | "Innobase Oy", |
203 | 15 | 15 | ||
204 | === modified file 'innodb_lru_dump_restore.patch' | |||
205 | --- innodb_lru_dump_restore.patch 2011-02-02 14:49:16 +0000 | |||
206 | +++ innodb_lru_dump_restore.patch 2011-02-08 02:15:10 +0000 | |||
207 | @@ -409,7 +409,7 @@ | |||
208 | 409 | diff -ruN a/storage/innodb_plugin/handler/ha_innodb.cc b/storage/innodb_plugin/handler/ha_innodb.cc | 409 | diff -ruN a/storage/innodb_plugin/handler/ha_innodb.cc b/storage/innodb_plugin/handler/ha_innodb.cc |
209 | 410 | --- a/storage/innodb_plugin/handler/ha_innodb.cc 2010-10-01 09:57:56.486228425 +0900 | 410 | --- a/storage/innodb_plugin/handler/ha_innodb.cc 2010-10-01 09:57:56.486228425 +0900 |
210 | 411 | +++ b/storage/innodb_plugin/handler/ha_innodb.cc 2010-10-01 10:00:13.292228546 +0900 | 411 | +++ b/storage/innodb_plugin/handler/ha_innodb.cc 2010-10-01 10:00:13.292228546 +0900 |
212 | 412 | @@ -11473,6 +11473,12 @@ | 412 | @@ -11478,6 +11478,12 @@ |
213 | 413 | "Limit the allocated memory for dictionary cache. (0: unlimited)", | 413 | "Limit the allocated memory for dictionary cache. (0: unlimited)", |
214 | 414 | NULL, NULL, 0, 0, LONG_MAX, 0); | 414 | NULL, NULL, 0, 0, LONG_MAX, 0); |
215 | 415 | 415 | ||
216 | @@ -422,7 +422,7 @@ | |||
217 | 422 | static struct st_mysql_sys_var* innobase_system_variables[]= { | 422 | static struct st_mysql_sys_var* innobase_system_variables[]= { |
218 | 423 | MYSQL_SYSVAR(additional_mem_pool_size), | 423 | MYSQL_SYSVAR(additional_mem_pool_size), |
219 | 424 | MYSQL_SYSVAR(autoextend_increment), | 424 | MYSQL_SYSVAR(autoextend_increment), |
221 | 425 | @@ -11555,6 +11561,7 @@ | 425 | @@ -11560,6 +11566,7 @@ |
222 | 426 | #endif /* UNIV_DEBUG || UNIV_IBUF_DEBUG */ | 426 | #endif /* UNIV_DEBUG || UNIV_IBUF_DEBUG */ |
223 | 427 | MYSQL_SYSVAR(read_ahead_threshold), | 427 | MYSQL_SYSVAR(read_ahead_threshold), |
224 | 428 | MYSQL_SYSVAR(io_capacity), | 428 | MYSQL_SYSVAR(io_capacity), |
225 | 429 | 429 | ||
226 | === modified file 'innodb_pass_corrupt_table.patch' | |||
227 | --- innodb_pass_corrupt_table.patch 2011-02-02 14:49:16 +0000 | |||
228 | +++ innodb_pass_corrupt_table.patch 2011-02-08 02:15:10 +0000 | |||
229 | @@ -899,7 +899,7 @@ | |||
230 | 899 | switch (ret) { | 899 | switch (ret) { |
231 | 900 | case DB_SUCCESS: | 900 | case DB_SUCCESS: |
232 | 901 | error = 0; | 901 | error = 0; |
234 | 902 | @@ -5852,6 +5903,10 @@ | 902 | @@ -5857,6 +5908,10 @@ |
235 | 903 | { | 903 | { |
236 | 904 | DBUG_ENTER("change_active_index"); | 904 | DBUG_ENTER("change_active_index"); |
237 | 905 | 905 | ||
238 | @@ -910,7 +910,7 @@ | |||
239 | 910 | ut_ad(user_thd == ha_thd()); | 910 | ut_ad(user_thd == ha_thd()); |
240 | 911 | ut_a(prebuilt->trx == thd_to_trx(user_thd)); | 911 | ut_a(prebuilt->trx == thd_to_trx(user_thd)); |
241 | 912 | 912 | ||
243 | 913 | @@ -5942,6 +5997,10 @@ | 913 | @@ -5947,6 +6002,10 @@ |
244 | 914 | 914 | ||
245 | 915 | DBUG_ENTER("general_fetch"); | 915 | DBUG_ENTER("general_fetch"); |
246 | 916 | 916 | ||
247 | @@ -921,7 +921,7 @@ | |||
248 | 921 | ut_a(prebuilt->trx == thd_to_trx(user_thd)); | 921 | ut_a(prebuilt->trx == thd_to_trx(user_thd)); |
249 | 922 | 922 | ||
250 | 923 | innodb_srv_conc_enter_innodb(prebuilt->trx); | 923 | innodb_srv_conc_enter_innodb(prebuilt->trx); |
252 | 924 | @@ -5951,6 +6010,10 @@ | 924 | @@ -5956,6 +6015,10 @@ |
253 | 925 | 925 | ||
254 | 926 | innodb_srv_conc_exit_innodb(prebuilt->trx); | 926 | innodb_srv_conc_exit_innodb(prebuilt->trx); |
255 | 927 | 927 | ||
256 | @@ -932,7 +932,7 @@ | |||
257 | 932 | switch (ret) { | 932 | switch (ret) { |
258 | 933 | case DB_SUCCESS: | 933 | case DB_SUCCESS: |
259 | 934 | error = 0; | 934 | error = 0; |
261 | 935 | @@ -7201,6 +7264,10 @@ | 935 | @@ -7206,6 +7269,10 @@ |
262 | 936 | DBUG_RETURN(my_errno=HA_ERR_WRONG_COMMAND); | 936 | DBUG_RETURN(my_errno=HA_ERR_WRONG_COMMAND); |
263 | 937 | } | 937 | } |
264 | 938 | 938 | ||
265 | @@ -943,7 +943,7 @@ | |||
266 | 943 | /* Truncate the table in InnoDB */ | 943 | /* Truncate the table in InnoDB */ |
267 | 944 | 944 | ||
268 | 945 | error = row_truncate_table_for_mysql(prebuilt->table, prebuilt->trx); | 945 | error = row_truncate_table_for_mysql(prebuilt->table, prebuilt->trx); |
270 | 946 | @@ -7209,6 +7276,10 @@ | 946 | @@ -7214,6 +7281,10 @@ |
271 | 947 | goto fallback; | 947 | goto fallback; |
272 | 948 | } | 948 | } |
273 | 949 | 949 | ||
274 | @@ -954,7 +954,7 @@ | |||
275 | 954 | error = convert_error_code_to_mysql(error, prebuilt->table->flags, | 954 | error = convert_error_code_to_mysql(error, prebuilt->table->flags, |
276 | 955 | NULL); | 955 | NULL); |
277 | 956 | 956 | ||
279 | 957 | @@ -7721,6 +7792,16 @@ | 957 | @@ -7726,6 +7797,16 @@ |
280 | 958 | return(ranges + (double) rows / (double) total_rows * time_for_scan); | 958 | return(ranges + (double) rows / (double) total_rows * time_for_scan); |
281 | 959 | } | 959 | } |
282 | 960 | 960 | ||
283 | @@ -971,7 +971,7 @@ | |||
284 | 971 | /*********************************************************************//** | 971 | /*********************************************************************//** |
285 | 972 | Calculates the key number used inside MySQL for an Innobase index. We will | 972 | Calculates the key number used inside MySQL for an Innobase index. We will |
286 | 973 | first check the "index translation table" for a match of the index to get | 973 | first check the "index translation table" for a match of the index to get |
288 | 974 | @@ -7842,7 +7923,7 @@ | 974 | @@ -7847,7 +7928,7 @@ |
289 | 975 | ib_table = prebuilt->table; | 975 | ib_table = prebuilt->table; |
290 | 976 | 976 | ||
291 | 977 | if (flag & HA_STATUS_TIME) { | 977 | if (flag & HA_STATUS_TIME) { |
292 | @@ -980,7 +980,7 @@ | |||
293 | 980 | /* In sql_show we call with this flag: update | 980 | /* In sql_show we call with this flag: update |
294 | 981 | then statistics so that they are up-to-date */ | 981 | then statistics so that they are up-to-date */ |
295 | 982 | 982 | ||
297 | 983 | @@ -8133,10 +8214,18 @@ | 983 | @@ -8138,10 +8219,18 @@ |
298 | 984 | THD* thd, /*!< in: connection thread handle */ | 984 | THD* thd, /*!< in: connection thread handle */ |
299 | 985 | HA_CHECK_OPT* check_opt) /*!< in: currently ignored */ | 985 | HA_CHECK_OPT* check_opt) /*!< in: currently ignored */ |
300 | 986 | { | 986 | { |
301 | @@ -999,7 +999,7 @@ | |||
302 | 999 | return(0); | 999 | return(0); |
303 | 1000 | } | 1000 | } |
304 | 1001 | 1001 | ||
306 | 1002 | @@ -8318,6 +8407,10 @@ | 1002 | @@ -8323,6 +8412,10 @@ |
307 | 1003 | my_error(ER_QUERY_INTERRUPTED, MYF(0)); | 1003 | my_error(ER_QUERY_INTERRUPTED, MYF(0)); |
308 | 1004 | } | 1004 | } |
309 | 1005 | 1005 | ||
310 | @@ -1010,7 +1010,7 @@ | |||
311 | 1010 | DBUG_RETURN(is_ok ? HA_ADMIN_OK : HA_ADMIN_CORRUPT); | 1010 | DBUG_RETURN(is_ok ? HA_ADMIN_OK : HA_ADMIN_CORRUPT); |
312 | 1011 | } | 1011 | } |
313 | 1012 | 1012 | ||
315 | 1013 | @@ -9043,6 +9136,10 @@ | 1013 | @@ -9048,6 +9141,10 @@ |
316 | 1014 | 1014 | ||
317 | 1015 | update_thd(thd); | 1015 | update_thd(thd); |
318 | 1016 | 1016 | ||
319 | @@ -1021,7 +1021,7 @@ | |||
320 | 1021 | if (prebuilt->table->ibd_file_missing && !thd_tablespace_op(thd)) { | 1021 | if (prebuilt->table->ibd_file_missing && !thd_tablespace_op(thd)) { |
321 | 1022 | ut_print_timestamp(stderr); | 1022 | ut_print_timestamp(stderr); |
322 | 1023 | fprintf(stderr, | 1023 | fprintf(stderr, |
324 | 1024 | @@ -11487,6 +11584,14 @@ | 1024 | @@ -11492,6 +11589,14 @@ |
325 | 1025 | "0 (the default) disables automatic dumps.", | 1025 | "0 (the default) disables automatic dumps.", |
326 | 1026 | NULL, NULL, 0, 0, UINT_MAX32, 0); | 1026 | NULL, NULL, 0, 0, UINT_MAX32, 0); |
327 | 1027 | 1027 | ||
328 | @@ -1036,7 +1036,7 @@ | |||
329 | 1036 | static struct st_mysql_sys_var* innobase_system_variables[]= { | 1036 | static struct st_mysql_sys_var* innobase_system_variables[]= { |
330 | 1037 | MYSQL_SYSVAR(additional_mem_pool_size), | 1037 | MYSQL_SYSVAR(additional_mem_pool_size), |
331 | 1038 | MYSQL_SYSVAR(autoextend_increment), | 1038 | MYSQL_SYSVAR(autoextend_increment), |
333 | 1039 | @@ -11572,6 +11677,7 @@ | 1039 | @@ -11577,6 +11682,7 @@ |
334 | 1040 | MYSQL_SYSVAR(io_capacity), | 1040 | MYSQL_SYSVAR(io_capacity), |
335 | 1041 | MYSQL_SYSVAR(auto_lru_dump), | 1041 | MYSQL_SYSVAR(auto_lru_dump), |
336 | 1042 | MYSQL_SYSVAR(use_purge_thread), | 1042 | MYSQL_SYSVAR(use_purge_thread), |
337 | 1043 | 1043 | ||
338 | === modified file 'innodb_purge_thread.patch' | |||
339 | --- innodb_purge_thread.patch 2011-02-02 14:49:16 +0000 | |||
340 | +++ innodb_purge_thread.patch 2011-02-08 02:15:10 +0000 | |||
341 | @@ -8,7 +8,7 @@ | |||
342 | 8 | diff -ruN a/storage/innodb_plugin/handler/ha_innodb.cc b/storage/innodb_plugin/handler/ha_innodb.cc | 8 | diff -ruN a/storage/innodb_plugin/handler/ha_innodb.cc b/storage/innodb_plugin/handler/ha_innodb.cc |
343 | 9 | --- a/storage/innodb_plugin/handler/ha_innodb.cc 2010-08-27 16:23:31.022060427 +0900 | 9 | --- a/storage/innodb_plugin/handler/ha_innodb.cc 2010-08-27 16:23:31.022060427 +0900 |
344 | 10 | +++ b/storage/innodb_plugin/handler/ha_innodb.cc 2010-08-27 16:25:49.004020662 +0900 | 10 | +++ b/storage/innodb_plugin/handler/ha_innodb.cc 2010-08-27 16:25:49.004020662 +0900 |
346 | 11 | @@ -10974,6 +10974,11 @@ | 11 | @@ -10979,6 +10979,11 @@ |
347 | 12 | "Output statistics of recovery process after it.", | 12 | "Output statistics of recovery process after it.", |
348 | 13 | NULL, NULL, FALSE); | 13 | NULL, NULL, FALSE); |
349 | 14 | 14 | ||
350 | @@ -20,7 +20,7 @@ | |||
351 | 20 | static MYSQL_SYSVAR_BOOL(overwrite_relay_log_info, innobase_overwrite_relay_log_info, | 20 | static MYSQL_SYSVAR_BOOL(overwrite_relay_log_info, innobase_overwrite_relay_log_info, |
352 | 21 | PLUGIN_VAR_NOCMDARG | PLUGIN_VAR_READONLY, | 21 | PLUGIN_VAR_NOCMDARG | PLUGIN_VAR_READONLY, |
353 | 22 | "During InnoDB crash recovery on slave overwrite relay-log.info " | 22 | "During InnoDB crash recovery on slave overwrite relay-log.info " |
355 | 23 | @@ -11497,6 +11502,7 @@ | 23 | @@ -11502,6 +11507,7 @@ |
356 | 24 | #endif /* UNIV_DEBUG || UNIV_IBUF_DEBUG */ | 24 | #endif /* UNIV_DEBUG || UNIV_IBUF_DEBUG */ |
357 | 25 | MYSQL_SYSVAR(read_ahead_threshold), | 25 | MYSQL_SYSVAR(read_ahead_threshold), |
358 | 26 | MYSQL_SYSVAR(io_capacity), | 26 | MYSQL_SYSVAR(io_capacity), |
359 | 27 | 27 | ||
360 | === modified file 'innodb_recovery_patches.patch' | |||
361 | --- innodb_recovery_patches.patch 2010-12-16 11:35:26 +0000 | |||
362 | +++ innodb_recovery_patches.patch 2011-02-08 02:15:10 +0000 | |||
363 | @@ -127,7 +127,7 @@ | |||
364 | 127 | srv_use_doublewrite_buf = (ibool) innobase_use_doublewrite; | 127 | srv_use_doublewrite_buf = (ibool) innobase_use_doublewrite; |
365 | 128 | srv_use_checksums = (ibool) innobase_use_checksums; | 128 | srv_use_checksums = (ibool) innobase_use_checksums; |
366 | 129 | 129 | ||
368 | 130 | @@ -10960,6 +10964,16 @@ | 130 | @@ -10965,6 +10969,16 @@ |
369 | 131 | "don't use the datafile for normal mysqld or ibbackup! ####", | 131 | "don't use the datafile for normal mysqld or ibbackup! ####", |
370 | 132 | NULL, NULL, FALSE); | 132 | NULL, NULL, FALSE); |
371 | 133 | 133 | ||
372 | @@ -144,7 +144,7 @@ | |||
373 | 144 | static MYSQL_SYSVAR_BOOL(overwrite_relay_log_info, innobase_overwrite_relay_log_info, | 144 | static MYSQL_SYSVAR_BOOL(overwrite_relay_log_info, innobase_overwrite_relay_log_info, |
374 | 145 | PLUGIN_VAR_NOCMDARG | PLUGIN_VAR_READONLY, | 145 | PLUGIN_VAR_NOCMDARG | PLUGIN_VAR_READONLY, |
375 | 146 | "During InnoDB crash recovery on slave overwrite relay-log.info " | 146 | "During InnoDB crash recovery on slave overwrite relay-log.info " |
377 | 147 | @@ -11412,6 +11426,8 @@ | 147 | @@ -11417,6 +11431,8 @@ |
378 | 148 | MYSQL_SYSVAR(data_home_dir), | 148 | MYSQL_SYSVAR(data_home_dir), |
379 | 149 | MYSQL_SYSVAR(doublewrite), | 149 | MYSQL_SYSVAR(doublewrite), |
380 | 150 | MYSQL_SYSVAR(extra_undoslots), | 150 | MYSQL_SYSVAR(extra_undoslots), |
381 | 151 | 151 | ||
382 | === modified file 'innodb_separate_doublewrite.patch' | |||
383 | --- innodb_separate_doublewrite.patch 2011-02-02 14:49:16 +0000 | |||
384 | +++ innodb_separate_doublewrite.patch 2011-02-08 02:15:10 +0000 | |||
385 | @@ -357,7 +357,7 @@ | |||
386 | 357 | srv_extra_undoslots = (ibool) innobase_extra_undoslots; | 357 | srv_extra_undoslots = (ibool) innobase_extra_undoslots; |
387 | 358 | 358 | ||
388 | 359 | srv_use_sys_stats_table = (ibool) innobase_use_sys_stats_table; | 359 | srv_use_sys_stats_table = (ibool) innobase_use_sys_stats_table; |
390 | 360 | @@ -11321,6 +11324,11 @@ | 360 | @@ -11326,6 +11329,11 @@ |
391 | 361 | "Path to individual files and their sizes.", | 361 | "Path to individual files and their sizes.", |
392 | 362 | NULL, NULL, NULL); | 362 | NULL, NULL, NULL); |
393 | 363 | 363 | ||
394 | @@ -369,7 +369,7 @@ | |||
395 | 369 | static MYSQL_SYSVAR_LONG(autoinc_lock_mode, innobase_autoinc_lock_mode, | 369 | static MYSQL_SYSVAR_LONG(autoinc_lock_mode, innobase_autoinc_lock_mode, |
396 | 370 | PLUGIN_VAR_RQCMDARG | PLUGIN_VAR_READONLY, | 370 | PLUGIN_VAR_RQCMDARG | PLUGIN_VAR_READONLY, |
397 | 371 | "The AUTOINC lock modes supported by InnoDB: " | 371 | "The AUTOINC lock modes supported by InnoDB: " |
399 | 372 | @@ -11487,6 +11495,7 @@ | 372 | @@ -11492,6 +11500,7 @@ |
400 | 373 | MYSQL_SYSVAR(commit_concurrency), | 373 | MYSQL_SYSVAR(commit_concurrency), |
401 | 374 | MYSQL_SYSVAR(concurrency_tickets), | 374 | MYSQL_SYSVAR(concurrency_tickets), |
402 | 375 | MYSQL_SYSVAR(data_file_path), | 375 | MYSQL_SYSVAR(data_file_path), |
403 | 376 | 376 | ||
404 | === modified file 'innodb_show_lock_name.patch' | |||
405 | --- innodb_show_lock_name.patch 2011-02-02 14:49:16 +0000 | |||
406 | +++ innodb_show_lock_name.patch 2011-02-08 02:15:10 +0000 | |||
407 | @@ -8,7 +8,7 @@ | |||
408 | 8 | diff -ruN a/storage/innodb_plugin/handler/ha_innodb.cc b/storage/innodb_plugin/handler/ha_innodb.cc | 8 | diff -ruN a/storage/innodb_plugin/handler/ha_innodb.cc b/storage/innodb_plugin/handler/ha_innodb.cc |
409 | 9 | --- a/storage/innodb_plugin/handler/ha_innodb.cc 2010-08-27 16:29:12.539982446 +0900 | 9 | --- a/storage/innodb_plugin/handler/ha_innodb.cc 2010-08-27 16:29:12.539982446 +0900 |
410 | 10 | +++ b/storage/innodb_plugin/handler/ha_innodb.cc 2010-08-27 16:29:24.322059309 +0900 | 10 | +++ b/storage/innodb_plugin/handler/ha_innodb.cc 2010-08-27 16:29:24.322059309 +0900 |
412 | 11 | @@ -9233,8 +9233,8 @@ | 11 | @@ -9238,8 +9238,8 @@ |
413 | 12 | rw_lock_wait_time += mutex->lspent_time; | 12 | rw_lock_wait_time += mutex->lspent_time; |
414 | 13 | } | 13 | } |
415 | 14 | #else /* UNIV_DEBUG */ | 14 | #else /* UNIV_DEBUG */ |
416 | @@ -19,7 +19,7 @@ | |||
417 | 19 | buf2len= (uint) my_snprintf(buf2, sizeof(buf2), "os_waits=%lu", | 19 | buf2len= (uint) my_snprintf(buf2, sizeof(buf2), "os_waits=%lu", |
418 | 20 | (ulong) mutex->count_os_wait); | 20 | (ulong) mutex->count_os_wait); |
419 | 21 | 21 | ||
421 | 22 | @@ -9249,9 +9249,8 @@ | 22 | @@ -9254,9 +9254,8 @@ |
422 | 23 | 23 | ||
423 | 24 | if (block_mutex) { | 24 | if (block_mutex) { |
424 | 25 | buf1len = (uint) my_snprintf(buf1, sizeof buf1, | 25 | buf1len = (uint) my_snprintf(buf1, sizeof buf1, |
425 | @@ -31,7 +31,7 @@ | |||
426 | 31 | buf2len = (uint) my_snprintf(buf2, sizeof buf2, | 31 | buf2len = (uint) my_snprintf(buf2, sizeof buf2, |
427 | 32 | "os_waits=%lu", | 32 | "os_waits=%lu", |
428 | 33 | (ulong) block_mutex_oswait_count); | 33 | (ulong) block_mutex_oswait_count); |
430 | 34 | @@ -9280,8 +9279,8 @@ | 34 | @@ -9285,8 +9284,8 @@ |
431 | 35 | continue; | 35 | continue; |
432 | 36 | } | 36 | } |
433 | 37 | 37 | ||
434 | @@ -42,7 +42,7 @@ | |||
435 | 42 | buf2len = my_snprintf(buf2, sizeof buf2, "os_waits=%lu", | 42 | buf2len = my_snprintf(buf2, sizeof buf2, "os_waits=%lu", |
436 | 43 | (ulong) lock->count_os_wait); | 43 | (ulong) lock->count_os_wait); |
437 | 44 | 44 | ||
439 | 45 | @@ -9295,9 +9294,8 @@ | 45 | @@ -9300,9 +9299,8 @@ |
440 | 46 | 46 | ||
441 | 47 | if (block_lock) { | 47 | if (block_lock) { |
442 | 48 | buf1len = (uint) my_snprintf(buf1, sizeof buf1, | 48 | buf1len = (uint) my_snprintf(buf1, sizeof buf1, |
443 | 49 | 49 | ||
444 | === modified file 'innodb_show_sys_tables.patch' | |||
445 | --- innodb_show_sys_tables.patch 2010-12-16 11:35:26 +0000 | |||
446 | +++ innodb_show_sys_tables.patch 2011-02-08 02:15:10 +0000 | |||
447 | @@ -8,7 +8,7 @@ | |||
448 | 8 | diff -ruN a/storage/innodb_plugin/handler/ha_innodb.cc b/storage/innodb_plugin/handler/ha_innodb.cc | 8 | diff -ruN a/storage/innodb_plugin/handler/ha_innodb.cc b/storage/innodb_plugin/handler/ha_innodb.cc |
449 | 9 | --- a/storage/innodb_plugin/handler/ha_innodb.cc 2010-08-27 16:45:46.194411503 +0900 | 9 | --- a/storage/innodb_plugin/handler/ha_innodb.cc 2010-08-27 16:45:46.194411503 +0900 |
450 | 10 | +++ b/storage/innodb_plugin/handler/ha_innodb.cc 2010-08-27 16:49:26.171990559 +0900 | 10 | +++ b/storage/innodb_plugin/handler/ha_innodb.cc 2010-08-27 16:49:26.171990559 +0900 |
452 | 11 | @@ -11793,6 +11793,9 @@ | 11 | @@ -11798,6 +11798,9 @@ |
453 | 12 | i_s_innodb_table_stats, | 12 | i_s_innodb_table_stats, |
454 | 13 | i_s_innodb_index_stats, | 13 | i_s_innodb_index_stats, |
455 | 14 | i_s_innodb_admin_command, | 14 | i_s_innodb_admin_command, |
456 | 15 | 15 | ||
457 | === modified file 'innodb_stats.patch' | |||
458 | --- innodb_stats.patch 2011-02-02 14:49:16 +0000 | |||
459 | +++ innodb_stats.patch 2011-02-08 02:15:10 +0000 | |||
460 | @@ -1128,7 +1128,19 @@ | |||
461 | 1128 | innodb_srv_conc_exit_innodb(trx); | 1128 | innodb_srv_conc_exit_innodb(trx); |
462 | 1129 | 1129 | ||
463 | 1130 | error = convert_error_code_to_mysql( | 1130 | error = convert_error_code_to_mysql( |
465 | 1131 | @@ -5897,6 +5912,11 @@ | 1131 | @@ -5688,6 +5703,11 @@ |
466 | 1132 | case DB_SUCCESS: | ||
467 | 1133 | error = 0; | ||
468 | 1134 | table->status = 0; | ||
469 | 1135 | +#ifdef EXTENDED_FOR_USERSTAT | ||
470 | 1136 | + rows_read++; | ||
471 | 1137 | + if (active_index < MAX_KEY) | ||
472 | 1138 | + index_rows_read[active_index]++; | ||
473 | 1139 | +#endif | ||
474 | 1140 | break; | ||
475 | 1141 | case DB_RECORD_NOT_FOUND: | ||
476 | 1142 | error = HA_ERR_KEY_NOT_FOUND; | ||
477 | 1143 | @@ -5897,6 +5917,11 @@ | ||
478 | 1132 | case DB_SUCCESS: | 1144 | case DB_SUCCESS: |
479 | 1133 | error = 0; | 1145 | error = 0; |
480 | 1134 | table->status = 0; | 1146 | table->status = 0; |
481 | @@ -1140,7 +1152,7 @@ | |||
482 | 1140 | break; | 1152 | break; |
483 | 1141 | case DB_RECORD_NOT_FOUND: | 1153 | case DB_RECORD_NOT_FOUND: |
484 | 1142 | error = HA_ERR_END_OF_FILE; | 1154 | error = HA_ERR_END_OF_FILE; |
486 | 1143 | @@ -7783,11 +7803,31 @@ | 1155 | @@ -7783,11 +7808,31 @@ |
487 | 1144 | /* In sql_show we call with this flag: update | 1156 | /* In sql_show we call with this flag: update |
488 | 1145 | then statistics so that they are up-to-date */ | 1157 | then statistics so that they are up-to-date */ |
489 | 1146 | 1158 | ||
490 | @@ -1173,7 +1185,7 @@ | |||
491 | 1173 | 1185 | ||
492 | 1174 | prebuilt->trx->op_info = "returning various info to MySQL"; | 1186 | prebuilt->trx->op_info = "returning various info to MySQL"; |
493 | 1175 | } | 1187 | } |
495 | 1176 | @@ -7865,7 +7905,7 @@ | 1188 | @@ -7865,7 +7910,7 @@ |
496 | 1177 | are asked by MySQL to avoid locking. Another reason to | 1189 | are asked by MySQL to avoid locking. Another reason to |
497 | 1178 | avoid the call is that it uses quite a lot of CPU. | 1190 | avoid the call is that it uses quite a lot of CPU. |
498 | 1179 | See Bug#38185. */ | 1191 | See Bug#38185. */ |
499 | @@ -1182,7 +1194,7 @@ | |||
500 | 1182 | /* We do not update delete_length if no | 1194 | /* We do not update delete_length if no |
501 | 1183 | locking is requested so the "old" value can | 1195 | locking is requested so the "old" value can |
502 | 1184 | remain. delete_length is initialized to 0 in | 1196 | remain. delete_length is initialized to 0 in |
504 | 1185 | @@ -11045,6 +11085,45 @@ | 1197 | @@ -11045,6 +11090,45 @@ |
505 | 1186 | "The number of index pages to sample when calculating statistics (default 8)", | 1198 | "The number of index pages to sample when calculating statistics (default 8)", |
506 | 1187 | NULL, NULL, 8, 1, ~0ULL, 0); | 1199 | NULL, NULL, 8, 1, ~0ULL, 0); |
507 | 1188 | 1200 | ||
508 | @@ -1228,7 +1240,7 @@ | |||
509 | 1228 | static MYSQL_SYSVAR_BOOL(adaptive_hash_index, btr_search_enabled, | 1240 | static MYSQL_SYSVAR_BOOL(adaptive_hash_index, btr_search_enabled, |
510 | 1229 | PLUGIN_VAR_OPCMDARG, | 1241 | PLUGIN_VAR_OPCMDARG, |
511 | 1230 | "Enable InnoDB adaptive hash index (enabled by default). " | 1242 | "Enable InnoDB adaptive hash index (enabled by default). " |
513 | 1231 | @@ -11363,6 +11442,10 @@ | 1243 | @@ -11363,6 +11447,10 @@ |
514 | 1232 | MYSQL_SYSVAR(overwrite_relay_log_info), | 1244 | MYSQL_SYSVAR(overwrite_relay_log_info), |
515 | 1233 | MYSQL_SYSVAR(rollback_on_timeout), | 1245 | MYSQL_SYSVAR(rollback_on_timeout), |
516 | 1234 | MYSQL_SYSVAR(stats_on_metadata), | 1246 | MYSQL_SYSVAR(stats_on_metadata), |
517 | @@ -1239,7 +1251,7 @@ | |||
518 | 1239 | MYSQL_SYSVAR(stats_sample_pages), | 1251 | MYSQL_SYSVAR(stats_sample_pages), |
519 | 1240 | MYSQL_SYSVAR(adaptive_hash_index), | 1252 | MYSQL_SYSVAR(adaptive_hash_index), |
520 | 1241 | MYSQL_SYSVAR(replication_delay), | 1253 | MYSQL_SYSVAR(replication_delay), |
522 | 1242 | @@ -11427,6 +11510,8 @@ | 1254 | @@ -11427,6 +11515,8 @@ |
523 | 1243 | i_s_innodb_cmp_reset, | 1255 | i_s_innodb_cmp_reset, |
524 | 1244 | i_s_innodb_cmpmem, | 1256 | i_s_innodb_cmpmem, |
525 | 1245 | i_s_innodb_cmpmem_reset, | 1257 | i_s_innodb_cmpmem_reset, |
Test case passes. Manual reproducing - feature works fine.