Advertisement
Guest User

Untitled

a guest
Sep 15th, 2018
308
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.50 KB | None | 0 0
  1. root@***:~# find / -name my.cnf
  2. /usr/local/mariadb10/etc/mysql/my.cnf
  3. /volume1/@appstore/MariaDB10/usr/local/mariadb10/etc/mysql/my.cnf
  4. /volume1/@appstore/MariaDB10/usr/local/mariadb10/mysql-test/plugin/spider/spider/oracle2/my.cnf
  5. /volume1/@appstore/MariaDB10/usr/local/mariadb10/mysql-test/plugin/spider/spider/bg/my.cnf
  6. /volume1/@appstore/MariaDB10/usr/local/mariadb10/mysql-test/plugin/spider/spider/my.cnf
  7. /volume1/@appstore/MariaDB10/usr/local/mariadb10/mysql-test/plugin/spider/spider/oracle/my.cnf
  8. /volume1/@appstore/MariaDB10/usr/local/mariadb10/mysql-test/plugin/spider/spider/handler/my.cnf
  9. /volume1/@appstore/MariaDB10/usr/local/mariadb10/mysql-test/plugin/sphinx/sphinx/my.cnf
  10. /volume1/@appstore/MariaDB10/usr/local/mariadb10/mysql-test/plugin/connect/connect/my.cnf
  11. /volume1/@appstore/MariaDB10/usr/local/mariadb10/mysql-test/plugin/heap/mtr2/my.cnf
  12. /volume1/@appstore/MariaDB10/usr/local/mariadb10/mysql-test/suite/rpl/my.cnf
  13. /volume1/@appstore/MariaDB10/usr/local/mariadb10/mysql-test/suite/federated/my.cnf
  14. /volume1/@appstore/MariaDB10/usr/local/mariadb10/mysql-test/suite/multi_source/my.cnf
  15. /volume1/@appstore/MariaDB10/usr/local/mariadb10/mysql-test/suite/unit/my.cnf
  16. /volume1/@appstore/MariaDB10/usr/local/mariadb10/mysql-test/suite/storage_engine/parts/my.cnf
  17. /volume1/@appstore/MariaDB10/usr/local/mariadb10/mysql-test/suite/storage_engine/trx/my.cnf
  18. /volume1/@appstore/MariaDB10/usr/local/mariadb10/mysql-test/suite/storage_engine/my.cnf
  19.  
  20. root@***:~# cp /volume1/@appstore/MariaDB10/usr/local/mariadb10/etc/mysql/my.cnf /volume1/@appstore/MariaDB10/usr/local/mariadb10/etc/mysql/my.cnf.bk
  21.  
  22. root@***:~# find / -name my.cnf.bk
  23. /volume1/@appstore/MariaDB10/usr/local/mariadb10/etc/mysql/my.cnf.bk
  24.  
  25. root@***:~# sudo vi /volume1/@appstore/MariaDB10/usr/local/mariadb10/etc/mysql/my.cnf
  26.  
  27. [client]
  28. port = 3307
  29. socket = /run/mysqld/mysqld10.sock
  30.  
  31. [mysqld]
  32. skip-name-resolve
  33. bind-address = 0.0.0.0
  34. port = 3307
  35. socket = /run/mysqld/mysqld10.sock
  36. pid-file = /run/mysqld/mysqld10.pid
  37. skip-external-locking
  38. key_buffer_size = 16K
  39. max_allowed_packet = 1M
  40. table_open_cache = 4
  41. read_buffer_size = 256K
  42. read_rnd_buffer_size = 256K
  43. net_buffer_length = 2K
  44. thread_stack = 240K
  45. innodb_data_home_dir = /var/packages/MariaDB10/target/mysql
  46. innodb_data_file_path = ibdata1:10M:autoextend
  47. innodb_log_group_home_dir = /var/packages/MariaDB10/target/mysql
  48. innodb_buffer_pool_size = 16M
  49. innodb_additional_mem_pool_size = 2M
  50. #innodb_log_file_size = 5M
  51. #innodb_log_buffer_size = 8M
  52. #innodb_flush_log_at_trx_commit = 1
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement