Optimizing MySQL - Low CPU but extremely high Memory usage
I am attempting to optimize the MySQL 5.1.49 server. I noticed that the CPU usage is at about 20% but Memory usage is 90%. I am curious on if I should do anything about this. At this time I am the only person on the server running a series of queries. Traffic is between 900-1000 KB/S. Query Cache Hitrate is 0.13%. Key Efficiency is steady at 50%.
I need to be as prepared as possible for having 50 users on the server running similar queries. What can I do?