my.cnf 1.5 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869
  1. # Begin /etc/mysql/my.cnf
  2. # The following options will be passed to all MySQL clients
  3. [client]
  4. #password = your_password
  5. port = 3306
  6. socket = /run/mysqld/mysqld.sock
  7. # The MySQL server
  8. [mysqld]
  9. port = 3306
  10. socket = /run/mysqld/mysqld.sock
  11. datadir = /srv/mysql
  12. skip-external-locking
  13. key_buffer_size = 16M
  14. max_allowed_packet = 1M
  15. sort_buffer_size = 512K
  16. net_buffer_length = 16K
  17. myisam_sort_buffer_size = 8M
  18. # Don't listen on a TCP/IP port at all.
  19. # skip-networking
  20. # required unique id between 1 and 2^32 - 1
  21. server-id = 1
  22. # Uncomment the following if you are using BDB tables
  23. #bdb_cache_size = 4M
  24. #bdb_max_lock = 10000
  25. # InnoDB tables are now used by default
  26. innodb_data_home_dir = /srv/mysql
  27. innodb_log_group_home_dir = /srv/mysql
  28. # All the innodb_xxx values below are the default ones:
  29. innodb_data_file_path = ibdata1:12M:autoextend
  30. # You can set .._buffer_pool_size up to 50 - 80 %
  31. # of RAM but beware of setting memory usage too high
  32. innodb_buffer_pool_size = 128M
  33. innodb_log_file_size = 48M
  34. innodb_log_buffer_size = 16M
  35. innodb_flush_log_at_trx_commit = 1
  36. innodb_lock_wait_timeout = 50
  37. [mysqldump]
  38. quick
  39. max_allowed_packet = 16M
  40. [mysql]
  41. no-auto-rehash
  42. # Remove the next comment character if you are not familiar with SQL
  43. #safe-updates
  44. [isamchk]
  45. key_buffer = 20M
  46. sort_buffer_size = 20M
  47. read_buffer = 2M
  48. write_buffer = 2M
  49. [myisamchk]
  50. key_buffer_size = 20M
  51. sort_buffer_size = 20M
  52. read_buffer = 2M
  53. write_buffer = 2M
  54. [mysqlhotcopy]
  55. interactive-timeout
  56. # End /etc/mysql/my.cnf