innodb_admin_command_base.patch

   1 # name       : innodb_admin_command_base.patch
   2 # introduced : 11 or before
   3 # maintainer : Yasufumi
   4 #
   5 #!!! notice !!!
   6 # Any small change to this file in the main branch
   7 # should be done or reviewed by the maintainer!
   8 diff -ruN a/storage/innobase/handler/ha_innodb.cc b/storage/innobase/handler/ha_innodb.cc
   9 --- a/storage/innobase/handler/ha_innodb.cc     2010-12-03 17:32:15.624039043 +0900
  10 +++ b/storage/innobase/handler/ha_innodb.cc     2010-12-03 17:32:35.424957827 +0900
  11 @@ -11772,7 +11772,8 @@
  12  i_s_innodb_sys_foreign_cols,
  13  i_s_innodb_sys_stats,
  14  i_s_innodb_table_stats,
  15 -i_s_innodb_index_stats
  16 +i_s_innodb_index_stats,
  17 +i_s_innodb_admin_command
  18  mysql_declare_plugin_end;
  19
  20  /** @brief Initialize the default value of innodb_commit_concurrency.
  21 diff -ruN a/storage/innobase/handler/i_s.cc b/storage/innobase/handler/i_s.cc
  22 --- a/storage/innobase/handler/i_s.cc   2010-12-03 17:30:16.299955549 +0900
  23 +++ b/storage/innobase/handler/i_s.cc   2010-12-03 17:32:35.425989972 +0900
  24 @@ -4161,3 +4161,139 @@
  25         STRUCT_FLD(system_vars, NULL),
  26         STRUCT_FLD(__reserved1, NULL)
  27  };
  28 +
  29 +/***********************************************************************
  30 +*/
  31 +static ST_FIELD_INFO   i_s_innodb_admin_command_info[] =
  32 +{
  33 +       {STRUCT_FLD(field_name,         "result_message"),
  34 +        STRUCT_FLD(field_length,       1024),
  35 +        STRUCT_FLD(field_type,         MYSQL_TYPE_STRING),
  36 +        STRUCT_FLD(value,              0),
  37 +        STRUCT_FLD(field_flags,        0),
  38 +        STRUCT_FLD(old_name,           ""),
  39 +        STRUCT_FLD(open_method,        SKIP_OPEN_TABLE)},
  40 +
  41 +       END_OF_ST_FIELD_INFO
  42 +};
  43 +
  44 +#ifndef INNODB_COMPATIBILITY_HOOKS
  45 +#error InnoDB needs MySQL to be built with #define INNODB_COMPATIBILITY_HOOKS
  46 +#endif
  47 +
  48 +extern "C" {
  49 +char **thd_query(MYSQL_THD thd);
  50 +}
  51 +
  52 +static
  53 +int
  54 +i_s_innodb_admin_command_fill(
  55 +/*==========================*/
  56 +       THD*            thd,
  57 +       TABLE_LIST*     tables,
  58 +       COND*           cond)
  59 +{
  60 +       TABLE*  i_s_table       = (TABLE *) tables->table;
  61 +       char**  query_str;
  62 +       char*   ptr;
  63 +       char    quote   = '\0';
  64 +       const char*     command_head = "XTRA_";
  65 +
  66 +       DBUG_ENTER("i_s_innodb_admin_command_fill");
  67 +
  68 +       /* deny access to non-superusers */
  69 +       if (check_global_access(thd, PROCESS_ACL)) {
  70 +               DBUG_RETURN(0);
  71 +       }
  72 +
  73 +       if(thd_sql_command(thd) != SQLCOM_SELECT) {
  74 +               field_store_string(i_s_table->field[0],
  75 +                       "SELECT command is only accepted.");
  76 +               goto end_func;
  77 +       }
  78 +
  79 +       query_str = thd_query(thd);
  80 +       ptr = *query_str;
  81 +
  82 +       for (; *ptr; ptr++) {
  83 +               if (*ptr == quote) {
  84 +                       quote = '\0';
  85 +               } else if (quote) {
  86 +               } else if (*ptr == '`' || *ptr == '"') {
  87 +                       quote = *ptr;
  88 +               } else {
  89 +                       long    i;
  90 +                       for (i = 0; command_head[i]; i++) {
  91 +                               if (toupper((int)(unsigned char)(ptr[i]))
  92 +                                   != toupper((int)(unsigned char)
  93 +                                     (command_head[i]))) {
  94 +                                       goto nomatch;
  95 +                               }
  96 +                       }
  97 +                       break;
  98 +nomatch:
  99 +                       ;
 100 +               }
 101 +       }
 102 +
 103 +       if (!*ptr) {
 104 +               field_store_string(i_s_table->field[0],
 105 +                       "No XTRA_* command in the SQL statement."
 106 +                       " Please add /*!XTRA_xxxx*/ to the SQL.");
 107 +               goto end_func;
 108 +       }
 109 +
 110 +       if (!strncasecmp("XTRA_HELLO", ptr, 10)) {
 111 +               /* This is example command XTRA_HELLO */
 112 +
 113 +               ut_print_timestamp(stderr);
 114 +               fprintf(stderr, " InnoDB: administration command test for XtraDB"
 115 +                               " 'XTRA_HELLO' was detected.\n");
 116 +
 117 +               field_store_string(i_s_table->field[0],
 118 +                       "Hello!");
 119 +               goto end_func;
 120 +       }
 121 +
 122 +       field_store_string(i_s_table->field[0],
 123 +               "Undefined XTRA_* command.");
 124 +       goto end_func;
 125 +
 126 +end_func:
 127 +       if (schema_table_store_record(thd, i_s_table)) {
 128 +               DBUG_RETURN(1);
 129 +       } else {
 130 +               DBUG_RETURN(0);
 131 +       }
 132 +}
 133 +
 134 +static
 135 +int
 136 +i_s_innodb_admin_command_init(
 137 +/*==========================*/
 138 +       void*   p)
 139 +{
 140 +       DBUG_ENTER("i_s_innodb_admin_command_init");
 141 +       ST_SCHEMA_TABLE* schema = (ST_SCHEMA_TABLE*) p;
 142 +
 143 +       schema->fields_info = i_s_innodb_admin_command_info;
 144 +       schema->fill_table = i_s_innodb_admin_command_fill;
 145 +
 146 +       DBUG_RETURN(0);
 147 +}
 148 +
 149 +UNIV_INTERN struct st_mysql_plugin     i_s_innodb_admin_command =
 150 +{
 151 +       STRUCT_FLD(type, MYSQL_INFORMATION_SCHEMA_PLUGIN),
 152 +       STRUCT_FLD(info, &i_s_info),
 153 +       STRUCT_FLD(name, "XTRADB_ADMIN_COMMAND"),
 154 +       STRUCT_FLD(author, plugin_author),
 155 +       STRUCT_FLD(descr, "XtraDB specific command acceptor"),
 156 +       STRUCT_FLD(license, PLUGIN_LICENSE_GPL),
 157 +       STRUCT_FLD(init, i_s_innodb_admin_command_init),
 158 +       STRUCT_FLD(deinit, i_s_common_deinit),
 159 +       STRUCT_FLD(version, 0x0100 /* 1.0 */),
 160 +       STRUCT_FLD(status_vars, NULL),
 161 +       STRUCT_FLD(system_vars, NULL),
 162 +       STRUCT_FLD(__reserved1, NULL)
 163 +};
 164 diff -ruN a/storage/innobase/handler/i_s.h b/storage/innobase/handler/i_s.h
 165 --- a/storage/innobase/handler/i_s.h    2010-12-03 17:30:16.301987692 +0900
 166 +++ b/storage/innobase/handler/i_s.h    2010-12-03 17:32:35.426954555 +0900
 167 @@ -44,5 +44,6 @@
 168  extern struct st_mysql_plugin  i_s_innodb_sys_stats;
 169  extern struct st_mysql_plugin  i_s_innodb_table_stats;
 170  extern struct st_mysql_plugin  i_s_innodb_index_stats;
 171 +extern struct st_mysql_plugin  i_s_innodb_admin_command;
 172
 173  #endif /* i_s_h */