sql_show.cc 37.7 KB
Newer Older
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1
/* Copyright (C) 2000 MySQL AB & MySQL Finland AB & TCX DataKonsult AB
2

bk@work.mysql.com's avatar
bk@work.mysql.com committed
3 4 5 6
   This program is free software; you can redistribute it and/or modify
   it under the terms of the GNU General Public License as published by
   the Free Software Foundation; either version 2 of the License, or
   (at your option) any later version.
7

bk@work.mysql.com's avatar
bk@work.mysql.com committed
8 9 10 11
   This program is distributed in the hope that it will be useful,
   but WITHOUT ANY WARRANTY; without even the implied warranty of
   MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
   GNU General Public License for more details.
12

bk@work.mysql.com's avatar
bk@work.mysql.com committed
13 14 15 16 17 18 19 20
   You should have received a copy of the GNU General Public License
   along with this program; if not, write to the Free Software
   Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA  02111-1307  USA */


/* Function with list databases, tables or fields */

#include "mysql_priv.h"
21
#include "sql_select.h"                         // For select_describe
bk@work.mysql.com's avatar
bk@work.mysql.com committed
22 23
#include "sql_acl.h"
#include <my_dir.h>
24

tim@cane.mysql.fi's avatar
tim@cane.mysql.fi committed
25 26 27 28
#ifdef HAVE_BERKELEY_DB
#include "ha_berkeley.h"			// For berkeley_show_logs
#endif

29
/* extern "C" pthread_mutex_t THR_LOCK_keycache; */
bk@work.mysql.com's avatar
bk@work.mysql.com committed
30 31 32 33 34 35

static const char *grant_names[]={
  "select","insert","update","delete","create","drop","reload","shutdown",
  "process","file","grant","references","index","alter"};

static TYPELIB grant_types = { sizeof(grant_names)/sizeof(char **),
36 37
                               "grant_types",
                               grant_names};
bk@work.mysql.com's avatar
bk@work.mysql.com committed
38 39

static int mysql_find_files(THD *thd,List<char> *files, const char *db,
40
                            const char *path, const char *wild, bool dir);
bk@work.mysql.com's avatar
bk@work.mysql.com committed
41 42

static int
43 44 45 46
store_create_info(THD *thd, TABLE *table, String *packet);

static void
append_identifier(THD *thd, String *packet, const char *name);
bk@work.mysql.com's avatar
bk@work.mysql.com committed
47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63

/****************************************************************************
** Send list of databases
** A database is a directory in the mysql_data_home directory
****************************************************************************/


int
mysqld_show_dbs(THD *thd,const char *wild)
{
  Item_string *field=new Item_string("",0);
  List<Item> field_list;
  char *end;
  List<char> files;
  char *file_name;
  DBUG_ENTER("mysqld_show_dbs");

64
  field->name=(char*) thd->alloc(20+ (wild ? (uint) strlen(wild)+4: 0));
bk@work.mysql.com's avatar
bk@work.mysql.com committed
65 66 67 68 69 70 71 72 73 74 75 76 77
  field->max_length=NAME_LEN;
  end=strmov(field->name,"Database");
  if (wild && wild[0])
    strxmov(end," (",wild,")",NullS);
  field_list.push_back(field);

  if (send_fields(thd,field_list,1))
    DBUG_RETURN(1);
  if (mysql_find_files(thd,&files,NullS,mysql_data_home,wild,1))
    DBUG_RETURN(1);
  List_iterator<char> it(files);
  while ((file_name=it++))
  {
78 79 80 81 82 83 84 85 86 87 88
    if (!opt_safe_show_db || thd->master_access ||
	acl_get(thd->host, thd->ip, (char*) &thd->remote.sin_addr,
		thd->priv_user, file_name) ||
	(grant_option && !check_grant_db(thd, file_name)))
      {
      thd->packet.length(0);
      net_store_data(&thd->packet,file_name);
      if (my_net_write(&thd->net, (char*) thd->packet.ptr(),
		       thd->packet.length()))
	DBUG_RETURN(-1);
    }
bk@work.mysql.com's avatar
bk@work.mysql.com committed
89 90 91 92 93
  }
  send_eof(&thd->net);
  DBUG_RETURN(0);
}

94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115
/***************************************************************************
** List all open tables in a database
***************************************************************************/

int mysqld_show_open_tables(THD *thd,const char *db,const char *wild)
{
  Item_string *field=new Item_string("",0);
  List<Item> field_list;
  char *end,*table_name;
  List<char> tables;
  DBUG_ENTER("mysqld_show_open_tables");

  field->name=(char*) thd->alloc(20+(uint) strlen(db)+(wild ? (uint) strlen(wild)+4:0));
  end=strxmov(field->name,"Open_tables_in_",db,NullS);
  if (wild && wild[0])
    strxmov(end," (",wild,")",NullS);
  field->max_length=NAME_LEN;
  field_list.push_back(field);
  field_list.push_back(new Item_empty_string("Comment",80));

  if (send_fields(thd,field_list,1))
    DBUG_RETURN(1);
116

117 118 119 120 121 122 123 124 125 126
  if (list_open_tables(thd,&tables,db,wild))
    DBUG_RETURN(-1);

  List_iterator<char> it(tables);
  while ((table_name=it++))
  {
    thd->packet.length(0);
    net_store_data(&thd->packet,table_name);
    net_store_data(&thd->packet,query_table_status(thd,db,table_name));
    if (my_net_write(&thd->net,(char*) thd->packet.ptr(),thd->packet.length()))
127
    {
128
      DBUG_RETURN(-1);
129
    }
130 131 132 133 134
  }
  send_eof(&thd->net);
  DBUG_RETURN(0);
}

135

bk@work.mysql.com's avatar
bk@work.mysql.com committed
136 137 138 139 140 141 142 143 144 145 146 147 148 149
/***************************************************************************
** List all tables in a database (fast version)
** A table is a .frm file in the current databasedir
***************************************************************************/

int mysqld_show_tables(THD *thd,const char *db,const char *wild)
{
  Item_string *field=new Item_string("",0);
  List<Item> field_list;
  char path[FN_LEN],*end;
  List<char> files;
  char *file_name;
  DBUG_ENTER("mysqld_show_tables");

150
  field->name=(char*) thd->alloc(20+(uint) strlen(db)+(wild ? (uint) strlen(wild)+4:0));
bk@work.mysql.com's avatar
bk@work.mysql.com committed
151 152 153 154 155 156 157 158 159 160 161 162 163 164 165 166 167 168 169 170 171 172 173 174 175 176
  end=strxmov(field->name,"Tables_in_",db,NullS);
  if (wild && wild[0])
    strxmov(end," (",wild,")",NullS);
  field->max_length=NAME_LEN;
  (void) sprintf(path,"%s/%s",mysql_data_home,db);
  (void) unpack_dirname(path,path);
  field_list.push_back(field);
  if (send_fields(thd,field_list,1))
    DBUG_RETURN(1);
  if (mysql_find_files(thd,&files,db,path,wild,0))
    DBUG_RETURN(-1);
  List_iterator<char> it(files);
  while ((file_name=it++))
  {
    thd->packet.length(0);
    net_store_data(&thd->packet,file_name);
    if (my_net_write(&thd->net,(char*) thd->packet.ptr(),thd->packet.length()))
      DBUG_RETURN(-1);
  }
  send_eof(&thd->net);
  DBUG_RETURN(0);
}


