Merge lp:~percona-dev/percona-server/5.1.54-fix-bug602047 into lp:percona-server/release-5.1.54-12

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
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
To post a comment you must log in.
Revision history for this message
Valentine Gostev (longbow) wrote :

Test case passes. Manual reproducing - feature works fine.

review: Approve (qa)
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 'innodb_adjust_defaults.patch'
--- innodb_adjust_defaults.patch 2010-12-16 11:35:26 +0000
+++ innodb_adjust_defaults.patch 2011-02-08 02:15:10 +0000
@@ -8,7 +8,7 @@
8diff -ruN a/storage/innodb_plugin/handler/ha_innodb.cc b/storage/innodb_plugin/handler/ha_innodb.cc8diff -ruN a/storage/innodb_plugin/handler/ha_innodb.cc b/storage/innodb_plugin/handler/ha_innodb.cc
9--- a/storage/innodb_plugin/handler/ha_innodb.cc 2010-04-30 16:39:14.000000000 +09009--- a/storage/innodb_plugin/handler/ha_innodb.cc 2010-04-30 16:39:14.000000000 +0900
10+++ b/storage/innodb_plugin/handler/ha_innodb.cc 2010-04-30 16:43:26.000000000 +090010+++ b/storage/innodb_plugin/handler/ha_innodb.cc 2010-04-30 16:43:26.000000000 +0900
11@@ -11210,7 +11210,7 @@11@@ -11215,7 +11215,7 @@
12 static MYSQL_SYSVAR_ULONG(use_purge_thread, srv_use_purge_thread,12 static MYSQL_SYSVAR_ULONG(use_purge_thread, srv_use_purge_thread,
13 PLUGIN_VAR_RQCMDARG | PLUGIN_VAR_READONLY,13 PLUGIN_VAR_RQCMDARG | PLUGIN_VAR_READONLY,
14 "Number of purge devoted threads. #### over 1 is EXPERIMENTAL ####",14 "Number of purge devoted threads. #### over 1 is EXPERIMENTAL ####",
@@ -17,7 +17,7 @@
17 17
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,
19 PLUGIN_VAR_NOCMDARG | PLUGIN_VAR_READONLY,19 PLUGIN_VAR_NOCMDARG | PLUGIN_VAR_READONLY,
20@@ -11310,7 +11310,7 @@20@@ -11315,7 +11315,7 @@
21 static MYSQL_SYSVAR_BOOL(adaptive_flushing, srv_adaptive_flushing,21 static MYSQL_SYSVAR_BOOL(adaptive_flushing, srv_adaptive_flushing,
22 PLUGIN_VAR_NOCMDARG,22 PLUGIN_VAR_NOCMDARG,
23 "Attempt flushing dirty pages to avoid IO bursts at checkpoints.",23 "Attempt flushing dirty pages to avoid IO bursts at checkpoints.",
@@ -26,7 +26,7 @@
26 26
27 static MYSQL_SYSVAR_ULONG(max_purge_lag, srv_max_purge_lag,27 static MYSQL_SYSVAR_ULONG(max_purge_lag, srv_max_purge_lag,
28 PLUGIN_VAR_RQCMDARG,28 PLUGIN_VAR_RQCMDARG,
29@@ -11555,7 +11555,7 @@29@@ -11560,7 +11560,7 @@
30 static MYSQL_SYSVAR_ULONG(ibuf_active_contract, srv_ibuf_active_contract,30 static MYSQL_SYSVAR_ULONG(ibuf_active_contract, srv_ibuf_active_contract,
31 PLUGIN_VAR_RQCMDARG,31 PLUGIN_VAR_RQCMDARG,
32 "Enable/Disable active_contract of insert buffer. 0:disable 1:enable",32 "Enable/Disable active_contract of insert buffer. 0:disable 1:enable",
@@ -35,7 +35,7 @@
35 35
36 static MYSQL_SYSVAR_ULONG(ibuf_accel_rate, srv_ibuf_accel_rate,36 static MYSQL_SYSVAR_ULONG(ibuf_accel_rate, srv_ibuf_accel_rate,
37 PLUGIN_VAR_RQCMDARG,37 PLUGIN_VAR_RQCMDARG,
38@@ -11635,8 +11635,8 @@38@@ -11640,8 +11640,8 @@
39 };39 };
40 static MYSQL_SYSVAR_ENUM(adaptive_checkpoint, srv_adaptive_checkpoint,40 static MYSQL_SYSVAR_ENUM(adaptive_checkpoint, srv_adaptive_checkpoint,
41 PLUGIN_VAR_RQCMDARG,41 PLUGIN_VAR_RQCMDARG,
4242
=== modified file 'innodb_admin_command_base.patch'
--- innodb_admin_command_base.patch 2010-12-16 11:35:26 +0000
+++ innodb_admin_command_base.patch 2011-02-08 02:15:10 +0000
@@ -8,7 +8,7 @@
8diff -ruN a/storage/innodb_plugin/handler/ha_innodb.cc b/storage/innodb_plugin/handler/ha_innodb.cc8diff -ruN a/storage/innodb_plugin/handler/ha_innodb.cc b/storage/innodb_plugin/handler/ha_innodb.cc
9--- a/storage/innodb_plugin/handler/ha_innodb.cc 2010-08-27 16:27:30.222410116 +09009--- a/storage/innodb_plugin/handler/ha_innodb.cc 2010-08-27 16:27:30.222410116 +0900
10+++ b/storage/innodb_plugin/handler/ha_innodb.cc 2010-08-27 16:27:44.073104773 +090010+++ b/storage/innodb_plugin/handler/ha_innodb.cc 2010-08-27 16:27:44.073104773 +0900
11@@ -11534,6 +11534,7 @@11@@ -11539,6 +11539,7 @@
12 i_s_innodb_cmpmem_reset,12 i_s_innodb_cmpmem_reset,
13 i_s_innodb_table_stats,13 i_s_innodb_table_stats,
14 i_s_innodb_index_stats,14 i_s_innodb_index_stats,
1515
=== modified file 'innodb_buffer_pool_shm.patch'
--- innodb_buffer_pool_shm.patch 2010-12-16 11:35:26 +0000
+++ innodb_buffer_pool_shm.patch 2011-02-08 02:15:10 +0000
@@ -683,7 +683,7 @@
683 683
684 #ifdef HAVE_LARGE_PAGES684 #ifdef HAVE_LARGE_PAGES
685 if ((os_use_large_pages = (ibool) my_use_large_pages))685 if ((os_use_large_pages = (ibool) my_use_large_pages))
686@@ -11405,6 +11407,16 @@686@@ -11410,6 +11412,16 @@
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.",
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);
689 689
@@ -700,7 +700,7 @@
700 static MYSQL_SYSVAR_ULONG(commit_concurrency, innobase_commit_concurrency,700 static MYSQL_SYSVAR_ULONG(commit_concurrency, innobase_commit_concurrency,
701 PLUGIN_VAR_RQCMDARG,701 PLUGIN_VAR_RQCMDARG,
702 "Helps in performance tuning in heavily concurrent environments.",702 "Helps in performance tuning in heavily concurrent environments.",
703@@ -11680,6 +11692,8 @@703@@ -11685,6 +11697,8 @@
704 MYSQL_SYSVAR(additional_mem_pool_size),704 MYSQL_SYSVAR(additional_mem_pool_size),
705 MYSQL_SYSVAR(autoextend_increment),705 MYSQL_SYSVAR(autoextend_increment),
706 MYSQL_SYSVAR(buffer_pool_size),706 MYSQL_SYSVAR(buffer_pool_size),
707707
=== modified file 'innodb_extend_slow.patch'
--- innodb_extend_slow.patch 2011-02-02 14:49:16 +0000
+++ innodb_extend_slow.patch 2011-02-08 02:15:10 +0000
@@ -428,7 +428,7 @@
428 /*********************************************************************//**428 /*********************************************************************//**
429 Construct ha_innobase handler. */429 Construct ha_innobase handler. */
430 UNIV_INTERN430 UNIV_INTERN
431@@ -8940,6 +8976,25 @@431@@ -8945,6 +8981,25 @@
432 statement has ended */432 statement has ended */
433 433
434 if (trx->n_mysql_tables_in_use == 0) {434 if (trx->n_mysql_tables_in_use == 0) {
@@ -766,7 +766,7 @@
766 766
767 if ((ulint)ret == n) {767 if ((ulint)ret == n) {
768 768
769@@ -3642,10 +3677,11 @@769@@ -3642,10 +3676,11 @@
770 (can be used to identify a completed770 (can be used to identify a completed
771 aio operation); ignored if mode is771 aio operation); ignored if mode is
772 OS_AIO_SYNC */772 OS_AIO_SYNC */
@@ -779,7 +779,7 @@
779 {779 {
780 os_aio_array_t* array;780 os_aio_array_t* array;
781 os_aio_slot_t* slot;781 os_aio_slot_t* slot;
782@@ -3687,8 +3723,8 @@782@@ -3687,8 +3722,8 @@
783 wait in the Windows case. */783 wait in the Windows case. */
784 784
785 if (type == OS_FILE_READ) {785 if (type == OS_FILE_READ) {
@@ -790,7 +790,7 @@
790 }790 }
791 791
792 ut_a(type == OS_FILE_WRITE);792 ut_a(type == OS_FILE_WRITE);
793@@ -3721,6 +3757,11 @@793@@ -3721,6 +3756,11 @@
794 ut_error;794 ut_error;
795 }795 }
796 796
797797
=== modified file 'innodb_fast_checksum.patch'
--- innodb_fast_checksum.patch 2010-12-16 11:35:26 +0000
+++ innodb_fast_checksum.patch 2011-02-08 02:15:10 +0000
@@ -178,7 +178,7 @@
178 178
179 #ifdef HAVE_LARGE_PAGES179 #ifdef HAVE_LARGE_PAGES
180 if ((os_use_large_pages = (ibool) my_use_large_pages))180 if ((os_use_large_pages = (ibool) my_use_large_pages))
181@@ -11105,6 +11107,15 @@181@@ -11110,6 +11112,15 @@
182 "Disable with --skip-innodb-checksums.",182 "Disable with --skip-innodb-checksums.",
183 NULL, NULL, TRUE);183 NULL, NULL, TRUE);
184 184
@@ -194,7 +194,7 @@
194 static MYSQL_SYSVAR_STR(data_home_dir, innobase_data_home_dir,194 static MYSQL_SYSVAR_STR(data_home_dir, innobase_data_home_dir,
195 PLUGIN_VAR_READONLY,195 PLUGIN_VAR_READONLY,
196 "The common part for InnoDB table spaces.",196 "The common part for InnoDB table spaces.",
197@@ -11597,6 +11608,7 @@197@@ -11602,6 +11613,7 @@
198 MYSQL_SYSVAR(autoextend_increment),198 MYSQL_SYSVAR(autoextend_increment),
199 MYSQL_SYSVAR(buffer_pool_size),199 MYSQL_SYSVAR(buffer_pool_size),
200 MYSQL_SYSVAR(checksums),200 MYSQL_SYSVAR(checksums),
201201
=== modified file 'innodb_fast_shutdown.patch'
--- innodb_fast_shutdown.patch 2010-12-13 11:43:12 +0000
+++ innodb_fast_shutdown.patch 2011-02-08 02:15:10 +0000
@@ -212,7 +212,7 @@
212 212
213 if (srv_shutdown_state >= SRV_SHUTDOWN_CLEANUP) {213 if (srv_shutdown_state >= SRV_SHUTDOWN_CLEANUP) {
214 goto exit_func;214 goto exit_func;
215@@ -2770,7 +2773,7 @@215@@ -2773,7 +2776,7 @@
216 if (!skip_sleep) {216 if (!skip_sleep) {
217 if (next_itr_time > cur_time) {217 if (next_itr_time > cur_time) {
218 218
@@ -221,7 +221,7 @@
221 srv_main_sleeps++;221 srv_main_sleeps++;
222 222
223 /*223 /*
224@@ -3476,9 +3479,10 @@224@@ -3480,9 +3483,10 @@
225 mutex_exit(&kernel_mutex);225 mutex_exit(&kernel_mutex);
226 226
227 sleep_ms = 10;227 sleep_ms = 10;
228228
=== modified file 'innodb_files_extend.patch'
--- innodb_files_extend.patch 2011-02-02 14:49:16 +0000
+++ innodb_files_extend.patch 2011-02-08 02:15:10 +0000
@@ -187,7 +187,7 @@
187 #ifndef MYSQL_SERVER187 #ifndef MYSQL_SERVER
188 innodb_overwrite_relay_log_info = FALSE;188 innodb_overwrite_relay_log_info = FALSE;
189 #endif189 #endif
190@@ -7004,9 +7063,9 @@190@@ -7009,9 +7068,9 @@
191 | DICT_TF_COMPACT191 | DICT_TF_COMPACT
192 | DICT_TF_FORMAT_ZIP192 | DICT_TF_FORMAT_ZIP
193 << DICT_TF_FORMAT_SHIFT;193 << DICT_TF_FORMAT_SHIFT;
@@ -200,7 +200,7 @@
200 }200 }
201 }201 }
202 202
203@@ -11116,6 +11175,16 @@203@@ -11121,6 +11180,16 @@
204 "#### Attention: The checksum is not compatible for normal or disabled version! ####",204 "#### Attention: The checksum is not compatible for normal or disabled version! ####",
205 NULL, NULL, FALSE);205 NULL, NULL, FALSE);
206 206
@@ -217,7 +217,7 @@
217 static MYSQL_SYSVAR_STR(data_home_dir, innobase_data_home_dir,217 static MYSQL_SYSVAR_STR(data_home_dir, innobase_data_home_dir,
218 PLUGIN_VAR_READONLY,218 PLUGIN_VAR_READONLY,
219 "The common part for InnoDB table spaces.",219 "The common part for InnoDB table spaces.",
220@@ -11604,6 +11673,8 @@220@@ -11609,6 +11678,8 @@
221 NULL, NULL, 0, 0, 1, 0);221 NULL, NULL, 0, 0, 1, 0);
222 222
223 static struct st_mysql_sys_var* innobase_system_variables[]= {223 static struct st_mysql_sys_var* innobase_system_variables[]= {
224224
=== modified file 'innodb_fix_misc.patch'
--- innodb_fix_misc.patch 2011-02-02 14:49:16 +0000
+++ innodb_fix_misc.patch 2011-02-08 02:15:10 +0000
@@ -8,7 +8,7 @@
8diff -ruN a/storage/innodb_plugin/handler/ha_innodb.cc b/storage/innodb_plugin/handler/ha_innodb.cc8diff -ruN a/storage/innodb_plugin/handler/ha_innodb.cc b/storage/innodb_plugin/handler/ha_innodb.cc
9--- a/storage/innodb_plugin/handler/ha_innodb.cc 2010-08-27 16:50:59.626327847 +09009--- a/storage/innodb_plugin/handler/ha_innodb.cc 2010-08-27 16:50:59.626327847 +0900
10+++ b/storage/innodb_plugin/handler/ha_innodb.cc 2010-08-27 16:55:20.281021252 +090010+++ b/storage/innodb_plugin/handler/ha_innodb.cc 2010-08-27 16:55:20.281021252 +0900
11@@ -11770,7 +11770,7 @@11@@ -11775,7 +11775,7 @@
12 &innobase_storage_engine,12 &innobase_storage_engine,
13 innobase_hton_name,13 innobase_hton_name,
14 "Innobase Oy",14 "Innobase Oy",
1515
=== modified file 'innodb_lru_dump_restore.patch'
--- innodb_lru_dump_restore.patch 2011-02-02 14:49:16 +0000
+++ innodb_lru_dump_restore.patch 2011-02-08 02:15:10 +0000
@@ -409,7 +409,7 @@
409diff -ruN a/storage/innodb_plugin/handler/ha_innodb.cc b/storage/innodb_plugin/handler/ha_innodb.cc409diff -ruN a/storage/innodb_plugin/handler/ha_innodb.cc b/storage/innodb_plugin/handler/ha_innodb.cc
410--- a/storage/innodb_plugin/handler/ha_innodb.cc 2010-10-01 09:57:56.486228425 +0900410--- a/storage/innodb_plugin/handler/ha_innodb.cc 2010-10-01 09:57:56.486228425 +0900
411+++ b/storage/innodb_plugin/handler/ha_innodb.cc 2010-10-01 10:00:13.292228546 +0900411+++ b/storage/innodb_plugin/handler/ha_innodb.cc 2010-10-01 10:00:13.292228546 +0900
412@@ -11473,6 +11473,12 @@412@@ -11478,6 +11478,12 @@
413 "Limit the allocated memory for dictionary cache. (0: unlimited)",413 "Limit the allocated memory for dictionary cache. (0: unlimited)",
414 NULL, NULL, 0, 0, LONG_MAX, 0);414 NULL, NULL, 0, 0, LONG_MAX, 0);
415 415
@@ -422,7 +422,7 @@
422 static struct st_mysql_sys_var* innobase_system_variables[]= {422 static struct st_mysql_sys_var* innobase_system_variables[]= {
423 MYSQL_SYSVAR(additional_mem_pool_size),423 MYSQL_SYSVAR(additional_mem_pool_size),
424 MYSQL_SYSVAR(autoextend_increment),424 MYSQL_SYSVAR(autoextend_increment),
425@@ -11555,6 +11561,7 @@425@@ -11560,6 +11566,7 @@
426 #endif /* UNIV_DEBUG || UNIV_IBUF_DEBUG */426 #endif /* UNIV_DEBUG || UNIV_IBUF_DEBUG */
427 MYSQL_SYSVAR(read_ahead_threshold),427 MYSQL_SYSVAR(read_ahead_threshold),
428 MYSQL_SYSVAR(io_capacity),428 MYSQL_SYSVAR(io_capacity),
429429
=== modified file 'innodb_pass_corrupt_table.patch'
--- innodb_pass_corrupt_table.patch 2011-02-02 14:49:16 +0000
+++ innodb_pass_corrupt_table.patch 2011-02-08 02:15:10 +0000
@@ -899,7 +899,7 @@
899 switch (ret) {899 switch (ret) {
900 case DB_SUCCESS:900 case DB_SUCCESS:
901 error = 0;901 error = 0;
902@@ -5852,6 +5903,10 @@902@@ -5857,6 +5908,10 @@
903 {903 {
904 DBUG_ENTER("change_active_index");904 DBUG_ENTER("change_active_index");
905 905
@@ -910,7 +910,7 @@
910 ut_ad(user_thd == ha_thd());910 ut_ad(user_thd == ha_thd());
911 ut_a(prebuilt->trx == thd_to_trx(user_thd));911 ut_a(prebuilt->trx == thd_to_trx(user_thd));
912 912
913@@ -5942,6 +5997,10 @@913@@ -5947,6 +6002,10 @@
914 914
915 DBUG_ENTER("general_fetch");915 DBUG_ENTER("general_fetch");
916 916
@@ -921,7 +921,7 @@
921 ut_a(prebuilt->trx == thd_to_trx(user_thd));921 ut_a(prebuilt->trx == thd_to_trx(user_thd));
922 922
923 innodb_srv_conc_enter_innodb(prebuilt->trx);923 innodb_srv_conc_enter_innodb(prebuilt->trx);
924@@ -5951,6 +6010,10 @@924@@ -5956,6 +6015,10 @@
925 925
926 innodb_srv_conc_exit_innodb(prebuilt->trx);926 innodb_srv_conc_exit_innodb(prebuilt->trx);
927 927
@@ -932,7 +932,7 @@
932 switch (ret) {932 switch (ret) {
933 case DB_SUCCESS:933 case DB_SUCCESS:
934 error = 0;934 error = 0;
935@@ -7201,6 +7264,10 @@935@@ -7206,6 +7269,10 @@
936 DBUG_RETURN(my_errno=HA_ERR_WRONG_COMMAND);936 DBUG_RETURN(my_errno=HA_ERR_WRONG_COMMAND);
937 }937 }
938 938
@@ -943,7 +943,7 @@
943 /* Truncate the table in InnoDB */943 /* Truncate the table in InnoDB */
944 944
945 error = row_truncate_table_for_mysql(prebuilt->table, prebuilt->trx);945 error = row_truncate_table_for_mysql(prebuilt->table, prebuilt->trx);
946@@ -7209,6 +7276,10 @@946@@ -7214,6 +7281,10 @@
947 goto fallback;947 goto fallback;
948 }948 }
949 949
@@ -954,7 +954,7 @@
954 error = convert_error_code_to_mysql(error, prebuilt->table->flags,954 error = convert_error_code_to_mysql(error, prebuilt->table->flags,
955 NULL);955 NULL);
956 956
957@@ -7721,6 +7792,16 @@957@@ -7726,6 +7797,16 @@
958 return(ranges + (double) rows / (double) total_rows * time_for_scan);958 return(ranges + (double) rows / (double) total_rows * time_for_scan);
959 }959 }
960 960
@@ -971,7 +971,7 @@
971 /*********************************************************************//**971 /*********************************************************************//**
972 Calculates the key number used inside MySQL for an Innobase index. We will972 Calculates the key number used inside MySQL for an Innobase index. We will
973 first check the "index translation table" for a match of the index to get973 first check the "index translation table" for a match of the index to get
974@@ -7842,7 +7923,7 @@974@@ -7847,7 +7928,7 @@
975 ib_table = prebuilt->table;975 ib_table = prebuilt->table;
976 976
977 if (flag & HA_STATUS_TIME) {977 if (flag & HA_STATUS_TIME) {
@@ -980,7 +980,7 @@
980 /* In sql_show we call with this flag: update980 /* In sql_show we call with this flag: update
981 then statistics so that they are up-to-date */981 then statistics so that they are up-to-date */
982 982
983@@ -8133,10 +8214,18 @@983@@ -8138,10 +8219,18 @@
984 THD* thd, /*!< in: connection thread handle */984 THD* thd, /*!< in: connection thread handle */
985 HA_CHECK_OPT* check_opt) /*!< in: currently ignored */985 HA_CHECK_OPT* check_opt) /*!< in: currently ignored */
986 {986 {
@@ -999,7 +999,7 @@
999 return(0);999 return(0);
1000 }1000 }
1001 1001
1002@@ -8318,6 +8407,10 @@1002@@ -8323,6 +8412,10 @@
1003 my_error(ER_QUERY_INTERRUPTED, MYF(0));1003 my_error(ER_QUERY_INTERRUPTED, MYF(0));
1004 }1004 }
1005 1005
@@ -1010,7 +1010,7 @@
1010 DBUG_RETURN(is_ok ? HA_ADMIN_OK : HA_ADMIN_CORRUPT);1010 DBUG_RETURN(is_ok ? HA_ADMIN_OK : HA_ADMIN_CORRUPT);
1011 }1011 }
1012 1012
1013@@ -9043,6 +9136,10 @@1013@@ -9048,6 +9141,10 @@
1014 1014
1015 update_thd(thd);1015 update_thd(thd);
1016 1016
@@ -1021,7 +1021,7 @@
1021 if (prebuilt->table->ibd_file_missing && !thd_tablespace_op(thd)) {1021 if (prebuilt->table->ibd_file_missing && !thd_tablespace_op(thd)) {
1022 ut_print_timestamp(stderr);1022 ut_print_timestamp(stderr);
1023 fprintf(stderr,1023 fprintf(stderr,
1024@@ -11487,6 +11584,14 @@1024@@ -11492,6 +11589,14 @@
1025 "0 (the default) disables automatic dumps.",1025 "0 (the default) disables automatic dumps.",
1026 NULL, NULL, 0, 0, UINT_MAX32, 0);1026 NULL, NULL, 0, 0, UINT_MAX32, 0);
1027 1027
@@ -1036,7 +1036,7 @@
1036 static struct st_mysql_sys_var* innobase_system_variables[]= {1036 static struct st_mysql_sys_var* innobase_system_variables[]= {
1037 MYSQL_SYSVAR(additional_mem_pool_size),1037 MYSQL_SYSVAR(additional_mem_pool_size),
1038 MYSQL_SYSVAR(autoextend_increment),1038 MYSQL_SYSVAR(autoextend_increment),
1039@@ -11572,6 +11677,7 @@1039@@ -11577,6 +11682,7 @@
1040 MYSQL_SYSVAR(io_capacity),1040 MYSQL_SYSVAR(io_capacity),
1041 MYSQL_SYSVAR(auto_lru_dump),1041 MYSQL_SYSVAR(auto_lru_dump),
1042 MYSQL_SYSVAR(use_purge_thread),1042 MYSQL_SYSVAR(use_purge_thread),
10431043
=== modified file 'innodb_purge_thread.patch'
--- innodb_purge_thread.patch 2011-02-02 14:49:16 +0000
+++ innodb_purge_thread.patch 2011-02-08 02:15:10 +0000
@@ -8,7 +8,7 @@
8diff -ruN a/storage/innodb_plugin/handler/ha_innodb.cc b/storage/innodb_plugin/handler/ha_innodb.cc8diff -ruN a/storage/innodb_plugin/handler/ha_innodb.cc b/storage/innodb_plugin/handler/ha_innodb.cc
9--- a/storage/innodb_plugin/handler/ha_innodb.cc 2010-08-27 16:23:31.022060427 +09009--- a/storage/innodb_plugin/handler/ha_innodb.cc 2010-08-27 16:23:31.022060427 +0900
10+++ b/storage/innodb_plugin/handler/ha_innodb.cc 2010-08-27 16:25:49.004020662 +090010+++ b/storage/innodb_plugin/handler/ha_innodb.cc 2010-08-27 16:25:49.004020662 +0900
11@@ -10974,6 +10974,11 @@11@@ -10979,6 +10979,11 @@
12 "Output statistics of recovery process after it.",12 "Output statistics of recovery process after it.",
13 NULL, NULL, FALSE);13 NULL, NULL, FALSE);
14 14
@@ -20,7 +20,7 @@
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,
21 PLUGIN_VAR_NOCMDARG | PLUGIN_VAR_READONLY,21 PLUGIN_VAR_NOCMDARG | PLUGIN_VAR_READONLY,
22 "During InnoDB crash recovery on slave overwrite relay-log.info "22 "During InnoDB crash recovery on slave overwrite relay-log.info "
23@@ -11497,6 +11502,7 @@23@@ -11502,6 +11507,7 @@
24 #endif /* UNIV_DEBUG || UNIV_IBUF_DEBUG */24 #endif /* UNIV_DEBUG || UNIV_IBUF_DEBUG */
25 MYSQL_SYSVAR(read_ahead_threshold),25 MYSQL_SYSVAR(read_ahead_threshold),
26 MYSQL_SYSVAR(io_capacity),26 MYSQL_SYSVAR(io_capacity),
2727
=== modified file 'innodb_recovery_patches.patch'
--- innodb_recovery_patches.patch 2010-12-16 11:35:26 +0000
+++ innodb_recovery_patches.patch 2011-02-08 02:15:10 +0000
@@ -127,7 +127,7 @@
127 srv_use_doublewrite_buf = (ibool) innobase_use_doublewrite;127 srv_use_doublewrite_buf = (ibool) innobase_use_doublewrite;
128 srv_use_checksums = (ibool) innobase_use_checksums;128 srv_use_checksums = (ibool) innobase_use_checksums;
129 129
130@@ -10960,6 +10964,16 @@130@@ -10965,6 +10969,16 @@
131 "don't use the datafile for normal mysqld or ibbackup! ####",131 "don't use the datafile for normal mysqld or ibbackup! ####",
132 NULL, NULL, FALSE);132 NULL, NULL, FALSE);
133 133
@@ -144,7 +144,7 @@
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,
145 PLUGIN_VAR_NOCMDARG | PLUGIN_VAR_READONLY,145 PLUGIN_VAR_NOCMDARG | PLUGIN_VAR_READONLY,
146 "During InnoDB crash recovery on slave overwrite relay-log.info "146 "During InnoDB crash recovery on slave overwrite relay-log.info "
147@@ -11412,6 +11426,8 @@147@@ -11417,6 +11431,8 @@
148 MYSQL_SYSVAR(data_home_dir),148 MYSQL_SYSVAR(data_home_dir),
149 MYSQL_SYSVAR(doublewrite),149 MYSQL_SYSVAR(doublewrite),
150 MYSQL_SYSVAR(extra_undoslots),150 MYSQL_SYSVAR(extra_undoslots),
151151
=== modified file 'innodb_separate_doublewrite.patch'
--- innodb_separate_doublewrite.patch 2011-02-02 14:49:16 +0000
+++ innodb_separate_doublewrite.patch 2011-02-08 02:15:10 +0000
@@ -357,7 +357,7 @@
357 srv_extra_undoslots = (ibool) innobase_extra_undoslots;357 srv_extra_undoslots = (ibool) innobase_extra_undoslots;
358 358
359 srv_use_sys_stats_table = (ibool) innobase_use_sys_stats_table;359 srv_use_sys_stats_table = (ibool) innobase_use_sys_stats_table;
360@@ -11321,6 +11324,11 @@360@@ -11326,6 +11329,11 @@
361 "Path to individual files and their sizes.",361 "Path to individual files and their sizes.",
362 NULL, NULL, NULL);362 NULL, NULL, NULL);
363 363
@@ -369,7 +369,7 @@
369 static MYSQL_SYSVAR_LONG(autoinc_lock_mode, innobase_autoinc_lock_mode,369 static MYSQL_SYSVAR_LONG(autoinc_lock_mode, innobase_autoinc_lock_mode,
370 PLUGIN_VAR_RQCMDARG | PLUGIN_VAR_READONLY,370 PLUGIN_VAR_RQCMDARG | PLUGIN_VAR_READONLY,
371 "The AUTOINC lock modes supported by InnoDB: "371 "The AUTOINC lock modes supported by InnoDB: "
372@@ -11487,6 +11495,7 @@372@@ -11492,6 +11500,7 @@
373 MYSQL_SYSVAR(commit_concurrency),373 MYSQL_SYSVAR(commit_concurrency),
374 MYSQL_SYSVAR(concurrency_tickets),374 MYSQL_SYSVAR(concurrency_tickets),
375 MYSQL_SYSVAR(data_file_path),375 MYSQL_SYSVAR(data_file_path),
376376
=== modified file 'innodb_show_lock_name.patch'
--- innodb_show_lock_name.patch 2011-02-02 14:49:16 +0000
+++ innodb_show_lock_name.patch 2011-02-08 02:15:10 +0000
@@ -8,7 +8,7 @@
8diff -ruN a/storage/innodb_plugin/handler/ha_innodb.cc b/storage/innodb_plugin/handler/ha_innodb.cc8diff -ruN a/storage/innodb_plugin/handler/ha_innodb.cc b/storage/innodb_plugin/handler/ha_innodb.cc
9--- a/storage/innodb_plugin/handler/ha_innodb.cc 2010-08-27 16:29:12.539982446 +09009--- a/storage/innodb_plugin/handler/ha_innodb.cc 2010-08-27 16:29:12.539982446 +0900
10+++ b/storage/innodb_plugin/handler/ha_innodb.cc 2010-08-27 16:29:24.322059309 +090010+++ b/storage/innodb_plugin/handler/ha_innodb.cc 2010-08-27 16:29:24.322059309 +0900
11@@ -9233,8 +9233,8 @@11@@ -9238,8 +9238,8 @@
12 rw_lock_wait_time += mutex->lspent_time;12 rw_lock_wait_time += mutex->lspent_time;
13 }13 }
14 #else /* UNIV_DEBUG */14 #else /* UNIV_DEBUG */
@@ -19,7 +19,7 @@
19 buf2len= (uint) my_snprintf(buf2, sizeof(buf2), "os_waits=%lu",19 buf2len= (uint) my_snprintf(buf2, sizeof(buf2), "os_waits=%lu",
20 (ulong) mutex->count_os_wait);20 (ulong) mutex->count_os_wait);
21 21
22@@ -9249,9 +9249,8 @@22@@ -9254,9 +9254,8 @@
23 23
24 if (block_mutex) {24 if (block_mutex) {
25 buf1len = (uint) my_snprintf(buf1, sizeof buf1,25 buf1len = (uint) my_snprintf(buf1, sizeof buf1,
@@ -31,7 +31,7 @@
31 buf2len = (uint) my_snprintf(buf2, sizeof buf2,31 buf2len = (uint) my_snprintf(buf2, sizeof buf2,
32 "os_waits=%lu",32 "os_waits=%lu",
33 (ulong) block_mutex_oswait_count);33 (ulong) block_mutex_oswait_count);
34@@ -9280,8 +9279,8 @@34@@ -9285,8 +9284,8 @@
35 continue;35 continue;
36 }36 }
37 37
@@ -42,7 +42,7 @@
42 buf2len = my_snprintf(buf2, sizeof buf2, "os_waits=%lu",42 buf2len = my_snprintf(buf2, sizeof buf2, "os_waits=%lu",
43 (ulong) lock->count_os_wait);43 (ulong) lock->count_os_wait);
44 44
45@@ -9295,9 +9294,8 @@45@@ -9300,9 +9299,8 @@
46 46
47 if (block_lock) {47 if (block_lock) {
48 buf1len = (uint) my_snprintf(buf1, sizeof buf1,48 buf1len = (uint) my_snprintf(buf1, sizeof buf1,
4949
=== modified file 'innodb_show_sys_tables.patch'
--- innodb_show_sys_tables.patch 2010-12-16 11:35:26 +0000
+++ innodb_show_sys_tables.patch 2011-02-08 02:15:10 +0000
@@ -8,7 +8,7 @@
8diff -ruN a/storage/innodb_plugin/handler/ha_innodb.cc b/storage/innodb_plugin/handler/ha_innodb.cc8diff -ruN a/storage/innodb_plugin/handler/ha_innodb.cc b/storage/innodb_plugin/handler/ha_innodb.cc
9--- a/storage/innodb_plugin/handler/ha_innodb.cc 2010-08-27 16:45:46.194411503 +09009--- a/storage/innodb_plugin/handler/ha_innodb.cc 2010-08-27 16:45:46.194411503 +0900
10+++ b/storage/innodb_plugin/handler/ha_innodb.cc 2010-08-27 16:49:26.171990559 +090010+++ b/storage/innodb_plugin/handler/ha_innodb.cc 2010-08-27 16:49:26.171990559 +0900
11@@ -11793,6 +11793,9 @@11@@ -11798,6 +11798,9 @@
12 i_s_innodb_table_stats,12 i_s_innodb_table_stats,
13 i_s_innodb_index_stats,13 i_s_innodb_index_stats,
14 i_s_innodb_admin_command,14 i_s_innodb_admin_command,
1515
=== modified file 'innodb_stats.patch'
--- innodb_stats.patch 2011-02-02 14:49:16 +0000
+++ innodb_stats.patch 2011-02-08 02:15:10 +0000
@@ -1128,7 +1128,19 @@
1128 innodb_srv_conc_exit_innodb(trx);1128 innodb_srv_conc_exit_innodb(trx);
1129 1129
1130 error = convert_error_code_to_mysql(1130 error = convert_error_code_to_mysql(
1131@@ -5897,6 +5912,11 @@1131@@ -5688,6 +5703,11 @@
1132 case DB_SUCCESS:
1133 error = 0;
1134 table->status = 0;
1135+#ifdef EXTENDED_FOR_USERSTAT
1136+ rows_read++;
1137+ if (active_index < MAX_KEY)
1138+ index_rows_read[active_index]++;
1139+#endif
1140 break;
1141 case DB_RECORD_NOT_FOUND:
1142 error = HA_ERR_KEY_NOT_FOUND;
1143@@ -5897,6 +5917,11 @@
1132 case DB_SUCCESS:1144 case DB_SUCCESS:
1133 error = 0;1145 error = 0;
1134 table->status = 0;1146 table->status = 0;
@@ -1140,7 +1152,7 @@
1140 break;1152 break;
1141 case DB_RECORD_NOT_FOUND:1153 case DB_RECORD_NOT_FOUND:
1142 error = HA_ERR_END_OF_FILE;1154 error = HA_ERR_END_OF_FILE;
1143@@ -7783,11 +7803,31 @@1155@@ -7783,11 +7808,31 @@
1144 /* In sql_show we call with this flag: update1156 /* In sql_show we call with this flag: update
1145 then statistics so that they are up-to-date */1157 then statistics so that they are up-to-date */
1146 1158
@@ -1173,7 +1185,7 @@
1173 1185
1174 prebuilt->trx->op_info = "returning various info to MySQL";1186 prebuilt->trx->op_info = "returning various info to MySQL";
1175 }1187 }
1176@@ -7865,7 +7905,7 @@1188@@ -7865,7 +7910,7 @@
1177 are asked by MySQL to avoid locking. Another reason to1189 are asked by MySQL to avoid locking. Another reason to
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.
1179 See Bug#38185. */1191 See Bug#38185. */
@@ -1182,7 +1194,7 @@
1182 /* We do not update delete_length if no1194 /* We do not update delete_length if no
1183 locking is requested so the "old" value can1195 locking is requested so the "old" value can
1184 remain. delete_length is initialized to 0 in1196 remain. delete_length is initialized to 0 in
1185@@ -11045,6 +11085,45 @@1197@@ -11045,6 +11090,45 @@
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)",
1187 NULL, NULL, 8, 1, ~0ULL, 0);1199 NULL, NULL, 8, 1, ~0ULL, 0);
1188 1200
@@ -1228,7 +1240,7 @@
1228 static MYSQL_SYSVAR_BOOL(adaptive_hash_index, btr_search_enabled,1240 static MYSQL_SYSVAR_BOOL(adaptive_hash_index, btr_search_enabled,
1229 PLUGIN_VAR_OPCMDARG,1241 PLUGIN_VAR_OPCMDARG,
1230 "Enable InnoDB adaptive hash index (enabled by default). "1242 "Enable InnoDB adaptive hash index (enabled by default). "
1231@@ -11363,6 +11442,10 @@1243@@ -11363,6 +11447,10 @@
1232 MYSQL_SYSVAR(overwrite_relay_log_info),1244 MYSQL_SYSVAR(overwrite_relay_log_info),
1233 MYSQL_SYSVAR(rollback_on_timeout),1245 MYSQL_SYSVAR(rollback_on_timeout),
1234 MYSQL_SYSVAR(stats_on_metadata),1246 MYSQL_SYSVAR(stats_on_metadata),
@@ -1239,7 +1251,7 @@
1239 MYSQL_SYSVAR(stats_sample_pages),1251 MYSQL_SYSVAR(stats_sample_pages),
1240 MYSQL_SYSVAR(adaptive_hash_index),1252 MYSQL_SYSVAR(adaptive_hash_index),
1241 MYSQL_SYSVAR(replication_delay),1253 MYSQL_SYSVAR(replication_delay),
1242@@ -11427,6 +11510,8 @@1254@@ -11427,6 +11515,8 @@
1243 i_s_innodb_cmp_reset,1255 i_s_innodb_cmp_reset,
1244 i_s_innodb_cmpmem,1256 i_s_innodb_cmpmem,
1245 i_s_innodb_cmpmem_reset,1257 i_s_innodb_cmpmem_reset,

Subscribers

People subscribed via source and target branches

to all changes: