Temp Tables in mySQL Stored Procedures
Hello everyone,
I have started using temp tables in my stored procedures recently. The procedures are created and being dropped explicitly at the end. However I am facing some issues when those procedures are being executed frequently from AWS EC2 instance, the storage usage increased all of a sudden. I have not change anything but this introduction of the temp tables in SP and suspecting if this is the reason for sudden storage usage increase. I am using mySQL 5.7 version. I would like to have your opinion on this if anyone has faced similar situation. Thanks !!
Subject
Views
Written By
Posted
Temp Tables in mySQL Stored Procedures
682
January 31, 2020 02:15AM
351
January 31, 2020 10:21AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.