Guest User

my.cnf

a guest
May 9th, 2013
1,449
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. #
  2. # The MySQL database server configuration file.
  3. #
  4. # You can copy this to one of:
  5. # - "/etc/mysql/my.cnf" to set global options,
  6. # - "~/.my.cnf" to set user-specific options.
  7. #
  8. # One can use all long options that the program supports.
  9. # Run program with --help to get a list of available options and with
  10. # --print-defaults to see which it would actually understand and use.
  11. #
  12. # For explanations see
  13. # http://dev.mysql.com/doc/mysql/en/server-system-variables.html
  14. # This will be passed to all mysql clients
  15. # It has been reported that passwords should be enclosed with ticks/quotes
  16. # escpecially if they contain "#" chars...
  17. # Remember to edit /etc/mysql/debian.cnf when changing the socket location.
  18. [client]
  19. port = 3306
  20. socket = /var/run/mysqld/mysqld.sock
  21.  
  22. # Here is entries for some specific programs
  23. # The following values assume you have at least 32M ram
  24.  
  25. # This was formally known as [safe_mysqld]. Both versions are currently parsed.
  26. [mysqld_safe]
  27. socket = /var/run/mysqld/mysqld.sock
  28. nice = 0
  29.  
  30. [mysqld]
  31. #
  32. # * Basic Settings
  33. #
  34. user = mysql
  35. pid-file = /var/run/mysqld/mysqld.pid
  36. socket = /var/run/mysqld/mysqld.sock
  37. port = 3306
  38. basedir = /usr
  39. datadir = /var/lib/mysql
  40. tmpdir = /tmp
  41. lc-messages-dir = /usr/share/mysql
  42. skip-external-locking
  43. myisam-recover=backup,force
  44. #
  45. # Instead of skip-networking the default is now to listen only on
  46. # localhost which is more compatible and is not less secure.
  47. bind-address = 127.0.0.1
  48. #
  49. # * Fine Tuning
  50. #
  51. key_buffer = 58M
  52. max_allowed_packet = 16M
  53. thread_stack = 128K
  54. thread_cache_size = 8
  55. # This replaces the startup script and checks MyISAM tables if needed
  56. # the first time they are touched
  57. myisam-recover = BACKUP
  58. max_connections = 500
  59. #table_cache = 512
  60. #thread_concurrency = 10
  61. #
  62. # * Query Cache Configuration
  63. #
  64. query_cache_limit = 1M
  65. query_cache_size = 16M
  66. #
  67. # * Logging and Replication
  68. #
  69. # Both location gets rotated by the cronjob.
  70. # Be aware that this log type is a performance killer.
  71. # As of 5.1 you can enable the log at runtime!
  72. #general_log_file = /var/log/mysql/mysql.log
  73. #general_log = 1
  74. #
  75. # Error log - should be very few entries.
  76. #
  77. log_error = /var/log/mysql/error.log
  78. #
  79. # Here you can see queries with especially long duration
  80. log_slow_queries = /var/log/mysql/mysql-slow.log
  81. #long_query_time = 2
  82. #log-queries-not-using-indexes
  83. #
  84. # The following can be used as easy to replay backup logs or for replication.
  85. # note: if you are setting up a replication slave, see README.Debian about
  86. # other settings you may need to change.
  87. #server-id = 1
  88. #log_bin = /var/log/mysql/mysql-bin.log
  89. expire_logs_days = 10
  90. max_binlog_size = 100M
  91. #binlog_do_db = include_database_name
  92. #binlog_ignore_db = include_database_name
  93. #
  94. # * InnoDB
  95. # InnoDB is enabled by default with a 10MB datafile in /var/lib/mysql/.
  96. # Read the manual for more InnoDB related options. There are many!
  97. #
  98. # * Security Features
  99. #
  100. # Read the manual, too, if you want chroot!
  101. # chroot = /var/lib/mysql/
  102. #
  103. # For generating SSL certificates I recommend the OpenSSL GUI "tinyca".
  104. #
  105. # ssl-ca=/etc/mysql/cacert.pem
  106. # ssl-cert=/etc/mysql/server-cert.pem
  107. # ssl-key=/etc/mysql/server-key.pem
  108.  
  109.  
  110.  
  111. [mysqldump]
  112. quick
  113. quote-names
  114. max_allowed_packet = 16M
  115.  
  116. [mysql]
  117. #no-auto-rehash # faster start of mysql but no tab completition
  118.  
  119. [isamchk]
  120. key_buffer = 16M
  121.  
  122. #
  123. # * IMPORTANT: Additional settings that can override those from this file!
  124. # The files must end with '.cnf', otherwise they'll be ignored.
  125. #
RAW Paste Data

Adblocker detected! Please consider disabling it...

We've detected AdBlock Plus or some other adblocking software preventing Pastebin.com from fully loading.

We don't have any obnoxious sound, or popup ads, we actively block these annoying types of ads!

Please add Pastebin.com to your ad blocker whitelist or disable your adblocking software.

×