API tools faq
paste
Advertisement
Sergey_Gorshkov

Untitled

Sergey_Gorshkov
Apr 19th, 2019
147
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 34.92 KB | None | 0 0
raw download clone embed print report
  1. Variables (--variable-name=value)
  2. and boolean options {FALSE|TRUE} Value (after reading options)
  3. ------------------------------------------------------------ -------------
  4. abort-slave-event-count 0
  5. allow-suspicious-udfs FALSE
  6. archive ON
  7. auto-increment-increment 1
  8. auto-increment-offset 1
  9. autocommit TRUE
  10. automatic-sp-privileges TRUE
  11. avoid-temporal-upgrade FALSE
  12. back-log 80
  13. basedir /usr/
  14. big-tables FALSE
  15. bind-address 127.0.0.1
  16. binlog-cache-size 32768
  17. binlog-checksum CRC32
  18. binlog-direct-non-transactional-updates FALSE
  19. binlog-error-action ABORT_SERVER
  20. binlog-format ROW
  21. binlog-group-commit-sync-delay 0
  22. binlog-group-commit-sync-no-delay-count 0
  23. binlog-gtid-simple-recovery TRUE
  24. binlog-max-flush-queue-time 0
  25. binlog-order-commits TRUE
  26. binlog-row-event-max-size 8192
  27. binlog-row-image FULL
  28. binlog-rows-query-log-events FALSE
  29. binlog-stmt-cache-size 32768
  30. binlog-transaction-dependency-history-size 25000
  31. binlog-transaction-dependency-tracking COMMIT_ORDER
  32. blackhole ON
  33. block-encryption-mode aes-128-ecb
  34. bulk-insert-buffer-size 8388608
  35. character-set-client-handshake TRUE
  36. character-set-filesystem binary
  37. character-set-server latin1
  38. character-sets-dir /usr/share/mysql/charsets/
  39. check-proxy-users FALSE
  40. chroot (No default value)
  41. collation-server latin1_swedish_ci
  42. completion-type NO_CHAIN
  43. concurrent-insert AUTO
  44. connect-timeout 10
  45. console FALSE
  46. daemonize FALSE
  47. datadir /var/lib/mysql/
  48. date-format %Y-%m-%d
  49. datetime-format %Y-%m-%d %H:%i:%s
  50. default-authentication-plugin mysql_native_password
  51. default-password-lifetime 0
  52. default-storage-engine InnoDB
  53. default-time-zone (No default value)
  54. default-tmp-storage-engine InnoDB
  55. default-week-format 0
  56. delay-key-write ON
  57. delayed-insert-limit 100
  58. delayed-insert-timeout 300
  59. delayed-queue-size 1000
  60. des-key-file (No default value)
  61. disable-partition-engine-check TRUE
  62. disabled-storage-engines
  63. disconnect-on-expired-password TRUE
  64. disconnect-slave-event-count 0
  65. div-precision-increment 4
  66. end-markers-in-json FALSE
  67. enforce-gtid-consistency FALSE
  68. eq-range-index-dive-limit 200
  69. event-scheduler OFF
  70. expire-logs-days 0
  71. explicit-defaults-for-timestamp FALSE
  72. external-locking FALSE
  73. federated ON
  74. flush FALSE
  75. flush-time 0
  76. ft-boolean-syntax + -><()~*:""&|
  77. ft-max-word-len 84
  78. ft-min-word-len 4
  79. ft-query-expansion-limit 20
  80. ft-stopword-file (No default value)
  81. gdb FALSE
  82. general-log FALSE
  83. general-log-file /var/lib/mysql/mysql-master.log
  84. group-concat-max-len 1024
  85. gtid-executed-compression-period 1000
  86. gtid-mode OFF
  87. help TRUE
  88. host-cache-size 279
  89. ignore-builtin-innodb FALSE
  90. init-connect
  91. init-file (No default value)
  92. init-slave
  93. initialize FALSE
  94. initialize-insecure FALSE
  95. innodb-adaptive-flushing TRUE
  96. innodb-adaptive-flushing-lwm 10
  97. innodb-adaptive-hash-index TRUE
  98. innodb-adaptive-hash-index-parts 8
  99. innodb-adaptive-max-sleep-delay 150000
  100. innodb-api-bk-commit-interval 5
  101. innodb-api-disable-rowlock FALSE
  102. innodb-api-enable-binlog FALSE
  103. innodb-api-enable-mdl FALSE
  104. innodb-api-trx-level 0
  105. innodb-autoextend-increment 64
  106. innodb-autoinc-lock-mode 1
  107. innodb-buffer-pool-chunk-size 134217728
  108. innodb-buffer-pool-dump-at-shutdown TRUE
  109. innodb-buffer-pool-dump-now FALSE
  110. innodb-buffer-pool-dump-pct 25
  111. innodb-buffer-pool-filename ib_buffer_pool
  112. innodb-buffer-pool-instances 0
  113. innodb-buffer-pool-load-abort FALSE
  114. innodb-buffer-pool-load-at-startup TRUE
  115. innodb-buffer-pool-load-now FALSE
  116. innodb-buffer-pool-size 134217728
  117. innodb-change-buffer-max-size 25
  118. innodb-change-buffering all
  119. innodb-checksum-algorithm crc32
  120. innodb-checksums TRUE
  121. innodb-cmp-per-index-enabled FALSE
  122. innodb-commit-concurrency 0
  123. innodb-compression-failure-threshold-pct 5
  124. innodb-compression-level 6
  125. innodb-compression-pad-pct-max 50
  126. innodb-concurrency-tickets 5000
  127. innodb-data-file-path (No default value)
  128. innodb-data-home-dir (No default value)
  129. innodb-deadlock-detect TRUE
  130. innodb-default-row-format dynamic
  131. innodb-disable-sort-file-cache FALSE
  132. innodb-doublewrite TRUE
  133. innodb-fast-shutdown 1
  134. innodb-file-format Barracuda
  135. innodb-file-format-check TRUE
  136. innodb-file-format-max Antelope
  137. innodb-file-per-table TRUE
  138. innodb-fill-factor 100
  139. innodb-flush-log-at-timeout 1
  140. innodb-flush-log-at-trx-commit 1
  141. innodb-flush-method (No default value)
  142. innodb-flush-neighbors 1
  143. innodb-flush-sync TRUE
  144. innodb-flushing-avg-loops 30
  145. innodb-force-load-corrupted FALSE
  146. innodb-force-recovery 0
  147. innodb-ft-aux-table (No default value)
  148. innodb-ft-cache-size 8000000
  149. innodb-ft-enable-diag-print FALSE
  150. innodb-ft-enable-stopword TRUE
  151. innodb-ft-max-token-size 84
  152. innodb-ft-min-token-size 3
  153. innodb-ft-num-word-optimize 2000
  154. innodb-ft-result-cache-limit 2000000000
  155. innodb-ft-server-stopword-table (No default value)
  156. innodb-ft-sort-pll-degree 2
  157. innodb-ft-total-cache-size 640000000
  158. innodb-ft-user-stopword-table (No default value)
  159. innodb-io-capacity 200
  160. innodb-io-capacity-max 18446744073709551615
  161. innodb-large-prefix TRUE
  162. innodb-lock-wait-timeout 50
  163. innodb-locks-unsafe-for-binlog FALSE
  164. innodb-log-buffer-size 16777216
  165. innodb-log-checksums TRUE
  166. innodb-log-compressed-pages TRUE
  167. innodb-log-file-size 50331648
  168. innodb-log-files-in-group 2
  169. innodb-log-group-home-dir (No default value)
  170. innodb-log-write-ahead-size 8192
  171. innodb-lru-scan-depth 1024
  172. innodb-max-dirty-pages-pct 75
  173. innodb-max-dirty-pages-pct-lwm 0
  174. innodb-max-purge-lag 0
  175. innodb-max-purge-lag-delay 0
  176. innodb-max-undo-log-size 1073741824
  177. innodb-monitor-disable (No default value)
  178. innodb-monitor-enable (No default value)
  179. innodb-monitor-reset (No default value)
  180. innodb-monitor-reset-all (No default value)
  181. innodb-numa-interleave FALSE
  182. innodb-old-blocks-pct 37
  183. innodb-old-blocks-time 1000
  184. innodb-online-alter-log-max-size 134217728
  185. innodb-open-files 0
  186. innodb-optimize-fulltext-only FALSE
  187. innodb-page-cleaners 4
  188. innodb-page-size 16384
  189. innodb-print-all-deadlocks FALSE
  190. innodb-purge-batch-size 300
  191. innodb-purge-rseg-truncate-frequency 128
  192. innodb-purge-threads 4
  193. innodb-random-read-ahead FALSE
  194. innodb-read-ahead-threshold 56
  195. innodb-read-io-threads 4
  196. innodb-read-only FALSE
  197. innodb-replication-delay 0
  198. innodb-rollback-on-timeout FALSE
  199. innodb-rollback-segments 128
  200. innodb-sort-buffer-size 1048576
  201. innodb-spin-wait-delay 6
  202. innodb-stats-auto-recalc TRUE
  203. innodb-stats-include-delete-marked FALSE
  204. innodb-stats-method nulls_equal
  205. innodb-stats-on-metadata FALSE
  206. innodb-stats-persistent TRUE
  207. innodb-stats-persistent-sample-pages 20
  208. innodb-stats-sample-pages 8
  209. innodb-stats-transient-sample-pages 8
  210. innodb-status-file FALSE
  211. innodb-status-output FALSE
  212. innodb-status-output-locks FALSE
  213. innodb-strict-mode TRUE
  214. innodb-support-xa TRUE
  215. innodb-sync-array-size 1
  216. innodb-sync-spin-loops 30
  217. innodb-table-locks TRUE
  218. innodb-temp-data-file-path (No default value)
  219. innodb-thread-concurrency 0
  220. innodb-thread-sleep-delay 10000
  221. innodb-tmpdir (No default value)
  222. innodb-undo-directory (No default value)
  223. innodb-undo-log-truncate FALSE
  224. innodb-undo-logs 128
  225. innodb-undo-tablespaces 0
  226. innodb-use-native-aio TRUE
  227. innodb-write-io-threads 4
  228. interactive-timeout 28800
  229. internal-tmp-disk-storage-engine InnoDB
  230. join-buffer-size 262144
  231. keep-files-on-create FALSE
  232. key-buffer-size 8388608
  233. key-cache-age-threshold 300
  234. key-cache-block-size 1024
  235. key-cache-division-limit 100
  236. keyring-migration-destination (No default value)
  237. keyring-migration-host (No default value)
  238. keyring-migration-port 0
  239. keyring-migration-socket (No default value)
  240. keyring-migration-source (No default value)
  241. keyring-migration-user (No default value)
  242. language /usr/share/mysql/
  243. large-pages FALSE
  244. lc-messages en_US
  245. lc-messages-dir /usr/share/mysql/
  246. lc-time-names en_US
  247. local-infile TRUE
  248. lock-wait-timeout 31536000
  249. log-bin (No default value)
  250. log-bin-index (No default value)
  251. log-bin-trust-function-creators FALSE
  252. log-bin-use-v1-row-events FALSE
  253. log-builtin-as-identified-by-password FALSE
  254. log-error stderr
  255. log-error-verbosity 1
  256. log-isam myisam.log
  257. log-output FILE
  258. log-queries-not-using-indexes FALSE
  259. log-raw FALSE
  260. log-short-format FALSE
  261. log-slave-updates FALSE
  262. log-slow-admin-statements FALSE
  263. log-slow-slave-statements FALSE
  264. log-statements-unsafe-for-binlog TRUE
  265. log-syslog FALSE
  266. log-syslog-facility daemon
  267. log-syslog-include-pid TRUE
  268. log-syslog-tag
  269. log-tc tc.log
  270. log-tc-size 24576
  271. log-throttle-queries-not-using-indexes 0
  272. log-timestamps UTC
  273. log-warnings 0
  274. long-query-time 10
  275. low-priority-updates FALSE
  276. lower-case-table-names 0
  277. master-info-file master.info
  278. master-info-repository FILE
  279. master-retry-count 86400
  280. master-verify-checksum FALSE
  281. max-allowed-packet 4194304
  282. max-binlog-cache-size 18446744073709547520
  283. max-binlog-dump-events 0
  284. max-binlog-size 1073741824
  285. max-binlog-stmt-cache-size 18446744073709547520
  286. max-connect-errors 100
  287. max-connections 151
  288. max-delayed-threads 20
  289. max-digest-length 1024
  290. max-error-count 64
  291. max-execution-time 0
  292. max-heap-table-size 16777216
  293. max-join-size 18446744073709551615
  294. max-length-for-sort-data 1024
  295. max-points-in-geometry 65536
  296. max-prepared-stmt-count 16382
  297. max-relay-log-size 0
  298. max-seeks-for-key 18446744073709551615
  299. max-sort-length 1024
  300. max-sp-recursion-depth 0
  301. max-tmp-tables 32
  302. max-user-connections 0
  303. max-write-lock-count 18446744073709551615
  304. memlock FALSE
  305. metadata-locks-cache-size 1024
  306. metadata-locks-hash-instances 8
  307. min-examined-row-limit 0
  308. multi-range-count 256
  309. myisam-block-size 1024
  310. myisam-data-pointer-size 6
  311. myisam-max-sort-file-size 9223372036853727232
  312. myisam-mmap-size 18446744073709551615
  313. myisam-recover-options OFF
  314. myisam-repair-threads 1
  315. myisam-sort-buffer-size 8388608
  316. myisam-stats-method nulls_unequal
  317. myisam-use-mmap FALSE
  318. mysql-native-password-proxy-users FALSE
  319. net-buffer-length 16384
  320. net-read-timeout 30
  321. net-retry-count 10
  322. net-write-timeout 60
  323. new FALSE
  324. ngram ON
  325. ngram-token-size 2
  326. offline-mode FALSE
  327. old FALSE
  328. old-alter-table FALSE
  329. old-passwords 0
  330. old-style-user-limits FALSE
  331. open-files-limit 5000
  332. optimizer-prune-level 1
  333. optimizer-search-depth 62
  334. optimizer-switch index_merge=on,index_merge_union=on,index_merge_sort_union=on,index_merge_intersection=on,engine_condition_pushdown=on,index_condition_pushdown=on,mrr=on,mrr_cost_based=on,block_nested_loop=on,batched_key_access=off,materialization=on,semijoin=on,loosescan=on,firstmatch=on,duplicateweedout=on,subquery_materialization_cost_based=on,use_index_extensions=on,condition_fanout_filter=on,derived_merge=on
  335. optimizer-trace
  336. optimizer-trace-features greedy_search=on,range_optimizer=on,dynamic_range=on,repeated_subselect=on
  337. optimizer-trace-limit 1
  338. optimizer-trace-max-mem-size 16384
  339. optimizer-trace-offset -1
  340. parser-max-mem-size 18446744073709551615
  341. partition ON
  342. performance-schema TRUE
  343. performance-schema-accounts-size -1
  344. performance-schema-consumer-events-stages-current FALSE
  345. performance-schema-consumer-events-stages-history FALSE
  346. performance-schema-consumer-events-stages-history-long FALSE
  347. performance-schema-consumer-events-statements-current TRUE
  348. performance-schema-consumer-events-statements-history TRUE
  349. performance-schema-consumer-events-statements-history-long FALSE
  350. performance-schema-consumer-events-transactions-current FALSE
  351. performance-schema-consumer-events-transactions-history FALSE
  352. performance-schema-consumer-events-transactions-history-long FALSE
  353. performance-schema-consumer-events-waits-current FALSE
  354. performance-schema-consumer-events-waits-history FALSE
  355. performance-schema-consumer-events-waits-history-long FALSE
  356. performance-schema-consumer-global-instrumentation TRUE
  357. performance-schema-consumer-statements-digest TRUE
  358. performance-schema-consumer-thread-instrumentation TRUE
  359. performance-schema-digests-size -1
  360. performance-schema-events-stages-history-long-size -1
  361. performance-schema-events-stages-history-size -1
  362. performance-schema-events-statements-history-long-size -1
  363. performance-schema-events-statements-history-size -1
  364. performance-schema-events-transactions-history-long-size -1
  365. performance-schema-events-transactions-history-size -1
  366. performance-schema-events-waits-history-long-size -1
  367. performance-schema-events-waits-history-size -1
  368. performance-schema-hosts-size -1
  369. performance-schema-instrument
  370. performance-schema-max-cond-classes 80
  371. performance-schema-max-cond-instances -1
  372. performance-schema-max-digest-length 1024
  373. performance-schema-max-file-classes 80
  374. performance-schema-max-file-handles 32768
  375. performance-schema-max-file-instances -1
  376. performance-schema-max-index-stat -1
  377. performance-schema-max-memory-classes 320
  378. performance-schema-max-metadata-locks -1
  379. performance-schema-max-mutex-classes 210
  380. performance-schema-max-mutex-instances -1
  381. performance-schema-max-prepared-statements-instances -1
  382. performance-schema-max-program-instances -1
  383. performance-schema-max-rwlock-classes 50
  384. performance-schema-max-rwlock-instances -1
  385. performance-schema-max-socket-classes 10
  386. performance-schema-max-socket-instances -1
  387. performance-schema-max-sql-text-length 1024
  388. performance-schema-max-stage-classes 150
  389. performance-schema-max-statement-classes 193
  390. performance-schema-max-statement-stack 10
  391. performance-schema-max-table-handles -1
  392. performance-schema-max-table-instances -1
  393. performance-schema-max-table-lock-stat -1
  394. performance-schema-max-thread-classes 50
  395. performance-schema-max-thread-instances -1
  396. performance-schema-session-connect-attrs-size -1
  397. performance-schema-setup-actors-size -1
  398. performance-schema-setup-objects-size -1
  399. performance-schema-users-size -1
  400. pid-file /var/run/mysqld/mysqld.pid
  401. plugin-dir /usr/lib/mysql/plugin/
  402. port 3306
  403. port-open-timeout 0
  404. preload-buffer-size 32768
  405. profiling-history-size 15
  406. query-alloc-block-size 8192
  407. query-cache-limit 1048576
  408. query-cache-min-res-unit 4096
  409. query-cache-size 1048576
  410. query-cache-type OFF
  411. query-cache-wlock-invalidate FALSE
  412. query-prealloc-size 8192
  413. range-alloc-block-size 4096
  414. range-optimizer-max-mem-size 8388608
  415. read-buffer-size 131072
  416. read-only FALSE
  417. read-rnd-buffer-size 262144
  418. relay-log (No default value)
  419. relay-log-index (No default value)
  420. relay-log-info-file relay-log.info
  421. relay-log-info-repository FILE
  422. relay-log-purge TRUE
  423. relay-log-recovery FALSE
  424. relay-log-space-limit 0
  425. replicate-same-server-id FALSE
  426. report-host (No default value)
  427. report-password (No default value)
  428. report-port 0
  429. report-user (No default value)
  430. require-secure-transport FALSE
  431. rpl-stop-slave-timeout 31536000
  432. safe-user-create FALSE
  433. secure-auth TRUE
  434. secure-file-priv /var/lib/mysql-files/
  435. server-id 0
  436. server-id-bits 32
  437. session-track-gtids OFF
  438. session-track-schema TRUE
  439. session-track-state-change FALSE
  440. session-track-system-variables time_zone,autocommit,character_set_client,character_set_results,character_set_connection
  441. session-track-transaction-info OFF
  442. sha256-password-proxy-users FALSE
  443. show-compatibility-56 FALSE
  444. show-create-table-verbosity FALSE
  445. show-old-temporals FALSE
  446. show-slave-auth-info FALSE
  447. skip-grant-tables FALSE
  448. skip-name-resolve FALSE
  449. skip-networking FALSE
  450. skip-show-database FALSE
  451. skip-slave-start FALSE
  452. slave-allow-batching FALSE
  453. slave-checkpoint-group 512
  454. slave-checkpoint-period 300
  455. slave-compressed-protocol FALSE
  456. slave-exec-mode STRICT
  457. slave-load-tmpdir /tmp
  458. slave-max-allowed-packet 1073741824
  459. slave-net-timeout 60
  460. slave-parallel-type DATABASE
  461. slave-parallel-workers 0
  462. slave-pending-jobs-size-max 16777216
  463. slave-preserve-commit-order FALSE
  464. slave-rows-search-algorithms TABLE_SCAN,INDEX_SCAN
  465. slave-skip-errors (No default value)
  466. slave-sql-verify-checksum TRUE
  467. slave-transaction-retries 10
  468. slave-type-conversions
  469. slow-launch-time 2
  470. slow-query-log FALSE
  471. slow-query-log-file /var/lib/mysql/mysql-master-slow.log
  472. socket /var/run/mysqld/mysqld.sock
  473. sort-buffer-size 262144
  474. sporadic-binlog-dump-fail FALSE
  475. sql-mode ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION
  476. ssl TRUE
  477. ssl-ca (No default value)
  478. ssl-capath (No default value)
  479. ssl-cert (No default value)
  480. ssl-cipher (No default value)
  481. ssl-crl (No default value)
  482. ssl-crlpath (No default value)
  483. ssl-key (No default value)
  484. stored-program-cache 256
  485. super-large-pages FALSE
  486. super-read-only FALSE
  487. symbolic-links FALSE
  488. sync-binlog 1
  489. sync-frm TRUE
  490. sync-master-info 10000
  491. sync-relay-log 10000
  492. sync-relay-log-info 10000
  493. sysdate-is-now FALSE
  494. table-definition-cache 1400
  495. table-open-cache 2000
  496. table-open-cache-instances 16
  497. tc-heuristic-recover OFF
  498. temp-pool TRUE
  499. thread-cache-size 9
  500. thread-handling one-thread-per-connection
  501. thread-stack 262144
  502. time-format %H:%i:%s
  503. tls-version TLSv1,TLSv1.1
  504. tmp-table-size 16777216
  505. tmpdir /tmp
  506. transaction-alloc-block-size 8192
  507. transaction-isolation REPEATABLE-READ
  508. transaction-prealloc-size 4096
  509. transaction-read-only FALSE
  510. transaction-write-set-extraction OFF
  511. updatable-views-with-limit YES
  512. validate-user-plugins TRUE
  513. verbose TRUE
  514. wait-timeout 28800
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
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!