static int
mysql_find_files(THD *thd,List<char> *files, const char *db,const char *path,
177
                 const char *wild, bool dir)
bk@work.mysql.com's avatar
bk@work.mysql.com committed
178 179 180 181 182 183 184 185 186
{
  uint i;
  char *ext;
  MY_DIR *dirp;
  FILEINFO *file;
  uint col_access=thd->col_access;
  TABLE_LIST table_list;
  DBUG_ENTER("mysql_find_files");

187 188
  if (wild && !wild[0])
    wild=0;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
189 190 191 192 193
  bzero((char*) &table_list,sizeof(table_list));

  if (!(dirp = my_dir(path,MYF(MY_WME | (dir ? MY_WANT_STAT : 0)))))
    DBUG_RETURN(-1);

194
  for (i=0 ; i < (uint) dirp->number_off_files  ; i++)
bk@work.mysql.com's avatar
bk@work.mysql.com committed
195 196 197
  {
    file=dirp->dir_entry+i;
    if (dir)
198
    {                                           /* Return databases */
bk@work.mysql.com's avatar
bk@work.mysql.com committed
199 200 201
#ifdef USE_SYMDIR
      char *ext;
      if (my_use_symdir && !strcmp(ext=fn_ext(file->name), ".sym"))
202
        *ext=0;                                 /* Remove extension */
bk@work.mysql.com's avatar
bk@work.mysql.com committed
203 204 205
      else
#endif
      {
206
        if (file->name[0] == '.' || !MY_S_ISDIR(file->mystat.st_mode) ||
207
            (wild && wild_compare(file->name,wild)))
208
          continue;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
209 210 211 212
      }
    }
    else
    {
213
        // Return only .frm files which aren't temp files.
bk@work.mysql.com's avatar
bk@work.mysql.com committed
214
      if (my_strcasecmp(ext=fn_ext(file->name),reg_ext) ||
215
          is_prefix(file->name,tmp_file_prefix))
216
        continue;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
217
      *ext=0;
218 219 220 221 222 223 224 225 226 227
      if (wild)
      {
	if (lower_case_table_names)
	{
	  if (wild_case_compare(file->name,wild))
	    continue;
	}
	else if (wild_compare(file->name,wild))
	  continue;
      }
bk@work.mysql.com's avatar
bk@work.mysql.com committed
228 229 230 231 232 233 234
    }
    /* Don't show tables where we don't have any privileges */
    if (db && !(col_access & TABLE_ACLS))
    {
      table_list.db= (char*) db;
      table_list.real_name=file->name;
      table_list.grant.privilege=col_access;
monty@hundin.mysql.fi's avatar
monty@hundin.mysql.fi committed
235
      if (check_grant(thd,TABLE_ACLS,&table_list,1,1))
236
        continue;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
237
    }
238
    if (files->push_back(thd->strdup(file->name)))
bk@work.mysql.com's avatar
bk@work.mysql.com committed
239 240 241 242 243 244 245 246 247 248 249 250 251 252 253 254 255 256 257 258 259 260 261 262 263 264 265 266 267 268 269 270 271 272 273 274 275 276 277 278 279 280 281 282 283 284 285 286 287 288 289 290 291 292 293 294 295
    {
      my_dirend(dirp);
      DBUG_RETURN(-1);
    }
  }
  DBUG_PRINT("info",("found: %d files", files->elements));
  my_dirend(dirp);
  DBUG_RETURN(0);
}

/***************************************************************************
** Extended version of mysqld_show_tables
***************************************************************************/

