Aw Snap! Error

[pcunit]

I am getting the following error as soon as the traffic increases on the site.

Aw, snap! Internal Server Error - Check your error_log or enable debug_mode = 3 (chevereto.com/docs/debug).

Can you please let me know what to do.
I am on a 4 GB ram 2 x E5 - Xeon CPUs

I had a feeling it was due to the database. I optimised it but still i get the same errors on and off.

What should be ideal php and mysql settings for a site with 50000 or more daily page views

 

[Rodolfo]

Try enabling logs as the error suggests, provide the relevant log entries.

 

[pcunit]

/var/log/messages-20200405:Apr 3 07:22:47 imgcredit kernel: Out of memory: Kill process 1258 (clamd) score 233 or sacrifice child

/var/log/messages-20200405:Apr 3 07:24:03 imgcredit kernel: Out of memory: Kill process 19049 (mysqld) score 59 or sacrifice child

/var/log/messages-20200405:Apr 3 07:24:06 imgcredit kernel: Out of memory: Kill process 19055 (mysqld) score 59 or sacrifice child

/var/log/messages-20200405:Apr 3 07:24:09 imgcredit kernel: Out of memory: Kill process 19056 (mysqld) score 59 or sacrifice child

/var/log/messages-20200405:Apr 3 07:24:11 imgcredit kernel: Out of memory: Kill process 19062 (mysqld) score 59 or sacrifice child

/var/log/messages-20200405:Apr 3 07:24:12 imgcredit kernel: Out of memory: Kill process 8207 (mysqld) score 59 or sacrifice child

/var/log/messages-20200405:Apr 3 08:19:41 imgcredit kernel: Out of memory: Kill process 8046 (clamd) score 231 or sacrifice child

/var/log/messages-20200412:Apr 7 13:50:49 imgcredit kernel: Out of memory: Kill process 1266 (clamd) score 236 or sacrifice child

/var/log/messages-20200412:Apr 7 13:50:52 imgcredit kernel: Out of memory: Kill process 1430 (mysqld) score 51 or sacrifice child

/var/log/messages-20200412:Apr 7 14:23:24 imgcredit kernel: Out of memory: Kill process 20498 (clamd) score 234 or sacrifice child

 

[pcunit]

Following is My VPS's Mysql Settings

skip-external-locking
key_buffer_size = 16M
max_allowed_packet = 16M
table_open_cache = 64
sort_buffer_size = 512K
net_buffer_length = 8K
read_buffer_size = 256K
read_rnd_buffer_size = 512K
myisam_sort_buffer_size = 8M

innodb_use_native_aio = 0
innodb_file_per_table

max_connections=70
max_user_connections=30
wait_timeout=10
interactive_timeout=50
long_query_time=5

 

[imghut]

You using ClamAV, it's memory hungry and it's memory use jumps up and down all the time,
I had a simlilar problem and solved it by adding a 4 gig swap space, open a terminal and type 'free -h' (without quotes) this command will show how much memory in use and if you have a swap.
You also type 'top' to see memory use of each process.

 

[pcunit]

You using ClamAV, it's memory hungry and it's memory use jumps up and down all the time,
I had a simlilar problem and solved it by adding a 4 gig swap space, open a terminal and type 'free -h' (without quotes) this command will show how much memory in use and if you have a swap.
You also type 'top' to see memory use of each process.

But would creating swap space make me loose all my existing data?

also if i stop clamAV would it help?

 

[imghut]

No, a new swap will only use up free space, stopping ClamAV will help but have you run free -h & top yet to see whats what?

 

[pcunit]

I've attached a screenshot.

 

[imghut]

I think you forgot to attach 🙂

 

[pcunit]

I've enabled the 4 GB Swap

Seems to be working for the moment. Will watch for 24 hrs

 

[pcunit]

I think you forgot to attach 🙂

It is attached. I had to change it as it was a different pic

 

[imghut]

I've enabled the 4 GB Swap

Seems to be working for the moment. Will watch for 24 hrs

It should help a lot 😉

 

[pcunit]

It should help a lot 😉

Let us wait and watch. I will put in a feedback after 24 hrs same time tomorrow

 

[pcunit]

can somebody suggest optimal settings for the following

Following is My VPS's Mysql Settings

skip-external-locking
key_buffer_size = 16M
max_allowed_packet = 16M
table_open_cache = 64
sort_buffer_size = 512K
net_buffer_length = 8K
read_buffer_size = 256K
read_rnd_buffer_size = 512K
myisam_sort_buffer_size = 8M

innodb_use_native_aio = 0
innodb_file_per_table

max_connections=70
max_user_connections=30
wait_timeout=10
interactive_timeout=50
long_query_time=5

 

[imghut]

I can't tell you if these are optimal settings, but here are my settings for 10.3.22-MariaDB-0+deb10u1 Debian 10

key_buffer_size = 128M
max_allowed_packet = 64M
table_open_cache = 2000
sort_buffer_size = 1M
net_buffer_length = 16K
read_buffer_size = 128K
read_rnd_buffer_size = 256K
myisam_sort_buffer_size = 128M

innodb_use_native_aio = ON
innodb_file_per_table = ON

max_connections=151
max_user_connections=0
wait_timeout=28800
interactive_timeout=28800
long_query_time=10.000000

 

[pcunit]

how much ram and how many cores does your processor have and is it a vps or a dedicated one?

 

[imghut]

It's a VPS, single core, 1024MB Ram, I have 9 other sites on the same VPS.

 

[pcunit]

oh mine is a 2 core processor with 4 GB ram and gets just around 50000 daily page views and still I am facing these issues.