Guest User

Untitled

a guest
Dec 5th, 2013
246
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.43 KB | None | 0 0
  1. [client]
  2. port = 3306
  3. socket = /var/run/mysqld/mysqld.sock
  4.  
  5. [mysqld_safe]
  6. socket = /var/run/mysqld/mysqld.sock
  7. nice = 0
  8.  
  9. [mysqld]
  10. user = mysql
  11. pid-file = /var/run/mysqld/mysqld.pid
  12. socket = /var/run/mysqld/mysqld.sock
  13. port = 3306
  14. basedir = /usr
  15. datadir = /var/lib/mysql
  16. tmpdir = /tmp
  17. lc-messages-dir = /usr/share/mysql
  18. skip-external-locking
  19. skip-networking
  20. key_buffer = 16M
  21. max_allowed_packet = 16M
  22. thread_stack = 192K
  23. thread_cache_size = 32
  24. myisam-recover = BACKUP
  25. #max_connections = 100
  26. #thread_concurrency = 10
  27. key_buffer_size = 368M
  28. query_cache_limit = 4M
  29. query_cache_size = 512M
  30. innodb_buffer_pool_size = 2048M
  31. sort_buffer_size = 8M
  32. read_rnd_buffer_size = 4M
  33. tmp_table_size = 512M
  34. max_heap_table_size = 512M
  35. table_cache = 1024
  36. #general_log_file = /var/log/mysql/mysql.log
  37. #general_log = 1
  38. #log_slow_queries = /var/log/mysql/mysql-slow.log
  39. #long_query_time = 2
  40. #log-queries-not-using-indexes
  41. #server-id = 1
  42. #log_bin = /var/log/mysql/mysql-bin.log
  43. expire_logs_days = 10
  44. max_binlog_size = 100M
  45. #binlog_do_db = include_database_name
  46. #binlog_ignore_db = include_database_name
  47.  
  48. [mysqldump]
  49. quick
  50. quote-names
  51. max_allowed_packet = 16M
  52.  
  53. [mysql]
  54. #no-auto-rehash # faster start of mysql but no tab completition
  55.  
  56. [isamchk]
  57. key_buffer = 16M
  58.  
  59. !includedir /etc/mysql/conf.d/
Advertisement
Add Comment
Please, Sign In to add comment