daily pastebin goal
94%
SHARE
TWEET

Untitled

a guest Sep 25th, 2017 46 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. # Example MySQL config file for small systems.
  2. #
  3. # This is for a system with little memory (<= 64M) where MySQL is only used
  4. # from time to time and it's important that the mysqld daemon
  5. # doesn't use much resources.
  6. #
  7. # You can copy this file to
  8. # /etc/my.cnf to set global options,
  9. # mysql-data-dir/my.cnf to set server-specific options (in this
  10. # installation this directory is C:\mysql\data) or
  11. # ~/.my.cnf to set user-specific options.
  12. #
  13. # In this file, you can use all long options that a program supports.
  14. # If you want to know which options a program supports, run the program
  15. # with the "--help" option.
  16.  
  17. # The following options will be passed to all MySQL clients
  18. [client]
  19. #password   = your_password
  20. pipe
  21. socket      = ZWC-DB
  22.  
  23. # Here follows entries for some specific programs
  24.  
  25. [mysqldump]
  26. quick
  27. max_allowed_packet = 16M
  28.  
  29. [mysql]
  30. no-auto-rehash
  31. socket  = ZWC-DB
  32. # Remove the next comment character if you are not familiar with SQL
  33. #safe-updates
  34.  
  35. [isamchk]
  36. key_buffer = 30M
  37. sort_buffer_size = 8M
  38.  
  39. [myisamchk]
  40. key_buffer = 30M
  41. sort_buffer_size = 8M
  42.  
  43. [mysqlhotcopy]
  44. interactive-timeout
  45.  
  46. # The MySQL server
  47. [mysqld]
  48. enable-named-pipe
  49. socket=ZWC-DB
  50. port=41337
  51. skip-locking
  52. key_buffer = 16M
  53. max_allowed_packet = 1M
  54. table_cache = 32
  55. sort_buffer_size = 4m
  56. read_buffer_size = 3M
  57. read_rnd_buffer_size = 4M
  58. net_buffer_length = 2K
  59. thread_stack = 64K
  60. character_set_server=utf8
  61. skip-character-set-client-handshake
  62. collation_server=utf8_unicode_ci
  63. log=zcbmysqllog.txt
  64. thread_cache_size=4
  65. query_cache_size=256K
  66. query_cache_limit=256K
  67. skip-innodb
  68. log-slow-queries
  69. table_cache=64
  70. max_connections=40
  71. max_heap_table_size=50M
  72. wait_timeout=300
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