API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Apr 16th, 2014
70
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 18.63 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. back-log 50
  12. basedir /usr
  13. big-tables FALSE
  14. bind-address 127.0.0.1
  15. binlog-cache-size 32768
  16. binlog-direct-non-transactional-updates FALSE
  17. binlog-format STATEMENT
  18. binlog-row-event-max-size 1024
  19. binlog-stmt-cache-size 32768
  20. blackhole ON
  21. bulk-insert-buffer-size 8388608
  22. character-set-client-handshake TRUE
  23. character-set-filesystem binary
  24. character-set-server latin1
  25. character-sets-dir /usr/share/mysql/charsets/
  26. chroot (No default value)
  27. collation-server latin1_swedish_ci
  28. completion-type NO_CHAIN
  29. concurrent-insert AUTO
  30. connect-timeout 10
  31. console FALSE
  32. datadir /var/lib/mysql/
  33. date-format %Y-%m-%d
  34. datetime-format %Y-%m-%d %H:%i:%s
  35. default-storage-engine InnoDB
  36. default-time-zone (No default value)
  37. default-week-format 0
  38. delay-key-write ON
  39. delayed-insert-limit 100
  40. delayed-insert-timeout 300
  41. delayed-queue-size 1000
  42. des-key-file (No default value)
  43. disconnect-slave-event-count 0
  44. div-precision-increment 4
  45. engine-condition-pushdown TRUE
  46. event-scheduler OFF
  47. expire-logs-days 10
  48. external-locking FALSE
  49. federated ON
  50. flush FALSE
  51. flush-time 0
  52. ft-boolean-syntax + -><()~*:""&|
  53. ft-max-word-len 84
  54. ft-min-word-len 4
  55. ft-query-expansion-limit 20
  56. ft-stopword-file (No default value)
  57. gdb FALSE
  58. general-log FALSE
  59. general-log-file /var/lib/mysql/app.log
  60. group-concat-max-len 1024
  61. help TRUE
  62. ignore-builtin-innodb FALSE
  63. init-connect
  64. init-file (No default value)
  65. init-rpl-role MASTER
  66. init-slave
  67. innodb ON
  68. innodb-adaptive-flushing TRUE
  69. innodb-adaptive-hash-index TRUE
  70. innodb-additional-mem-pool-size 8388608
  71. innodb-autoextend-increment 8
  72. innodb-autoinc-lock-mode 1
  73. innodb-buffer-page ON
  74. innodb-buffer-page-lru ON
  75. innodb-buffer-pool-instances 1
  76. innodb-buffer-pool-size 134217728
  77. innodb-buffer-pool-stats ON
  78. innodb-change-buffering all
  79. innodb-checksums TRUE
  80. innodb-cmp ON
  81. innodb-cmp-reset ON
  82. innodb-cmpmem ON
  83. innodb-cmpmem-reset ON
  84. innodb-commit-concurrency 0
  85. innodb-concurrency-tickets 500
  86. innodb-data-file-path (No default value)
  87. innodb-data-home-dir (No default value)
  88. innodb-doublewrite TRUE
  89. innodb-fast-shutdown 1
  90. innodb-file-format Antelope
  91. innodb-file-format-check TRUE
  92. innodb-file-format-max Antelope
  93. innodb-file-io-threads 4
  94. innodb-file-per-table FALSE
  95. innodb-flush-log-at-trx-commit 1
  96. innodb-flush-method (No default value)
  97. innodb-force-load-corrupted FALSE
  98. innodb-force-recovery 0
  99. innodb-io-capacity 200
  100. innodb-large-prefix FALSE
  101. innodb-lock-wait-timeout 50
  102. innodb-lock-waits ON
  103. innodb-locks ON
  104. innodb-locks-unsafe-for-binlog FALSE
  105. innodb-log-buffer-size 8388608
  106. innodb-log-file-size 5242880
  107. innodb-log-files-in-group 2
  108. innodb-log-group-home-dir (No default value)
  109. innodb-max-dirty-pages-pct 75
  110. innodb-max-purge-lag 0
  111. innodb-mirrored-log-groups 1
  112. innodb-old-blocks-pct 37
  113. innodb-old-blocks-time 0
  114. innodb-open-files 300
  115. innodb-print-all-deadlocks FALSE
  116. innodb-purge-batch-size 20
  117. innodb-purge-threads 0
  118. innodb-random-read-ahead FALSE
  119. innodb-read-ahead-threshold 56
  120. innodb-read-io-threads 4
  121. innodb-replication-delay 0
  122. innodb-rollback-on-timeout FALSE
  123. innodb-rollback-segments 128
  124. innodb-spin-wait-delay 6
  125. innodb-stats-method nulls_equal
  126. innodb-stats-on-metadata TRUE
  127. innodb-stats-sample-pages 8
  128. innodb-status-file FALSE
  129. innodb-strict-mode FALSE
  130. innodb-support-xa TRUE
  131. innodb-sync-spin-loops 30
  132. innodb-table-locks TRUE
  133. innodb-thread-concurrency 0
  134. innodb-thread-sleep-delay 10000
  135. innodb-trx ON
  136. innodb-use-native-aio TRUE
  137. innodb-use-sys-malloc TRUE
  138. innodb-write-io-threads 4
  139. interactive-timeout 28800
  140. join-buffer-size 131072
  141. keep-files-on-create FALSE
  142. key-buffer-size 16777216
  143. key-cache-age-threshold 300
  144. key-cache-block-size 1024
  145. key-cache-division-limit 100
  146. language /usr/share/mysql/
  147. large-pages FALSE
  148. lc-messages en_US
  149. lc-messages-dir /usr/share/mysql/
  150. lc-time-names en_US
  151. local-infile TRUE
  152. lock-wait-timeout 31536000
  153. log /var/lib/mysql/app.log
  154. log-bin (No default value)
  155. log-bin-index (No default value)
  156. log-bin-trust-function-creators FALSE
  157. log-error
  158. log-isam myisam.log
  159. log-output FILE
  160. log-queries-not-using-indexes FALSE
  161. log-short-format FALSE
  162. log-slave-updates FALSE
  163. log-slow-admin-statements FALSE
  164. log-slow-queries /var/lib/mysql/pp-slow.log
  165. log-slow-slave-statements FALSE
  166. log-tc tc.log
  167. log-tc-size 24576
  168. log-warnings 1
  169. long-query-time 10
  170. low-priority-updates FALSE
  171. lower-case-table-names 0
  172. master-info-file master.info
  173. master-retry-count 86400
  174. max-allowed-packet 16777216
  175. max-binlog-cache-size 18446744073709547520
  176. max-binlog-dump-events 0
  177. max-binlog-size 104857600
  178. max-binlog-stmt-cache-size 18446744073709547520
  179. max-connect-errors 10
  180. max-connections 151
  181. max-delayed-threads 20
  182. max-error-count 64
  183. max-heap-table-size 16777216
  184. max-join-size 18446744073709551615
  185. max-length-for-sort-data 1024
  186. max-long-data-size 16777216
  187. max-prepared-stmt-count 16382
  188. max-relay-log-size 0
  189. max-seeks-for-key 18446744073709551615
  190. max-sort-length 1024
  191. max-sp-recursion-depth 0
  192. max-tmp-tables 32
  193. max-user-connections 0
  194. max-write-lock-count 18446744073709551615
  195. memlock FALSE
  196. metadata-locks-cache-size 1024
  197. min-examined-row-limit 0
  198. multi-range-count 256
  199. myisam-block-size 1024
  200. myisam-data-pointer-size 6
  201. myisam-max-sort-file-size 9223372036853727232
  202. myisam-mmap-size 18446744073709551615
  203. myisam-recover-options BACKUP
  204. myisam-repair-threads 1
  205. myisam-sort-buffer-size 8388608
  206. myisam-stats-method nulls_unequal
  207. myisam-use-mmap FALSE
  208. net-buffer-length 16384
  209. net-read-timeout 30
  210. net-retry-count 10
  211. net-write-timeout 60
  212. new FALSE
  213. old FALSE
  214. old-alter-table FALSE
  215. old-passwords FALSE
  216. old-style-user-limits FALSE
  217. open-files-limit 1024
  218. optimizer-prune-level 1
  219. optimizer-search-depth 62
  220. optimizer-switch index_merge=on,index_merge_union=on,index_merge_sort_union=on,index_merge_intersection=on,engine_condition_pushdown=on
  221. partition ON
  222. performance-schema FALSE
  223. performance-schema-events-waits-history-long-size 10000
  224. performance-schema-events-waits-history-size 10
  225. performance-schema-max-cond-classes 80
  226. performance-schema-max-cond-instances 1000
  227. performance-schema-max-file-classes 50
  228. performance-schema-max-file-handles 32768
  229. performance-schema-max-file-instances 10000
  230. performance-schema-max-mutex-classes 200
  231. performance-schema-max-mutex-instances 1000000
  232. performance-schema-max-rwlock-classes 30
  233. performance-schema-max-rwlock-instances 1000000
  234. performance-schema-max-table-handles 100000
  235. performance-schema-max-table-instances 50000
  236. performance-schema-max-thread-classes 50
  237. performance-schema-max-thread-instances 1000
  238. pid-file /var/run/mysqld/mysqld.pid
  239. plugin-dir /usr/lib/mysql/plugin/
  240. plugin-load (No default value)
  241. port 3306
  242. port-open-timeout 0
  243. preload-buffer-size 32768
  244. profiling-history-size 15
  245. query-alloc-block-size 8192
  246. query-cache-limit 1048576
  247. query-cache-min-res-unit 4096
  248. query-cache-size 16777216
  249. query-cache-type ON
  250. query-cache-wlock-invalidate FALSE
  251. query-prealloc-size 8192
  252. range-alloc-block-size 4096
  253. read-buffer-size 131072
  254. read-only FALSE
  255. read-rnd-buffer-size 262144
  256. relay-log (No default value)
  257. relay-log-index (No default value)
  258. relay-log-info-file relay-log.info
  259. relay-log-purge TRUE
  260. relay-log-recovery FALSE
  261. relay-log-space-limit 0
  262. replicate-same-server-id FALSE
  263. report-host (No default value)
  264. report-password (No default value)
  265. report-port 0
  266. report-user (No default value)
  267. rpl-recovery-rank 0
  268. safe-user-create FALSE
  269. secure-auth FALSE
  270. secure-file-priv (No default value)
  271. server-id 0
  272. show-slave-auth-info FALSE
  273. skip-grant-tables FALSE
  274. skip-name-resolve FALSE
  275. skip-networking FALSE
  276. skip-show-database FALSE
  277. skip-slave-start FALSE
  278. slave-compressed-protocol FALSE
  279. slave-exec-mode STRICT
  280. slave-load-tmpdir /tmp
  281. slave-max-allowed-packet 1073741824
  282. slave-net-timeout 3600
  283. slave-skip-errors (No default value)
  284. slave-transaction-retries 10
  285. slave-type-conversions
  286. slow-launch-time 2
  287. slow-query-log FALSE
  288. slow-query-log-file /var/lib/mysql/app-slow.log
  289. socket /var/run/mysqld/mysqld.sock
  290. sort-buffer-size 2097152
  291. sporadic-binlog-dump-fail FALSE
  292. sql-mode
  293. ssl FALSE
  294. ssl-ca (No default value)
  295. ssl-capath (No default value)
  296. ssl-cert (No default value)
  297. ssl-cipher (No default value)
  298. ssl-key (No default value)
  299. stored-program-cache 256
  300. super-large-pages FALSE
  301. symbolic-links TRUE
  302. sync-binlog 0
  303. sync-frm TRUE
  304. sync-master-info 0
  305. sync-relay-log 0
  306. sync-relay-log-info 0
  307. sysdate-is-now FALSE
  308. table-cache 400
  309. table-definition-cache 400
  310. table-open-cache 400
  311. tc-heuristic-recover COMMIT
  312. temp-pool TRUE
  313. thread-cache-size 8
  314. thread-concurrency 10
  315. thread-handling one-thread-per-connection
  316. thread-stack 196608
  317. time-format %H:%i:%s
  318. timed-mutexes FALSE
  319. tmp-table-size 16777216
  320. tmpdir /tmp
  321. transaction-alloc-block-size 8192
  322. transaction-isolation REPEATABLE-READ
  323. transaction-prealloc-size 4096
  324. updatable-views-with-limit YES
  325. verbose TRUE
  326. 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!