1. Oct 10, 2014 #1
   

   pamamolf Well-Known Member

   4,125

   429

   83

   May 31, 2014

   Ratings:

   +841

   Local Time:

   4:01 AM

   Nginx-1.29.x

   MariaDB 10.6.x

   Hi
   
   Is there and where any log file enabled by default that i can view the Joins performed without indexes ?
   

   ---

   
   If not how can i enable it?
   
   Thanks

    
2. Oct 10, 2014 #2
   

   eva2000 Administrator Staff Member

   58,915

   12,490

   113

   May 24, 2014

   Brisbane, Australia

   Ratings:

   +19,122

   Local Time:

   11:01 AM

   Nginx 1.31.x

   MariaDB 10.x/11.4+/12.3+

   need to read mysql documentation for logging at MySQL :: MySQL 5.5 Reference Manual :: 5.2 MySQL Server Logs particularly slow query logging
   
   in fact all answers are in official manual MySQL :: MySQL 5.5 Reference Manual
   
   other members here are free to offer advice, but this is going beyond Centmin Mod's provided as policy for me.

    

   Last edited: Oct 10, 2014

• Log in with Facebook

Your name or email address:

Do you already have an account?

• No, create an account now.
• Yes, my password is:
• Forgot your password?
  Lost access to your email account?