(Solved) Mysql crashes Server


#1

Hello Easy Engine Community.

Once more i find the need to ask for your help, because i’m facing a server crash because of my inability of setting up correctly the mysql configurations.

I’m using a 1gb DO vps, with a single site on the server.

Mysqltuner - http://pastebin.com/q26Gux5G Mysqlconf - http://pastebin.com/cc3Hb9NE

What changes do you recommend? Thanks


#2

Which DB engines are you require to use for your data?

You have all three of these enabled: Aria, InnoDB and MyISAM. Since you have only 1GB of RAM perhaps you should consider disabling two and using just one to reduce the memory consumption. For example, you InnoDB is only using 7M of data out of available 256M, perhaps you will be better off with just MyISAM disabling both InnoDB and Aria. Or at least reduce innodb_buffer_pool_size = 256M to something like 32M.

Then you should reduce amount of connections from 100 to just say 20-30 (you’re currently using only 6). You can increase this value gradually over time if this will not be enough. max_connections = 30

Try to increase both tmp_table_size = 32M and max_heap_table_size = 32M to 64M or even 128M (you have too many tables createdd on the disk).

query_cache_size = 64M - try to reduce to 32M (Query cache efficiency is only at 47.4%)

key_buffer_size = 128M - try to reduce to 32M (you’re using only 18%). You can always increase it later if required.

Then run MySQL Tuner again in a few days to check.


#3

Tyrro i really appreciate your help on this, i need to dig deeper into this stuff and learn how to do a proper setup.

I’m using easy engine defaults, and i’ve already changed the values. So far so good. I’ve also reduced the php7-fpm max children to a more reasonable value, it was at 100.

By the way, i’m also using Cloudflare as CDN. This website is something for 500-1000 online max!

Disabling the other database services is a simple thing to do? If i comment the settings on mysql will it be disabled?

Thank you once again, i really like managing my servers but i’m still a noob.


#4

Please use Google to find tutorials on how to disable InnoDB and Aria, but be aware that if you already have data in tables with these engines you first need to convert them to MyISAM if this is the one you will keep.

I think EasyEngine site had a tutorial on this here: https://easyengine.io/tutorials/mysql/innodb-to-myisam/


#5

I’ll create a development enviroment to test this things out.

Thank you for your help and have a great day!


#6