I need to explore queries, which were executed on certain table.
For example, in Oracle we could investigate the
V$SQL_TEXT, maybe something similar exists in MySQL 5.5?
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It only takes a minute to sign up.Sign up to join this community
long_query_time=0, records all queries, plus performance-related info, for all tables.
In either case, you would need to filter down to the desired table. This cannot be done with a simple
grep since the log formats involve multiple lines of text. Still, it is better than nothing.
(There is no feature of MySQL to monitor a single table or database or user. This Answer applies to all(?) versions of MySQL.)