Page 1 of 1
[mysql]settings
Posted: Tue Jan 27, 2015 2:09 am
by Maui
hello
I have a server and want some settings in mysql that it does not lag
software:linux x64
Ram : 32G
cores: 8
connection: 10G
when can someone tell me what settings do
Re: [mysql]settings
Posted: Tue Jan 27, 2015 3:45 pm
by Bencratus
Maui wrote:hello
I have a server and want some settings in mysql that it does not lag
software:linux x64
Ram : 32G
cores: 8
connection: 10G
when can someone tell me what settings do
Hi,
MySQL doesn't have amazing settings to make it unlagy, everything is in your core, how it connect to database, close after work etc. Just use normal settings like all and if you feel lags, because of database (if you think so), I think it will be your custom stuff.
Some tips:
1. Make everyday auto restart.
2. Download latest MySQL.
3. Update server to the last master revision from GitHub (because it is some new libs of mysql).
It is my opinion:)
Best Regards,
Bencratus