Vi Veri Veniversum Vivus Vici
  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
  14.  
  15. # This will be passed to all mysql clients
  16. # It has been reported that passwords should be enclosed with ticks/quotes
  17. # escpecially if they contain "#" chars...
  18. # Remember to edit /etc/mysql/debian.cnf when changing the socket location.
  19. [client]
  20. port		= 3306
  21. socket		= /var/run/mysqld/mysqld.sock
  22.  
  23. # Here is entries for some specific programs
  24. # The following values assume you have at least 32M ram
  25.  
  26. # This was formally known as [safe_mysqld]. Both versions are currently parsed.
  27. [mysqld_safe]
  28. socket		= /var/run/mysqld/mysqld.sock
  29. nice		= 0
  30.  
  31. [mysqld]
  32. #
  33. # * Basic Settings
  34. #
  35. user		= mysql
  36. pid-file	= /var/run/mysqld/mysqld.pid
  37. socket		= /var/run/mysqld/mysqld.sock
  38. port		= 3306
  39. basedir		= /usr
  40. datadir		= /home/mysql
  41. tmpdir		= /tmp
  42. lc-messages-dir	= /usr/share/mysql
  43. skip-external-locking
  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		= 32M
  52. max_allowed_packet	= 32M
  53. thread_stack		= 192K
  54. thread_cache_size       = 16
  55. # This replaces the startup sсript and checks MyISAM tables if needed
  56. # the first time they are touched
  57. myisam-recover         = BACKUP
  58. max_connections        = 64
  59. table_cache             = 1000
  60. #thread_concurrency     = 10
  61. #
  62. # * Query Cache Configuration
  63. #
  64. query_cache_limit	= 16M
  65. query_cache_size        = 64M
  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 logging goes to syslog due to /etc/mysql/conf.d/mysqld_safe_syslog.cnf.
  76. #
  77. # Here you can see queries with especially long duration
  78. log_slow_queries	= /var/log/mysql/mysql-slow.log
  79. long_query_time = 0
  80. slow_query_log = 1
  81. #log-queries-not-using-indexes
  82. #
  83. # The following can be used as easy to replay backup logs or for replication.
  84. # note: if you are setting up a replication slave, see README.Debian about
  85. #       other settings you may need to change.
  86. #server-id		= 1
  87. #log_bin			= /var/log/mysql/mysql-bin.log
  88. expire_logs_days	= 10
  89. max_binlog_size         = 100M
  90. #binlog_do_db		= include_database_name
  91. #binlog_ignore_db	= include_database_name
  92. #
  93. # * InnoDB
  94. #
  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. innodb_buffer_pool_size = 256M
  111. innodb_additional_mem_pool_size = 16M
  112. innodb_log_file_size = 128M
  113. innodb_log_buffer_size = 8M
  114. innodb_flush_log_at_trx_commit = 2
  115. innodb_thread_concurrency = 8
  116. innodb_flush_method = O_DIRECT
  117.  
  118. innodb_checksums = 0
  119. innodb_file_format_check = 0
  120. innodb_stats_on_metadata=0
  121.  
  122. [mysqldump]
  123. quick
  124. quote-names
  125. max_allowed_packet	= 16M
  126.  
  127. [mysql]
  128. #no-auto-rehash	# faster start of mysql but no tab completition
  129.  
  130. [isamchk]
  131. key_buffer		= 16M
  132.  
  133. #
  134. # * IMPORTANT: Additional settings that can override those from this file!
  135. #   The files must end with '.cnf', otherwise they'll be ignored.
  136. #
  137. !includedir /etc/mysql/conf.d/
  138.  


@темы: MySQL