home *** CD-ROM | disk | FTP | other *** search
/ PC World 2003 July & August / PCWorld_2003-07-08_cd.bin / Software / Vyzkuste / mysql / data1.cab / Servers / my-medium.cnf < prev    next >
Text File  |  2003-05-17  |  2KB  |  84 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=16M
  22. set-variable    = max_allowed_packet=1M
  23. set-variable    = table_cache=64
  24. set-variable    = sort_buffer=512K
  25. set-variable    = net_buffer_length=8K
  26. set-variable    = myisam_sort_buffer_size=8M
  27. server-id    = 1
  28.  
  29. # Uncomment the following if you want to log updates
  30. #log-bin
  31.  
  32. # Uncomment the following rows if you move the MySQL distribution to another
  33. # location
  34. #basedir = d:/mysql/
  35. #datadir = d:/mysql/data/
  36.  
  37.  
  38. # Uncomment the following if you are NOT using BDB tables
  39. #skip-bdb
  40.  
  41. # Uncomment the following if you are using BDB tables
  42. #set-variable    = bdb_cache_size=4M
  43. #set-variable    = bdb_max_lock=10000
  44.  
  45. # Uncomment the following if you are using Innobase tables
  46. #innodb_data_file_path = ibdata1:400M
  47. #innodb_data_home_dir = c:\ibdata
  48. #innodb_log_group_home_dir = c:\iblogs
  49. #innodb_log_arch_dir = c:\iblogs
  50. #set-variable = innodb_mirrored_log_groups=1
  51. #set-variable = innodb_log_files_in_group=3
  52. #set-variable = innodb_log_file_size=5M
  53. #set-variable = innodb_log_buffer_size=8M
  54. #innodb_flush_log_at_trx_commit=1
  55. #innodb_log_archive=0
  56. #set-variable = innodb_buffer_pool_size=16M
  57. #set-variable = innodb_additional_mem_pool_size=2M
  58. #set-variable = innodb_file_io_threads=4
  59. #set-variable = innodb_lock_wait_timeout=50
  60.  
  61. [mysqldump]
  62. quick
  63. set-variable    = max_allowed_packet=16M
  64.  
  65. [mysql]
  66. no-auto-rehash
  67. # Remove the next comment character if you are not familiar with SQL
  68. #safe-updates
  69.  
  70. [isamchk]
  71. set-variable    = key_buffer=20M
  72. set-variable    = sort_buffer=20M
  73. set-variable    = read_buffer=2M
  74. set-variable    = write_buffer=2M
  75.  
  76. [myisamchk]
  77. set-variable    = key_buffer=20M
  78. set-variable    = sort_buffer=20M
  79. set-variable    = read_buffer=2M
  80. set-variable    = write_buffer=2M
  81.  
  82. [mysqlhotcopy]
  83. interactive-timeout
  84.