Advertisement
Guest User

Untitled

a guest
Sep 25th, 2017
68
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.66 KB | None | 0 0
  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
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement