Setting up MySQL is not enough; monitoring and adjusting the settings is equally important. MySQL can be tuned and optimized in different ways. Buffer pool of MySQL needs to be properly sized and evaluated over time to optimize performance. Taking care of caching settings is also an integral part. Query cache, if tuned and sized properly, helps Magento in better page rendering time while table caches, max allowed packets, log buffers, etc can be modified to improve MySQL performance. Proper sizing must be taken care of as it is a vital part of speeded performances. This blog enlists various important ways in which MySQL can have optimized performance.
Disclaimer: The above article has been aggregated by a computer program and summarised by an eCommerce specialist. You can read the original article at Lexiconn