1

I'm using Amazon cloud and I've performance issue since the HDD is not located on my machine. My database is small (~500MB) and I can afford to keep it all in my RAM. I do not want to keep queries in my RAM, i need all the tables there.

How can i do it?

Thanks, Koby

P.S. I'm using ubuntu server...

koby
  • 665
  • 2
  • 6
  • 15

2 Answers2

2

You could add a caching layer. Memcached might be a good choice for you:

http://memcached.org/

Ike Walker
  • 64,401
  • 14
  • 110
  • 109
1

You can load indexes into cache; if you have small ISAM tables that are frequently queried, MySQL will probably load these into cache as well. Here is a good Performance Wiki article on MySQL tuning.

gareth_bowles
  • 20,760
  • 5
  • 52
  • 82
  • I do not have problem with the queries performance. its the time that takes to fetch all the data. – koby Mar 22 '10 at 15:45