my-huge.cnf
Upload User: dzyhzl
Upload Date: 2019-04-29
Package Size: 56270k
Code Size: 2k
Development Platform:

C/C++

  1. # Example mysql config file.
  2. # Copy this file to c:my.cnf to set global options
  3. # One can use all long options that the program supports.
  4. # Run the program with --help to get a list of available options
  5. # This will be passed to all mysql clients
  6. [client]
  7. #password=my_password
  8. port=3306
  9. #socket=MySQL
  10. # Here is entries for some specific programs
  11. # The following values assume you have at least 32M ram
  12. # The MySQL server
  13. [mysqld]
  14. port=3306
  15. #socket=MySQL
  16. skip-locking
  17. set-variable = key_buffer=384M
  18. set-variable = max_allowed_packet=1M
  19. set-variable = table_cache=512
  20. set-variable = sort_buffer=2M
  21. set-variable = record_buffer=2M
  22. set-variable = thread_cache=8
  23. # Try number of CPU's*2 for thread_concurrency
  24. set-variable = thread_concurrency=8
  25. set-variable = myisam_sort_buffer_size=64M
  26. server-id = 1
  27. # Uncomment the following if you want to log updates
  28. #log-bin
  29. # Uncomment the following rows if you move the MySQL distribution to another
  30. # location
  31. #basedir = d:/mysql/
  32. #datadir = d:/mysql/data/
  33. # Uncomment the following if you are NOT using BDB tables
  34. #skip-bdb
  35. # Uncomment the following if you are using BDB tables
  36. #set-variable = bdb_cache_size=384M
  37. #set-variable = bdb_max_lock=100000
  38. # Uncomment the following if you are using Innobase tables
  39. #innodb_data_file_path = ibdata1:2000M;ibdata2:2000M
  40. #innodb_data_home_dir = c:ibdata
  41. #innodb_log_group_home_dir = c:iblogs
  42. #innodb_log_arch_dir = c:iblogs
  43. #set-variable = innodb_mirrored_log_groups=1
  44. #set-variable = innodb_log_files_in_group=3
  45. #set-variable = innodb_log_file_size=5M
  46. #set-variable = innodb_log_buffer_size=8M
  47. #innodb_flush_log_at_trx_commit=1
  48. #innodb_log_archive=0
  49. #set-variable = innodb_buffer_pool_size=16M
  50. #set-variable = innodb_additional_mem_pool_size=2M
  51. #set-variable = innodb_file_io_threads=4
  52. #set-variable = innodb_lock_wait_timeout=50
  53. [mysqldump]
  54. quick
  55. set-variable = max_allowed_packet=16M
  56. [mysql]
  57. no-auto-rehash
  58. # Remove the next comment character if you are not familiar with SQL
  59. #safe-updates
  60. [isamchk]
  61. set-variable = key_buffer=256M
  62. set-variable = sort_buffer=256M
  63. set-variable = read_buffer=2M
  64. set-variable = write_buffer=2M
  65. [myisamchk]
  66. set-variable = key_buffer=256M
  67. set-variable = sort_buffer=256M
  68. set-variable = read_buffer=2M
  69. set-variable = write_buffer=2M
  70. [mysqlhotcopy]
  71. interactive-timeout