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