When I reload my site for 5/6 times instant, it showing database erro

[eshikhon]

hello Hope you are doing well. when my visitor visit my site some of them see database error like the screenshot. I'm using a2hosting mach vps 16 packages that can hits 2000+ live(real time) visitors as they said. when my site hits 200+ live audience and then it became slow and for some visitors it showing, error established database connection.

[Veronica]

hi can you please share a screenshot as no screenshot is available in the topic description

[eshikhon]

This reply has been marked as private.

[Anshuman Sahu]

post id 4027606 is quite big . Seems like you have hundreds of courses then? The issue is related to database connection , the database keeps on getting crashing . Please install this plugin : https://wordpress.org/plugins/query-monitor/ to check whuich plugin is putting load on your server ?

[eshikhon]

What is the solution for database crash. Now I see my database size is 2.56GB How can I reduce database size? I have huge post that have no data only post id has created.

[Anshuman Sahu]

2.56 GB is very Big for a website .There is so much data on your website . How many users and courses are there on your site actually ? what is the sizes of these tables ? : posts , postmeta , users , usermeta tables? Please install this plugin : https://wordpress.org/plugins/query-monitor/ to check whuich plugin is putting load on your server ?

[Author]

Posts