SHARE
TWEET

MYSQL max connections

a guest Aug 3rd, 2015 12 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.  
  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.  
  20. # Here is entries for some specific programs
  21. # The following values assume you have at least 32M ram
  22.  
  23. [mysqld_safe]
  24. socket          = /var/run/mysqld/mysqld.sock
  25. nice            = 0
  26. open_files_limit = 1024000
  27.  
  28. [mysqld]
  29. #
  30. # * Basic Settings
  31. #
  32. user            = mysql
  33. pid-file        = /var/run/mysqld/mysqld.pid
  34. socket          = /var/run/mysqld/mysqld.sock
  35. port            = 3306
  36. basedir         = /usr
  37. datadir         = /var/lib/mysql
  38. tmpdir          = /tmp
  39. lc-messages-dir = /usr/share/mysql
  40. skip-external-locking
  41. #
  42. # Instead of skip-networking the default is now to listen only on
  43. # localhost which is more compatible and is not less secure.
  44. bind-address            = 127.0.0.1
  45. bind-address        = 37.59.3.174
  46. #
  47. # * Fine Tuning
  48. #
  49. key_buffer_size         = 20M
  50. max_allowed_packet      = 20M
  51. thread_stack            = 200K
  52. thread_cache_size   = 16
  53. # This replaces the startup script and checks MyISAM tables if needed
  54. # the first time they are touched
  55. myisam-recover         = BACKUP
  56. open_files_limit       = 10000
  57. max_connections        = 2000
  58. max_user_connections   = 2000
  59. #table_cache            = 64
  60. #thread_concurrency     = 10
  61. #
  62. # * Query Cache Configuration
  63. #
  64. query_cache_type        = 1
  65. query_cache_limit       = 1M
  66. query_cache_size        = 30M
  67. #
  68. # * Logging and Replication
  69. #
  70. # Both location gets rotated by the cronjob.
  71. # Be aware that this log type is a performance killer.
  72. # As of 5.1 you can enable the log at runtime!
  73. #general_log_file        = /var/log/mysql/mysql.log
  74. #general_log             = 1
  75. #
  76. # Error log - should be very few entries.
  77. #
  78. log_error = /var/log/mysql/error.log
  79. #
  80. # Here you can see queries with especially long duration
  81. #log_slow_queries       = /var/log/mysql/mysql-slow.log
  82. #long_query_time = 2
  83. #log-queries-not-using-indexes
  84. #
  85. # The following can be used as easy to replay backup logs or for replication.
  86. # note: if you are setting up a replication slave, see README.Debian about
  87. #       other settings you may need to change.
  88. #server-id              = 1
  89. #log_bin                        = /var/log/mysql/mysql-bin.log
  90. expire_logs_days        = 10
  91. max_binlog_size   = 100M
  92. #binlog_do_db           = include_database_name
  93. #binlog_ignore_db       = include_database_name
  94. #
  95. # * InnoDB
  96. #
  97. # InnoDB is enabled by default with a 10MB datafile in /var/lib/mysql/.
  98. # Read the manual for more InnoDB related options. There are many!
  99. #
  100. # * Security Features
  101. #
  102. # Read the manual, too, if you want chroot!
  103. # chroot = /var/lib/mysql/
  104. #
  105. # For generating SSL certificates I recommend the OpenSSL GUI "tinyca".
  106. #
  107. # ssl-ca=/etc/mysql/cacert.pem
  108. # ssl-cert=/etc/mysql/server-cert.pem
  109. # ssl-key=/etc/mysql/server-key.pem
RAW Paste Data
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy. OK, I Understand
Top