Advertisement
Guest User

Untitled

a guest
Jul 15th, 2012
199
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.59 KB | None | 0 0
  1. cd /Ap # /etc/mysql/my.cnf: The global mysql configuration file.
  2.  
  3. # This file can be simultaneously placed in three places:
  4. # 1. /etc/mysql/my.cnf to set global options.
  5. # 2. /var/lib/mysql/my.cnf to set server-specific options.
  6. # 3. ~/.my.cnf to set user-specific options.
  7. #
  8. # One can use all long options that the program supports.
  9. # Run the program with --help to get a list of them.
  10. #
  11. # The following values assume you have at least 32M RAM!
  12.  
  13. [client]
  14. #password = my_password
  15. port = 3308
  16. socket = __PREFIX/var/run/mysqld/mysqld.sock
  17.  
  18. [safe_mysqld]
  19. err-log = __PREFIX/var/log/mysql/mysql.err
  20. pid-file = __PREFIX/var/run/mysqld/mysqld.pid
  21. socket = __PREFIX/var/run/mysqld/mysqld.sock
  22.  
  23. [mysqld_safe]
  24. err-log = __PREFIX/var/log/mysql/mysql.err
  25. pid-file = __PREFIX/var/run/mysqld/mysqld.pid
  26. socket = __PREFIX/var/run/mysqld/mysqld.sock
  27.  
  28. [mysqld]
  29. #skip-networking
  30. skip-innodb
  31. user = mysql
  32. pid-file = __PREFIX/var/run/mysqld/mysqld.pid
  33. socket = __PREFIX/var/run/mysqld/mysqld.sock
  34. port = 3308
  35. log = __PREFIX/var/log/mysql/mysql.log
  36. basedir = __PREFIX
  37. datadir = __PREFIX/var/db/mysql
  38. tmpdir = /tmp
  39. language = __PREFIX/share/mysql/english
  40. skip-locking
  41. set-variable = key_buffer=16M
  42. set-variable = max_allowed_packet=1M
  43. set-variable = thread_stack=128K
  44.  
  45. [mysqldump]
  46. quick
  47. set-variable = max_allowed_packet=1M
  48.  
  49. [mysql]
  50. #no-auto-rehash # faster start of mysql but no tab completition
  51.  
  52. [isamchk]
  53. set-variable = key_buffer=16
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement