Hello
I’m troubleshooting issues with our mysql database and i have been running pt-stalk to output anything over 30 queries. There is a file that it keeps producing with this error:
[root@mysql01 (prod) percona]# cat 2013_05_16_18_44_40-opentables1
2013_05_16_18_44_41 Too many open tables: 1221
[root@mysql01 (prod) percona]#
[root@mysql01 (prod) percona]# cat 2013_05_16_18_44_40-opentables2
2013_05_16_18_44_41 Too many open tables: 1221
[root@mysql01 (prod) percona]#
I'm confused as this limit is way higher than 1221
global variables:
| table_definition_cache | 800 |
| table_open_cache | 2048
Before table_open_cache was set to 1024 and pt-stalk was showing too many open tables at 1025 and it was consistently showing that. Is there another setting I might be missing?
Any help would be greatly appreciated.