Translations:Administrators/Optimize performance/MySQL/13/en

These MySQL variables are worth looking for:
 * innodb_buffer_pool_size : The higher this value, the more data and indexes are available in memory and this is much faster than reading them from the hard disk
 * query_cache_size : The higher the value, the more queries can be answered directly without accessing the hard disk
 * sort_buffer_size : The buffer size that is available for sorting result sets if no index can be used
 * tmp_table_size : The size of the in-memory buffer for temporary tables before they are written to the hard disk