Using innodb_use_sys_stats_table=1 leads to warning " failed to store 2 stats entries of db/table/field to SYS_STATS system table"
Bug #890623 reported by
Olivier Doucet
This bug affects 2 people
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
Percona Server moved to https://jira.percona.com/projects/PS |
Fix Released
|
Medium
|
Alexey Kopytov | ||
5.1 |
Fix Released
|
Medium
|
Alexey Kopytov | ||
5.5 |
Fix Released
|
Medium
|
Alexey Kopytov |
Bug Description
using version 5.1.51-percona-11.5 (innodb version 1.0.12-12.1)
I added "innodb_
My log are now filled with tons of message like this :
InnoDB: Warning: failed to store 2 stats entries of XXX/YYY/id to SYS_STATS system table.
One message is printed for each field of each table of each database loaded.
select count(*) from information_
=> 0
I would be glad to provide more information if needed. Please let me know what you need.
Related branches
lp:~akopytov/percona-server/bug890623-5.1
- Laurynas Biveinis (community): Approve
-
Diff: 15 lines (+0/-6)1 file modifiedPercona-Server/storage/innodb_plugin/dict/dict0dict.c (+0/-6)
lp:~akopytov/percona-server/bug890623-5.5
- Laurynas Biveinis (community): Approve
Changed in percona-server: | |
importance: | Undecided → Low |
status: | Confirmed → Triaged |
To post a comment you must log in.
Running "ANALYZE TABLE" on each table fixed the issue. I'm not sure this is default behaviour. use_sys_ stats_table= 1 there's no need to run it.
Also, if CREATE TABLE is run when innodb_