API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Sep 20th, 2017
107
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 26.65 KB | None | 0 0
raw download clone embed print report
  1. Edit Edit auto increment incrementDocumentation 1
  2. Edit Edit auto increment offsetDocumentation 1
  3. Edit Edit autocommitDocumentation ON
  4. Edit Edit automatic sp privilegesDocumentation ON
  5. Edit Edit avoid temporal upgrade OFF
  6. Edit Edit back logDocumentation 150
  7. Edit Edit basedirDocumentation /usr/
  8. Edit Edit big tablesDocumentation OFF
  9. Edit Edit bind addressDocumentation *
  10. Edit Edit binlog cache sizeDocumentation <abbr title="32,768">32 KiB</abbr>
  11. Edit Edit binlog checksumDocumentation CRC32
  12. Edit Edit binlog direct non transactional updatesDocumentation OFF
  13. Edit Edit binlog error action IGNORE_ERROR
  14. Edit Edit binlog formatDocumentation STATEMENT
  15. Edit Edit binlog gtid simple recovery OFF
  16. Edit Edit binlog max flush queue timeDocumentation 0
  17. Edit Edit binlog order commitsDocumentation ON
  18. Edit Edit binlog row imageDocumentation FULL
  19. Edit Edit binlog rows query log eventsDocumentation OFF
  20. Edit Edit binlog stmt cache sizeDocumentation <abbr title="32,768">32 KiB</abbr>
  21. Edit Edit binlogging impossible mode IGNORE_ERROR
  22. Edit Edit block encryption modeDocumentation aes-128-ecb
  23. Edit Edit bulk insert buffer sizeDocumentation <abbr title="16,777,216">16 MiB</abbr>
  24. Edit Edit character set clientDocumentation utf8
  25. (Session value ) utf8mb4
  26. Edit Edit character set connectionDocumentation utf8
  27. (Session value ) utf8mb4
  28. Edit Edit character set databaseDocumentation utf8
  29. Edit Edit character set filesystemDocumentation binary
  30. Edit Edit character set resultsDocumentation utf8
  31. (Session value ) utf8mb4
  32. Edit Edit character set serverDocumentation utf8
  33. Edit Edit character set systemDocumentation utf8
  34. Edit Edit character sets dirDocumentation /usr/share/percona-server/charsets/
  35. Edit Edit collation connectionDocumentation utf8_general_ci
  36. (Session value ) utf8mb4_unicode_ci
  37. Edit Edit collation databaseDocumentation utf8_general_ci
  38. Edit Edit collation serverDocumentation utf8_general_ci
  39. Edit Edit completion typeDocumentation NO_CHAIN
  40. Edit Edit concurrent insertDocumentation AUTO
  41. Edit Edit connect timeoutDocumentation 60
  42. Edit Edit core fileDocumentation OFF
  43. Edit Edit csv mode
  44. Edit Edit datadirDocumentation /var/lib/mysql/
  45. Edit Edit date formatDocumentation %Y-%m-%d
  46. Edit Edit datetime formatDocumentation %Y-%m-%d %H:%i:%s
  47. Edit Edit default storage engineDocumentation InnoDB
  48. Edit Edit default tmp storage engineDocumentation InnoDB
  49. Edit Edit default week formatDocumentation 0
  50. Edit Edit delay key writeDocumentation ON
  51. Edit Edit delayed insert limitDocumentation 100
  52. Edit Edit delayed insert timeoutDocumentation 10
  53. Edit Edit delayed queue sizeDocumentation 1,000
  54. Edit Edit disconnect on expired passwordDocumentation ON
  55. Edit Edit div precision incrementDocumentation 4
  56. Edit Edit end markers in jsonDocumentation OFF
  57. Edit Edit enforce gtid consistencyDocumentation OFF
  58. Edit Edit enforce storage engine
  59. Edit Edit eq range index dive limitDocumentation 10
  60. Edit Edit event schedulerDocumentation OFF
  61. Edit Edit expand fast index creation OFF
  62. Edit Edit expire logs daysDocumentation 0
  63. Edit Edit explicit defaults for timestampDocumentation OFF
  64. Edit Edit extra max connections 1
  65. Edit Edit extra port 0
  66. Edit Edit flushDocumentation OFF
  67. Edit Edit flush timeDocumentation 0
  68. Edit Edit foreign key checksDocumentation ON
  69. Edit Edit ft boolean syntaxDocumentation + -><()~*:""&|
  70. Edit Edit ft max word lenDocumentation 84
  71. Edit Edit ft min word lenDocumentation 3
  72. Edit Edit ft query expansion limitDocumentation 20
  73. Edit Edit ft stopword fileDocumentation (built-in)
  74. Edit Edit general logDocumentation OFF
  75. Edit Edit general log fileDocumentation /var/lib/mysql/siteground291.log
  76. Edit Edit group concat max lenDocumentation 1,024
  77. Edit Edit gtid deployment step OFF
  78. Edit Edit gtid executedDocumentation
  79. Edit Edit gtid modeDocumentation OFF
  80. Edit Edit gtid ownedDocumentation
  81. Edit Edit gtid purgedDocumentation
  82. Edit Edit have backup locks YES
  83. Edit Edit have backup safe binlog info YES
  84. Edit Edit have compressDocumentation YES
  85. Edit Edit have cryptDocumentation YES
  86. Edit Edit have dynamic loadingDocumentation YES
  87. Edit Edit have elliptic curve crypto YES
  88. Edit Edit have geometryDocumentation YES
  89. Edit Edit have opensslDocumentation DISABLED
  90. Edit Edit have profilingDocumentation YES
  91. Edit Edit have query cacheDocumentation YES
  92. Edit Edit have rtree keysDocumentation YES
  93. Edit Edit have snapshot cloning YES
  94. Edit Edit have sslDocumentation DISABLED
  95. Edit Edit have statement timeout YES
  96. Edit Edit have symlinkDocumentation YES
  97. Edit Edit have tlsv1 2 YES
  98. Edit Edit host cache sizeDocumentation 628
  99. Edit Edit hostnameDocumentation siteground291.com
  100. Edit Edit ignore builtin innodbDocumentation OFF
  101. Edit Edit ignore db dirsDocumentation
  102. Edit Edit init connectDocumentation
  103. Edit Edit init fileDocumentation
  104. Edit Edit init slaveDocumentation
  105. Edit Edit innodb adaptive flushingDocumentation ON
  106. Edit Edit innodb adaptive flushing lwmDocumentation 10
  107. Edit Edit innodb adaptive hash indexDocumentation ON
  108. Edit Edit innodb adaptive hash index partitions 1
  109. Edit Edit innodb adaptive max sleep delayDocumentation 150,000
  110. Edit Edit innodb additional mem pool sizeDocumentation <abbr title="8,388,608">8 MiB</abbr>
  111. Edit Edit innodb api bk commit intervalDocumentation 5
  112. Edit Edit innodb api disable rowlockDocumentation OFF
  113. Edit Edit innodb api enable binlogDocumentation OFF
  114. Edit Edit innodb api enable mdlDocumentation OFF
  115. Edit Edit innodb api trx levelDocumentation 0
  116. Edit Edit innodb autoextend incrementDocumentation 64
  117. Edit Edit innodb autoinc lock modeDocumentation 0
  118. Edit Edit innodb buffer pool dump at shutdownDocumentation OFF
  119. Edit Edit innodb buffer pool dump nowDocumentation OFF
  120. Edit Edit innodb buffer pool filenameDocumentation ib_buffer_pool
  121. Edit Edit innodb buffer pool instancesDocumentation 8
  122. Edit Edit innodb buffer pool load abortDocumentation OFF
  123. Edit Edit innodb buffer pool load at startupDocumentation OFF
  124. Edit Edit innodb buffer pool load nowDocumentation OFF
  125. Edit Edit innodb buffer pool populate OFF
  126. Edit Edit innodb buffer pool sizeDocumentation <abbr title="268,435,456">256 MiB</abbr>
  127. Edit Edit innodb change buffer max sizeDocumentation 25
  128. Edit Edit innodb change bufferingDocumentation all
  129. Edit Edit innodb checksum algorithmDocumentation innodb
  130. Edit Edit innodb checksumsDocumentation ON
  131. Edit Edit innodb cleaner lsn age factor high_checkpoint
  132. Edit Edit innodb cmp per index enabledDocumentation OFF
  133. Edit Edit innodb commit concurrencyDocumentation 0
  134. Edit Edit innodb compressed columns threshold 96
  135. Edit Edit innodb compressed columns zip level 6
  136. Edit Edit innodb compression failure threshold pctDocumentation 5
  137. Edit Edit innodb compression levelDocumentation 6
  138. Edit Edit innodb compression pad pct maxDocumentation 50
  139. Edit Edit innodb concurrency ticketsDocumentation 5,000
  140. Edit Edit innodb corrupt table action assert
  141. Edit Edit innodb data file pathDocumentation ibdata1:12M:autoextend
  142. Edit Edit innodb data home dirDocumentation
  143. Edit Edit innodb disable sort file cacheDocumentation OFF
  144. Edit Edit innodb doublewriteDocumentation OFF
  145. Edit Edit innodb empty free list algorithm backoff
  146. Edit Edit innodb fake changes OFF
  147. Edit Edit innodb fast shutdownDocumentation 1
  148. Edit Edit innodb file formatDocumentation Antelope
  149. Edit Edit innodb file format checkDocumentation ON
  150. Edit Edit innodb file format maxDocumentation Antelope
  151. Edit Edit innodb file per tableDocumentation ON
  152. Edit Edit innodb flush log at timeoutDocumentation 1
  153. Edit Edit innodb flush log at trx commitDocumentation 2
  154. Edit Edit innodb flush methodDocumentation O_DIRECT
  155. Edit Edit innodb flush neighborsDocumentation 1
  156. Edit Edit innodb flushing avg loopsDocumentation 30
  157. Edit Edit innodb force load corruptedDocumentation OFF
  158. Edit Edit innodb force recoveryDocumentation 0
  159. Edit Edit innodb foreground preflush exponential_backoff
  160. Edit Edit innodb ft aux tableDocumentation
  161. Edit Edit innodb ft cache sizeDocumentation 8,000,000
  162. Edit Edit innodb ft enable diag printDocumentation OFF
  163. Edit Edit innodb ft enable stopwordDocumentation ON
  164. Edit Edit innodb ft max token sizeDocumentation 84
  165. Edit Edit innodb ft min token sizeDocumentation 3
  166. Edit Edit innodb ft num word optimizeDocumentation 2,000
  167. Edit Edit innodb ft result cache limitDocumentation 2,000,000,000
  168. Edit Edit innodb ft server stopword tableDocumentation
  169. Edit Edit innodb ft sort pll degreeDocumentation 2
  170. Edit Edit innodb ft total cache sizeDocumentation 640,000,000
  171. Edit Edit innodb ft user stopword tableDocumentation
  172. Edit Edit innodb io capacityDocumentation 400
  173. Edit Edit innodb io capacity maxDocumentation 2,000
  174. Edit Edit innodb kill idle transaction 0
  175. Edit Edit innodb large prefixDocumentation OFF
  176. Edit Edit innodb lock wait timeoutDocumentation 50
  177. Edit Edit innodb locking fake changes ON
  178. Edit Edit innodb locks unsafe for binlogDocumentation OFF
  179. Edit Edit innodb log arch dir ./
  180. Edit Edit innodb log arch expire sec 0
  181. Edit Edit innodb log archive OFF
  182. Edit Edit innodb log block size 512
  183. Edit Edit innodb log buffer sizeDocumentation <abbr title="8,388,608">8 MiB</abbr>
  184. Edit Edit innodb log checksum algorithm innodb
  185. Edit Edit innodb log compressed pagesDocumentation ON
  186. Edit Edit innodb log file sizeDocumentation <abbr title="134,217,728">128 MiB</abbr>
  187. Edit Edit innodb log files in groupDocumentation 2
  188. Edit Edit innodb log group home dirDocumentation ./
  189. Edit Edit innodb lru scan depthDocumentation 1,024
  190. Edit Edit innodb max bitmap file size 104,857,600
  191. Edit Edit innodb max changed pages 1,000,000
  192. Edit Edit innodb max dirty pages pctDocumentation 40
  193. Edit Edit innodb max dirty pages pct lwmDocumentation 0
  194. Edit Edit innodb max purge lagDocumentation 0
  195. Edit Edit innodb max purge lag delayDocumentation 0
  196. Edit Edit innodb mirrored log groupsDocumentation 1
  197. Edit Edit innodb monitor disableDocumentation
  198. Edit Edit innodb monitor enableDocumentation
  199. Edit Edit innodb monitor resetDocumentation
  200. Edit Edit innodb monitor reset allDocumentation
  201. Edit Edit innodb numa interleave OFF
  202. Edit Edit innodb old blocks pctDocumentation 37
  203. Edit Edit innodb old blocks timeDocumentation 1,000
  204. Edit Edit innodb online alter log max sizeDocumentation 134,217,728
  205. Edit Edit innodb open filesDocumentation 2,048
  206. Edit Edit innodb optimize fulltext onlyDocumentation OFF
  207. Edit Edit innodb page sizeDocumentation 16,384
  208. Edit Edit innodb print all deadlocksDocumentation OFF
  209. Edit Edit innodb purge batch sizeDocumentation 300
  210. Edit Edit innodb purge threadsDocumentation 1
  211. Edit Edit innodb random read aheadDocumentation OFF
  212. Edit Edit innodb read ahead thresholdDocumentation 56
  213. Edit Edit innodb read io threadsDocumentation 4
  214. Edit Edit innodb read onlyDocumentation OFF
  215. Edit Edit innodb replication delayDocumentation 0
  216. Edit Edit innodb rollback on timeoutDocumentation OFF
  217. Edit Edit innodb rollback segmentsDocumentation 128
  218. Edit Edit innodb sched priority cleaner 19
  219. Edit Edit innodb show locks held 10
  220. Edit Edit innodb show verbose locks 0
  221. Edit Edit innodb sort buffer sizeDocumentation 1,048,576
  222. Edit Edit innodb spin wait delayDocumentation 6
  223. Edit Edit innodb stats auto recalcDocumentation ON
  224. Edit Edit innodb stats include delete marked OFF
  225. Edit Edit innodb stats methodDocumentation nulls_equal
  226. Edit Edit innodb stats on metadataDocumentation OFF
  227. Edit Edit innodb stats persistentDocumentation ON
  228. Edit Edit innodb stats persistent sample pagesDocumentation 20
  229. Edit Edit innodb stats sample pagesDocumentation 8
  230. Edit Edit innodb stats transient sample pagesDocumentation 8
  231. Edit Edit innodb status outputDocumentation OFF
  232. Edit Edit innodb status output locksDocumentation OFF
  233. Edit Edit innodb strict modeDocumentation OFF
  234. Edit Edit innodb support xaDocumentation OFF
  235. Edit Edit innodb sync array sizeDocumentation 1
  236. Edit Edit innodb sync spin loopsDocumentation 30
  237. Edit Edit innodb table locksDocumentation ON
  238. Edit Edit innodb thread concurrencyDocumentation 4
  239. Edit Edit innodb thread sleep delayDocumentation 0
  240. Edit Edit innodb tmpdir
  241. Edit Edit innodb track changed pages OFF
  242. Edit Edit innodb undo directoryDocumentation .
  243. Edit Edit innodb undo logsDocumentation 128
  244. Edit Edit innodb undo tablespacesDocumentation 0
  245. Edit Edit innodb use atomic writes OFF
  246. Edit Edit innodb use global flush log at trx commit ON
  247. Edit Edit innodb use native aioDocumentation ON
  248. Edit Edit innodb use sys mallocDocumentation ON
  249. Edit Edit innodb versionDocumentation 5.6.36-82.1
  250. Edit Edit innodb write io threadsDocumentation 4
  251. Edit Edit interactive timeoutDocumentation 20
  252. Edit Edit join buffer sizeDocumentation <abbr title="1,048,576">1 MiB</abbr>
  253. Edit Edit keep files on createDocumentation OFF
  254. Edit Edit key buffer sizeDocumentation <abbr title="536,870,912">512 MiB</abbr>
  255. Edit Edit key cache age thresholdDocumentation 300
  256. Edit Edit key cache block sizeDocumentation <abbr title="1,024">1 KiB</abbr>
  257. Edit Edit key cache division limitDocumentation 100
  258. Edit Edit kill idle transaction 0
  259. Edit Edit large files supportDocumentation ON
  260. Edit Edit large page sizeDocumentation <abbr title="0">0 B</abbr>
  261. Edit Edit large pagesDocumentation OFF
  262. Edit Edit lc messagesDocumentation en_US
  263. Edit Edit lc messages dirDocumentation /usr/share/percona-server/
  264. Edit Edit lc time namesDocumentation en_US
  265. Edit Edit licenseDocumentation GPL
  266. Edit Edit local infileDocumentation ON
  267. Edit Edit lock wait timeoutDocumentation 31,536,000
  268. Edit Edit locked in memoryDocumentation OFF
  269. Edit Edit log binDocumentation OFF
  270. Edit Edit log bin basenameDocumentation
  271. Edit Edit log bin indexDocumentation
  272. Edit Edit log bin trust function creatorsDocumentation OFF
  273. Edit Edit log bin use v1 row eventsDocumentation OFF
  274. Edit Edit log errorDocumentation /var/lib/mysql/mysql.err
  275. Edit Edit log outputDocumentation FILE
  276. Edit Edit log queries not using indexesDocumentation OFF
  277. Edit Edit log slave updatesDocumentation OFF
  278. Edit Edit log slow admin statementsDocumentation OFF
  279. Edit Edit log slow filter
  280. Edit Edit log slow rate limit 1
  281. Edit Edit log slow rate type session
  282. Edit Edit log slow slave statementsDocumentation OFF
  283. Edit Edit log slow sp statements ON
  284. Edit Edit log slow verbosity
  285. Edit Edit log throttle queries not using indexesDocumentation 0
  286. Edit Edit log warningsDocumentation 1
  287. Edit Edit log warnings suppress
  288. Edit Edit long query timeDocumentation 1
  289. Edit Edit low priority updatesDocumentation ON
  290. Edit Edit lower case file systemDocumentation OFF
  291. Edit Edit lower case table namesDocumentation 0
  292. Edit Edit master info repositoryDocumentation FILE
  293. Edit Edit master verify checksumDocumentation OFF
  294. Edit Edit max allowed packetDocumentation 33,554,432
  295. Edit Edit max binlog cache sizeDocumentation <abbr title="18,446,744,073,709,547,520">16 EiB</abbr>
  296. Edit Edit max binlog files 0
  297. Edit Edit max binlog sizeDocumentation <abbr title="1,073,741,824">1 GiB</abbr>
  298. Edit Edit max binlog stmt cache sizeDocumentation <abbr title="18,446,744,073,709,547,520">16 EiB</abbr>
  299. Edit Edit max connect errorsDocumentation 25
  300. Edit Edit max connectionsDocumentation 500
  301. Edit Edit max delayed threadsDocumentation 20
  302. Edit Edit max digest length 1,024
  303. Edit Edit max error countDocumentation 64
  304. Edit Edit max heap table sizeDocumentation <abbr title="16,777,216">16 MiB</abbr>
  305. Edit Edit max insert delayed threadsDocumentation 20
  306. Edit Edit max join sizeDocumentation 18,446,744,073,709,551,616
  307. Edit Edit max length for sort dataDocumentation 1,024
  308. Edit Edit max prepared stmt countDocumentation 16,382
  309. Edit Edit max relay log sizeDocumentation <abbr title="0">0 B</abbr>
  310. Edit Edit max seeks for keyDocumentation 18,446,744,073,709,551,616
  311. Edit Edit max slowlog files 0
  312. Edit Edit max slowlog size 0
  313. Edit Edit max sort lengthDocumentation 1,024
  314. Edit Edit max sp recursion depthDocumentation 0
  315. Edit Edit max statement time 0
  316. Edit Edit max tmp tablesDocumentation 10
  317. Edit Edit max user connectionsDocumentation 0
  318. Edit Edit max write lock countDocumentation 10
  319. Edit Edit metadata locks cache sizeDocumentation 1,024
  320. Edit Edit metadata locks hash instancesDocumentation 8
  321. Edit Edit min examined row limitDocumentation 0
  322. Edit Edit multi range countDocumentation 256
  323. Edit Edit myisam data pointer sizeDocumentation <abbr title="6">6 B</abbr>
  324. Edit Edit myisam max sort file sizeDocumentation <abbr title="9,223,372,036,853,727,232">8 EiB</abbr>
  325. Edit Edit myisam mmap sizeDocumentation <abbr title="18,446,744,073,709,551,616">16 EiB</abbr>
  326. Edit Edit myisam recover optionsDocumentation OFF
  327. Edit Edit myisam repair threadsDocumentation 1
  328. Edit Edit myisam sort buffer sizeDocumentation <abbr title="1,048,576">1 MiB</abbr>
  329. Edit Edit myisam stats methodDocumentation nulls_unequal
  330. Edit Edit myisam use mmapDocumentation OFF
  331. Edit Edit net buffer lengthDocumentation 16,384
  332. Edit Edit net read timeoutDocumentation 30
  333. Edit Edit net retry countDocumentation 10
  334. Edit Edit net write timeoutDocumentation 60
  335. Edit Edit newDocumentation OFF
  336. Edit Edit oldDocumentation OFF
  337. Edit Edit old alter tableDocumentation OFF
  338. Edit Edit old passwordsDocumentation 0
  339. Edit Edit open files limitDocumentation 65,536
  340. Edit Edit optimizer prune levelDocumentation 1
  341. Edit Edit optimizer search depthDocumentation 62
  342. Edit Edit optimizer switchDocumentation 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,subquery_materialization_cost_based=on,use_index_extensions=on
  343. Edit Edit optimizer traceDocumentation enabled=off,one_line=off
  344. Edit Edit optimizer trace featuresDocumentation greedy_search=on,range_optimizer=on,dynamic_range=on,repeated_subselect=on
  345. Edit Edit optimizer trace limitDocumentation 1
  346. Edit Edit optimizer trace max mem sizeDocumentation 16,384
  347. Edit Edit optimizer trace offsetDocumentation -1
  348. Edit Edit performance schemaDocumentation ON
  349. Edit Edit performance schema accounts sizeDocumentation 100
  350. Edit Edit performance schema digests sizeDocumentation 10,000
  351. Edit Edit performance schema events stages history long sizeDocumentation 10,000
  352. Edit Edit performance schema events stages history sizeDocumentation 10
  353. Edit Edit performance schema events statements history long sizeDocumentation 10,000
  354. Edit Edit performance schema events statements history sizeDocumentation 10
  355. Edit Edit performance schema events waits history long sizeDocumentation 10,000
  356. Edit Edit performance schema events waits history sizeDocumentation 10
  357. Edit Edit performance schema hosts sizeDocumentation 100
  358. Edit Edit performance schema max cond classesDocumentation 80
  359. Edit Edit performance schema max cond instancesDocumentation 4,948
  360. Edit Edit performance schema max digest length 1,024
  361. Edit Edit performance schema max file classesDocumentation 50
  362. Edit Edit performance schema max file handlesDocumentation 32,768
  363. Edit Edit performance schema max file instancesDocumentation 100,825
  364. Edit Edit performance schema max mutex classesDocumentation 200
  365. Edit Edit performance schema max mutex instancesDocumentation 19,240
  366. Edit Edit performance schema max rwlock classesDocumentation 40
  367. Edit Edit performance schema max rwlock instancesDocumentation 9,944
  368. Edit Edit performance schema max socket classesDocumentation 10
  369. Edit Edit performance schema max socket instancesDocumentation 1,020
  370. Edit Edit performance schema max stage classesDocumentation 150
  371. Edit Edit performance schema max statement classesDocumentation 181
  372. Edit Edit performance schema max table handlesDocumentation 4,096
  373. Edit Edit performance schema max table instancesDocumentation 12,500
  374. Edit Edit performance schema max thread classesDocumentation 50
  375. Edit Edit performance schema max thread instancesDocumentation 1,100
  376. Edit Edit performance schema session connect attrs sizeDocumentation 512
  377. Edit Edit performance schema setup actors sizeDocumentation 100
  378. Edit Edit performance schema setup objects sizeDocumentation 100
  379. Edit Edit performance schema users sizeDocumentation 100
  380. Edit Edit pid fileDocumentation /var/lib/mysql/siteground291.com.pid
  381. Edit Edit plugin dirDocumentation /usr/lib64/mysql/plugin/
  382. Edit Edit portDocumentation 3,306
  383. Edit Edit preload buffer sizeDocumentation <abbr title="32,768">32 KiB</abbr>
  384. Edit Edit profilingDocumentation OFF
  385. Edit Edit profiling history sizeDocumentation 15
  386. Edit Edit protocol versionDocumentation 10
  387. Edit Edit proxy protocol networks
  388. Edit Edit query alloc block sizeDocumentation <abbr title="8,192">8 KiB</abbr>
  389. Edit Edit query cache limitDocumentation <abbr title="33,554,432">32 MiB</abbr>
  390. Edit Edit query cache min res unitDocumentation 4,096
  391. Edit Edit query cache sizeDocumentation <abbr title="536,870,912">512 MiB</abbr>
  392. Edit Edit query cache strip comments OFF
  393. Edit Edit query cache typeDocumentation ON
  394. Edit Edit query cache wlock invalidateDocumentation OFF
  395. Edit Edit query prealloc sizeDocumentation <abbr title="8,192">8 KiB</abbr>
  396. Edit Edit range alloc block sizeDocumentation <abbr title="4,096">4 KiB</abbr>
  397. Edit Edit read buffer sizeDocumentation <abbr title="1,048,576">1 MiB</abbr>
  398. Edit Edit read onlyDocumentation OFF
  399. Edit Edit read rnd buffer sizeDocumentation <abbr title="2,097,152">2 MiB</abbr>
  400. Edit Edit relay logDocumentation
  401. Edit Edit relay log basenameDocumentation
  402. Edit Edit relay log indexDocumentation
  403. Edit Edit relay log info fileDocumentation relay-log.info
  404. Edit Edit relay log info repositoryDocumentation FILE
  405. Edit Edit relay log purgeDocumentation ON
  406. Edit Edit relay log recoveryDocumentation OFF
  407. Edit Edit relay log space limitDocumentation 0
  408. Edit Edit report hostDocumentation
  409. Edit Edit report passwordDocumentation
  410. Edit Edit report portDocumentation 3,306
  411. Edit Edit report userDocumentation
  412. Edit Edit rpl stop slave timeoutDocumentation 31,536,000
  413. Edit Edit secure authDocumentation ON
  414. Edit Edit secure file privDocumentation /var/lib/mysql-files/
  415. Edit Edit server idDocumentation 0
  416. Edit Edit server id bitsDocumentation 32
  417. Edit Edit server uuidDocumentation 1beb9cba-dacd-11e5-ae89-00163e9b35af
  418. Edit Edit sha256 password private key path private_key.pem
  419. Edit Edit sha256 password public key path public_key.pem
  420. Edit Edit show old temporals OFF
  421. Edit Edit simplified binlog gtid recovery OFF
  422. Edit Edit skip external lockingDocumentation ON
  423. Edit Edit skip name resolveDocumentation OFF
  424. Edit Edit skip networkingDocumentation OFF
  425. Edit Edit skip show databaseDocumentation OFF
  426. Edit Edit slave allow batchingDocumentation OFF
  427. Edit Edit slave checkpoint groupDocumentation 512
  428. Edit Edit slave checkpoint periodDocumentation 300
  429. Edit Edit slave compressed protocolDocumentation OFF
  430. Edit Edit slave exec modeDocumentation STRICT
  431. Edit Edit slave load tmpdirDocumentation /tmp
  432. Edit Edit slave max allowed packetDocumentation 1,073,741,824
  433. Edit Edit slave net timeoutDocumentation 3,600
  434. Edit Edit slave parallel workersDocumentation 0
  435. Edit Edit slave pending jobs size maxDocumentation 16,777,216
  436. Edit Edit slave rows search algorithmsDocumentation TABLE_SCAN,INDEX_SCAN
  437. Edit Edit slave skip errorsDocumentation OFF
  438. Edit Edit slave sql verify checksumDocumentation ON
  439. Edit Edit slave transaction retriesDocumentation 10
  440. Edit Edit slave type conversionsDocumentation
  441. Edit Edit slow launch timeDocumentation 2
  442. Edit Edit slow query logDocumentation ON
  443. Edit Edit slow query log always write time 10
  444. Edit Edit slow query log fileDocumentation /var/lib/mysql/mysql-slow.log
  445. Edit Edit slow query log timestamp always OFF
  446. Edit Edit slow query log timestamp precision second
  447. Edit Edit slow query log use global control
  448. Edit Edit socketDocumentation /chroot/tmp/mysql.sock
  449. Edit Edit sort buffer sizeDocumentation <abbr title="1,048,576">1 MiB</abbr>
  450. Edit Edit sql auto is nullDocumentation OFF
  451. Edit Edit sql big selectsDocumentation ON
  452. Edit Edit sql buffer resultDocumentation OFF
  453. Edit Edit sql log binDocumentation ON
  454. Edit Edit sql log offDocumentation OFF
  455. Edit Edit sql modeDocumentation NO_ENGINE_SUBSTITUTION
  456. Edit Edit sql notesDocumentation ON
  457. Edit Edit sql quote show createDocumentation ON
  458. Edit Edit sql safe updatesDocumentation OFF
  459. Edit Edit sql select limitDocumentation 18,446,744,073,709,551,616
  460. Edit Edit sql slave skip counterDocumentation 0
  461. Edit Edit sql warningsDocumentation OFF
  462. Edit Edit ssl caDocumentation
  463. Edit Edit ssl capathDocumentation
  464. Edit Edit ssl certDocumentation
  465. Edit Edit ssl cipherDocumentation
  466. Edit Edit ssl crlDocumentation
  467. Edit Edit ssl crlpathDocumentation
  468. Edit Edit ssl keyDocumentation
  469. Edit Edit storage engineDocumentation InnoDB
  470. Edit Edit stored program cacheDocumentation 256
  471. Edit Edit super read only OFF
  472. Edit Edit sync binlogDocumentation 0
  473. Edit Edit sync frmDocumentation ON
  474. Edit Edit sync master infoDocumentation 10,000
  475. Edit Edit sync relay logDocumentation 10,000
  476. Edit Edit sync relay log infoDocumentation 10,000
  477. Edit Edit system time zoneDocumentation CDT
  478. Edit Edit table definition cacheDocumentation 1,424
  479. Edit Edit table open cacheDocumentation 2,048
  480. Edit Edit table open cache instancesDocumentation 1
  481. Edit Edit thread cache sizeDocumentation 192
  482. Edit Edit thread concurrencyDocumentation 4
  483. Edit Edit thread handlingDocumentation one-thread-per-connection
  484. Edit Edit thread pool high prio mode transactions
  485. Edit Edit thread pool high prio tickets 4,294,967,295
  486. Edit Edit thread pool idle timeout 60
  487. Edit Edit thread pool max threads 100,000
  488. Edit Edit thread pool oversubscribe 3
  489. Edit Edit thread pool size 40
  490. Edit Edit thread pool stall limit 500
  491. Edit Edit thread stackDocumentation 262,144
  492. Edit Edit thread statistics OFF
  493. Edit Edit time formatDocumentation %H:%i:%s
  494. Edit Edit time zoneDocumentation SYSTEM
  495. Edit Edit timed mutexesDocumentation OFF
  496. Edit Edit tls version TLSv1.1,TLSv1.2
  497. Edit Edit tmp table sizeDocumentation <abbr title="268,435,456">256 MiB</abbr>
  498. Edit Edit tmpdirDocumentation /tmp
  499. Edit Edit transaction alloc block sizeDocumentation <abbr title="8,192">8 KiB</abbr>
  500. Edit Edit transaction prealloc sizeDocumentation <abbr title="4,096">4 KiB</abbr>
  501. Edit Edit tx isolationDocumentation REPEATABLE-READ
  502. Edit Edit tx read onlyDocumentation OFF
  503. Edit Edit unique checksDocumentation ON
  504. Edit Edit updatable views with limitDocumentation YES
  505. Edit Edit userstat ON
  506. Edit Edit versionDocumentation 5.6.36-82.1-log
  507. Edit Edit version commentDocumentation Percona Server (GPL), Release 82.1, Revision 1a00d79
  508. Edit Edit version compile machineDocumentation x86_64
  509. Edit Edit version compile osDocumentation Linux
  510. Edit Edit wait timeoutDocumentation 6
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!