int mysqld_extend_show_tables(THD *thd,const char *db,const char *wild)
{
  Item *item;
  List<char> files;
  List<Item> field_list;
  char path[FN_LEN];
  char *file_name;
  TABLE *table;
  String *packet= &thd->packet;
  DBUG_ENTER("mysqld_extend_show_tables");

  (void) sprintf(path,"%s/%s",mysql_data_home,db);
  (void) unpack_dirname(path,path);

  field_list.push_back(item=new Item_empty_string("Name",NAME_LEN));
  item->maybe_null=1;
  field_list.push_back(item=new Item_empty_string("Type",10));
  item->maybe_null=1;
  field_list.push_back(item=new Item_empty_string("Row_format",10));
  item->maybe_null=1;
  field_list.push_back(item=new Item_int("Rows",(longlong) 1,21));
  item->maybe_null=1;
  field_list.push_back(item=new Item_int("Avg_row_length",(int32) 0,21));
  item->maybe_null=1;
  field_list.push_back(item=new Item_int("Data_length",(longlong) 1,21));
  item->maybe_null=1;
  field_list.push_back(item=new Item_int("Max_data_length",(longlong) 1,21));
  item->maybe_null=1;
  field_list.push_back(item=new Item_int("Index_length",(longlong) 1,21));
  item->maybe_null=1;
  field_list.push_back(item=new Item_int("Data_free",(longlong) 1,21));
  item->maybe_null=1;
  field_list.push_back(item=new Item_int("Auto_increment",(longlong) 1,21));
  item->maybe_null=1;
  field_list.push_back(item=new Item_datetime("Create_time"));
  item->maybe_null=1;
  field_list.push_back(item=new Item_datetime("Update_time"));
  item->maybe_null=1;
  field_list.push_back(item=new Item_datetime("Check_time"));
  item->maybe_null=1;
  field_list.push_back(item=new Item_empty_string("Create_options",255));
  item->maybe_null=1;
  field_list.push_back(item=new Item_empty_string("Comment",80));
296
  item->maybe_null=1;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
297 298 299 300 301 302 303 304 305 306 307 308 309
  if (send_fields(thd,field_list,1))
    DBUG_RETURN(1);

  if (mysql_find_files(thd,&files,db,path,wild,0))
    DBUG_RETURN(-1);
  List_iterator<char> it(files);
  while ((file_name=it++))
  {
    TABLE_LIST table_list;
    bzero((char*) &table_list,sizeof(table_list));
    packet->length(0);
    net_store_data(packet,file_name);
    table_list.db=(char*) db;
310
    table_list.real_name= table_list.alias= file_name;
311 312
    if (lower_case_table_names)
      casedn_str(file_name);
bk@work.mysql.com's avatar
bk@work.mysql.com committed
313 314 315
    if (!(table = open_ltable(thd, &table_list, TL_READ)))
    {
      for (uint i=0 ; i < field_list.elements ; i++)
316
        net_store_null(packet);
bk@work.mysql.com's avatar
bk@work.mysql.com committed
317 318 319 320 321 322 323 324 325 326
      net_store_data(packet,thd->net.last_error);
      thd->net.last_error[0]=0;
    }
    else
    {
      struct tm tm_tmp;
      handler *file=table->file;
      file->info(HA_STATUS_VARIABLE | HA_STATUS_TIME | HA_STATUS_NO_LOCK);
      net_store_data(packet, file->table_type());
      net_store_data(packet,
327 328 329 330
                     (table->db_options_in_use & HA_OPTION_PACK_RECORD) ?
                     "Dynamic" :
                     (table->db_options_in_use & HA_OPTION_COMPRESS_RECORD)
                     ? "Compressed" : "Fixed");
bk@work.mysql.com's avatar
bk@work.mysql.com committed
331 332 333 334
      net_store_data(packet, (longlong) file->records);
      net_store_data(packet, (uint32) file->mean_rec_length);
      net_store_data(packet, (longlong) file->data_file_length);
      if (file->max_data_file_length)
335
        net_store_data(packet, (longlong) file->max_data_file_length);
bk@work.mysql.com's avatar
bk@work.mysql.com committed
336
      else
337
        net_store_null(packet);
bk@work.mysql.com's avatar
bk@work.mysql.com committed
338 339 340 341
      net_store_data(packet, (longlong) file->index_file_length);
      net_store_data(packet, (longlong) file->delete_length);
      if (table->found_next_number_field)
      {
342 343 344 345 346
        table->next_number_field=table->found_next_number_field;
        table->next_number_field->reset();
        file->update_auto_increment();
        net_store_data(packet, table->next_number_field->val_int());
        table->next_number_field=0;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
347 348
      }
      else
349
        net_store_null(packet);
bk@work.mysql.com's avatar
bk@work.mysql.com committed
350
      if (!file->create_time)
351
        net_store_null(packet);
bk@work.mysql.com's avatar
bk@work.mysql.com committed
352 353
      else
      {
354 355
        localtime_r(&file->create_time,&tm_tmp);
        net_store_data(packet, &tm_tmp);
bk@work.mysql.com's avatar
bk@work.mysql.com committed
356 357
      }
      if (!file->update_time)
358
        net_store_null(packet);
bk@work.mysql.com's avatar
bk@work.mysql.com committed
359 360
      else
      {
361 362
        localtime_r(&file->update_time,&tm_tmp);
        net_store_data(packet, &tm_tmp);
bk@work.mysql.com's avatar
bk@work.mysql.com committed
363 364
      }
      if (!file->check_time)
365
        net_store_null(packet);
bk@work.mysql.com's avatar
bk@work.mysql.com committed
366 367
      else
      {
368 369
        localtime_r(&file->check_time,&tm_tmp);
        net_store_data(packet, &tm_tmp);
bk@work.mysql.com's avatar
bk@work.mysql.com committed
370 371
      }
      {
372 373 374 375 376 377 378 379 380 381 382 383 384 385 386 387 388 389 390 391 392 393 394 395 396 397
        char option_buff[350],*ptr;
        ptr=option_buff;
        if (table->min_rows)
        {
          ptr=strmov(ptr," min_rows=");
          ptr=longlong10_to_str(table->min_rows,ptr,10);
        }
        if (table->max_rows)
        {
          ptr=strmov(ptr," max_rows=");
          ptr=longlong10_to_str(table->max_rows,ptr,10);
        }
        if (table->avg_row_length)
        {
          ptr=strmov(ptr," avg_row_length=");
          ptr=longlong10_to_str(table->avg_row_length,ptr,10);
        }
        if (table->db_create_options & HA_OPTION_PACK_KEYS)
          ptr=strmov(ptr," pack_keys=1");
        if (table->db_create_options & HA_OPTION_NO_PACK_KEYS)
          ptr=strmov(ptr," pack_keys=0");
        if (table->db_create_options & HA_OPTION_CHECKSUM)
          ptr=strmov(ptr," checksum=1");
        if (table->db_create_options & HA_OPTION_DELAY_KEY_WRITE)
          ptr=strmov(ptr," delay_key_write=1");
        if (table->row_type != ROW_TYPE_DEFAULT)
398
          ptr=strxmov(ptr, " row_format=", ha_row_type[(uint) table->row_type],
399 400 401 402 403 404 405 406 407 408
                      NullS);
        if (file->raid_type)
        {
          char buff[100];
          sprintf(buff," raid_type=%s raid_chunks=%d raid_chunksize=%ld",
                  my_raid_type(file->raid_type), file->raid_chunks, file->raid_chunksize/RAID_BLOCK_SIZE);
          ptr=strmov(ptr,buff);
        }
        net_store_data(packet, option_buff+1,
                       (ptr == option_buff ? 0 : (uint) (ptr-option_buff)-1));
bk@work.mysql.com's avatar
bk@work.mysql.com committed
409
      }
410 411 412 413 414 415
      {
	char *comment=table->file->update_table_comment(table->comment);
	net_store_data(packet, comment);
	if (comment != table->comment)
	  my_free(comment,MYF(0));
      }
bk@work.mysql.com's avatar
bk@work.mysql.com committed
416 417 418
      close_thread_tables(thd,0);
    }
    if (my_net_write(&thd->net,(char*) packet->ptr(),
419
                     packet->length()))
bk@work.mysql.com's avatar
bk@work.mysql.com committed
420 421 422 423 424 425 426 427 428
      DBUG_RETURN(-1);
  }
  send_eof(&thd->net);
  DBUG_RETURN(0);
}



/***************************************************************************
429
** List all columns in a table_list->real_name
bk@work.mysql.com's avatar
bk@work.mysql.com committed
430 431 432
***************************************************************************/

int
monty@donna.mysql.com's avatar
monty@donna.mysql.com committed
433 434
mysqld_show_fields(THD *thd, TABLE_LIST *table_list,const char *wild,
		   bool verbose)
