Expert MySQL by Charles Bell

Author:Charles Bell [Bell, Charles]
Language: eng
Format: epub, pdf
ISBN: 9781430246596
Publisher: Apress
Published: 2012-12-19T05:00:00+00:00

/* send the fields "Database" and "Size" */

field_list.push_back(new Item_empty_string("Database",50));

field_list.push_back(new Item_return_int("Size_in_bytes", 7,

MYSQL_TYPE_LONGLONG));

if (protocol->send_result_set_metadata(&field_list,

Protocol::SEND_NUM_ROWS |

Protocol::SEND_EOF))

DBUG_RETURN(TRUE);

/* get database directories */

find_files_result res = find_files(thd, &dbs, 0, mysql_data_home,0,1);

if (res != FIND_FILES_OK)

DBUG_RETURN(1);

List_iterator_fast<LEX_STRING> it_dbs(dbs);

path = (char *)my_malloc(PATH_MAX, MYF(MY_ZEROFILL));

dirp = my_dir(mysql_data_home, MYF(MY_WANT_STAT));

fsizes = 0;

for (int i = 0; i < (int)dirp->number_off_files; i++)

{

file = dirp->dir_entry + i;

if (strncasecmp(file->name, "ibdata", 6) == 0)

fsizes = fsizes + file->mystat->st_size;

else if (strncasecmp(file->name, "ib", 2) == 0)

lsizes = lsizes + file->mystat->st_size;

}

Download

Copyright Disclaimer:
This site does not store any files on its server. We only index and link to content provided by other sites. Please contact the content providers to delete copyright contents if any and email us, we'll remove relevant links or contents immediately.