### 9 Queries 
### Total time: 15.652594, Average time: 1.73917711111111
### Taking 1.155827 , 1.217237 , 1.272763 , 1.456513 , 1.543757 , 2.049331 , 2.055721 , 2.435688 , 2.465757  seconds to complete
### Rows analyzed 0, 0, 0, 0, 2, 7, 7, 7 and 20
# User@Host: root[root] @ localhost []

# User@Host: root[root] @ localhost []


### 2 Queries 
### Total time: 3.591515, Average time: 1.7957575
### Taking 1.155827 , 2.435688  seconds to complete
### Rows analyzed 0 and 0
SET timestamp=XXX;
SELECT DISTINCT TABLESPACE_NAME, FILE_NAME, LOGFILE_GROUP_NAME, EXTENT_SIZE, INITIAL_SIZE, ENGINE FROM INFORMATION_SCHEMA.FILES WHERE FILE_TYPE = 'XXX' AND TABLESPACE_NAME IN (SELECT DISTINCT TABLESPACE_NAME FROM INFORMATION_SCHEMA.PARTITIONS WHERE TABLE_SCHEMA IN ('XXX')) ORDER BY TABLESPACE_NAME, LOGFILE_GROUP_NAME;

SET timestamp=1406799605;
SELECT DISTINCT TABLESPACE_NAME, FILE_NAME, LOGFILE_GROUP_NAME, EXTENT_SIZE, INITIAL_SIZE, ENGINE FROM INFORMATION_SCHEMA.FILES WHERE FILE_TYPE = 'DATAFILE' AND TABLESPACE_NAME IN (SELECT DISTINCT TABLESPACE_NAME FROM INFORMATION_SCHEMA.PARTITIONS WHERE TABLE_SCHEMA IN ('mysql')) ORDER BY TABLESPACE_NAME, LOGFILE_GROUP_NAME;


### 2 Queries 
### Total time: 3.00027, Average time: 1.500135
### Taking 1.456513 , 1.543757  seconds to complete
### Rows analyzed 7 and 7
SET timestamp=XXX;
show fields from `columns_priv`;

SET timestamp=1406800204;
show fields from `columns_priv`;


### 2 Queries 
### Total time: 2.61658, Average time: 1.30829
### Taking 1.272763 , 1.343817  seconds to complete
### Rows analyzed 0 and 0
SET timestamp=XXX;
SHOW TRIGGERS LIKE 'XXX';

SET timestamp=1406800503;
SHOW TRIGGERS LIKE 'ndb\_binlog\_index';


### 1 Query 
### Total time: 2.465757, Average time: 2.465757
### Taking 2.465757  seconds to complete
### Rows analyzed 7
use mysql;
SET timestamp=XXX;
show fields from `columns_priv`;

use mysql;
SET timestamp=1406797804;
show fields from `columns_priv`;


### 1 Query 
### Total time: 2.055721, Average time: 2.055721
### Taking 2.055721  seconds to complete
### Rows analyzed 2
SET timestamp=XXX;
show fields from `time_zone_name`;

SET timestamp=1406798105;
show fields from `time_zone_name`;


### 1 Query 
### Total time: 2.049331, Average time: 2.049331
### Taking 2.049331  seconds to complete
### Rows analyzed 0
SET timestamp=XXX;
SELECT LOGFILE_GROUP_NAME, FILE_NAME, TOTAL_EXTENTS, INITIAL_SIZE, ENGINE, EXTRA FROM INFORMATION_SCHEMA.FILES WHERE FILE_TYPE = 'XXX' AND FILE_NAME IS NOT NULL AND LOGFILE_GROUP_NAME IN (SELECT DISTINCT LOGFILE_GROUP_NAME FROM INFORMATION_SCHEMA.FILES WHERE FILE_TYPE = 'XXX' AND TABLESPACE_NAME IN (SELECT DISTINCT TABLESPACE_NAME FROM INFORMATION_SCHEMA.PARTITIONS WHERE TABLE_SCHEMA IN ('XXX'))) GROUP BY LOGFILE_GROUP_NAME, FILE_NAME, ENGINE ORDER BY LOGFILE_GROUP_NAME;

SET timestamp=1406799604;
SELECT LOGFILE_GROUP_NAME, FILE_NAME, TOTAL_EXTENTS, INITIAL_SIZE, ENGINE, EXTRA FROM INFORMATION_SCHEMA.FILES WHERE FILE_TYPE = 'UNDO LOG' AND FILE_NAME IS NOT NULL AND LOGFILE_GROUP_NAME IN (SELECT DISTINCT LOGFILE_GROUP_NAME FROM INFORMATION_SCHEMA.FILES WHERE FILE_TYPE = 'DATAFILE' AND TABLESPACE_NAME IN (SELECT DISTINCT TABLESPACE_NAME FROM INFORMATION_SCHEMA.PARTITIONS WHERE TABLE_SCHEMA IN ('mysql'))) GROUP BY LOGFILE_GROUP_NAME, FILE_NAME, ENGINE ORDER BY LOGFILE_GROUP_NAME;


### 1 Query 
### Total time: 1.343817, Average time: 1.343817
### Taking 1.343817  seconds to complete
### Rows analyzed 0
# User@Host: dbXXX_ecology[dbXXX_ecology] @  [XXX.XXX.XXX.XXX]

# User@Host: db188109_ecology[db188109_ecology] @  [205.186.184.33]


### 1 Query 
### Total time: 1.217237, Average time: 1.217237
### Taking 1.217237  seconds to complete
### Rows analyzed 20
SET timestamp=XXX;
show fields from `host`;

SET timestamp=1406798343;
show fields from `host`;