bk@work.mysql.com's avatar
bk@work.mysql.com committed
435 436 437 438
{
  TABLE *table;
  handler *file;
  char tmp[MAX_FIELD_WIDTH];
439
  Item *item;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
440 441
  DBUG_ENTER("mysqld_show_fields");
  DBUG_PRINT("enter",("db: %s  table: %s",table_list->db,
442
                      table_list->real_name));
bk@work.mysql.com's avatar
bk@work.mysql.com committed
443 444 445 446 447 448 449 450 451 452 453 454 455 456 457

  if (!(table = open_ltable(thd, table_list, TL_UNLOCK)))
  {
    send_error(&thd->net);
    DBUG_RETURN(1);
  }
  file=table->file;
  file->info(HA_STATUS_VARIABLE | HA_STATUS_NO_LOCK);
  (void) get_table_grant(thd, table_list);

  List<Item> field_list;
  field_list.push_back(new Item_empty_string("Field",NAME_LEN));
  field_list.push_back(new Item_empty_string("Type",40));
  field_list.push_back(new Item_empty_string("Null",1));
  field_list.push_back(new Item_empty_string("Key",3));
458 459
  field_list.push_back(item=new Item_empty_string("Default",NAME_LEN));
  item->maybe_null=1;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
460
  field_list.push_back(new Item_empty_string("Extra",20));
monty@donna.mysql.com's avatar
monty@donna.mysql.com committed
461 462
  if (verbose)
    field_list.push_back(new Item_empty_string("Privileges",80));
bk@work.mysql.com's avatar
bk@work.mysql.com committed
463

464
        // Send first number of fields and records
bk@work.mysql.com's avatar
bk@work.mysql.com committed
465 466 467 468 469 470 471 472 473
  {
    char *pos;
    pos=net_store_length(tmp, (uint) field_list.elements);
    pos=net_store_length(pos,(ulonglong) file->records);
    (void) my_net_write(&thd->net,tmp,(uint) (pos-tmp));
  }

  if (send_fields(thd,field_list,0))
    DBUG_RETURN(1);
474
  restore_record(table,2);      // Get empty record
bk@work.mysql.com's avatar
bk@work.mysql.com committed
475 476

  Field **ptr,*field;
tim@cane.mysql.fi's avatar
tim@cane.mysql.fi committed
477
  String *packet= &thd->packet;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
478 479 480 481 482 483
  for (ptr=table->field; (field= *ptr) ; ptr++)
  {
    if (!wild || !wild[0] || !wild_case_compare(field->field_name,wild))
    {
#ifdef NOT_USED
      if (thd->col_access & TABLE_ACLS ||
484 485
          ! check_grant_column(thd,table,field->field_name,
                               (uint) strlen(field->field_name),1))
bk@work.mysql.com's avatar
bk@work.mysql.com committed
486 487
#endif
      {
488 489
        byte *pos;
        uint flags=field->flags;
tim@cane.mysql.fi's avatar
tim@cane.mysql.fi committed
490
        String type(tmp,sizeof(tmp));
491 492 493 494 495 496 497 498 499 500 501 502 503 504 505 506 507 508 509 510 511 512 513 514 515 516 517 518 519 520 521 522 523 524 525 526
        uint col_access;
        bool null_default_value=0;

        packet->length(0);
        net_store_data(packet,field->field_name);
        field->sql_type(type);
        net_store_data(packet,type.ptr(),type.length());

        pos=(byte*) ((flags & NOT_NULL_FLAG) &&
                     field->type() != FIELD_TYPE_TIMESTAMP ?
                     "" : "YES");
        net_store_data(packet,(const char*) pos);
        pos=(byte*) ((field->flags & PRI_KEY_FLAG) ? "PRI" :
                     (field->flags & UNIQUE_KEY_FLAG) ? "UNI" :
                     (field->flags & MULTIPLE_KEY_FLAG) ? "MUL":"");
        net_store_data(packet,(char*) pos);

        if (field->type() == FIELD_TYPE_TIMESTAMP ||
            field->unireg_check == Field::NEXT_NUMBER)
          null_default_value=1;
        if (!null_default_value && !field->is_null())
        {                                               // Not null by default
          type.set(tmp,sizeof(tmp));
          field->val_str(&type,&type);
          net_store_data(packet,type.ptr(),type.length());
        }
        else if (field->maybe_null() || null_default_value)
          net_store_null(packet);                       // Null as default
        else
          net_store_data(packet,tmp,0);

        char *end=tmp;
        if (field->unireg_check == Field::NEXT_NUMBER)
          end=strmov(tmp,"auto_increment");
        net_store_data(packet,tmp,(uint) (end-tmp));

monty@donna.mysql.com's avatar
monty@donna.mysql.com committed
527 528 529 530 531 532 533 534 535 536 537 538 539 540 541
	if (verbose)
	{
	  /* Add grant options */
	  col_access= get_column_grant(thd,table_list,field) & COL_ACLS;
	  end=tmp;
	  for (uint bitnr=0; col_access ; col_access>>=1,bitnr++)
	  {
	    if (col_access & 1)
	    {
	      *end++=',';
	      end=strmov(end,grant_types.type_names[bitnr]);
	    }
	  }
	  net_store_data(packet,tmp+1,end == tmp ? 0 : (uint) (end-tmp-1));
	}
542 543
        if (my_net_write(&thd->net,(char*) packet->ptr(),packet->length()))
          DBUG_RETURN(1);
bk@work.mysql.com's avatar
bk@work.mysql.com committed
544 545 546 547 548 549 550 551 552 553 554 555 556
      }
    }
  }
  send_eof(&thd->net);
  DBUG_RETURN(0);
}

int
mysqld_show_create(THD *thd, TABLE_LIST *table_list)
{
  TABLE *table;
  DBUG_ENTER("mysqld_show_create");
  DBUG_PRINT("enter",("db: %s  table: %s",table_list->db,
557
                      table_list->real_name));
bk@work.mysql.com's avatar
bk@work.mysql.com committed
558

monty@donna.mysql.com's avatar
monty@donna.mysql.com committed
559
  /* Only one table for now */
bk@work.mysql.com's avatar
bk@work.mysql.com committed
560 561 562 563 564 565 566 567 568 569 570 571
  if (!(table = open_ltable(thd, table_list, TL_UNLOCK)))
  {
    send_error(&thd->net);
    DBUG_RETURN(1);
  }

  List<Item> field_list;
  field_list.push_back(new Item_empty_string("Table",NAME_LEN));
  field_list.push_back(new Item_empty_string("Create Table",1024));

  if (send_fields(thd,field_list,1))
    DBUG_RETURN(1);
572

bk@work.mysql.com's avatar
bk@work.mysql.com committed
573
  String *packet = &thd->packet;
monty@donna.mysql.com's avatar
monty@donna.mysql.com committed
574 575 576
  {
    packet->length(0);
    net_store_data(packet, table->table_name);
577 578 579 580 581
    /*
      A hack - we need to reserve some space for the length before
      we know what it is - let's assume that the length of create table
      statement will fit into 3 bytes ( 16 MB max :-) )
    */
monty@donna.mysql.com's avatar
monty@donna.mysql.com committed
582 583 584 585 586 587
    ulong store_len_offset = packet->length();
    packet->length(store_len_offset + 4);
    if (store_create_info(thd, table, packet))
      DBUG_RETURN(-1);
    ulong create_len = packet->length() - store_len_offset - 4;
    if (create_len > 0x00ffffff) // better readable in HEX ...
588 589 590 591 592 593 594
    {
      /*
	Just in case somebody manages to create a table
	with *that* much stuff in the definition
      */
      DBUG_RETURN(1);
    }
monty@donna.mysql.com's avatar
monty@donna.mysql.com committed
595

596 597 598 599 600
    /*
      Now we have to store the length in three bytes, even if it would fit
      into fewer bytes, so we cannot use net_store_data() anymore,
      and do it ourselves
    */
monty@donna.mysql.com's avatar
monty@donna.mysql.com committed
601 602 603 604 605 606 607 608
    char* p = (char*)packet->ptr() + store_len_offset;
    *p++ = (char) 253; // The client the length is stored using 3-bytes
    int3store(p, create_len);

    // now we are in business :-)
    if (my_net_write(&thd->net, (char*)packet->ptr(), packet->length()))
      DBUG_RETURN(1);
  }
bk@work.mysql.com's avatar
bk@work.mysql.com committed
609 610 611 612 613
  send_eof(&thd->net);
  DBUG_RETURN(0);
}


