Stats in Mysql

[turbohost]

Hi,

Is there a way to check via command line how many times a specific row in a mysql table has been accessed?

I also want to see which queries are running in real-time.

Thx,
Turbohost

[turbohost]

Anyone?

[jatar_k]

not off the top of my head but maybe this bump will help ;)

[coopster]

To the best of my knowledge, the only way to track row access/usage is the old "do-it-yourself" tracking method. One way would be to create an integer column that you increment on each

SELECT

query executed on that row. Another option would be to roll-your-own script that parsers the MySQL log files.
[dev.mysql.com...]