Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Duplicate
-
10.6
-
None
-
Not for Release Notes
-
Q3/2026 Server Maintenance
Description
On a clean install (tested on 10.6.18), querying the Sys Schema innodb_buffer_stats_by_schema view returns two warnings. Querying x$innodb_buffer_stats_by_schema doesn't return any warnings.
SELECT * FROM sys.innodb_buffer_stats_by_schema\G
|
*************************** 1. row ***************************
|
object_schema: InnoDB System
|
allocated: 160.00 KiB
|
data: 4.77 KiB
|
pages: 10
|
pages_hashed: 10
|
pages_old: 10
|
rows_cached: 16
|
*************************** 2. row ***************************
|
object_schema: mysql
|
allocated: 48.00 KiB
|
data: 457 bytes
|
pages: 3
|
pages_hashed: 3
|
pages_old: 3
|
rows_cached: 5
|
2 rows in set, 2 warnings (0.036 sec)
|
|
|
SHOW WARNINGS;
|
+---------+------+------------------------------------------+
|
| Level | Code | Message |
|
+---------+------+------------------------------------------+
|
| Warning | 1292 | Truncated incorrect DECIMAL value: 'YES' |
|
| Warning | 1292 | Truncated incorrect DECIMAL value: 'YES' |
|
+---------+------+------------------------------------------+
|
Attachments
Issue Links
- is caused by
-
MDEV-40208 INNODB_BUFFER_PAGE/INNODB_BUFFER_PAGE_LRU: IS_HASHED and IS_OLD changed from 'YES'/'NO' to integer — MySQL-incompatible, undocumented, contradicts the KB
-
- Open
-