1. Oct 10, 2014 #1
   

   pamamolf Premium Member Premium Member

   4,101

   428

   83

   May 31, 2014

   Ratings:

   +837

   Local Time:

   11:57 AM

   Nginx-1.26.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

   55,197

   12,251

   113

   May 24, 2014

   Brisbane, Australia

   Ratings:

   +18,829

   Local Time:

   6:57 PM

   Nginx 1.27.x

   MariaDB 10.x/11.4+

   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?