my.cnf 1.6 KB

12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758596061626364656667686970
  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. # Uncomment the following if you are using InnoDB tables
  26. #innodb_data_home_dir = /srv/mysql
  27. #innodb_data_file_path = ibdata1:10M:autoextend
  28. #innodb_log_group_home_dir = /srv/mysql
  29. # You can set .._buffer_pool_size up to 50 - 80 %
  30. # of RAM but beware of setting memory usage too high
  31. #innodb_buffer_pool_size = 16M
  32. #innodb_additional_mem_pool_size = 2M
  33. # Set .._log_file_size to 25 % of buffer pool size
  34. #innodb_log_file_size = 5M
  35. #innodb_log_buffer_size = 8M
  36. #innodb_flush_log_at_trx_commit = 1
  37. #innodb_lock_wait_timeout = 50
  38. [mysqldump]
  39. quick
  40. max_allowed_packet = 16M
  41. [mysql]
  42. no-auto-rehash
  43. # Remove the next comment character if you are not familiar with SQL
  44. #safe-updates
  45. [isamchk]
  46. key_buffer = 20M
  47. sort_buffer_size = 20M
  48. read_buffer = 2M
  49. write_buffer = 2M
  50. [myisamchk]
  51. key_buffer_size = 20M
  52. sort_buffer_size = 20M
  53. read_buffer = 2M
  54. write_buffer = 2M
  55. [mysqlhotcopy]
  56. interactive-timeout
  57. # End /etc/mysql/my.cnf