MySQL Forums
Forum List  »  Backup

Advanced Search
New Topic

Re: SQL Script to get the queries which are using full table scan
Posted by: Vitaly Karasik
Date: March 15, 2016 06:52AM

I'll start with activating and analyzing slow queries log - see https://www.percona.com/blog/2014/03/14/mysql-slow-query-log-tools-and-tips/ and https://www.digitalocean.com/community/tutorials/how-to-use-mysql-query-profiling for example.
Regards,
Vitaly Karasik
http://vitalykarasik.com

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Views
Written By
Posted
SQL Script to get the queries which are using full table scan
1630
Vinodh selvaraj
March 15, 2016 05:26AM
Re: SQL Script to get the queries which are using full table scan
1038
Vitaly Karasik
March 15, 2016 06:52AM
Re: SQL Script to get the queries which are using full table scan
1044
Rick James
March 16, 2016 05:12PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.