Please. How do I calculate the nginx and database optimization

Hamka

I want to ask 🙏..I have a news website..I use a server with :
16 core cpu and 128 ram..
how can the calculation optimize its value on nginx and mariadb ?

i didn't find the option for 128 gb ram in the mariadb optimization menu...

I also want to ask for help to fill in the optimization value in Nginx 🙏

aapanel_power

Hamka Wow, your server is really powerful. We haven't done any simulation tests on this type of machine yet, but I think the default configuration is good enough

JAY

if its wordpress then only option to cache post with a cache plugin

Hamka

JAY
not that I mean my friend.
is the choice only up to the limit of ram 16 - 32? If later I use RAM 128 .. will it appear automatically?

aapanel_power

This is my first discussion as an administrator of AAPANEL, hahaha

zuantou

aapanel_power Hello, could you tell me who you are

Hamka

aapanel_power
😀😀🙏🙏🙏
thank you for answering my question ... but is there any sample value to use in the 128 ram optimization configuration menu mysqld optimization

jhin1m

aapanel_power Oh, i found this 🙂 your first discussion as an administrator

aapanel_power

zuantou Hello, brother, today is the Chinese New Year, I think of a Mysql configuration here. This is a Mysql configuration auto-generation tool developed by Lao Ye. Lao Ye is an ACE certified by Oracle, but his configuration is to run Mysql alone, and you can modify it according to its configuration. In the case of Nginx, I don't think there is any need to optimize it. The execution in the memory is faster than the local disk. Good luck.
I am the official operation and maintenance of AAPANEL
Lao Ye:https://imysql.cn/my-cnf-wizard.html

zuantou

Hamka You can refer to the following post to optimize your MySQL, I'm sorry it had not English version, you need to use translation plug-ins
https://www.bt.cn/bbs/thread-6346-1-1.html

Hamka

zuantou

is there a picture if using 128 ram?

zuantou

Hamka There is no

Hamka

aapanel_power thanks brother .....

aapanel_power

Hamka Hello, brother, thank you, we are a family