Stack Exchange network consists of 183 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.
Additional information request. RAM size, # cores, any SSD or NVME devices on MySQL Host server? Post on pastebin.com and share the links. From your SSH login root, Text results of: B) SHOW GLOBAL STATUS; after minimum 24 hours UPTIME C) SHOW GLOBAL VARIABLES; D) SHOW FULL PROCESSLIST; E) complete MySQLTuner report AND Optional helpful information, if available includes - htop OR top for most active apps, ulimit -a for a Linux/Unix list of limits, iostat -xm 5 3 for IOPS by device and core/cpu count, for server workload tuning analysis to provide suggestions.
Additional information request. RAM size, # cores, any SSD devices on MySQL Host server? Post on pastebin.com and share the links. From SSH login root, Text results of: B) SHOW GLOBAL STATUS; after minimum 24 hours UPTIME C) SHOW GLOBAL VARIABLES; E) complete MySQLTuner report for server workload tuning analysis to provide suggestions.
Remember to SELECT @@innodb_buffer_pool_size; to review current size and an increase of 10% in your my.cnf (or my.ini) will frequently eliminate the problem.
Additional information request. RAM size, # cores, any SSD/NVME devices on MySQL Host server? Post on pastebin.com and share the links. A) complete (not edited) my.cnf or my.ini From SSH login root, Text results of: B) SHOW GLOBAL STATUS; after minimum 24 hours UPTIME C) SHOW GLOBAL VARIABLES; D) SHOW FULL PROCESSLIST; E) complete MySQLTuner report use this url for Windows version github.com/pmachapman F) SHOW ENGINE INNODB STATUS; when you are ready for server workload tuning analysis to provide suggestions.
Additional information request. RAM size, # cores, any SSD/NVME devices on MySQL Host server? Post on pastebin.com and share the links. A) complete (not edited) my.cnf or my.ini From SSH login root, Text results of: B) SHOW GLOBAL STATUS; after minimum 24 hours UPTIME C) SHOW GLOBAL VARIABLES; D) SHOW FULL PROCESSLIST; E) complete MySQLTuner report Use this url for Windows version of software github.com/pmachapman F) SHOW ENGINE INNODB STATUS; for server workload tuning analysis to provide suggestions.
Disclaimer: I am the content author of website mentioned in my profile, Network profile that includes downloadable Utility Scripts to assist with performance tuning, FAQ and contact info. Please make contact to review your situation.
@Christia SHOW GLOBAL STATUS LIKE 'aborted_connects'; will display a count of connection attempts that have failed, since start of your instance. A rapidly growing count is a symptom of a DDoS attack.
Additional information request. Post on pastebin.com and share the links. A) complete (not edited) my.cnf or my.ini From SSH root login, Text results of: B) SHOW GLOBAL STATUS; after minimum 24 hours UPTIME C) SHOW GLOBAL VARIABLES; D) SHOW FULL PROCESSLIST; E) complete MySQLTuner report AND Optional very helpful information, if available includes - htop OR top OR mytop for most active apps, ulimit -a for a linux/unix list of limits, iostat -xm 5 3 for IOPS by device and core/cpu count, for server workload tuning analysis to provide suggestions.
What is the size of the FILE that fails to load (bytes)? Your max_allowed_packet can support up to 256M in a file. Please post the QUERY that is failing. You are likely correct that there is a 'time' limit causing the failure. Post the LAST 400 lines of your error log, just after a 'failure to load' and before the STOP/START of MySQL, please. B) Are your using the same BROWSER at home and at work?
