MY SETUP ( example )
I am running Linux on an Amazon High CPU Extra Large EC2 instance with the following specs:
- 7 GB of memory
- 20 EC2 Compute Units (8 virtual cores with 2.5 EC2 Compute Units each)
- 1690 GB of local instance storage
- 64-bit platform
I have two large MySQL databases running on the MyISAM storage engine. One is 2GB and the other is 500MB. I'd like to make sure MySQL is using as much RAM as it can / needs to maximize query speeds. I know there are a bunch of MySQL memory config options like
MyISAM_sort_buffer_size, but I'm unfamiliar with optimizing these.
- How does one check what memory MySQL is currently using on a Linux system?
- How does one maximize / optimize MySQL memory usage?
- Assuming my queries and schema are optimized, what other changes should I consider?