MySQL Forums
Forum List  »  Performance

Mysql Apache on 2gb VM
Posted by: j a
Date: February 21, 2018 07:52PM

I am wondering if i am making a mistake attempting to run Apache and MySql on a 2gb of memory VM.

I will be hosting an aspnet core service on apache (it runs as a reverse proxy). I expect 300, maybe 400mb of memory to dedicate to this.

For a few months, I expect no more than 30-40-concurrent users max. That's pretty small. The database is a fairly simple structure - 10-12 tables each table less than 10-12 columns. I am super excited to use mysql after using mssql for 15 years!
Am I being realistic, or do I not know the true power of mysql yet? From what i read, there's a lot of caching going on and typically you should use up to 80% of memory. I don't have 80%. There are so many config options and some recommendations are that you can actually make it worse than leaving the defaults, which in my base my.cnf file, aren't very many.

I don't mind disk reads, i don't need the entire db in cache, but I don't want to cripple the engine either.

Please help.

Options: ReplyQuote

Written By
Mysql Apache on 2gb VM
j a
February 21, 2018 07:52PM
February 21, 2018 08:08PM
j a
February 21, 2018 08:57PM
j a
February 21, 2018 08:59PM
February 21, 2018 09:32PM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.