michaelmadman

MariaDB - Faster Config

Oct 5th, 2012
224
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.86 KB | None | 0 0
  1. [mysqld]
  2. datadir=C:/Program Files/MariaDB 5.5/data
  3. port=3306
  4. sql_mode="NO_ENGINE_SUBSTITUTION"
  5. default_storage_engine=innodb
  6. innodb_buffer_pool_size=287M
  7. innodb_log_file_size=50M
  8. [client]
  9. port=3306
  10.  
  11.  
  12. key_buffer_size = 384M
  13. max_allowed_packet = 100M
  14. table_open_cache = 512
  15. sort_buffer_size = 2M
  16. read_buffer_size = 2M
  17. read_rnd_buffer_size = 8M
  18. myisam_sort_buffer_size = 64M
  19. thread_cache_size = 8
  20. query_cache_size = 32M
  21. thread_concurrency = 8
  22.  
  23. query_cache_size=0
  24. table_cache=256
  25. tmp_table_size=26M
  26. thread_cache_size=8
  27.  
  28.  
  29. myisam_max_sort_file_size=100G
  30. myisam_sort_buffer_size=52M
  31. key_buffer_size=41M
  32. read_buffer_size=64K
  33. read_rnd_buffer_size=256K
  34. sort_buffer_size=256K
  35.  
  36. innodb_additional_mem_pool_size=2M
  37. innodb_flush_log_at_trx_commit=1
  38. innodb_log_buffer_size=1M
  39. innodb_buffer_pool_size=78M
  40. innodb_log_file_size=39M
  41. innodb_thread_concurrency=10
Advertisement
Add Comment
Please, Sign In to add comment