tim@cane.mysql.fi's avatar
tim@cane.mysql.fi committed
614 615 616 617 618 619 620 621 622 623 624 625 626
int
mysqld_show_logs(THD *thd)
{
  DBUG_ENTER("mysqld_show_logs");

  List<Item> field_list;
  field_list.push_back(new Item_empty_string("File",FN_REFLEN));
  field_list.push_back(new Item_empty_string("Type",10));
  field_list.push_back(new Item_empty_string("Status",10));

  if (send_fields(thd,field_list,1))
    DBUG_RETURN(1);

627
#ifdef HAVE_BERKELEY_DB
628
  if (!berkeley_skip && berkeley_show_logs(thd))
monty@donna.mysql.com's avatar
monty@donna.mysql.com committed
629
    DBUG_RETURN(-1);
630
#endif
tim@cane.mysql.fi's avatar
tim@cane.mysql.fi committed
631 632 633 634 635 636

  send_eof(&thd->net);
  DBUG_RETURN(0);
}


bk@work.mysql.com's avatar
bk@work.mysql.com committed
637 638 639 640 641 642 643
int
mysqld_show_keys(THD *thd, TABLE_LIST *table_list)
{
  TABLE *table;
  char buff[256];
  DBUG_ENTER("mysqld_show_keys");
  DBUG_PRINT("enter",("db: %s  table: %s",table_list->db,
644
                      table_list->real_name));
bk@work.mysql.com's avatar
bk@work.mysql.com committed
645 646 647 648 649 650 651 652 653 654 655 656 657 658 659 660 661 662 663 664 665 666 667 668 669 670 671 672

  if (!(table = open_ltable(thd, table_list, TL_UNLOCK)))
  {
    send_error(&thd->net);
    DBUG_RETURN(1);
  }

  List<Item> field_list;
  Item *item;
  field_list.push_back(new Item_empty_string("Table",NAME_LEN));
  field_list.push_back(new Item_int("Non_unique",0,1));
  field_list.push_back(new Item_empty_string("Key_name",NAME_LEN));
  field_list.push_back(new Item_int("Seq_in_index",0,2));
  field_list.push_back(new Item_empty_string("Column_name",NAME_LEN));
  field_list.push_back(item=new Item_empty_string("Collation",1));
  item->maybe_null=1;
  field_list.push_back(item=new Item_int("Cardinality",0,11));
  item->maybe_null=1;
  field_list.push_back(item=new Item_int("Sub_part",0,3));
  item->maybe_null=1;
  field_list.push_back(item=new Item_empty_string("Packed",10));
  item->maybe_null=1;
  field_list.push_back(new Item_empty_string("Comment",255));
  item->maybe_null=1;

  if (send_fields(thd,field_list,1))
    DBUG_RETURN(1);

tim@cane.mysql.fi's avatar
tim@cane.mysql.fi committed
673
  String *packet= &thd->packet;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
674 675 676 677 678 679 680 681 682 683 684 685 686 687 688
  KEY *key_info=table->key_info;
  table->file->info(HA_STATUS_VARIABLE | HA_STATUS_NO_LOCK | HA_STATUS_TIME);
  for (uint i=0 ; i < table->keys ; i++,key_info++)
  {
    KEY_PART_INFO *key_part= key_info->key_part;
    char *end;
    for (uint j=0 ; j < key_info->key_parts ; j++,key_part++)
    {
      packet->length(0);
      net_store_data(packet,table->table_name);
      net_store_data(packet,((key_info->flags & HA_NOSAME) ? "0" :"1"), 1);
      net_store_data(packet,key_info->name);
      end=int10_to_str((long) (j+1),(char*) buff,10);
      net_store_data(packet,buff,(uint) (end-buff));
      net_store_data(packet,key_part->field ? key_part->field->field_name :
689
                     "?unknown field?");
bk@work.mysql.com's avatar
bk@work.mysql.com committed
690
      if (table->file->option_flag() & HA_READ_ORDER)
691 692
        net_store_data(packet,((key_part->key_part_flag & HA_REVERSE_SORT)
                               ? "D" : "A"), 1);
bk@work.mysql.com's avatar
bk@work.mysql.com committed
693
      else
694
        net_store_null(packet); /* purecov: inspected */
bk@work.mysql.com's avatar
bk@work.mysql.com committed
695 696 697
      KEY *key=table->key_info+i;
      if (key->rec_per_key[j])
      {
698 699 700
        ulong records=(table->file->records / key->rec_per_key[j]);
        end=int10_to_str((long) records, buff, 10);
        net_store_data(packet,buff,(uint) (end-buff));
bk@work.mysql.com's avatar
bk@work.mysql.com committed
701 702
      }
      else
703
        net_store_null(packet);
bk@work.mysql.com's avatar
bk@work.mysql.com committed
704
      if (!key_part->field ||
705 706
          key_part->length !=
          table->field[key_part->fieldnr-1]->key_length())
bk@work.mysql.com's avatar
bk@work.mysql.com committed
707
      {
708 709
        end=int10_to_str((long) key_part->length, buff,10); /* purecov: inspected */
        net_store_data(packet,buff,(uint) (end-buff)); /* purecov: inspected */
bk@work.mysql.com's avatar
bk@work.mysql.com committed
710 711
      }
      else
712 713
        net_store_null(packet);
      net_store_null(packet);                   // No pack_information yet
714
      net_store_data(packet,key_info->flags & HA_FULLTEXT ? "FULLTEXT":"");
bk@work.mysql.com's avatar
bk@work.mysql.com committed
715
      if (my_net_write(&thd->net,(char*) packet->ptr(),packet->length()))
716
        DBUG_RETURN(1); /* purecov: inspected */
bk@work.mysql.com's avatar
bk@work.mysql.com committed
717 718 719 720 721 722 723 724 725 726 727 728 729 730 731 732 733 734 735 736 737 738 739 740 741 742 743 744 745 746 747 748
    }
  }
  send_eof(&thd->net);
  DBUG_RETURN(0);
}


/****************************************************************************
** Return only fields for API mysql_list_fields
** Use "show table wildcard" in mysql instead of this
****************************************************************************/

void
mysqld_list_fields(THD *thd, TABLE_LIST *table_list, const char *wild)
{
  TABLE *table;
  DBUG_ENTER("mysqld_list_fields");
  DBUG_PRINT("enter",("table: %s",table_list->real_name));

  if (!(table = open_ltable(thd, table_list, TL_UNLOCK)))
  {
    send_error(&thd->net);
    DBUG_VOID_RETURN;
  }
  List<Item> field_list;

  Field **ptr,*field;
  for (ptr=table->field ; (field= *ptr); ptr++)
  {
    if (!wild || !wild[0] || !wild_case_compare(field->field_name,wild))
      field_list.push_back(new Item_field(field));
  }
749
  restore_record(table,2);              // Get empty record
bk@work.mysql.com's avatar
bk@work.mysql.com committed
750 751 752 753 754 755 756 757 758 759 760 761 762
  if (send_fields(thd,field_list,2))
    DBUG_VOID_RETURN;
  VOID(net_flush(&thd->net));
  DBUG_VOID_RETURN;
}

int
mysqld_dump_create_info(THD *thd, TABLE *table, int fd)
{
  DBUG_ENTER("mysqld_dump_create_info");
  DBUG_PRINT("enter",("table: %s",table->real_name));
  String* packet = &thd->packet;
  packet->length(0);
763

bk@work.mysql.com's avatar
bk@work.mysql.com committed
764 765
  if(store_create_info(thd,table,packet))
    DBUG_RETURN(-1);
766

bk@work.mysql.com's avatar
bk@work.mysql.com committed
767
  if(fd < 0)
768 769 770 771 772
  {
    if(my_net_write(&thd->net, (char*)packet->ptr(), packet->length()))
      DBUG_RETURN(-1);
    VOID(net_flush(&thd->net));
  }
bk@work.mysql.com's avatar
bk@work.mysql.com committed
773
  else
774 775 776 777 778
  {
    if(my_write(fd, (const byte*) packet->ptr(), packet->length(),
                MYF(MY_WME)))
      DBUG_RETURN(-1);
  }
bk@work.mysql.com's avatar
bk@work.mysql.com committed
779 780 781

  DBUG_RETURN(0);
}
782

783 784 785 786 787 788 789 790 791 792 793 794 795 796 797
static void
append_identifier(THD *thd, String *packet, const char *name)
{
  if (thd->options & OPTION_QUOTE_SHOW_CREATE)
  {
    packet->append("`", 1);
    packet->append(name);
    packet->append("`", 1);
  }
  else
  {
    packet->append(name);
  }
}

bk@work.mysql.com's avatar
bk@work.mysql.com committed
798
static int
799
store_create_info(THD *thd, TABLE *table, String *packet)
bk@work.mysql.com's avatar
bk@work.mysql.com committed
800 801 802 803 804
{
  DBUG_ENTER("store_create_info");
  DBUG_PRINT("enter",("table: %s",table->real_name));

  restore_record(table,2); // Get empty record
805

bk@work.mysql.com's avatar
bk@work.mysql.com committed
806 807 808
  List<Item> field_list;
  char tmp[MAX_FIELD_WIDTH];
  String type(tmp, sizeof(tmp));
809 810 811 812
  if (table->tmp_table)
    packet->append("CREATE TEMPORARY TABLE ", 23);
  else
    packet->append("CREATE TABLE ", 13);
813
  append_identifier(thd,packet,table->real_name);
814
  packet->append(" (\n", 3);
815

bk@work.mysql.com's avatar
bk@work.mysql.com committed
816 817 818
  Field **ptr,*field;
  for (ptr=table->field ; (field= *ptr); ptr++)
  {
819
    if (ptr != table->field)
820
      packet->append(",\n", 2);
821

bk@work.mysql.com's avatar
bk@work.mysql.com committed
822
    uint flags = field->flags;
823
    packet->append("  ", 2);
824
    append_identifier(thd,packet,field->field_name);
bk@work.mysql.com's avatar
bk@work.mysql.com committed
825 826
    packet->append(' ');
    // check for surprises from the previous call to Field::sql_type()
827
    if (type.ptr() != tmp)
bk@work.mysql.com's avatar
bk@work.mysql.com committed
828
      type.set(tmp, sizeof(tmp));
829

bk@work.mysql.com's avatar
bk@work.mysql.com committed
830 831
    field->sql_type(type);
    packet->append(type.ptr(),type.length());
832

833
    bool has_default = (field->type() != FIELD_TYPE_BLOB &&
834 835 836 837
			field->type() != FIELD_TYPE_TIMESTAMP &&
			field->unireg_check != Field::NEXT_NUMBER);
    if (flags & NOT_NULL_FLAG)
      packet->append(" NOT NULL", 9);
838

839
    if (has_default)
840 841
    {
      packet->append(" default ", 9);
842
      if (!field->is_null())
843 844 845 846
      {                                             // Not null by default
        type.set(tmp,sizeof(tmp));
        field->val_str(&type,&type);
        packet->append('\'');
847
	if (type.length())
848
          append_unescaped(packet, type.c_ptr());
849
        packet->append('\'');
bk@work.mysql.com's avatar
bk@work.mysql.com committed
850
      }
851
      else if (field->maybe_null())
852 853 854 855
        packet->append("NULL", 4);                    // Null as default
      else
        packet->append(tmp,0);
    }
856

bk@work.mysql.com's avatar
bk@work.mysql.com committed
857
    if (field->unireg_check == Field::NEXT_NUMBER)
858
          packet->append(" auto_increment", 15 );
bk@work.mysql.com's avatar
bk@work.mysql.com committed
859 860 861 862 863
  }

  KEY *key_info=table->key_info;
  table->file->info(HA_STATUS_VARIABLE | HA_STATUS_NO_LOCK | HA_STATUS_TIME);
  uint primary_key = table->primary_key;
864

bk@work.mysql.com's avatar
bk@work.mysql.com committed
865 866
  for (uint i=0 ; i < table->keys ; i++,key_info++)
  {
867 868
    KEY_PART_INFO *key_part= key_info->key_part;
    bool found_primary=0;
869
    packet->append(",\n  ", 4);
870

871 872 873
    if (i == primary_key && !strcmp(key_info->name,"PRIMARY"))
    {
      found_primary=1;
874
      packet->append("PRIMARY ", 8);
875
    }
876
    else if (key_info->flags & HA_NOSAME)
877
      packet->append("UNIQUE ", 7);
878
    else if (key_info->flags & HA_FULLTEXT)
879 880
      packet->append("FULLTEXT ", 9);
    packet->append("KEY ", 4);
bk@work.mysql.com's avatar
bk@work.mysql.com committed
881

882
    if (!found_primary)
883
     append_identifier(thd,packet,key_info->name);
884

885
    packet->append(" (", 2);
886

bk@work.mysql.com's avatar
bk@work.mysql.com committed
887 888
    for (uint j=0 ; j < key_info->key_parts ; j++,key_part++)
    {
889
      if (j)
890
        packet->append(',');
891

892
      if (key_part->field)
893
        append_identifier(thd,packet,key_part->field->field_name);
bk@work.mysql.com's avatar
bk@work.mysql.com committed
894
      if (!key_part->field ||
895 896 897
          (key_part->length !=
           table->field[key_part->fieldnr-1]->key_length() &&
           !(key_info->flags & HA_FULLTEXT)))
bk@work.mysql.com's avatar
bk@work.mysql.com committed
898
      {
899 900 901 902 903
        char buff[64];
        buff[0] = '(';
        char* end=int10_to_str((long) key_part->length, buff + 1,10);
        *end++ = ')';
        packet->append(buff,(uint) (end-buff));
bk@work.mysql.com's avatar
bk@work.mysql.com committed
904 905 906 907
      }
    }
    packet->append(')');
  }
908

bk@work.mysql.com's avatar
bk@work.mysql.com committed
909
  handler *file = table->file;
910 911 912 913 914 915 916 917 918 919 920 921 922

  /* Get possible foreign key definitions stored in InnoDB and append them
  to the CREATE TABLE statement */

  char* for_str = file->get_foreign_key_create_info();

  if (for_str) {
  	packet->append(for_str, strlen(for_str));

  	file->free_foreign_key_create_info(for_str);
  }

  packet->append("\n)", 2);
923
  packet->append(" TYPE=", 6);
bk@work.mysql.com's avatar
bk@work.mysql.com committed
924 925 926
  packet->append(file->table_type());
  char buff[128];
  char* p;
927

928
  if (table->min_rows)
929 930 931 932 933
  {
    packet->append(" MIN_ROWS=");
    p = longlong10_to_str(table->min_rows, buff, 10);
    packet->append(buff, (uint) (p - buff));
  }
bk@work.mysql.com's avatar
bk@work.mysql.com committed
934

935
  if (table->max_rows)
936 937 938 939 940
  {
    packet->append(" MAX_ROWS=");
    p = longlong10_to_str(table->max_rows, buff, 10);
    packet->append(buff, (uint) (p - buff));
  }
941 942 943 944 945 946
  if (table->avg_row_length)
  {
    packet->append(" AVG_ROW_LENGTH=");
    p=longlong10_to_str(table->avg_row_length, buff,10);
    packet->append(buff, (uint) (p - buff));
  }
947

bk@work.mysql.com's avatar
bk@work.mysql.com committed
948
  if (table->db_create_options & HA_OPTION_PACK_KEYS)
949
    packet->append(" PACK_KEYS=1", 12);
bk@work.mysql.com's avatar
bk@work.mysql.com committed
950
  if (table->db_create_options & HA_OPTION_NO_PACK_KEYS)
951
    packet->append(" PACK_KEYS=0", 12);
bk@work.mysql.com's avatar
bk@work.mysql.com committed
952
  if (table->db_create_options & HA_OPTION_CHECKSUM)
953
    packet->append(" CHECKSUM=1", 11);
bk@work.mysql.com's avatar
bk@work.mysql.com committed
954
  if (table->db_create_options & HA_OPTION_DELAY_KEY_WRITE)
955
    packet->append(" DELAY_KEY_WRITE=1",18);
956 957 958 959 960
  if (table->row_type != ROW_TYPE_DEFAULT)
  {
    packet->append(" ROW_FORMAT=",12);
    packet->append(ha_row_type[(uint) table->row_type]);
  }
961
  table->file->append_create_info(packet);
monty@donna.mysql.com's avatar
merge  
monty@donna.mysql.com committed
962
  if (table->comment && table->comment[0])
monty@donna.mysql.com's avatar
monty@donna.mysql.com committed
963 964 965 966 967
  {
    packet->append(" COMMENT='", 10);
    append_unescaped(packet, table->comment);
    packet->append('\'');
  }
968 969 970 971 972 973 974
  if (file->raid_type)
  {
    char buff[100];
    sprintf(buff," RAID_TYPE=%s RAID_CHUNKS=%d RAID_CHUNKSIZE=%ld",
            my_raid_type(file->raid_type), file->raid_chunks, file->raid_chunksize/RAID_BLOCK_SIZE);
    packet->append(buff);
  }
bk@work.mysql.com's avatar
bk@work.mysql.com committed
975 976 977 978 979 980 981 982 983 984 985
  DBUG_RETURN(0);
}


