home *** CD-ROM | disk | FTP | other *** search
/ Enter 2004 June / ENTER.ISO / files / xampp-win32-1.4.5-installer.exe / xampp / my.cnf < prev    next >
Encoding:
Text File  |  2004-06-03  |  2.0 KB  |  75 lines
  1. # The MySQL client
  2. [client]
  3. #password       = your_password
  4. port            = 3306
  5. socket          =/xampp/mysql/mysql.sock
  6.  
  7. # Here follows entries for some specific programs
  8.  
  9. # The MySQL server
  10. [mysqld]
  11. port            = 3306
  12. socket          = /xampp/mysql/mysql.sock
  13. skip-locking
  14. set-variable    = key_buffer=16M
  15. set-variable    = max_allowed_packet=1M
  16. set-variable    = table_cache=64
  17. set-variable    = sort_buffer=512K
  18. set-variable    = net_buffer_length=8K
  19. set-variable    = myisam_sort_buffer_size=8M
  20. log-bin
  21. server-id       = 1
  22.  
  23. basedir=/xampp/mysql
  24. tmpdir=/xampp/tmp
  25. datadir=/xampp/mysql/data
  26.  
  27. #bind-address=192.168.1.1
  28. #log-update     = /path-to-dedicated-directory/hostname
  29.  
  30. # Uncomment the following if you are using BDB tables
  31. #set-variable   = bdb_cache_size=4M
  32. #set-variable   = bdb_max_lock=10000
  33.  
  34. skip-innodb
  35. # Uncomment the following if you are using InnoDB tables
  36. #innodb_data_home_dir = /xampp/mysql/
  37. #innodb_data_file_path = ibdata1:10M:autoextend
  38. #innodb_log_group_home_dir = /xampp/mysql/
  39. #innodb_log_arch_dir = /xampp/mysql/
  40. # You can set .._buffer_pool_size up to 50 - 80 %
  41. # of RAM but beware of setting memory usage too high
  42. #set-variable = innodb_buffer_pool_size=16M
  43. #set-variable = innodb_additional_mem_pool_size=2M
  44. # Set .._log_file_size to 25 % of buffer pool size
  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. #set-variable = innodb_lock_wait_timeout=50
  49.  
  50. [mysqldump]
  51. quick
  52. set-variable    = max_allowed_packet=16M
  53.  
  54. [mysql]
  55. no-auto-rehash
  56. # Remove the next comment character if you are not familiar with SQL
  57. #safe-updates
  58.  
  59. [isamchk]
  60. set-variable    = key_buffer=20M
  61. set-variable    = sort_buffer=20M
  62. set-variable    = read_buffer=2M
  63. set-variable    = write_buffer=2M
  64.  
  65. [myisamchk]
  66. set-variable    = key_buffer=20M
  67. set-variable    = sort_buffer=20M
  68. set-variable    = read_buffer=2M
  69. set-variable    = write_buffer=2M
  70.  
  71. [mysqlhotcopy]
  72. interactive-timeout
  73.  
  74. [WinMySQLadmin]
  75. Server=/xampp/mysql/bin/mysqld-nt.exe