Not the answer you need?
Register and ask your own question!
Many Forum changes were implemented on Tue 22 Sep. Read about new Ranks, Scoring, and Reactions.
Email [email protected] for any comments or concerns.

pt-stalk output

spgriffinjrspgriffinjr EntrantInactive User Role Beginner

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:

[[email protected] (prod) percona]# cat 2013_05_16_18_44_40-opentables1

2013_05_16_18_44_41 Too many open tables: 1221

[[email protected] (prod) percona]#

[[email protected] (prod) percona]# cat 2013_05_16_18_44_40-opentables2

2013_05_16_18_44_41 Too many open tables: 1221

[[email protected] (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.


  • przemekprzemek Percona Support Engineer Percona Staff Role
    Check open_files_limit variable and OS limits like that:
    cat /proc/`pgrep mysqld$`/limits
Sign In or Register to comment.

MySQL, InnoDB, MariaDB and MongoDB are trademarks of their respective owners.
Copyright ©2005 - 2020 Percona LLC. All rights reserved.