I have sql script that contains CREATE TEMPORARY TABLE, INSERT INTO...SELECT, DROP TEMPORARY TABLE. As I run this script over and over, my used memory (RAM) increases until an error says MySQL server has gone away. What could be the reason? I was thinking the memory used gets back to its previous size soon as the temporary table has been dropped.
Asked
Active
Viewed 21 times
0
tatskie
- 405
- 1
- 7
- 16
-
Do you have some entries in your error log? Normally if you MySQL crashes you should be an entry with an error. – René Höhle Dec 06 '17 at 14:08
-
`CREATE TEMPORARY TABLE` defaults to create a disk based temporary table unless you use `ENGINE=MEMORY` as option.. `MySQL server has gone away` could be caused by too little off free disk space. – Raymond Nijland Dec 06 '17 at 14:19