All geek questions in one place

Memcache vs MySQL in memory

I have a database that will not grow much. Its current size is about 1 GB.

It is desirable to achieve maximum performance.

Question When should Memcache be used or just use the MySQL Innodb function to store all my contents in RAM (innodb_buffer_pool_size)?

+4
source share
2 answers

I would only use memcached if you need more than one server to keep everything in RAM. Otherwise, you add complexity for a little functionality.

+3
source

mysql improves performance on many threads, and then memcached. so when you get a lot of simultaneous requests, memcached will respond almost at the same time, but mysql time will be worse.

In any case - until you get about 3-5 thousand tf (or more) to write - there is no reason to make the project infrastructure more complex.

+1
source

Source: https://habr.com/ru/post/1304096/

More articles:


All Articles