我笔记本上开发用的 MariaDB 数据库配置 my.ini

Question

这个文件是我笔记本上的MariaDB数据库的配置文件，基本上是安装时生成的，没做多大改动。

1. # The following options will be passed to all MySQL clients
2. [client]
3. #password        = your_password
4. port                = 3306
5. socket                = /tmp/mysql.sock
7. [mysql]
8. default-character-set=utf8
9. # Here follows entries for some specific programs
11. # The MySQL server
12. [mysqld]
13. default-character-set=utf8
14. basedir=D:\MariaDB
15. # set datadir to the location of your data directory
16. datadir=D:\MariaDB\data
18. port                = 3306
19. socket                = /tmp/mysql.sock
20. skip-locking
21. key_buffer_size = 256M
22. max_allowed_packet = 1M
23. table_open_cache = 256
24. sort_buffer_size = 1M
25. read_buffer_size = 1M
26. read_rnd_buffer_size = 4M
27. myisam_sort_buffer_size = 64M
28. thread_cache_size = 8
29. query_cache_size= 16M
30. # Try number of CPU's*2 for thread_concurrency
31. thread_concurrency = 8
33. # Replication Master Server (default)
34. # binary logging is required for replication
35. log-bin=mysql-bin
37. # binary logging format - mixed recommended
38. binlog_format=mixed
40. server-id        = 1
42. [mysqldump]
43. quick
44. max_allowed_packet = 16M
46. [mysql]
47. no-auto-rehash
48. # Remove the next comment character if you are not familiar with SQL
49. #safe-updates
51. [myisamchk]
52. key_buffer_size = 128M
53. sort_buffer_size = 128M
54. read_buffer = 2M
55. write_buffer = 2M
57. [mysqlhotcopy]
58. interactive-timeout

复制代码