/****************************************************************************
** Return info about all processes
** returns for each thread: thread id, user, host, db, command, info
****************************************************************************/

class thread_info :public ilink {
public:
monty@donna.mysql.com's avatar
monty@donna.mysql.com committed
986
  static void *operator new(size_t size) {return (void*) sql_alloc((uint) size); }
bk@work.mysql.com's avatar
bk@work.mysql.com committed
987
  static void operator delete(void *ptr __attribute__((unused)),
988
                              size_t size __attribute__((unused))) {} /*lint -e715 */
bk@work.mysql.com's avatar
bk@work.mysql.com committed
989

monty@donna.mysql.com's avatar
monty@donna.mysql.com committed
990 991
  ulong thread_id;
  time_t start_time;
992
  uint   command;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
993 994 995 996 997 998 999 1000 1001 1002 1003 1004 1005 1006 1007 1008 1009 1010 1011 1012 1013 1014 1015 1016 1017 1018 1019 1020 1021 1022 1023 1024 1025 1026 1027 1028 1029 1030
  const char *user,*host,*db,*proc_info,*state_info;
  char *query;
};

#ifdef __GNUC__
template class I_List<thread_info>;
#endif


void mysqld_list_processes(THD *thd,const char *user, bool verbose)
{
  Item *field;
  List<Item> field_list;
  I_List<thread_info> thread_infos;
  ulong max_query_length= verbose ? max_allowed_packet : PROCESS_LIST_WIDTH;
  DBUG_ENTER("mysqld_list_processes");

  field_list.push_back(new Item_int("Id",0,7));
  field_list.push_back(new Item_empty_string("User",16));
  field_list.push_back(new Item_empty_string("Host",64));
  field_list.push_back(field=new Item_empty_string("db",NAME_LEN));
  field->maybe_null=1;
  field_list.push_back(new Item_empty_string("Command",16));
  field_list.push_back(new Item_empty_string("Time",7));
  field_list.push_back(field=new Item_empty_string("State",30));
  field->maybe_null=1;
  field_list.push_back(field=new Item_empty_string("Info",max_query_length));
  field->maybe_null=1;
  if (send_fields(thd,field_list,1))
    DBUG_VOID_RETURN;

  VOID(pthread_mutex_lock(&LOCK_thread_count)); // For unlink from list
  if (!thd->killed)
  {
    I_List_iterator<THD> it(threads);
    THD *tmp;
    while ((tmp=it++))
    {
1031
      struct st_my_thread_var *mysys_var;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1032
      if ((tmp->net.vio || tmp->system_thread) &&
1033
          (!user || (tmp->user && !strcmp(tmp->user,user))))
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1034
      {
1035 1036 1037 1038 1039 1040
        thread_info *thd_info=new thread_info;

        thd_info->thread_id=tmp->thread_id;
        thd_info->user=thd->strdup(tmp->user ? tmp->user : (tmp->system_thread ?
                                  "system user" : "unauthenticated user"));
        thd_info->host=thd->strdup(tmp->host ? tmp->host : (tmp->ip ? tmp->ip :
1041 1042
                                   (tmp->system_thread ? "none" :
				    "connecting host")));
1043 1044 1045
        if ((thd_info->db=tmp->db))             // Safe test
          thd_info->db=thd->strdup(thd_info->db);
        thd_info->command=(int) tmp->command;
1046 1047
        if ((mysys_var= tmp->mysys_var))
          pthread_mutex_lock(&mysys_var->mutex);
1048 1049 1050 1051 1052 1053 1054 1055 1056 1057 1058
        thd_info->proc_info= (char*) (tmp->killed ? "Killed" : 0);
        thd_info->state_info= (char*) (tmp->locked ? "Locked" :
                                       tmp->net.reading_or_writing ?
                                       (tmp->net.reading_or_writing == 2 ?
                                        "Writing to net" :
                                        thd_info->command == COM_SLEEP ? "" :
                                        "Reading from net") :
                                       tmp->proc_info ? tmp->proc_info :
                                       tmp->mysys_var &&
                                       tmp->mysys_var->current_cond ?
                                       "Waiting on cond" : NullS);
1059 1060
        if (mysys_var)
          pthread_mutex_unlock(&mysys_var->mutex);
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1061 1062

#if !defined(DONT_USE_THR_ALARM) && ! defined(SCO)
1063 1064
        if (pthread_kill(tmp->real_id,0))
          tmp->proc_info="*** DEAD ***";        // This shouldn't happen
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1065
#endif
1066 1067 1068
#ifdef EXTRA_DEBUG
        thd_info->start_time= tmp->time_after_lock;
#else
1069
        thd_info->start_time= tmp->start_time;
1070
#endif
1071 1072 1073 1074 1075 1076 1077 1078 1079 1080
        thd_info->query=0;
        if (tmp->query)
        {
          uint length=(uint) strlen(tmp->query);
          if (length > max_query_length)
            length=max_query_length;
          thd_info->query=(char*) thd->memdup(tmp->query,length+1);
          thd_info->query[length]=0;
        }
        thread_infos.append(thd_info);
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1081 1082 1083 1084 1085 1086 1087 1088 1089 1090 1091 1092 1093 1094 1095 1096 1097 1098 1099 1100 1101 1102 1103 1104 1105
      }
    }
  }
  VOID(pthread_mutex_unlock(&LOCK_thread_count));

  thread_info *thd_info;
  String *packet= &thd->packet;
  while ((thd_info=thread_infos.get()))
  {
    char buff[20],*end;
    packet->length(0);
    end=int10_to_str((long) thd_info->thread_id, buff,10);
    net_store_data(packet,buff,(uint) (end-buff));
    net_store_data(packet,thd_info->user);
    net_store_data(packet,thd_info->host);
    if (thd_info->db)
      net_store_data(packet,thd_info->db);
    else
      net_store_null(packet);
    if (thd_info->proc_info)
      net_store_data(packet,thd_info->proc_info);
    else
      net_store_data(packet,command_name[thd_info->command]);
    if (thd_info->start_time)
      net_store_data(packet,(uint32)
1106
                     (time((time_t*) 0) - thd_info->start_time));
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1107 1108 1109 1110 1111 1112 1113 1114 1115 1116 1117 1118 1119 1120 1121 1122 1123 1124 1125 1126 1127 1128 1129 1130 1131 1132 1133 1134 1135 1136 1137 1138 1139 1140 1141
    else
      net_store_null(packet);
    if (thd_info->state_info)
      net_store_data(packet,thd_info->state_info);
    else
      net_store_null(packet);
    if (thd_info->query)
      net_store_data(packet,thd_info->query);
    else
      net_store_null(packet);
    if (my_net_write(&thd->net,(char*) packet->ptr(),packet->length()))
      break; /* purecov: inspected */
  }
  send_eof(&thd->net);
  DBUG_VOID_RETURN;
}


