Merge lp:~linuxjedi/drizzle/trunk-bug-655186 into lp:~drizzle-trunk/drizzle/development

Proposed by Andrew Hutchings
Status: Merged
Approved by: Brian Aker
Approved revision: 1849
Merged at revision: 1850
Proposed branch: lp:~linuxjedi/drizzle/trunk-bug-655186
Merge into: lp:~drizzle-trunk/drizzle/development
Diff against target: 64 lines (+8/-18)
1 file modified
plugin/innobase/handler/ha_innodb.cc (+8/-18)
To merge this branch: bzr merge lp:~linuxjedi/drizzle/trunk-bug-655186
Reviewer Review Type Date Requested Status
Drizzle Merge Team Pending
Review via email: mp+38414@code.launchpad.net

Description of the change

Remove stats_on_metadata option as it is only used for Analyze command in Drizzle and shouldn't even be used for that.

To post a comment you must log in.

Preview Diff

[H/L] Next/Prev Comment, [J/K] Next/Prev File, [N/P] Next/Prev Hunk
=== modified file 'plugin/innobase/handler/ha_innodb.cc'
--- plugin/innobase/handler/ha_innodb.cc 2010-10-12 12:50:35 +0000
+++ plugin/innobase/handler/ha_innodb.cc 2010-10-14 12:41:20 +0000
@@ -235,7 +235,6 @@
235static my_bool innobase_use_checksums = TRUE;235static my_bool innobase_use_checksums = TRUE;
236static my_bool innobase_rollback_on_timeout = FALSE;236static my_bool innobase_rollback_on_timeout = FALSE;
237static my_bool innobase_create_status_file = FALSE;237static my_bool innobase_create_status_file = FALSE;
238static my_bool innobase_stats_on_metadata = TRUE;
239238
240static char* internal_innobase_data_file_path = NULL;239static char* internal_innobase_data_file_path = NULL;
241240
@@ -1846,7 +1845,6 @@
1846 innobase_use_checksums= (vm.count("disable-checksums")) ? false : true;1845 innobase_use_checksums= (vm.count("disable-checksums")) ? false : true;
1847 innobase_use_doublewrite= (vm.count("disable-doublewrite")) ? false : true;1846 innobase_use_doublewrite= (vm.count("disable-doublewrite")) ? false : true;
1848 srv_adaptive_flushing= (vm.count("disable-adaptive-flushing")) ? false : true;1847 srv_adaptive_flushing= (vm.count("disable-adaptive-flushing")) ? false : true;
1849 innobase_stats_on_metadata= (vm.count("disable-stats-on-metadata")) ? false : true;
1850 srv_use_sys_malloc= (vm.count("use-internal-malloc")) ? false : true;1848 srv_use_sys_malloc= (vm.count("use-internal-malloc")) ? false : true;
1851 (SessionVAR(NULL,support_xa))= (vm.count("disable-xa")) ? false : true;1849 (SessionVAR(NULL,support_xa))= (vm.count("disable-xa")) ? false : true;
1852 (SessionVAR(NULL,table_locks))= (vm.count("disable-table-locks")) ? false : true;1850 (SessionVAR(NULL,table_locks))= (vm.count("disable-table-locks")) ? false : true;
@@ -6563,16 +6561,14 @@
6563 ib_table = prebuilt->table;6561 ib_table = prebuilt->table;
65646562
6565 if (flag & HA_STATUS_TIME) {6563 if (flag & HA_STATUS_TIME) {
6566 if (innobase_stats_on_metadata) {6564 /* In Analyze we call with this flag: update
6567 /* In sql_show we call with this flag: update6565 then statistics so that they are up-to-date */
6568 then statistics so that they are up-to-date */6566
65696567 prebuilt->trx->op_info = "updating table statistics";
6570 prebuilt->trx->op_info = "updating table statistics";6568
65716569 dict_update_statistics(ib_table);
6572 dict_update_statistics(ib_table);6570
65736571 prebuilt->trx->op_info = "returning various info to MySQL";
6574 prebuilt->trx->op_info = "returning various info to MySQL";
6575 }
65766572
6577 fs::path get_status_path(getDataHomeCatalog());6573 fs::path get_status_path(getDataHomeCatalog());
6578 get_status_path /= ib_table->name;6574 get_status_path /= ib_table->name;
@@ -8815,11 +8811,6 @@
8815 "Enable SHOW INNODB STATUS output in the innodb_status.<pid> file",8811 "Enable SHOW INNODB STATUS output in the innodb_status.<pid> file",
8816 NULL, NULL, FALSE);8812 NULL, NULL, FALSE);
88178813
8818static DRIZZLE_SYSVAR_BOOL(stats_on_metadata, innobase_stats_on_metadata,
8819 PLUGIN_VAR_OPCMDARG,
8820 "Enable statistics gathering for metadata commands such as SHOW TABLE STATUS (on by default)",
8821 NULL, NULL, TRUE);
8822
8823static DRIZZLE_SYSVAR_ULONGLONG(stats_sample_pages, srv_stats_sample_pages,8814static DRIZZLE_SYSVAR_ULONGLONG(stats_sample_pages, srv_stats_sample_pages,
8824 PLUGIN_VAR_RQCMDARG,8815 PLUGIN_VAR_RQCMDARG,
8825 "The number of index pages to sample when calculating statistics (default 8)",8816 "The number of index pages to sample when calculating statistics (default 8)",
@@ -9134,7 +9125,6 @@
9134 DRIZZLE_SYSVAR(old_blocks_pct),9125 DRIZZLE_SYSVAR(old_blocks_pct),
9135 DRIZZLE_SYSVAR(old_blocks_time),9126 DRIZZLE_SYSVAR(old_blocks_time),
9136 DRIZZLE_SYSVAR(open_files),9127 DRIZZLE_SYSVAR(open_files),
9137 DRIZZLE_SYSVAR(stats_on_metadata),
9138 DRIZZLE_SYSVAR(stats_sample_pages),9128 DRIZZLE_SYSVAR(stats_sample_pages),
9139 DRIZZLE_SYSVAR(adaptive_hash_index),9129 DRIZZLE_SYSVAR(adaptive_hash_index),
9140 DRIZZLE_SYSVAR(replication_delay),9130 DRIZZLE_SYSVAR(replication_delay),