MySQL 5.7.37 Server Automatically Stopping in Few Hours

aaP_Pradiprajbhar562

MySQL 5.7.34 was Stopping Automatically. After a few hours. I want to know why it's happened automatically. Kindly explain to me about this log. I'm using Centos right now

Check MySQL error log: https://pastebin.com/1sKrVqVh
MySQL 5.7.37 Slow Error Log AAPanel: - https://pastebin.com/aknrZmVW

aaPanel_Kern

aaP_Pradiprajbhar562
Hello, after using mysql for a period of time, please check the size of the /www/server/data/ibtmp1 file, is it too large? Almost taking up hard drive space?
Or check the size of the /www/server/data/ibtmp1 file after mysql is stopped (don't start mysql)

aaP_Pradiprajbhar562

aaPanel_Kern what is the solution

aaPanel_Kern

aaP_Pradiprajbhar562

Before modifying the configuration file, please make a backup first.
1.mysql configuration limit ibtmp1 file size: innodb_temp_data_file_path = ibtmp1:12M:autoextend:max:5G
2.Optimize SQL and avoid using temporary tables.
3.Restart the mysql instance to release the ibtmp1 file