# pt-stalk output

**URL:** <https://forums.percona.com/t/pt-stalk-output/2689>\
**Category:** Other MySQL® Questions\
**Created:** [May 16, 2013, 7:18pm UTC](https://forums.percona.com/t/pt-stalk-output/2689 "2013-05-16T19:18:50Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![spgriffinjr](https://avatars.discourse-cdn.com/v4/letter/s/53a042/32.png) [@spgriffinjr](https://forums.percona.com/u/spgriffinjr)\
**Post date:** [May 16, 2013, 7:18pm UTC](https://forums.percona.com/t/pt-stalk-output/2689/1 "2013-05-16T19:18:50Z")

</div>

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&#64;mysql01 (prod) percona]# cat 2013_05_16_18_44_40-opentables1

2013_05_16_18_44_41 Too many open tables: 1221

[root&#64;mysql01 (prod) percona]# 

	[root&#64;mysql01 (prod) percona]# cat 2013_05_16_18_44_40-opentables2

	2013_05_16_18_44_41 Too many open tables: 1221

	[root&#64;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.

---

<div class="post-metadata">

**Author:** ![przemek](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/przemek/32/3_2.png) [@przemek](https://forums.percona.com/u/przemek)\
**Post date:** [May 20, 2013, 8:01am UTC](https://forums.percona.com/t/pt-stalk-output/2689/2 "2013-05-20T08:01:38Z")

</div>

Check open\_files\_limit variable and OS limits like that:  
cat /proc/`pgrep mysqld$`/limits