Memcache vs MySQL in memory

I have a database that won't grow much in size. It's current size is about 1 GB.

Achieving the fastest performance is desired.

Question: When should I use Memcache vs simply using MySQL Innodb ability to store all my co开发者_JS百科ntent within RAM (innodb_buffer_pool_size)?

---

I would only resort to memcached if you require more than one server to hold everything in RAM. Otherwise, you're adding complexity for not much functionality.

---

mysql is more performance degradated on much threads then memcached. so when you will get much simultaneous requests - memcached will respond almost in the same constant time, but mysql's time will be worse.

anyway - until you get about 3-5k tps (or more) to write - there is no any reasons to make project infrastructure more complex.