Search code examples
mysqlwordpressiiswindows-server-2012iis-10

configuration of mysql for improve performance


i have mysql on server all query slow if change innodb_buffer_pool_size from 16M to other number will down server with high traffic because all query is very slow or any other recommendation to improve thanks for any help


Solution

  • innodb_buffer_pool_size should be about 70% of available RAM. 16M is too small.