[Need Help] How to fix this problem that cause server crash?

[swankiat]

Hi,

 

I am using prestashop 1.4.9. I have around 1600 products. I host my site on cloud server ( 2 vcpu, 4GB RAM, 4Mbps bandwidth).

 

Recently when visitors increasing to certain limit (about 160 visitors) and my server will crash. Below is the error I get.

 

 

======

130729 11:13:58 [ERROR] /usr/sbin/mysqld: Can't open file: './cphulkd/auths.frm' (errno: 24)

130729 11:13:59 [ERROR] /usr/sbin/mysqld: Can't open file: './eximstats/sends.frm' (errno: 24)

130729 11:13:59 [ERROR] /usr/sbin/mysqld: Can't open file: './tudung2u_tudung/ps_help_access.frm' (errno: 24)

130729 11:14:03 [ERROR] /usr/sbin/mysqld: Can't open file: './eximstats/smtp.frm' (errno: 24)

130729 11:17:53 [ERROR] Error in accept: Too many open files

130729 11:22:10 [ERROR] Error in accept: Too many open files

130729 11:26:00 [ERROR] /usr/sbin/mysqld: Can't open file: './eximstats/sends.frm' (errno: 24)

130729 11:26:04 [ERROR] /usr/sbin/mysqld: Can't open file: './eximstats/smtp.frm' (errno: 24)

130729 11:26:26 [ERROR] Error in accept: Too many open files

130729 11:30:43 [ERROR] Error in accept: Too many open files

======

 

Please kindly guide me how to solve this problem? Thanks a lot !

[vekia]

it looks like server side issue, not related to the prestashop, something is wrong with myslq server configuration (maybe it's related to high traffic?) you should definitely ask your hoster

[Jiten rash (away)]

about 160 visitors shud not effect 2 vcpu, 4GB RAM, 4Mbps bandwidth were u host site url plz visit statscrop.com and know how much bandwith u require for site visitors

[vekia]

well, i just thought about some hosting restrictions, for example related to the number of available connections etc.

error code mentioned in first post is strictly related to the server side issue