MySQL Forums
Forum List  »  Stored Procedures

Temp Tables in mySQL Stored Procedures
Posted by: Sangita Ghosal
Date: January 31, 2020 02:15AM

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 !!

Options: ReplyQuote


Subject
Views
Written By
Posted
Temp Tables in mySQL Stored Procedures
777
January 31, 2020 02:15AM


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.