Not a sysadmin so... We have a database that is approx 4GB in size on a MySQL 5.0.22 instance. The table is InnoDB / UTF-8. There is basically a single query that runs against it against an indexed column. The hardware has 16GB of memory. Ideally, I'd like to manage so that both the data file and index file should always be in memory (with writes being flushed to disk). There is very little activity on this server.
Assuming that it has sufficient memory (which I think it does), should this be the expected behavior without swapping to disk?
How could I confirm that this behavior is taking place?
thanks in advance