ohitsme Posted November 23, 2008 Share Posted November 23, 2008 Hey, How can I work out what mysql queries are taking a long time to execute (and also, is there a way to easily work out why (eg, if it tells you that it takes x seconds going through all the rows b/c of no index? or something like that) Quote Link to comment https://forums.phpfreaks.com/topic/133915-solved-how-to-see-what-queries-are-taking-forever-to-execute/ Share on other sites More sharing options...
Mchl Posted November 23, 2008 Share Posted November 23, 2008 There is slow queries log to log all queries that take more than xx seconds. There is EXPLAIN syntax that shows you query's execution plan (and hints on ways to improve it) Quote Link to comment https://forums.phpfreaks.com/topic/133915-solved-how-to-see-what-queries-are-taking-forever-to-execute/#findComment-697082 Share on other sites More sharing options...
ohitsme Posted November 23, 2008 Author Share Posted November 23, 2008 hey, where would i find this slow log? thanks Quote Link to comment https://forums.phpfreaks.com/topic/133915-solved-how-to-see-what-queries-are-taking-forever-to-execute/#findComment-697156 Share on other sites More sharing options...
Mchl Posted November 23, 2008 Share Posted November 23, 2008 Here's manual page Quote Link to comment https://forums.phpfreaks.com/topic/133915-solved-how-to-see-what-queries-are-taking-forever-to-execute/#findComment-697161 Share on other sites More sharing options...
ohitsme Posted November 24, 2008 Author Share Posted November 24, 2008 thanks mchl Quote Link to comment https://forums.phpfreaks.com/topic/133915-solved-how-to-see-what-queries-are-taking-forever-to-execute/#findComment-697306 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.