I am having various issues running [login to view URL]
Basically I think that the site/server is overloaded. There are 1000+ posts, 10000+ files due to thumbnails.
Each time a post is being created, there are 20+ thumbnails being generated and hence ultimately we getting too many files.
This is what I need to be done
1. Limit number of thumbnails to just a few instead of thumbnails.
The theme I am using is newstube. I am also using a plugin called one click video that imports embedded video from youtube. Newstube and oneclick video are basically creating too many thumbnails.
2. You will need to clear all thumbnails – I think there is a plugin that does that and then regenerate all thumbnails ie only the essential ones
Hence we ll be able to bring the number of files down and maybe there would be sql dataoverload
3. Database connections check/?brute force –
The following issue has been brought forward:
Currently, the website [login to view URL] goes to installation page. The issue is not due to maximum concurrent MySQL connections being exceeded. Sorry for the incorrect information given earlier. The issue is due to MySQL query limits being exceeded. This can be seen at the test database script at [login to view URL] which currently gives following output :
User 'QCCU48OYNV3L5dq' has exceeded the 'max_questions' resource (current value: 150000)
The database related to website is 'ss_dbname_nc7dke1a34'. The above mentioned error occurs when the user 'QCCU48OYNV3L5dq' of this database exceeds the hourly query limit. The hourly query limit is 150000. If this query limit is exceeded, then the Wordpress website will redirect to installation page. This setting is in place to ensure that the MySQL database cannot be overloaded with to many query requests.
It appears that, the script(s) related to your website's plugins/theme/widgets are not closing the MySQL connection after accessing the database and thus causing the query limit to exceed. Unfortunately, we can't say which exact script(s) is/are causing the issue. Please contact your website developer and have them make sure that the script(s) of your website's plugins/themes/widgets close the MySQL connection properly and are optimized so that they don't cause the query limits to be exceeded. It is also possible that, your website's pages/posts are getting frequent hits from a specific IP address through brute force tools or manually or from other websites. You can check raw logs available in the /stats directory or check the Visitor Statistics for such possibilities and use security plugins to block traffic from unwanted IPs. Please contact your website developer or online forums for more information regarding these kind of plugins.