The innodb_buffer_pool_size configuration variable controls how much RAM InnoDB uses to cache data and indexes. For a dedicated MySQL server, setting this to 70-80% of total RAM is a best-practice starting point.
