daily pastebin goal
45%
SHARE
TWEET

Untitled

a guest Jan 18th, 2019 75 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. # MySQL Server Instance Configuration File
  2. # ----------------------------------------------------------------------
  3. # Generated by the MySQL Server Instance Configuration Wizard
  4. #
  5. #
  6. # Installation Instructions
  7. # ----------------------------------------------------------------------
  8. #
  9. # On Linux you can copy this file to /etc/my.cnf to set global options,
  10. # mysql-data-dir/my.cnf to set server-specific options
  11. # (@localstatedir@ for this installation) or to
  12. # ~/.my.cnf to set user-specific options.
  13. #
  14. # On Windows you should keep this file in the installation directory
  15. # of your server (e.g. C:\Program Files\MySQL\MySQL Server X.Y). To
  16. # make sure the server reads the config file use the startup option
  17. # "--defaults-file".
  18. #
  19. # To run run the server from the command line, execute this in a
  20. # command line shell, e.g.
  21. # mysqld --defaults-file="C:\Program Files\MySQL\MySQL Server X.Y\my.ini"
  22. #
  23. # To install the server as a Windows service manually, execute this in a
  24. # command line shell, e.g.
  25. # mysqld --install MySQLXY --defaults-file="C:\Program Files\MySQL\MySQL Server X.Y\my.ini"
  26. #
  27. # And then execute this in a command line shell to start the server, e.g.
  28. # net start MySQLXY
  29. #
  30. #
  31. # Guildlines for editing this file
  32. # ----------------------------------------------------------------------
  33. #
  34. # In this file, you can use all long options that the program supports.
  35. # If you want to know the options a program supports, start the program
  36. # with the "--help" option.
  37. #
  38. # More detailed information about the individual options can also be
  39. # found in the manual.
  40. #
  41. #
  42. # CLIENT SECTION
  43. # ----------------------------------------------------------------------
  44. #
  45. # The following options will be read by MySQL client applications.
  46. # Note that only client applications shipped by MySQL are guaranteed
  47. # to read this section. If you want your own MySQL client program to
  48. # honor these values, you need to specify it as an option during the
  49. # MySQL client library initialization.
  50. #
  51. [client]
  52.  
  53. port=12000
  54.  
  55. [mysql]
  56.  
  57. default-character-set=utf8
  58.  
  59.  
  60. # SERVER SECTION
  61. # ----------------------------------------------------------------------
  62. #
  63. # The following options will be read by the MySQL Server. Make sure that
  64. # you have installed the server correctly (see above) so it reads this
  65. # file.
  66. #
  67. [mysqld]
  68. #server-id=1
  69. #log-bin=e:/data/logbin12000/bin.log
  70. #expire_logs_days=2
  71. #binlog-format=raw
  72. # The TCP/IP Port the MySQL Server will listen on
  73. port=12000
  74. wait_timeout=10000
  75.  
  76.  
  77. #Path to installation directory. All paths are usually resolved relative to this.
  78. basedir="d:/programs/DbServer2/"
  79.  
  80. #Path to the database root
  81. datadir="e:/data/db12000/data"
  82.  
  83. # The default character set that will be used when a new schema or table is
  84. # created and no character set is defined
  85. character-set-server=latin1
  86.  
  87. collation-server=latin1_swedish_ci
  88.  
  89. # The default storage engine that will be used when create new tables when
  90. default-storage-engine=InnoDB
  91.  
  92. # Set the SQL mode to strict
  93. sql-mode="STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"
  94.  
  95. # The maximum amount of concurrent sessions the MySQL server will
  96. # allow. One of these connections will be reserved for a user with
  97. # SUPER privileges to allow the administrator to login even if the
  98. # connection limit has been reached.
  99. max_connections=2000
  100.  
  101. # Query cache is used to cache SELECT results and later return them
  102. # without actual executing the same query once again. Having the query
  103. # cache enabled may result in significant speed improvements, if your
  104. # have a lot of identical queries and rarely changing tables. See the
  105. # "Qcache_lowmem_prunes" status variable to check if the current value
  106. # is high enough for your load.
  107. # Note: In case your tables change very often or if your queries are
  108. # textually different every time, the query cache may result in a
  109. # slowdown instead of a performance improvement.
  110. query_cache_size=84M
  111.  
  112. # The number of open tables for all threads. Increasing this value
  113. # increases the number of file descriptors that mysqld requires.
  114. # Therefore you have to make sure to set the amount of open files
  115. # allowed to at least 4096 in the variable "open-files-limit" in
  116. # section [mysqld_safe]
  117. table_cache=1520
  118.  
  119. # Maximum size for internal (in-memory) temporary tables. If a table
  120. # grows larger than this value, it is automatically converted to disk
  121. # based table This limitation is for a single table. There can be many
  122. # of them.
  123. tmp_table_size=30M
  124.  
  125.  
  126. # How many threads we should keep in a cache for reuse. When a client
  127. # disconnects, the client's threads are put in the cache if there aren't
  128. # more than thread_cache_size threads from before.  This greatly reduces
  129. # the amount of thread creations needed if you have a lot of new
  130. # connections. (Normally this doesn't give a notable performance
  131. # improvement if you have a good thread implementation.)
  132. thread_cache_size=38
  133.  
  134. #*** MyISAM Specific options
  135.  
  136. # The maximum size of the temporary file MySQL is allowed to use while
  137. # recreating the index (during REPAIR, ALTER TABLE or LOAD DATA INFILE.
  138. # If the file-size would be bigger than this, the index will be created
  139. # through the key cache (which is slower).
  140. myisam_max_sort_file_size=100G
  141.  
  142. # If the temporary file used for fast index creation would be bigger
  143. # than using the key cache by the amount specified here, then prefer the
  144. # key cache method.  This is mainly used to force long character keys in
  145. # large tables to use the slower key cache method to create the index.
  146. myisam_sort_buffer_size=30M
  147.  
  148. # Size of the Key Buffer, used to cache index blocks for MyISAM tables.
  149. # Do not set it larger than 30% of your available memory, as some memory
  150. # is also required by the OS to cache rows. Even if you're not using
  151. # MyISAM tables, you should still set it to 8-64M as it will also be
  152. # used for internal temporary disk tables.
  153. key_buffer_size=257M
  154.  
  155. # Size of the buffer used for doing full table scans of MyISAM tables.
  156. # Allocated per thread, if a full scan is needed.
  157. read_buffer_size=64K
  158. read_rnd_buffer_size=256K
  159.  
  160. # This buffer is allocated when MySQL needs to rebuild the index in
  161. # REPAIR, OPTIMZE, ALTER table statements as well as in LOAD DATA INFILE
  162. # into an empty table. It is allocated per thread so be careful with
  163. # large settings.
  164. sort_buffer_size=256K
  165.  
  166.  
  167. #*** INNODB Specific options ***
  168.  
  169.  
  170. # Use this option if you have a MySQL server with InnoDB support enabled
  171. # but you do not plan to use it. This will save memory and disk space
  172. # and speed up some things.
  173. #skip-innodb
  174.  
  175. # Additional memory pool that is used by InnoDB to store metadata
  176. # information.  If InnoDB requires more memory for this purpose it will
  177. # start to allocate it from the OS.  As this is fast enough on most
  178. # recent operating systems, you normally do not need to change this
  179. # value. SHOW INNODB STATUS will display the current amount used.
  180. innodb_additional_mem_pool_size=22M
  181.  
  182. # If set to 1, InnoDB will flush (fsync) the transaction logs to the
  183. # disk at each commit, which offers full ACID behavior. If you are
  184. # willing to compromise this safety, and you are running small
  185. # transactions, you may set this to 0 or 2 to reduce disk I/O to the
  186. # logs. Value 0 means that the log is only written to the log file and
  187. # the log file flushed to disk approximately once per second. Value 2
  188. # means the log is written to the log file at each commit, but the log
  189. # file is only flushed to disk approximately once per second.
  190. innodb_flush_log_at_trx_commit=1
  191.  
  192. # The size of the buffer InnoDB uses for buffering log data. As soon as
  193. # it is full, InnoDB will have to flush it to disk. As it is flushed
  194. # once per second anyway, it does not make sense to have it very large
  195. # (even with long transactions).
  196. innodb_log_buffer_size=11M
  197.  
  198. # InnoDB, unlike MyISAM, uses a buffer pool to cache both indexes and
  199. # row data. The bigger you set this the less disk I/O is needed to
  200. # access data in tables. On a dedicated database server you may set this
  201. # parameter up to 80% of the machine physical memory size. Do not set it
  202. # too large, though, because competition of the physical memory may
  203. # cause paging in the operating system.  Note that on 32bit systems you
  204. # might be limited to 2-3.5G of user level memory per process, so do not
  205. # set it too high.
  206. innodb_buffer_pool_size=1024M
  207.  
  208. # Size of each log file in a log group. You should set the combined size
  209. # of log files to about 25%-100% of your buffer pool size to avoid
  210. # unneeded buffer pool flush activity on log file overwrite. However,
  211. # note that a larger logfile size will increase the time needed for the
  212. # recovery process.
  213. innodb_log_file_size=200M
  214.  
  215. # Number of threads allowed inside the InnoDB kernel. The optimal value
  216. # depends highly on the application, hardware as well as the OS
  217. # scheduler properties. A too high value may lead to thread thrashing.
  218. innodb_thread_concurrency=18
  219.  
  220. skip-log-warnings
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