Announcement

Announcement Module
Collapse
No announcement yet.

pt-stalk output

Page Title Module
Move Remove Collapse
X
Conversation Detail Module
Collapse
  • Filter
  • Time
  • Show
Clear All
new posts

  • pt-stalk output

    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.

  • #2
    Check open_files_limit variable and OS limits like that:
    cat /proc/`pgrep mysqld$`/limits

    Comment

    Working...
    X