|
Edit
|
Copy
|
Delete
DELETE FROM innodb_index_stats WHERE `innodb_index_stats`.`database_name` = 'Akash' AND `innodb_index_stats`.`table_name` = 'Employees' AND `innodb_index_stats`.`index_name` = 'PRIMARY' AND `innodb_index_stats`.`stat_name` = 'n_diff_pfx01'
|
Akash |
Employees |
PRIMARY |
2024-05-23 15:37:51 |
n_diff_pfx01 |
0 |
1 |
id |
|
Edit
|
Copy
|
Delete
DELETE FROM innodb_index_stats WHERE `innodb_index_stats`.`database_name` = 'Akash' AND `innodb_index_stats`.`table_name` = 'Employees' AND `innodb_index_stats`.`index_name` = 'PRIMARY' AND `innodb_index_stats`.`stat_name` = 'n_leaf_pages'
|
Akash |
Employees |
PRIMARY |
2024-05-23 15:37:51 |
n_leaf_pages |
1 |
NULL
|
Number of leaf pages in the index |
|
Edit
|
Copy
|
Delete
DELETE FROM innodb_index_stats WHERE `innodb_index_stats`.`database_name` = 'Akash' AND `innodb_index_stats`.`table_name` = 'Employees' AND `innodb_index_stats`.`index_name` = 'PRIMARY' AND `innodb_index_stats`.`stat_name` = 'size'
|
Akash |
Employees |
PRIMARY |
2024-05-23 15:37:51 |
size |
1 |
NULL
|
Number of pages in the index |
|
Edit
|
Copy
|
Delete
DELETE FROM innodb_index_stats WHERE `innodb_index_stats`.`database_name` = 'HR' AND `innodb_index_stats`.`table_name` = 'DEPARTMENTS' AND `innodb_index_stats`.`index_name` = 'PRIMARY' AND `innodb_index_stats`.`stat_name` = 'n_diff_pfx01'
|
HR |
DEPARTMENTS |
PRIMARY |
2024-05-23 15:38:30 |
n_diff_pfx01 |
2 |
1 |
DEPT_ID_DEP |
|
Edit
|
Copy
|
Delete
DELETE FROM innodb_index_stats WHERE `innodb_index_stats`.`database_name` = 'HR' AND `innodb_index_stats`.`table_name` = 'DEPARTMENTS' AND `innodb_index_stats`.`index_name` = 'PRIMARY' AND `innodb_index_stats`.`stat_name` = 'n_leaf_pages'
|
HR |
DEPARTMENTS |
PRIMARY |
2024-05-23 15:38:30 |
n_leaf_pages |
1 |
NULL
|
Number of leaf pages in the index |
|
Edit
|
Copy
|
Delete
DELETE FROM innodb_index_stats WHERE `innodb_index_stats`.`database_name` = 'HR' AND `innodb_index_stats`.`table_name` = 'DEPARTMENTS' AND `innodb_index_stats`.`index_name` = 'PRIMARY' AND `innodb_index_stats`.`stat_name` = 'size'
|
HR |
DEPARTMENTS |
PRIMARY |
2024-05-23 15:38:30 |
size |
1 |
NULL
|
Number of pages in the index |
|
Edit
|
Copy
|
Delete
DELETE FROM innodb_index_stats WHERE `innodb_index_stats`.`database_name` = 'HR' AND `innodb_index_stats`.`table_name` = 'EMPLOYEES' AND `innodb_index_stats`.`index_name` = 'PRIMARY' AND `innodb_index_stats`.`stat_name` = 'n_diff_pfx01'
|
HR |
EMPLOYEES |
PRIMARY |
2024-05-23 15:39:07 |
n_diff_pfx01 |
10 |
1 |
EMP_ID |
|
Edit
|
Copy
|
Delete
DELETE FROM innodb_index_stats WHERE `innodb_index_stats`.`database_name` = 'HR' AND `innodb_index_stats`.`table_name` = 'EMPLOYEES' AND `innodb_index_stats`.`index_name` = 'PRIMARY' AND `innodb_index_stats`.`stat_name` = 'n_leaf_pages'
|
HR |
EMPLOYEES |
PRIMARY |
2024-05-23 15:39:07 |
n_leaf_pages |
1 |
NULL
|
Number of leaf pages in the index |
|
Edit
|
Copy
|
Delete
DELETE FROM innodb_index_stats WHERE `innodb_index_stats`.`database_name` = 'HR' AND `innodb_index_stats`.`table_name` = 'EMPLOYEES' AND `innodb_index_stats`.`index_name` = 'PRIMARY' AND `innodb_index_stats`.`stat_name` = 'size'
|
HR |
EMPLOYEES |
PRIMARY |
2024-05-23 15:39:07 |
size |
1 |
NULL
|
Number of pages in the index |
|
Edit
|
Copy
|
Delete
DELETE FROM innodb_index_stats WHERE `innodb_index_stats`.`database_name` = 'HR' AND `innodb_index_stats`.`table_name` = 'JOBS' AND `innodb_index_stats`.`index_name` = 'PRIMARY' AND `innodb_index_stats`.`stat_name` = 'n_diff_pfx01'
|
HR |
JOBS |
PRIMARY |
2024-05-23 15:38:57 |
n_diff_pfx01 |
10 |
1 |
JOB_IDENT |
|
Edit
|
Copy
|
Delete
DELETE FROM innodb_index_stats WHERE `innodb_index_stats`.`database_name` = 'HR' AND `innodb_index_stats`.`table_name` = 'JOBS' AND `innodb_index_stats`.`index_name` = 'PRIMARY' AND `innodb_index_stats`.`stat_name` = 'n_leaf_pages'
|
HR |
JOBS |
PRIMARY |
2024-05-23 15:38:57 |
n_leaf_pages |
1 |
NULL
|
Number of leaf pages in the index |
|
Edit
|
Copy
|
Delete
DELETE FROM innodb_index_stats WHERE `innodb_index_stats`.`database_name` = 'HR' AND `innodb_index_stats`.`table_name` = 'JOBS' AND `innodb_index_stats`.`index_name` = 'PRIMARY' AND `innodb_index_stats`.`stat_name` = 'size'
|
HR |
JOBS |
PRIMARY |
2024-05-23 15:38:57 |
size |
1 |
NULL
|
Number of pages in the index |
|
Edit
|
Copy
|
Delete
DELETE FROM innodb_index_stats WHERE `innodb_index_stats`.`database_name` = 'HR' AND `innodb_index_stats`.`table_name` = 'JOB_HISTORY' AND `innodb_index_stats`.`index_name` = 'PRIMARY' AND `innodb_index_stats`.`stat_name` = 'n_diff_pfx01'
|
HR |
JOB_HISTORY |
PRIMARY |
2024-05-23 15:39:08 |
n_diff_pfx01 |
10 |
1 |
EMPL_ID |
|
Edit
|
Copy
|
Delete
DELETE FROM innodb_index_stats WHERE `innodb_index_stats`.`database_name` = 'HR' AND `innodb_index_stats`.`table_name` = 'JOB_HISTORY' AND `innodb_index_stats`.`index_name` = 'PRIMARY' AND `innodb_index_stats`.`stat_name` = 'n_diff_pfx02'
|
HR |
JOB_HISTORY |
PRIMARY |
2024-05-23 15:39:08 |
n_diff_pfx02 |
10 |
1 |
EMPL_ID,JOBS_ID |
|
Edit
|
Copy
|
Delete
DELETE FROM innodb_index_stats WHERE `innodb_index_stats`.`database_name` = 'HR' AND `innodb_index_stats`.`table_name` = 'JOB_HISTORY' AND `innodb_index_stats`.`index_name` = 'PRIMARY' AND `innodb_index_stats`.`stat_name` = 'n_leaf_pages'
|
HR |
JOB_HISTORY |
PRIMARY |
2024-05-23 15:39:08 |
n_leaf_pages |
1 |
NULL
|
Number of leaf pages in the index |
|
Edit
|
Copy
|
Delete
DELETE FROM innodb_index_stats WHERE `innodb_index_stats`.`database_name` = 'HR' AND `innodb_index_stats`.`table_name` = 'JOB_HISTORY' AND `innodb_index_stats`.`index_name` = 'PRIMARY' AND `innodb_index_stats`.`stat_name` = 'size'
|
HR |
JOB_HISTORY |
PRIMARY |
2024-05-23 15:39:08 |
size |
1 |
NULL
|
Number of pages in the index |
|
Edit
|
Copy
|
Delete
DELETE FROM innodb_index_stats WHERE `innodb_index_stats`.`database_name` = 'HR' AND `innodb_index_stats`.`table_name` = 'LOCATIONS' AND `innodb_index_stats`.`index_name` = 'PRIMARY' AND `innodb_index_stats`.`stat_name` = 'n_diff_pfx01'
|
HR |
LOCATIONS |
PRIMARY |
2024-05-23 15:39:18 |
n_diff_pfx01 |
3 |
1 |
LOCT_ID |
|
Edit
|
Copy
|
Delete
DELETE FROM innodb_index_stats WHERE `innodb_index_stats`.`database_name` = 'HR' AND `innodb_index_stats`.`table_name` = 'LOCATIONS' AND `innodb_index_stats`.`index_name` = 'PRIMARY' AND `innodb_index_stats`.`stat_name` = 'n_diff_pfx02'
|
HR |
LOCATIONS |
PRIMARY |
2024-05-23 15:39:18 |
n_diff_pfx02 |
3 |
1 |
LOCT_ID,DEP_ID_LOC |
|
Edit
|
Copy
|
Delete
DELETE FROM innodb_index_stats WHERE `innodb_index_stats`.`database_name` = 'HR' AND `innodb_index_stats`.`table_name` = 'LOCATIONS' AND `innodb_index_stats`.`index_name` = 'PRIMARY' AND `innodb_index_stats`.`stat_name` = 'n_leaf_pages'
|
HR |
LOCATIONS |
PRIMARY |
2024-05-23 15:39:18 |
n_leaf_pages |
1 |
NULL
|
Number of leaf pages in the index |
|
Edit
|
Copy
|
Delete
DELETE FROM innodb_index_stats WHERE `innodb_index_stats`.`database_name` = 'HR' AND `innodb_index_stats`.`table_name` = 'LOCATIONS' AND `innodb_index_stats`.`index_name` = 'PRIMARY' AND `innodb_index_stats`.`stat_name` = 'size'
|
HR |
LOCATIONS |
PRIMARY |
2024-05-23 15:39:18 |
size |
1 |
NULL
|
Number of pages in the index |
|
Edit
|
Copy
|
Delete
DELETE FROM innodb_index_stats WHERE `innodb_index_stats`.`database_name` = 'Rohit' AND `innodb_index_stats`.`table_name` = 'users' AND `innodb_index_stats`.`index_name` = 'GEN_CLUST_INDEX' AND `innodb_index_stats`.`stat_name` = 'n_diff_pfx01'
|
Rohit |
users |
GEN_CLUST_INDEX |
2024-05-23 15:43:47 |
n_diff_pfx01 |
0 |
1 |
DB_ROW_ID |
|
Edit
|
Copy
|
Delete
DELETE FROM innodb_index_stats WHERE `innodb_index_stats`.`database_name` = 'Rohit' AND `innodb_index_stats`.`table_name` = 'users' AND `innodb_index_stats`.`index_name` = 'GEN_CLUST_INDEX' AND `innodb_index_stats`.`stat_name` = 'n_leaf_pages'
|
Rohit |
users |
GEN_CLUST_INDEX |
2024-05-23 15:43:47 |
n_leaf_pages |
1 |
NULL
|
Number of leaf pages in the index |
|
Edit
|
Copy
|
Delete
DELETE FROM innodb_index_stats WHERE `innodb_index_stats`.`database_name` = 'Rohit' AND `innodb_index_stats`.`table_name` = 'users' AND `innodb_index_stats`.`index_name` = 'GEN_CLUST_INDEX' AND `innodb_index_stats`.`stat_name` = 'size'
|
Rohit |
users |
GEN_CLUST_INDEX |
2024-05-23 15:43:47 |
size |
1 |
NULL
|
Number of pages in the index |
|
Edit
|
Copy
|
Delete
DELETE FROM innodb_index_stats WHERE `innodb_index_stats`.`database_name` = 'academia' AND `innodb_index_stats`.`table_name` = 'instituto' AND `innodb_index_stats`.`index_name` = 'PRIMARY' AND `innodb_index_stats`.`stat_name` = 'n_diff_pfx01'
|
academia |
instituto |
PRIMARY |
2024-05-23 15:35:42 |
n_diff_pfx01 |
0 |
1 |
id_instituto |
|
Edit
|
Copy
|
Delete
DELETE FROM innodb_index_stats WHERE `innodb_index_stats`.`database_name` = 'academia' AND `innodb_index_stats`.`table_name` = 'instituto' AND `innodb_index_stats`.`index_name` = 'PRIMARY' AND `innodb_index_stats`.`stat_name` = 'n_leaf_pages'
|
academia |
instituto |
PRIMARY |
2024-05-23 15:35:42 |
n_leaf_pages |
1 |
NULL
|
Number of leaf pages in the index |