How to check which user or from which database prepared statements originate

[Raghupradeep Aravindakshan]

Hi,

In one of my prod servers I am facing issue with max_prepared_stmt_count, I have set it as 64K, but was forced to push it more to 80K as one of the user complained that he is not able to create a prepared statement. This server have more than 50 databases in it and I am not getting a clue how to trace it to a single user or a database.

The version of MySQL that I am using is 5.5, I cant upgrade MySQL to 5.6 soon and I think in 5.6 there is some option via performance schema to pin it to a user, read from a blog.

So, how can I find a leak in prepared statement in Mysql 5.5 and pin it to a user or a database.

Thanks & Regards
Raghupradeep