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?
MySQL 5.5 – view all queries executed on certain table
MySQLmysql-5.5
Related Question
- MySQL 5.5 – How to Disable UTF8MB4 Entirely
- MySQL – Information_Schema.Tables Reports Different Results in MySQL 5.5 vs 5.7
- MySQL Replication – Performance Comparison Between MySQL 5.7 and 5.5
- Mysql – Table column length is fine in MySQL 5.5 and 5.6, but upgrading to 5.7 results in too many columns
- Mysql – After upgrade from MySQL 5.5 to 5.7 queries are more frequently encountering deadlock
Best Answer
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
grepsince 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.)