title: Can SHOW TABLES be fired automatically by mysql?
body: <p>I have a database with a lot of tables (> 50000), as a consequence the "SHOW TABLES" statement takes relatively long.</p>
  
  <p>The code I am running does not contain the statement, but I still see it showing up with "show processlist" each time I run my script.</p>
  
  <p>Is there any way mysql could execute the statement automatically ?</p>
  
  <p>FYI:
  The code is PHP running from the command line. It uses the adodb library to execute mysql statements. I have removed any instance of SHOW TABLES in the adodb code and replaced it with "blabla", but it still shows up.</p>
  
  <p>Thanks!</p>