/*****************************************************************************
** Status functions
*****************************************************************************/


int mysqld_show(THD *thd, const char *wild, show_var_st *variables)
{
  uint i;
  char buff[8192];
  String packet2(buff,sizeof(buff));
  List<Item> field_list;
  DBUG_ENTER("mysqld_show");
  field_list.push_back(new Item_empty_string("Variable_name",30));
  field_list.push_back(new Item_empty_string("Value",256));
  if (send_fields(thd,field_list,1))
    DBUG_RETURN(1); /* purecov: inspected */

1142
  /* pthread_mutex_lock(&THR_LOCK_keycache); */
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1143 1144 1145
  pthread_mutex_lock(&LOCK_status);
  for (i=0; variables[i].name; i++)
  {
1146
    if (!(wild && wild[0] && wild_case_compare(variables[i].name,wild)))
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1147 1148 1149 1150 1151 1152
    {
      packet2.length(0);
      net_store_data(&packet2,variables[i].name);
      switch (variables[i].type){
      case SHOW_LONG:
      case SHOW_LONG_CONST:
1153 1154 1155 1156
        net_store_data(&packet2,(uint32) *(ulong*) variables[i].value);
        break;
      case SHOW_LONG_AS_LONGLONG:
        net_store_data(&packet2,(longlong) *(ulong*) variables[i].value);
1157
        break;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1158
      case SHOW_BOOL:
1159 1160 1161
        net_store_data(&packet2,(ulong) *(bool*) variables[i].value ?
                       "ON" : "OFF");
        break;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1162
      case SHOW_MY_BOOL:
1163 1164 1165
        net_store_data(&packet2,(ulong) *(my_bool*) variables[i].value ?
                       "ON" : "OFF");
        break;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1166 1167
      case SHOW_INT_CONST:
      case SHOW_INT:
1168 1169
        net_store_data(&packet2,(uint32) *(int*) variables[i].value);
        break;
1170 1171 1172 1173 1174 1175 1176 1177
      case SHOW_HAVE:
      {
	SHOW_COMP_OPTION tmp= *(SHOW_COMP_OPTION*) variables[i].value;
        net_store_data(&packet2, (tmp == SHOW_OPTION_NO ? "NO" :
				  tmp == SHOW_OPTION_YES ? "YES" :
				  "DISABLED"));
        break;
      }
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1178
      case SHOW_CHAR:
1179 1180
        net_store_data(&packet2,variables[i].value);
        break;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1181
      case SHOW_STARTTIME:
1182 1183
        net_store_data(&packet2,(uint32) (thd->query_start() - start_time));
        break;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1184
      case SHOW_QUESTION:
1185 1186
        net_store_data(&packet2,(uint32) thd->query_id);
        break;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1187
      case SHOW_OPENTABLES:
1188 1189
        net_store_data(&packet2,(uint32) cached_tables());
        break;
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1190
      case SHOW_CHAR_PTR:
1191 1192 1193 1194 1195
        {
          char *value= *(char**) variables[i].value;
          net_store_data(&packet2,value ? value : "");
          break;
        }
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1196 1197
      }
      if (my_net_write(&thd->net, (char*) packet2.ptr(),packet2.length()))
1198
        goto err;                               /* purecov: inspected */
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1199 1200 1201
    }
  }
  pthread_mutex_unlock(&LOCK_status);
1202
  /* pthread_mutex_unlock(&THR_LOCK_keycache); */
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1203 1204 1205 1206 1207
  send_eof(&thd->net);
  DBUG_RETURN(0);

 err:
  pthread_mutex_unlock(&LOCK_status);
1208
  /* pthread_mutex_unlock(&THR_LOCK_keycache); */
bk@work.mysql.com's avatar
bk@work.mysql.com committed
1209 1210 1211 1212 1213 1214 1215
  DBUG_RETURN(1);
}

#ifdef __GNUC__
template class List_iterator<char>;
template class List<char>;
#endif