I have 6GB VPS, and site is not getting much traffic, hardly 200 pages per day; ram usage is around 25% https://prnt.sc/sC84i4pm1m50 all day, but MySQL is getting stopped automatically, i believe this is an Aapanel issue

entiretools Hello, the log shows that mysql has been closed by the system.

Hello, execute the command to view the error log cat /www/server/data/*.err|grep -i -C 10 error dmesg|grep -E "kill|mysql|oom" entiretools

Hi there I have uploaded notepad file it shows large nos of error

Hello, I suggest you check the system log to see if there is any relevant shutdown information? execute the command to view the error log dmesg|grep -E "kill|mysql|oom" entiretools

entiretools Hi there I have uploaded notepad file it shows large nos of error If there are errors, you can provide screenshots.

Website logs 2024/03/05 04:14:55 [error] 31014#0: *67233 open() ＂/www/wwwroot/tooliyo.com/.well-known/assetlinks.json＂ failed (2: No such file or directory), client: 143.198.214.137, server: tooliyo.com, request: ＂GET /.well-known/assetlinks.json HTTP/1.1＂, host: ＂tooliyo.com＂ 2024/03/05 04:15:00 [error] 31014#0: *67238 open() ＂/www/wwwroot/tooliyo.com/.well-known/assetlinks.json＂ failed (2: No such file or directory), client: 143.198.214.137, server: tooliyo.com, request: ＂GET /.well-known/assetlinks.json HTTP/1.1＂, host: ＂www.tooliyo.com＂ 2024/03/05 04:15:06 [error] 31014#0: *67241 open() ＂/www/wwwroot/tooliyo.com/.well-known/gpc.json＂ failed (2: No such file or directory), client: 143.198.214.137, server: tooliyo.com, request: ＂GET /.well-known/gpc.json HTTP/1.1＂, host: ＂tooliyo.com＂ 2024/03/05 04:15:12 [error] 31014#0: *67243 open() ＂/www/wwwroot/tooliyo.com/.well-known/gpc.json＂ failed (2: No such file or directory), client: 143.198.214.137, server: tooliyo.com, request: ＂GET /.well-known/gpc.json HTTP/1.1＂, host: ＂www.tooliyo.com＂ 2024/03/05 04:15:16 [error] 31014#0: *67244 open() ＂/www/wwwroot/tooliyo.com/.well-known/nodeinfo＂ failed (2: No such file or directory), client: 143.198.214.137, server: tooliyo.com, request: ＂GET /.well-known/nodeinfo HTTP/1.1＂, host: ＂tooliyo.com＂ 2024/03/05 04:15:21 [error] 31014#0: *67247 open() ＂/www/wwwroot/tooliyo.com/.well-known/nodeinfo＂ failed (2: No such file or directory), client: 143.198.214.137, server: tooliyo.com, request: ＂GET /.well-known/nodeinfo HTTP/1.1＂, host: ＂www.tooliyo.com＂ 2024/03/05 04:15:26 [error] 31014#0: *67248 open() ＂/www/wwwroot/tooliyo.com/.well-known/openid-configuration＂ failed (2: No such file or directory), client: 143.198.214.137, server: tooliyo.com, request: ＂GET /.well-known/openid-configuration HTTP/1.1＂, host: ＂tooliyo.com＂ 2024/03/05 04:15:31 [error] 31014#0: *67250 open() ＂/www/wwwroot/tooliyo.com/.well-known/openid-configuration＂ failed (2: No such file or directory), client: 143.198.214.137, server: tooliyo.com, request: ＂GET /.well-known/openid-configuration HTTP/1.1＂, host: ＂www.tooliyo.com＂ 2024/03/05 04:15:37 [error] 31014#0: *67252 open() ＂/www/wwwroot/tooliyo.com/.well-known/security.txt＂ failed (2: No such file or directory), client: 143.198.214.137, server: tooliyo.com, request: ＂GET /.well-known/security.txt HTTP/1.1＂, host: ＂tooliyo.com＂ 2024/03/05 04:15:47 [error] 31014#0: *67258 open() ＂/www/wwwroot/tooliyo.com/.well-known/security.txt＂ failed (2: No such file or directory), client: 143.198.214.137, server: tooliyo.com, request: ＂GET /.well-known/security.txt HTTP/1.1＂, host: ＂www.tooliyo.com＂ 2024/03/05 04:15:56 [error] 31014#0: *67267 open() ＂/www/wwwroot/tooliyo.com/.well-known/trust.txt＂ failed (2: No such file or directory), client: 143.198.214.137, server: tooliyo.com, request: ＂GET /.well-known/trust.txt HTTP/1.1＂, host: ＂tooliyo.com＂ 2024/03/05 04:16:08 [error] 31014#0: *67282 open() ＂/www/wwwroot/tooliyo.com/.well-known/trust.txt＂ failed (2: No such file or directory), client: 143.198.214.137, server: tooliyo.com, request: ＂GET /.well-known/trust.txt HTTP/1.1＂, host: ＂www.tooliyo.com＂

2024-03-05T17:23:37.045029Z 0 [Warning] option 'max_allowed_packet': unsigned value 107374182400 adjusted to 1073741824 2024-03-05T17:23:37.046050Z 0 [Warning] 'NO_ZERO_DATE', 'NO_ZERO_IN_DATE' and 'ERROR_FOR_DIVISION_BY_ZERO' sql modes should be used with strict mode. They will be merged with strict mode in a future release. 2024-03-05T17:23:37.046072Z 0 [Warning] 'NO_AUTO_CREATE_USER' sql mode was not set. 2024-03-05T17:23:37.046116Z 0 [Note] --secure-file-priv is set to NULL. Operations related to importing and exporting data are disabled 2024-03-05T17:23:37.046416Z 0 [Note] /www/server/mysql/bin/mysqld (mysqld 5.7.44-log) starting as process 54791 ... 2024-03-05T17:23:37.107457Z 0 [Note] InnoDB: PUNCH HOLE support available 2024-03-05T17:23:37.107498Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2024-03-05T17:23:37.107502Z 0 [Note] InnoDB: Uses event mutexes 2024-03-05T17:23:37.107505Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier 2024-03-05T17:23:37.107507Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.13 2024-03-05T17:23:37.108657Z 0 [Note] InnoDB: Number of pools: 1 2024-03-05T17:23:37.109794Z 0 [Note] InnoDB: Using CPU crc32 instructions 2024-03-05T17:23:37.112117Z 0 [Note] InnoDB: Initializing buffer pool, total size = 512M, instances = 1, chunk size = 128M 2024-03-05T17:23:37.195614Z 0 [Note] InnoDB: Completed initialization of buffer pool 2024-03-05T17:23:37.244942Z 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority(). 2024-03-05T17:23:37.317998Z 0 [Note] InnoDB: Highest supported file format is Barracuda. 2024-03-05T17:23:37.360481Z 0 [Note] InnoDB: Log scan progressed past the checkpoint lsn 620112324 2024-03-05T17:23:37.360537Z 0 [Note] InnoDB: Doing recovery: scanned up to log sequence number 620112333 2024-03-05T17:23:37.360565Z 0 [Note] InnoDB: Database was not shutdown normally! 2024-03-05T17:23:37.360570Z 0 [Note] InnoDB: Starting crash recovery.

Hello, if users apply for certificates in this directory, there will generally be no files. entiretools

aaPanel_Kern but why it is closing without any high usage?

Mysql Stopping frequently

entiretools

i increase the ram

but still mysql is stops, i see lots of other people also face this issue

entiretools

This is Ram usage whole days it donest reach 50% , than why ram shortage???

aaPanel_Kern

What you need is to reduce the memory usage configuration

entiretools

How much memory to allow ?

aaPanel_Kern

Recommend 2-3G

entiretools

I set to 2,3 gb ram but still MySQL stops

aaPanel_Kern

Hello, I suggest you check what is causing the memory usage.

entiretools

I see that PHP FPM usage is high

entiretools

IN CPU

entiretools

In RAM usage

entiretools

can you pls reply

aaPanel_Kern

Hello, it is recommended to check whether the php slow log and mysql slow log are normal?

entiretools

here mysql slow logs

« Previous Page