I am facing Memory issue in our server. While debugging I came to know that, many number (millions) of temporary tables are created. Is there any way to identify which databases are creating this temporary tables? We have around 50 databases and many of the databases using
create temporary table statement in its procedures. In
/tmp directory I could see the
.frm and few
MYD files. Is it possible to find which database contributing more to creation of temporary tables? Please let me know, if you need any other information.
Thanks in advance.