pmsguy
asked on
mysql rows_examined
How do I get the rows_examined after I run a query?
I know I can look at the mysql log file, which is not the answer I am looking for.
Basically, something similar to:
mysql> select rows_examined from users left join acct on users.id=acct.id;
This will allow me to analyzed LARGE rows_examined so I can see where my slow queries are based on joins.
I know I can look at the mysql log file, which is not the answer I am looking for.
Basically, something similar to:
mysql> select rows_examined from users left join acct on users.id=acct.id;
This will allow me to analyzed LARGE rows_examined so I can see where my slow queries are based on joins.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.