SHARE
TWEET

rds5632-dimitrik-60k.cnf

a guest Jul 19th, 2019 108 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. [mysqld]
  2.  
  3. ## Variable needed by PolarFS, every role in one specified PolarDB cluster must have unique value.
  4. skip-log-bin
  5. port=15000
  6.  
  7. # general
  8. max_connections=4000
  9. table_open_cache=8000
  10. table_open_cache_instances=16
  11. back_log=1500
  12. #default_password_lifetime=0
  13. ssl=0
  14. performance_schema=OFF
  15. max_prepared_stmt_count=512000
  16. skip_log_bin=1
  17. character_set_server=latin1
  18. collation_server=latin1_swedish_ci
  19. transaction_isolation=REPEATABLE-READ
  20.  
  21. # files
  22. innodb_file_per_table
  23. innodb_log_file_size=1024M
  24. innodb_log_files_in_group=3
  25. innodb_open_files=4000
  26.  
  27. # buffers
  28. innodb_buffer_pool_size=32000M
  29. innodb_buffer_pool_instances=16
  30. innodb_log_buffer_size=64M
  31.  
  32. # tune
  33. innodb_doublewrite=0
  34. innodb_thread_concurrency=0
  35. innodb_flush_log_at_trx_commit=1
  36. innodb_max_dirty_pages_pct=90
  37. innodb_max_dirty_pages_pct_lwm=10
  38.  
  39. join_buffer_size=32K
  40. sort_buffer_size=32K
  41. innodb_use_native_aio=1
  42. innodb_stats_persistent=1
  43. innodb_spin_wait_delay=6
  44.  
  45. innodb_max_purge_lag_delay=300000
  46. innodb_max_purge_lag=0
  47. innodb_flush_method=O_DIRECT_NO_FSYNC
  48. innodb_checksum_algorithm=crc32
  49. innodb_io_capacity=4000
  50. innodb_io_capacity_max=20000
  51. innodb_lru_scan_depth=9000
  52. innodb_change_buffering=none
  53. innodb_read_only=0
  54. #innodb_page_cleaners=4
  55. #innodb_undo_log_truncate=off
  56.  
  57. # perf special
  58. innodb_adaptive_flushing=1
  59. innodb_flush_neighbors=0
  60. innodb_read_io_threads=16
  61. innodb_write_io_threads=16
  62. innodb_purge_threads=4
  63. innodb_adaptive_hash_index=0
  64.  
  65. # monitoring
  66. innodb_monitor_enable='%'
  67.  
  68. performance_schema = OFF
  69.  
  70. [mysql]
  71. default-character-set=latin1
  72.  
  73. [mysqlshow]
  74. default-character-set=latin1
  75.  
  76. [mysqlimport]
  77. default-character-set=latin1
  78.  
  79. [mysqlcheck]
  80. default-character-set=latin1
  81.  
  82. [mysql_upgrade]
  83. default-character-set=latin1
  84. tmpdir=/disk12/xin/polardb/bu/mysql-test/var/tmp
  85.  
  86. [mysqld.1]
  87. #!run-master-sh
  88. #log-bin=master-bin
  89. #loose-enable-performance-schema
  90. basedir=/home/panfeng.zhou/RDS_5632
  91. tmpdir=/home/panfeng.zhou/RDS_5632/mysql-test/var/tmp/mysqld.1
  92. character-sets-dir=/home/panfeng.zhou/RDS_5632/sql/share/charsets
  93. lc-messages-dir=/home/panfeng.zhou/RDS_5632/sql/share/
  94. datadir=/home/panfeng.zhou/RDS_5632/mysql-test/var/mysqld.1/data
  95. pid-file=/home/panfeng.zhou/RDS_5632/mysql-test/var/run/mysqld.1.pid
  96. #host=localhost
  97. port=15000
  98. socket=/home/panfeng.zhou/RDS_5632/mysql-test/var/tmp/mysqld.1.sock
  99. #log-error=/home/panfeng.zhou/RDS_5632/mysql-test/var/log/mysqld.1.err
  100. #general_log=1
  101. general_log_file=/home/panfeng.zhou/RDS_5632/mysql-test/var/mysqld.1/mysqld.log
  102. #slow_query_log=1
  103. slow_query_log_file=/home/panfeng.zhou/RDS_5632/mysql-test/var/mysqld.1/mysqld-slow.log
  104. #user=root
  105. #password=
  106. server-id=1
  107. secure-file-priv=/home/panfeng.zhou/RDS_5632/mysql-test/var
  108. ssl-ca=/home/panfeng.zhou/RDS_5632/mysql-test/std_data/cacert.pem
  109. ssl-cert=/home/panfeng.zhou/RDS_5632/mysql-test/std_data/server-cert.pem
  110. ssl-key=/home/panfeng.zhou/RDS_5632/mysql-test/std_data/server-key.pem
  111.  
  112. [mysqlbinlog]
  113. disable-force-if-open
  114. character-sets-dir=/home/panfeng.zhou/RDS_5632/sql/share/charsets
  115.  
  116. [ENV]
  117. MASTER_MYPORT=15000
  118. MASTER_MYSOCK=/home/panfeng.zhou/RDS_5632/mysql-test/var/tmp/mysqld.1.sock
  119.  
  120. [client]
  121. password=
  122. user=root
  123. port=15000
  124. host=localhost
  125. socket=/home/panfeng.zhou/RDS_5632/mysql-test/var/tmp/mysqld.1.sock
  126.  
  127. #[mysqltest]
  128. #ssl-ca=/home/panfeng.zhou/RDS_5632/mysql-test/std_data/cacert.pem
  129. #ssl-cert=/home/panfeng.zhou/RDS_5632/mysql-test/std_data/client-cert.pem
  130. #ssl-key=/home/panfeng.zhou/RDS_5632/mysql-test/std_data/client-key.pem
  131. #skip-ssl=1
  132.  
  133. [client.1]
  134. password=
  135. user=root
  136. port=15000
  137. host=localhost
  138. socket=/home/panfeng.zhou/RDS_5632/mysql-test/var/tmp/mysqld.1.sock
RAW Paste Data
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy. OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!
 
Top