Advertisement
riespandi

mariadb.cnf

Jan 28th, 2016
64
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. [mysqld]
  2. datadir              = /var/lib/mysql
  3. log_error            = /var/log/mysqld.log
  4. log_bin              = /var/log/mysql/mariadb-bin
  5. log_bin_index        = /var/log/mysql/mariadb-bin.index
  6. socket               = /var/run/mysqld/mysqld.sock
  7. bind-address         = 0.0.0.0
  8. user                 = mysql
  9. port                 = 3306
  10. old_passwords        = 0
  11. local_infile         = 0
  12.  
  13. table_cache          = 1M
  14. max_connections      = 10
  15. max_user_connections = 50
  16. max_allowed_packet   = 2M
  17. interactive_timeout  = 64
  18. wait_timeout         = 64
  19. connect_timeout      = 10
  20.  
  21. query_cache_type     = 1
  22. query_cache_size     = 2M
  23. query_cache_limit    = 4K
  24. thread_cache_size    = 128
  25. join_buffer_size     = 64K
  26. read_buffer_size     = 32K
  27. key_buffer_size      = 2M
  28.  
  29. bulk_insert_buffer_size = 0
  30. thread_stack            = 16K
  31. read_rnd_buffer_size    = 8K
  32. max_heap_table_size     = 16K
  33. tmp_table_size          = 1K
  34. net_buffer_length       = 1K
  35. binlog_cache_size       = 4K
  36. binlog_stmt_cache_size  = 4K
  37.  
  38. [isamchk]
  39. key_buffer_size      = 2M
  40. write_buffer_size    = 2M
  41. read_buffer_size     = 32K
  42. sort_buffer_size     = 64K
  43.  
  44. [mysqldump]
  45. max_allowed_packet   = 2M
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement