Advertisement
Guest User

my.cnf

a guest
Dec 5th, 2011
80
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Bash 1.03 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. socket          = /var/run/mysqld/mysqld.sock
  12. port            = 3306
  13. basedir         = /usr
  14. datadir         = /var/lib/mysql
  15. tmpdir          = /tmp
  16. skip-external-locking
  17. bind-address            = 127.0.0.1
  18. key_buffer              = 32M
  19. max_allowed_packet      = 16M
  20. thread_stack            = 192K
  21. thread_cache_size       = 128
  22. myisam-recover         = BACKUP
  23. max_connections        = 300
  24. table_cache            = 2000
  25. query_cache_limit       = 1M
  26. query_cache_size        = 32M
  27. skip-innodb
  28. skip-name-resolve
  29. log_error                = /var/log/mysql/error.log
  30. expire_logs_days        = 10
  31. max_binlog_size         = 100M
  32. [mysqldump]
  33. quick
  34. quote-names
  35. max_allowed_packet      = 16M
  36.  
  37. [mysql]
  38. #no-auto-rehash # faster start of mysql but no tab completition
  39.  
  40. [isamchk]
  41. key_buffer              = 16M
  42. !includedir /etc/mysql/conf.d/
  43.  
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement