Skip to content

Instantly share code, notes, and snippets.

@raihan-uddin

raihan-uddin/xampp mysql cache configureation.txt

Created December 14, 2020 10:47
Show Gist options
  • Save raihan-uddin/350a9d0e81e930961713e054e36d4e2b to your computer and use it in GitHub Desktop.
Save raihan-uddin/350a9d0e81e930961713e054e36d4e2b to your computer and use it in GitHub Desktop.
Download ZIP
Raw
xampp mysql cache configureation.txt
MYSQL CONFIGURATION:
innodb_buffer_pool_size = 16M
innodb_additional_mem_pool_size = 2M
## Set .._log_file_size to 25 % of buffer pool size
innodb_log_file_size = 5M
innodb_log_buffer_size = 8M
#----------------------------------------------------
# !!!! Query Cache Config !!!!
#----------------------------------------------------
query-cache-size = 524288000
query-cache-limit = 5242880
query-cache-type = 1
#----------------------------------------------------
# !!!! InnoDB Buffer Config !!!!
#----------------------------------------------------
innodb-buffer-pool-size = 1000M
innodb-additional-mem-pool-size = 200M
innodb-log-files-in-group = 2
innodb-log-buffer-size = 10M
innodb-file-per-table = 1
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment