title: MYSQL Temporary Tables - How to view active ones
body: <p>We have a simple "crm-like" software in our company. There are some complex queries that were taking some time, daily-use queries... so i am testing some modifications to use Temporary Tables to replace all the complex joins and subqueries we need.</p>
  
  <p>So far going really well, got a 90%+ speed.</p>
  
  <p>Since its a web app (codeigniter + mysql), i plan to put it in a "production-test" enviroment so 50% of the users can help me test it. I would like to monitor the tables that are active, and if possible for each connection.</p>
  
  <p>My question is - Is there any way i can view all the TEMPORARY TABLES that are active in the mysql instance? Maybe view its data?</p>
  
  <p>I read something about a PLUGIN or something like, but the article was far to messy and i coudnt understand.</p>
  
  <p>Thanks alot and sorry for my english - not my native lang. </p>