|
Изменить
|
Копировать
|
Удалить
DELETE FROM innodb_index_stats WHERE `innodb_index_stats`.`database_name` = 'klo' AND `innodb_index_stats`.`table_name` = 'Parks' AND `innodb_index_stats`.`index_name` = 'PRIMARY' AND `innodb_index_stats`.`stat_name` = 'n_diff_pfx01'
|
klo |
Parks |
PRIMARY |
2024-06-24 15:14:37 |
n_diff_pfx01 |
5 |
1 |
ParkID |
|
Изменить
|
Копировать
|
Удалить
DELETE FROM innodb_index_stats WHERE `innodb_index_stats`.`database_name` = 'klo' AND `innodb_index_stats`.`table_name` = 'Parks' AND `innodb_index_stats`.`index_name` = 'PRIMARY' AND `innodb_index_stats`.`stat_name` = 'n_leaf_pages'
|
klo |
Parks |
PRIMARY |
2024-06-24 15:14:37 |
n_leaf_pages |
1 |
NULL
|
Number of leaf pages in the index |
|
Изменить
|
Копировать
|
Удалить
DELETE FROM innodb_index_stats WHERE `innodb_index_stats`.`database_name` = 'klo' AND `innodb_index_stats`.`table_name` = 'Parks' AND `innodb_index_stats`.`index_name` = 'PRIMARY' AND `innodb_index_stats`.`stat_name` = 'size'
|
klo |
Parks |
PRIMARY |
2024-06-24 15:14:37 |
size |
1 |
NULL
|
Number of pages in the index |
|
Изменить
|
Копировать
|
Удалить
DELETE FROM innodb_index_stats WHERE `innodb_index_stats`.`database_name` = 'klo' AND `innodb_index_stats`.`table_name` = 'RentalPoints' AND `innodb_index_stats`.`index_name` = 'PRIMARY' AND `innodb_index_stats`.`stat_name` = 'n_diff_pfx01'
|
klo |
RentalPoints |
PRIMARY |
2024-06-24 15:14:38 |
n_diff_pfx01 |
5 |
1 |
RentalPointID |
|
Изменить
|
Копировать
|
Удалить
DELETE FROM innodb_index_stats WHERE `innodb_index_stats`.`database_name` = 'klo' AND `innodb_index_stats`.`table_name` = 'RentalPoints' AND `innodb_index_stats`.`index_name` = 'PRIMARY' AND `innodb_index_stats`.`stat_name` = 'n_leaf_pages'
|
klo |
RentalPoints |
PRIMARY |
2024-06-24 15:14:38 |
n_leaf_pages |
1 |
NULL
|
Number of leaf pages in the index |
|
Изменить
|
Копировать
|
Удалить
DELETE FROM innodb_index_stats WHERE `innodb_index_stats`.`database_name` = 'klo' AND `innodb_index_stats`.`table_name` = 'RentalPoints' AND `innodb_index_stats`.`index_name` = 'PRIMARY' AND `innodb_index_stats`.`stat_name` = 'size'
|
klo |
RentalPoints |
PRIMARY |
2024-06-24 15:14:38 |
size |
1 |
NULL
|
Number of pages in the index |
|
Изменить
|
Копировать
|
Удалить
DELETE FROM innodb_index_stats WHERE `innodb_index_stats`.`database_name` = 'klo' AND `innodb_index_stats`.`table_name` = 'RentalPoints' AND `innodb_index_stats`.`index_name` = 'ParkID' AND `innodb_index_stats`.`stat_name` = 'n_diff_pfx01'
|
klo |
RentalPoints |
ParkID |
2024-06-24 15:14:38 |
n_diff_pfx01 |
5 |
1 |
ParkID |
|
Изменить
|
Копировать
|
Удалить
DELETE FROM innodb_index_stats WHERE `innodb_index_stats`.`database_name` = 'klo' AND `innodb_index_stats`.`table_name` = 'RentalPoints' AND `innodb_index_stats`.`index_name` = 'ParkID' AND `innodb_index_stats`.`stat_name` = 'n_diff_pfx02'
|
klo |
RentalPoints |
ParkID |
2024-06-24 15:14:38 |
n_diff_pfx02 |
5 |
1 |
ParkID,RentalPointID |
|
Изменить
|
Копировать
|
Удалить
DELETE FROM innodb_index_stats WHERE `innodb_index_stats`.`database_name` = 'klo' AND `innodb_index_stats`.`table_name` = 'RentalPoints' AND `innodb_index_stats`.`index_name` = 'ParkID' AND `innodb_index_stats`.`stat_name` = 'n_leaf_pages'
|
klo |
RentalPoints |
ParkID |
2024-06-24 15:14:38 |
n_leaf_pages |
1 |
NULL
|
Number of leaf pages in the index |
|
Изменить
|
Копировать
|
Удалить
DELETE FROM innodb_index_stats WHERE `innodb_index_stats`.`database_name` = 'klo' AND `innodb_index_stats`.`table_name` = 'RentalPoints' AND `innodb_index_stats`.`index_name` = 'ParkID' AND `innodb_index_stats`.`stat_name` = 'size'
|
klo |
RentalPoints |
ParkID |
2024-06-24 15:14:38 |
size |
1 |
NULL
|
Number of pages in the index |
|
Изменить
|
Копировать
|
Удалить
DELETE FROM innodb_index_stats WHERE `innodb_index_stats`.`database_name` = 'klo' AND `innodb_index_stats`.`table_name` = 'Rentals' AND `innodb_index_stats`.`index_name` = 'PRIMARY' AND `innodb_index_stats`.`stat_name` = 'n_diff_pfx01'
|
klo |
Rentals |
PRIMARY |
2024-06-24 15:14:38 |
n_diff_pfx01 |
0 |
1 |
RentalID |
|
Изменить
|
Копировать
|
Удалить
DELETE FROM innodb_index_stats WHERE `innodb_index_stats`.`database_name` = 'klo' AND `innodb_index_stats`.`table_name` = 'Rentals' AND `innodb_index_stats`.`index_name` = 'PRIMARY' AND `innodb_index_stats`.`stat_name` = 'n_leaf_pages'
|
klo |
Rentals |
PRIMARY |
2024-06-24 15:14:38 |
n_leaf_pages |
1 |
NULL
|
Number of leaf pages in the index |
|
Изменить
|
Копировать
|
Удалить
DELETE FROM innodb_index_stats WHERE `innodb_index_stats`.`database_name` = 'klo' AND `innodb_index_stats`.`table_name` = 'Rentals' AND `innodb_index_stats`.`index_name` = 'PRIMARY' AND `innodb_index_stats`.`stat_name` = 'size'
|
klo |
Rentals |
PRIMARY |
2024-06-24 15:14:38 |
size |
1 |
NULL
|
Number of pages in the index |
|
Изменить
|
Копировать
|
Удалить
DELETE FROM innodb_index_stats WHERE `innodb_index_stats`.`database_name` = 'klo' AND `innodb_index_stats`.`table_name` = 'Rentals' AND `innodb_index_stats`.`index_name` = 'VehicleID' AND `innodb_index_stats`.`stat_name` = 'n_diff_pfx01'
|
klo |
Rentals |
VehicleID |
2024-06-24 15:14:38 |
n_diff_pfx01 |
0 |
1 |
VehicleID |
|
Изменить
|
Копировать
|
Удалить
DELETE FROM innodb_index_stats WHERE `innodb_index_stats`.`database_name` = 'klo' AND `innodb_index_stats`.`table_name` = 'Rentals' AND `innodb_index_stats`.`index_name` = 'VehicleID' AND `innodb_index_stats`.`stat_name` = 'n_diff_pfx02'
|
klo |
Rentals |
VehicleID |
2024-06-24 15:14:38 |
n_diff_pfx02 |
0 |
1 |
VehicleID,RentalID |
|
Изменить
|
Копировать
|
Удалить
DELETE FROM innodb_index_stats WHERE `innodb_index_stats`.`database_name` = 'klo' AND `innodb_index_stats`.`table_name` = 'Rentals' AND `innodb_index_stats`.`index_name` = 'VehicleID' AND `innodb_index_stats`.`stat_name` = 'n_leaf_pages'
|
klo |
Rentals |
VehicleID |
2024-06-24 15:14:38 |
n_leaf_pages |
1 |
NULL
|
Number of leaf pages in the index |
|
Изменить
|
Копировать
|
Удалить
DELETE FROM innodb_index_stats WHERE `innodb_index_stats`.`database_name` = 'klo' AND `innodb_index_stats`.`table_name` = 'Rentals' AND `innodb_index_stats`.`index_name` = 'VehicleID' AND `innodb_index_stats`.`stat_name` = 'size'
|
klo |
Rentals |
VehicleID |
2024-06-24 15:14:38 |
size |
1 |
NULL
|
Number of pages in the index |
|
Изменить
|
Копировать
|
Удалить
DELETE FROM innodb_index_stats WHERE `innodb_index_stats`.`database_name` = 'klo' AND `innodb_index_stats`.`table_name` = 'Vehicles' AND `innodb_index_stats`.`index_name` = 'PRIMARY' AND `innodb_index_stats`.`stat_name` = 'n_diff_pfx01'
|
klo |
Vehicles |
PRIMARY |
2024-06-24 15:14:38 |
n_diff_pfx01 |
0 |
1 |
VehicleID |
|
Изменить
|
Копировать
|
Удалить
DELETE FROM innodb_index_stats WHERE `innodb_index_stats`.`database_name` = 'klo' AND `innodb_index_stats`.`table_name` = 'Vehicles' AND `innodb_index_stats`.`index_name` = 'PRIMARY' AND `innodb_index_stats`.`stat_name` = 'n_leaf_pages'
|
klo |
Vehicles |
PRIMARY |
2024-06-24 15:14:38 |
n_leaf_pages |
1 |
NULL
|
Number of leaf pages in the index |
|
Изменить
|
Копировать
|
Удалить
DELETE FROM innodb_index_stats WHERE `innodb_index_stats`.`database_name` = 'klo' AND `innodb_index_stats`.`table_name` = 'Vehicles' AND `innodb_index_stats`.`index_name` = 'PRIMARY' AND `innodb_index_stats`.`stat_name` = 'size'
|
klo |
Vehicles |
PRIMARY |
2024-06-24 15:14:38 |
size |
1 |
NULL
|
Number of pages in the index |
|
Изменить
|
Копировать
|
Удалить
DELETE FROM innodb_index_stats WHERE `innodb_index_stats`.`database_name` = 'klo' AND `innodb_index_stats`.`table_name` = 'Vehicles' AND `innodb_index_stats`.`index_name` = 'RentalPointID' AND `innodb_index_stats`.`stat_name` = 'n_diff_pfx01'
|
klo |
Vehicles |
RentalPointID |
2024-06-24 15:14:38 |
n_diff_pfx01 |
0 |
1 |
RentalPointID |
|
Изменить
|
Копировать
|
Удалить
DELETE FROM innodb_index_stats WHERE `innodb_index_stats`.`database_name` = 'klo' AND `innodb_index_stats`.`table_name` = 'Vehicles' AND `innodb_index_stats`.`index_name` = 'RentalPointID' AND `innodb_index_stats`.`stat_name` = 'n_diff_pfx02'
|
klo |
Vehicles |
RentalPointID |
2024-06-24 15:14:38 |
n_diff_pfx02 |
0 |
1 |
RentalPointID,VehicleID |
|
Изменить
|
Копировать
|
Удалить
DELETE FROM innodb_index_stats WHERE `innodb_index_stats`.`database_name` = 'klo' AND `innodb_index_stats`.`table_name` = 'Vehicles' AND `innodb_index_stats`.`index_name` = 'RentalPointID' AND `innodb_index_stats`.`stat_name` = 'n_leaf_pages'
|
klo |
Vehicles |
RentalPointID |
2024-06-24 15:14:38 |
n_leaf_pages |
1 |
NULL
|
Number of leaf pages in the index |
|
Изменить
|
Копировать
|
Удалить
DELETE FROM innodb_index_stats WHERE `innodb_index_stats`.`database_name` = 'klo' AND `innodb_index_stats`.`table_name` = 'Vehicles' AND `innodb_index_stats`.`index_name` = 'RentalPointID' AND `innodb_index_stats`.`stat_name` = 'size'
|
klo |
Vehicles |
RentalPointID |
2024-06-24 15:14:38 |
size |
1 |
NULL
|
Number of pages in the index |
|
Изменить
|
Копировать
|
Удалить
DELETE FROM innodb_index_stats WHERE `innodb_index_stats`.`database_name` = 'mysql' AND `innodb_index_stats`.`table_name` = 'component' AND `innodb_index_stats`.`index_name` = 'PRIMARY' AND `innodb_index_stats`.`stat_name` = 'n_diff_pfx01'
|
mysql |
component |
PRIMARY |
2019-10-30 15:09:29 |
n_diff_pfx01 |
0 |
1 |
component_id |