Advertisement
Guest User

variables

a guest
Dec 21st, 2018
80
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 17.33 KB | None | 0 0
  1. ARIA_BLOCK_SIZE 8192
  2. ARIA_CHECKPOINT_INTERVAL 30
  3. ARIA_CHECKPOINT_LOG_ACTIVITY 1048576
  4. ARIA_ENCRYPT_TABLES OFF
  5. ARIA_FORCE_START_AFTER_RECOVERY_FAILURES 0
  6. ARIA_GROUP_COMMIT none
  7. ARIA_GROUP_COMMIT_INTERVAL 0
  8. ARIA_LOG_FILE_SIZE 1073741824
  9. ARIA_LOG_PURGE_TYPE immediate
  10. ARIA_MAX_SORT_FILE_SIZE 9223372036853727232
  11. ARIA_PAGECACHE_AGE_THRESHOLD 300
  12. ARIA_PAGECACHE_BUFFER_SIZE 134217728
  13. ARIA_PAGECACHE_DIVISION_LIMIT 100
  14. ARIA_PAGECACHE_FILE_HASH_SIZE 512
  15. ARIA_PAGE_CHECKSUM ON
  16. ARIA_RECOVER NORMAL
  17. ARIA_REPAIR_THREADS 1
  18. ARIA_SORT_BUFFER_SIZE 268434432
  19. ARIA_STATS_METHOD nulls_unequal
  20. ARIA_SYNC_LOG_DIR NEWFILE
  21. ARIA_USED_FOR_TEMP_TABLES ON
  22. AUTOCOMMIT ON
  23. AUTOMATIC_SP_PRIVILEGES ON
  24. AUTO_INCREMENT_INCREMENT 1
  25. AUTO_INCREMENT_OFFSET 1
  26. BACK_LOG 70
  27. BASEDIR /usr
  28. BIG_TABLES OFF
  29. BINLOG_ANNOTATE_ROW_EVENTS OFF
  30. BINLOG_CACHE_SIZE 32768
  31. BINLOG_CHECKSUM NONE
  32. BINLOG_COMMIT_WAIT_COUNT 0
  33. BINLOG_COMMIT_WAIT_USEC 100000
  34. BINLOG_DIRECT_NON_TRANSACTIONAL_UPDATES OFF
  35. BINLOG_FORMAT STATEMENT
  36. BINLOG_OPTIMIZE_THREAD_SCHEDULING ON
  37. BINLOG_ROW_IMAGE FULL
  38. BINLOG_STMT_CACHE_SIZE 32768
  39. BULK_INSERT_BUFFER_SIZE 16777216
  40. CHARACTER_SETS_DIR /usr/share/mysql/charsets/
  41. CHARACTER_SET_CLIENT latin1
  42. CHARACTER_SET_CONNECTION latin1
  43. CHARACTER_SET_DATABASE latin1
  44. CHARACTER_SET_FILESYSTEM binary
  45. CHARACTER_SET_RESULTS latin1
  46. CHARACTER_SET_SERVER latin1
  47. CHARACTER_SET_SYSTEM utf8
  48. COLLATION_CONNECTION latin1_swedish_ci
  49. COLLATION_DATABASE latin1_swedish_ci
  50. COLLATION_SERVER latin1_swedish_ci
  51. COMPLETION_TYPE NO_CHAIN
  52. CONCURRENT_INSERT ALWAYS
  53. CONNECT_TIMEOUT 5
  54. DATADIR /var/lib/mysql/
  55. DATETIME_FORMAT %Y-%m-%d %H:%i:%s
  56. DATE_FORMAT %Y-%m-%d
  57. DEADLOCK_SEARCH_DEPTH_LONG 15
  58. DEADLOCK_SEARCH_DEPTH_SHORT 4
  59. DEADLOCK_TIMEOUT_LONG 50000000
  60. DEADLOCK_TIMEOUT_SHORT 10000
  61. DEBUG_NO_THREAD_ALARM OFF
  62. DEFAULT_REGEX_FLAGS
  63. DEFAULT_STORAGE_ENGINE InnoDB
  64. DEFAULT_TMP_STORAGE_ENGINE
  65. DEFAULT_WEEK_FORMAT 0
  66. DELAYED_INSERT_LIMIT 100
  67. DELAYED_INSERT_TIMEOUT 300
  68. DELAYED_QUEUE_SIZE 1000
  69. DELAY_KEY_WRITE ON
  70. DIV_PRECISION_INCREMENT 4
  71. ENCRYPT_BINLOG OFF
  72. ENCRYPT_TMP_DISK_TABLES OFF
  73. ENCRYPT_TMP_FILES OFF
  74. ENFORCE_STORAGE_ENGINE
  75. EVENT_SCHEDULER OFF
  76. EXPENSIVE_SUBQUERY_LIMIT 100
  77. EXPIRE_LOGS_DAYS 0
  78. EXPLICIT_DEFAULTS_FOR_TIMESTAMP OFF
  79. EXTRA_MAX_CONNECTIONS 1
  80. EXTRA_PORT 0
  81. FLUSH OFF
  82. FLUSH_TIME 0
  83. FOREIGN_KEY_CHECKS ON
  84. FT_BOOLEAN_SYNTAX + -><()~*:""&|
  85. FT_MAX_WORD_LEN 84
  86. FT_MIN_WORD_LEN 4
  87. FT_QUERY_EXPANSION_LIMIT 20
  88. FT_STOPWORD_FILE (built-in)
  89. GENERAL_LOG OFF
  90. GENERAL_LOG_FILE localhost.log
  91. GROUP_CONCAT_MAX_LEN 1024
  92. GTID_BINLOG_POS
  93. GTID_BINLOG_STATE
  94. GTID_CURRENT_POS
  95. GTID_DOMAIN_ID 0
  96. GTID_IGNORE_DUPLICATES OFF
  97. GTID_SLAVE_POS
  98. GTID_STRICT_MODE OFF
  99. HAVE_COMPRESS YES
  100. HAVE_CRYPT YES
  101. HAVE_DYNAMIC_LOADING YES
  102. HAVE_GEOMETRY YES
  103. HAVE_OPENSSL YES
  104. HAVE_PROFILING YES
  105. HAVE_QUERY_CACHE YES
  106. HAVE_RTREE_KEYS YES
  107. HAVE_SSL DISABLED
  108. HAVE_SYMLINK YES
  109. HISTOGRAM_SIZE 0
  110. HISTOGRAM_TYPE SINGLE_PREC_HB
  111. HOSTNAME localhost
  112. HOST_CACHE_SIZE 228
  113. IGNORE_BUILTIN_INNODB OFF
  114. IGNORE_DB_DIRS
  115. INIT_CONNECT
  116. INIT_FILE
  117. INIT_SLAVE
  118. INNODB_ADAPTIVE_FLUSHING ON
  119. INNODB_ADAPTIVE_FLUSHING_LWM 10.000000
  120. INNODB_ADAPTIVE_HASH_INDEX ON
  121. INNODB_ADAPTIVE_HASH_INDEX_PARTITIONS 1
  122. INNODB_ADAPTIVE_MAX_SLEEP_DELAY 150000
  123. INNODB_ADDITIONAL_MEM_POOL_SIZE 8388608
  124. INNODB_API_BK_COMMIT_INTERVAL 5
  125. INNODB_API_DISABLE_ROWLOCK OFF
  126. INNODB_API_ENABLE_BINLOG OFF
  127. INNODB_API_ENABLE_MDL OFF
  128. INNODB_API_TRX_LEVEL 0
  129. INNODB_AUTOEXTEND_INCREMENT 64
  130. INNODB_AUTOINC_LOCK_MODE 1
  131. INNODB_BACKGROUND_SCRUB_DATA_CHECK_INTERVAL 3600
  132. INNODB_BACKGROUND_SCRUB_DATA_COMPRESSED OFF
  133. INNODB_BACKGROUND_SCRUB_DATA_INTERVAL 604800
  134. INNODB_BACKGROUND_SCRUB_DATA_UNCOMPRESSED OFF
  135. INNODB_BUFFER_POOL_DUMP_AT_SHUTDOWN OFF
  136. INNODB_BUFFER_POOL_DUMP_NOW OFF
  137. INNODB_BUFFER_POOL_DUMP_PCT 100
  138. INNODB_BUFFER_POOL_FILENAME ib_buffer_pool
  139. INNODB_BUFFER_POOL_INSTANCES 6
  140. INNODB_BUFFER_POOL_LOAD_ABORT OFF
  141. INNODB_BUFFER_POOL_LOAD_AT_STARTUP OFF
  142. INNODB_BUFFER_POOL_LOAD_NOW OFF
  143. INNODB_BUFFER_POOL_POPULATE OFF
  144. INNODB_BUFFER_POOL_SIZE 6442450944
  145. INNODB_BUF_DUMP_STATUS_FREQUENCY 0
  146. INNODB_CHANGE_BUFFERING all
  147. INNODB_CHANGE_BUFFER_MAX_SIZE 25
  148. INNODB_CHECKSUMS ON
  149. INNODB_CHECKSUM_ALGORITHM INNODB
  150. INNODB_CLEANER_LSN_AGE_FACTOR HIGH_CHECKPOINT
  151. INNODB_CMP_PER_INDEX_ENABLED OFF
  152. INNODB_COMMIT_CONCURRENCY 0
  153. INNODB_COMPRESSION_ALGORITHM zlib
  154. INNODB_COMPRESSION_FAILURE_THRESHOLD_PCT 5
  155. INNODB_COMPRESSION_LEVEL 6
  156. INNODB_COMPRESSION_PAD_PCT_MAX 50
  157. INNODB_CONCURRENCY_TICKETS 5000
  158. INNODB_CORRUPT_TABLE_ACTION assert
  159. INNODB_DATA_FILE_PATH ibdata1:12M:autoextend
  160. INNODB_DATA_HOME_DIR
  161. INNODB_DEFAULT_ENCRYPTION_KEY_ID 1
  162. INNODB_DEFAULT_ROW_FORMAT compact
  163. INNODB_DEFRAGMENT OFF
  164. INNODB_DEFRAGMENT_FILL_FACTOR 0.900000
  165. INNODB_DEFRAGMENT_FILL_FACTOR_N_RECS 20
  166. INNODB_DEFRAGMENT_FREQUENCY 40
  167. INNODB_DEFRAGMENT_N_PAGES 7
  168. INNODB_DEFRAGMENT_STATS_ACCURACY 0
  169. INNODB_DISABLE_SORT_FILE_CACHE OFF
  170. INNODB_DISALLOW_WRITES OFF
  171. INNODB_DOUBLEWRITE ON
  172. INNODB_EMPTY_FREE_LIST_ALGORITHM BACKOFF
  173. INNODB_ENCRYPTION_ROTATE_KEY_AGE 1
  174. INNODB_ENCRYPTION_ROTATION_IOPS 100
  175. INNODB_ENCRYPTION_THREADS 0
  176. INNODB_ENCRYPT_LOG OFF
  177. INNODB_ENCRYPT_TABLES OFF
  178. INNODB_FAKE_CHANGES OFF
  179. INNODB_FAST_SHUTDOWN 1
  180. INNODB_FATAL_SEMAPHORE_WAIT_THRESHOLD 600
  181. INNODB_FILE_FORMAT Antelope
  182. INNODB_FILE_FORMAT_CHECK ON
  183. INNODB_FILE_FORMAT_MAX Antelope
  184. INNODB_FILE_PER_TABLE ON
  185. INNODB_FLUSHING_AVG_LOOPS 30
  186. INNODB_FLUSH_LOG_AT_TIMEOUT 1
  187. INNODB_FLUSH_LOG_AT_TRX_COMMIT 1
  188. INNODB_FLUSH_METHOD O_DIRECT
  189. INNODB_FLUSH_NEIGHBORS 1
  190. INNODB_FORCE_LOAD_CORRUPTED OFF
  191. INNODB_FORCE_PRIMARY_KEY OFF
  192. INNODB_FORCE_RECOVERY 0
  193. INNODB_FOREGROUND_PREFLUSH EXPONENTIAL_BACKOFF
  194. INNODB_FT_AUX_TABLE
  195. INNODB_FT_CACHE_SIZE 8000000
  196. INNODB_FT_ENABLE_DIAG_PRINT OFF
  197. INNODB_FT_ENABLE_STOPWORD ON
  198. INNODB_FT_MAX_TOKEN_SIZE 84
  199. INNODB_FT_MIN_TOKEN_SIZE 3
  200. INNODB_FT_NUM_WORD_OPTIMIZE 2000
  201. INNODB_FT_RESULT_CACHE_LIMIT 2000000000
  202. INNODB_FT_SERVER_STOPWORD_TABLE
  203. INNODB_FT_SORT_PLL_DEGREE 2
  204. INNODB_FT_TOTAL_CACHE_SIZE 640000000
  205. INNODB_FT_USER_STOPWORD_TABLE
  206. INNODB_IDLE_FLUSH_PCT 100
  207. INNODB_IMMEDIATE_SCRUB_DATA_UNCOMPRESSED OFF
  208. INNODB_INSTRUMENT_SEMAPHORES OFF
  209. INNODB_IO_CAPACITY 400
  210. INNODB_IO_CAPACITY_MAX 2000
  211. INNODB_KILL_IDLE_TRANSACTION 0
  212. INNODB_LARGE_PREFIX OFF
  213. INNODB_LOCKING_FAKE_CHANGES ON
  214. INNODB_LOCKS_UNSAFE_FOR_BINLOG OFF
  215. INNODB_LOCK_SCHEDULE_ALGORITHM fcfs
  216. INNODB_LOCK_WAIT_TIMEOUT 50
  217. INNODB_LOG_ARCHIVE OFF
  218. INNODB_LOG_ARCH_DIR ./
  219. INNODB_LOG_ARCH_EXPIRE_SEC 0
  220. INNODB_LOG_BLOCK_SIZE 512
  221. INNODB_LOG_BUFFER_SIZE 8388608
  222. INNODB_LOG_CHECKSUM_ALGORITHM INNODB
  223. INNODB_LOG_COMPRESSED_PAGES ON
  224. INNODB_LOG_FILES_IN_GROUP 2
  225. INNODB_LOG_FILE_SIZE 50331648
  226. INNODB_LOG_GROUP_HOME_DIR ./
  227. INNODB_LRU_SCAN_DEPTH 1024
  228. INNODB_MAX_BITMAP_FILE_SIZE 104857600
  229. INNODB_MAX_CHANGED_PAGES 1000000
  230. INNODB_MAX_DIRTY_PAGES_PCT 75.000000
  231. INNODB_MAX_DIRTY_PAGES_PCT_LWM 0.001000
  232. INNODB_MAX_PURGE_LAG 0
  233. INNODB_MAX_PURGE_LAG_DELAY 0
  234. INNODB_MIRRORED_LOG_GROUPS 1
  235. INNODB_MONITOR_DISABLE
  236. INNODB_MONITOR_ENABLE
  237. INNODB_MONITOR_RESET
  238. INNODB_MONITOR_RESET_ALL
  239. INNODB_MTFLUSH_THREADS 8
  240. INNODB_OLD_BLOCKS_PCT 37
  241. INNODB_OLD_BLOCKS_TIME 1000
  242. INNODB_ONLINE_ALTER_LOG_MAX_SIZE 134217728
  243. INNODB_OPEN_FILES 400
  244. INNODB_OPTIMIZE_FULLTEXT_ONLY OFF
  245. INNODB_PAGE_SIZE 16384
  246. INNODB_PREFIX_INDEX_CLUSTER_OPTIMIZATION OFF
  247. INNODB_PRINT_ALL_DEADLOCKS OFF
  248. INNODB_PRINT_LOCK_WAIT_TIMEOUT_INFO OFF
  249. INNODB_PURGE_BATCH_SIZE 300
  250. INNODB_PURGE_THREADS 1
  251. INNODB_RANDOM_READ_AHEAD OFF
  252. INNODB_READ_AHEAD_THRESHOLD 56
  253. INNODB_READ_IO_THREADS 4
  254. INNODB_READ_ONLY OFF
  255. INNODB_REPLICATION_DELAY 0
  256. INNODB_ROLLBACK_ON_TIMEOUT OFF
  257. INNODB_ROLLBACK_SEGMENTS 128
  258. INNODB_SCHED_PRIORITY_CLEANER 19
  259. INNODB_SCRUB_LOG OFF
  260. INNODB_SCRUB_LOG_SPEED 256
  261. INNODB_SHOW_LOCKS_HELD 10
  262. INNODB_SHOW_VERBOSE_LOCKS 0
  263. INNODB_SIMULATE_COMP_FAILURES 0
  264. INNODB_SORT_BUFFER_SIZE 1048576
  265. INNODB_SPIN_WAIT_DELAY 6
  266. INNODB_STATS_AUTO_RECALC ON
  267. INNODB_STATS_INCLUDE_DELETE_MARKED OFF
  268. INNODB_STATS_METHOD nulls_equal
  269. INNODB_STATS_MODIFIED_COUNTER 0
  270. INNODB_STATS_ON_METADATA OFF
  271. INNODB_STATS_PERSISTENT ON
  272. INNODB_STATS_PERSISTENT_SAMPLE_PAGES 20
  273. INNODB_STATS_SAMPLE_PAGES 8
  274. INNODB_STATS_TRADITIONAL ON
  275. INNODB_STATS_TRANSIENT_SAMPLE_PAGES 8
  276. INNODB_STATUS_OUTPUT OFF
  277. INNODB_STATUS_OUTPUT_LOCKS OFF
  278. INNODB_STRICT_MODE OFF
  279. INNODB_SUPPORT_XA ON
  280. INNODB_SYNC_ARRAY_SIZE 1
  281. INNODB_SYNC_SPIN_LOOPS 30
  282. INNODB_TABLE_LOCKS ON
  283. INNODB_THREAD_CONCURRENCY 0
  284. INNODB_THREAD_SLEEP_DELAY 10000
  285. INNODB_TMPDIR
  286. INNODB_TRACK_CHANGED_PAGES OFF
  287. INNODB_UNDO_DIRECTORY .
  288. INNODB_UNDO_LOGS 128
  289. INNODB_UNDO_TABLESPACES 0
  290. INNODB_USE_ATOMIC_WRITES OFF
  291. INNODB_USE_FALLOCATE OFF
  292. INNODB_USE_GLOBAL_FLUSH_LOG_AT_TRX_COMMIT ON
  293. INNODB_USE_MTFLUSH OFF
  294. INNODB_USE_NATIVE_AIO ON
  295. INNODB_USE_STACKTRACE OFF
  296. INNODB_USE_SYS_MALLOC ON
  297. INNODB_USE_TRIM OFF
  298. INNODB_VERSION 5.6.39-83.1
  299. INNODB_WRITE_IO_THREADS 4
  300. INTERACTIVE_TIMEOUT 28800
  301. JOIN_BUFFER_SIZE 262144
  302. JOIN_BUFFER_SPACE_LIMIT 2097152
  303. JOIN_CACHE_LEVEL 2
  304. KEEP_FILES_ON_CREATE OFF
  305. KEY_BUFFER_SIZE 33554432
  306. KEY_CACHE_AGE_THRESHOLD 300
  307. KEY_CACHE_BLOCK_SIZE 1024
  308. KEY_CACHE_DIVISION_LIMIT 100
  309. KEY_CACHE_FILE_HASH_SIZE 512
  310. KEY_CACHE_SEGMENTS 0
  311. LARGE_FILES_SUPPORT ON
  312. LARGE_PAGES OFF
  313. LARGE_PAGE_SIZE 0
  314. LC_MESSAGES en_US
  315. LC_MESSAGES_DIR /usr/share/mysql
  316. LC_TIME_NAMES en_US
  317. LICENSE GPL
  318. LOCAL_INFILE ON
  319. LOCKED_IN_MEMORY OFF
  320. LOCK_WAIT_TIMEOUT 31536000
  321. LOG_BIN OFF
  322. LOG_BIN_BASENAME
  323. LOG_BIN_INDEX
  324. LOG_BIN_TRUST_FUNCTION_CREATORS OFF
  325. LOG_ERROR
  326. LOG_OUTPUT FILE
  327. LOG_QUERIES_NOT_USING_INDEXES OFF
  328. LOG_SLAVE_UPDATES OFF
  329. LOG_SLOW_ADMIN_STATEMENTS OFF
  330. LOG_SLOW_FILTER admin,filesort,filesort_on_disk,full_join,full_scan,query_cache,query_cache_miss,tmp_table,tmp_table_on_disk
  331. LOG_SLOW_RATE_LIMIT 1
  332. LOG_SLOW_SLAVE_STATEMENTS OFF
  333. LOG_SLOW_VERBOSITY query_plan
  334. LOG_TC_SIZE 24576
  335. LOG_WARNINGS 2
  336. LONG_QUERY_TIME 10.000000
  337. LOWER_CASE_FILE_SYSTEM OFF
  338. LOWER_CASE_TABLE_NAMES 0
  339. LOW_PRIORITY_UPDATES OFF
  340. MASTER_VERIFY_CHECKSUM OFF
  341. MAX_ALLOWED_PACKET 16777216
  342. MAX_BINLOG_CACHE_SIZE 18446744073709547520
  343. MAX_BINLOG_SIZE 1073741824
  344. MAX_BINLOG_STMT_CACHE_SIZE 18446744073709547520
  345. MAX_CONNECTIONS 100
  346. MAX_CONNECT_ERRORS 100
  347. MAX_DELAYED_THREADS 20
  348. MAX_DIGEST_LENGTH 1024
  349. MAX_ERROR_COUNT 64
  350. MAX_HEAP_TABLE_SIZE 33554432
  351. MAX_INSERT_DELAYED_THREADS 20
  352. MAX_JOIN_SIZE 18446744073709551615
  353. MAX_LENGTH_FOR_SORT_DATA 1024
  354. MAX_LONG_DATA_SIZE 16777216
  355. MAX_PREPARED_STMT_COUNT 16382
  356. MAX_RELAY_LOG_SIZE 1073741824
  357. MAX_SEEKS_FOR_KEY 4294967295
  358. MAX_SESSION_MEM_USED 9223372036854775807
  359. MAX_SORT_LENGTH 1024
  360. MAX_SP_RECURSION_DEPTH 0
  361. MAX_STATEMENT_TIME 0.000000
  362. MAX_TMP_TABLES 32
  363. MAX_USER_CONNECTIONS 0
  364. MAX_WRITE_LOCK_COUNT 4294967295
  365. METADATA_LOCKS_CACHE_SIZE 1024
  366. METADATA_LOCKS_HASH_INSTANCES 8
  367. MIN_EXAMINED_ROW_LIMIT 0
  368. MRR_BUFFER_SIZE 262144
  369. MULTI_RANGE_COUNT 256
  370. MYISAM_BLOCK_SIZE 1024
  371. MYISAM_DATA_POINTER_SIZE 6
  372. MYISAM_MAX_SORT_FILE_SIZE 9223372036853727232
  373. MYISAM_MMAP_SIZE 18446744073709551615
  374. MYISAM_RECOVER_OPTIONS BACKUP
  375. MYISAM_REPAIR_THREADS 1
  376. MYISAM_SORT_BUFFER_SIZE 536870912
  377. MYISAM_STATS_METHOD NULLS_UNEQUAL
  378. MYISAM_USE_MMAP OFF
  379. MYSQL56_TEMPORAL_FORMAT ON
  380. NET_BUFFER_LENGTH 16384
  381. NET_READ_TIMEOUT 30
  382. NET_RETRY_COUNT 10
  383. NET_WRITE_TIMEOUT 60
  384. OLD OFF
  385. OLD_ALTER_TABLE OFF
  386. OLD_MODE
  387. OLD_PASSWORDS OFF
  388. OPEN_FILES_LIMIT 16364
  389. OPTIMIZER_PRUNE_LEVEL 1
  390. OPTIMIZER_SEARCH_DEPTH 62
  391. OPTIMIZER_SELECTIVITY_SAMPLING_LIMIT 100
  392. OPTIMIZER_SWITCH index_merge=on,index_merge_union=on,index_merge_sort_union=on,index_merge_intersection=on,index_merge_sort_intersection=off,engine_condition_pushdown=off,index_condition_pushdown=on,derived_merge=on,derived_with_keys=on,firstmatch=on,loosescan=on,materialization=on,in_to_exists=on,semijoin=on,partial_match_rowid_merge=on,partial_match_table_scan=on,subquery_cache=on,mrr=off,mrr_cost_based=off,mrr_sort_keys=off,outer_join_with_cache=on,semijoin_with_cache=on,join_cache_incremental=on,join_cache_hashed=on,join_cache_bka=on,optimize_join_buffer_size=off,table_elimination=on,extended_keys=on,exists_to_in=on,orderby_uses_equalities=off
  393. OPTIMIZER_USE_CONDITION_SELECTIVITY 1
  394. PERFORMANCE_SCHEMA OFF
  395. PERFORMANCE_SCHEMA_ACCOUNTS_SIZE -1
  396. PERFORMANCE_SCHEMA_DIGESTS_SIZE -1
  397. PERFORMANCE_SCHEMA_EVENTS_STAGES_HISTORY_LONG_SIZE -1
  398. PERFORMANCE_SCHEMA_EVENTS_STAGES_HISTORY_SIZE -1
  399. PERFORMANCE_SCHEMA_EVENTS_STATEMENTS_HISTORY_LONG_SIZE -1
  400. PERFORMANCE_SCHEMA_EVENTS_STATEMENTS_HISTORY_SIZE -1
  401. PERFORMANCE_SCHEMA_EVENTS_WAITS_HISTORY_LONG_SIZE -1
  402. PERFORMANCE_SCHEMA_EVENTS_WAITS_HISTORY_SIZE -1
  403. PERFORMANCE_SCHEMA_HOSTS_SIZE -1
  404. PERFORMANCE_SCHEMA_MAX_COND_CLASSES 80
  405. PERFORMANCE_SCHEMA_MAX_COND_INSTANCES -1
  406. PERFORMANCE_SCHEMA_MAX_DIGEST_LENGTH 1024
  407. PERFORMANCE_SCHEMA_MAX_FILE_CLASSES 50
  408. PERFORMANCE_SCHEMA_MAX_FILE_HANDLES 32768
  409. PERFORMANCE_SCHEMA_MAX_FILE_INSTANCES -1
  410. PERFORMANCE_SCHEMA_MAX_MUTEX_CLASSES 200
  411. PERFORMANCE_SCHEMA_MAX_MUTEX_INSTANCES -1
  412. PERFORMANCE_SCHEMA_MAX_RWLOCK_CLASSES 40
  413. PERFORMANCE_SCHEMA_MAX_RWLOCK_INSTANCES -1
  414. PERFORMANCE_SCHEMA_MAX_SOCKET_CLASSES 10
  415. PERFORMANCE_SCHEMA_MAX_SOCKET_INSTANCES -1
  416. PERFORMANCE_SCHEMA_MAX_STAGE_CLASSES 150
  417. PERFORMANCE_SCHEMA_MAX_STATEMENT_CLASSES 178
  418. PERFORMANCE_SCHEMA_MAX_TABLE_HANDLES -1
  419. PERFORMANCE_SCHEMA_MAX_TABLE_INSTANCES -1
  420. PERFORMANCE_SCHEMA_MAX_THREAD_CLASSES 50
  421. PERFORMANCE_SCHEMA_MAX_THREAD_INSTANCES -1
  422. PERFORMANCE_SCHEMA_SESSION_CONNECT_ATTRS_SIZE -1
  423. PERFORMANCE_SCHEMA_SETUP_ACTORS_SIZE 100
  424. PERFORMANCE_SCHEMA_SETUP_OBJECTS_SIZE 100
  425. PERFORMANCE_SCHEMA_USERS_SIZE -1
  426. PID_FILE /var/run/mysqld/mysqld.pid
  427. PLUGIN_DIR /usr/lib/mysql/plugin/
  428. PLUGIN_MATURITY unknown
  429. PORT 3306
  430. PRELOAD_BUFFER_SIZE 32768
  431. PROFILING OFF
  432. PROFILING_HISTORY_SIZE 15
  433. PROGRESS_REPORT_TIME 5
  434. PROTOCOL_VERSION 10
  435. QUERY_ALLOC_BLOCK_SIZE 16384
  436. QUERY_CACHE_LIMIT 131072
  437. QUERY_CACHE_MIN_RES_UNIT 4096
  438. QUERY_CACHE_SIZE 8388608
  439. QUERY_CACHE_STRIP_COMMENTS OFF
  440. QUERY_CACHE_TYPE ON
  441. QUERY_CACHE_WLOCK_INVALIDATE OFF
  442. QUERY_PREALLOC_SIZE 24576
  443. RANGE_ALLOC_BLOCK_SIZE 4096
  444. READ_BUFFER_SIZE 2097152
  445. READ_ONLY OFF
  446. READ_RND_BUFFER_SIZE 1048576
  447. RELAY_LOG
  448. RELAY_LOG_BASENAME
  449. RELAY_LOG_INDEX
  450. RELAY_LOG_INFO_FILE relay-log.info
  451. RELAY_LOG_PURGE ON
  452. RELAY_LOG_RECOVERY OFF
  453. RELAY_LOG_SPACE_LIMIT 0
  454. REPLICATE_ANNOTATE_ROW_EVENTS OFF
  455. REPLICATE_DO_DB
  456. REPLICATE_DO_TABLE
  457. REPLICATE_EVENTS_MARKED_FOR_SKIP REPLICATE
  458. REPLICATE_IGNORE_DB
  459. REPLICATE_IGNORE_TABLE
  460. REPLICATE_WILD_DO_TABLE
  461. REPLICATE_WILD_IGNORE_TABLE
  462. REPORT_HOST
  463. REPORT_PASSWORD
  464. REPORT_PORT 3306
  465. REPORT_USER
  466. ROWID_MERGE_BUFF_SIZE 8388608
  467. SECURE_AUTH ON
  468. SECURE_FILE_PRIV
  469. SERVER_ID 0
  470. SKIP_EXTERNAL_LOCKING ON
  471. SKIP_NAME_RESOLVE OFF
  472. SKIP_NETWORKING OFF
  473. SKIP_SHOW_DATABASE OFF
  474. SLAVE_COMPRESSED_PROTOCOL OFF
  475. SLAVE_DDL_EXEC_MODE IDEMPOTENT
  476. SLAVE_DOMAIN_PARALLEL_THREADS 0
  477. SLAVE_EXEC_MODE STRICT
  478. SLAVE_LOAD_TMPDIR /tmp
  479. SLAVE_MAX_ALLOWED_PACKET 1073741824
  480. SLAVE_NET_TIMEOUT 3600
  481. SLAVE_PARALLEL_MAX_QUEUED 131072
  482. SLAVE_PARALLEL_MODE conservative
  483. SLAVE_PARALLEL_THREADS 0
  484. SLAVE_RUN_TRIGGERS_FOR_RBR NO
  485. SLAVE_SKIP_ERRORS OFF
  486. SLAVE_SQL_VERIFY_CHECKSUM ON
  487. SLAVE_TRANSACTION_RETRIES 10
  488. SLAVE_TYPE_CONVERSIONS
  489. SLOW_LAUNCH_TIME 2
  490. SLOW_QUERY_LOG OFF
  491. SLOW_QUERY_LOG_FILE /var/log/mysql/mariadb-slow.log
  492. SOCKET /var/run/mysqld/mysqld.sock
  493. SORT_BUFFER_SIZE 4194304
  494. SQL_AUTO_IS_NULL OFF
  495. SQL_BIG_SELECTS ON
  496. SQL_BUFFER_RESULT OFF
  497. SQL_LOG_BIN ON
  498. SQL_LOG_OFF OFF
  499. SQL_MODE NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION
  500. SQL_NOTES ON
  501. SQL_QUOTE_SHOW_CREATE ON
  502. SQL_SAFE_UPDATES OFF
  503. SQL_SELECT_LIMIT 18446744073709551615
  504. SQL_SLAVE_SKIP_COUNTER 0
  505. SQL_WARNINGS OFF
  506. SSL_CA
  507. SSL_CAPATH
  508. SSL_CERT
  509. SSL_CIPHER
  510. SSL_CRL
  511. SSL_CRLPATH
  512. SSL_KEY
  513. STORAGE_ENGINE InnoDB
  514. STORED_PROGRAM_CACHE 256
  515. STRICT_PASSWORD_VALIDATION ON
  516. SYNC_BINLOG 0
  517. SYNC_FRM ON
  518. SYNC_MASTER_INFO 10000
  519. SYNC_RELAY_LOG 10000
  520. SYNC_RELAY_LOG_INFO 10000
  521. SYSTEM_TIME_ZONE EST
  522. TABLE_DEFINITION_CACHE 1024
  523. TABLE_OPEN_CACHE 2000
  524. THREAD_CACHE_SIZE 50
  525. THREAD_CONCURRENCY 10
  526. THREAD_HANDLING one-thread-per-connection
  527. THREAD_POOL_IDLE_TIMEOUT 60
  528. THREAD_POOL_MAX_THREADS 1000
  529. THREAD_POOL_OVERSUBSCRIBE 3
  530. THREAD_POOL_SIZE 2
  531. THREAD_POOL_STALL_LIMIT 500
  532. THREAD_STACK 295936
  533. TIMED_MUTEXES OFF
  534. TIME_FORMAT %H:%i:%s
  535. TIME_ZONE SYSTEM
  536. TMPDIR /tmp
  537. TMP_TABLE_SIZE 33554432
  538. TRANSACTION_ALLOC_BLOCK_SIZE 8192
  539. TRANSACTION_PREALLOC_SIZE 4096
  540. TX_ISOLATION REPEATABLE-READ
  541. TX_READ_ONLY OFF
  542. UNIQUE_CHECKS ON
  543. UPDATABLE_VIEWS_WITH_LIMIT YES
  544. USERSTAT OFF
  545. USE_STAT_TABLES NEVER
  546. VERSION 10.1.34-MariaDB-1~xenial
  547. VERSION_COMMENT mariadb.org binary distribution
  548. VERSION_COMPILE_MACHINE x86_64
  549. VERSION_COMPILE_OS debian-linux-gnu
  550. VERSION_MALLOC_LIBRARY system jemalloc
  551. VERSION_SSL_LIBRARY OpenSSL 1.0.2g 1 Mar 2016
  552. WAIT_TIMEOUT 600
  553. WSREP_AUTO_INCREMENT_CONTROL ON
  554. WSREP_CAUSAL_READS OFF
  555. WSREP_CERTIFY_NONPK ON
  556. WSREP_CLUSTER_ADDRESS
  557. WSREP_CLUSTER_NAME my_wsrep_cluster
  558. WSREP_CONVERT_LOCK_TO_TRX OFF
  559. WSREP_DATA_HOME_DIR /var/lib/mysql/
  560. WSREP_DBUG_OPTION
  561. WSREP_DEBUG OFF
  562. WSREP_DESYNC OFF
  563. WSREP_DIRTY_READS OFF
  564. WSREP_DRUPAL_282555_WORKAROUND OFF
  565. WSREP_FORCED_BINLOG_FORMAT NONE
  566. WSREP_GTID_DOMAIN_ID 0
  567. WSREP_GTID_MODE OFF
  568. WSREP_LOAD_DATA_SPLITTING ON
  569. WSREP_LOG_CONFLICTS OFF
  570. WSREP_MAX_WS_ROWS 0
  571. WSREP_MAX_WS_SIZE 2147483647
  572. WSREP_MYSQL_REPLICATION_BUNDLE 0
  573. WSREP_NODE_ADDRESS
  574. WSREP_NODE_INCOMING_ADDRESS AUTO
  575. WSREP_NODE_NAME localhost
  576. WSREP_NOTIFY_CMD
  577. WSREP_ON OFF
  578. WSREP_OSU_METHOD TOI
  579. WSREP_PATCH_VERSION wsrep_25.23
  580. WSREP_PROVIDER none
  581. WSREP_PROVIDER_OPTIONS
  582. WSREP_RECOVER OFF
  583. WSREP_REJECT_QUERIES NONE
  584. WSREP_REPLICATE_MYISAM OFF
  585. WSREP_RESTART_SLAVE OFF
  586. WSREP_RETRY_AUTOCOMMIT 1
  587. WSREP_SLAVE_FK_CHECKS ON
  588. WSREP_SLAVE_THREADS 1
  589. WSREP_SLAVE_UK_CHECKS OFF
  590. WSREP_SST_AUTH
  591. WSREP_SST_DONOR
  592. WSREP_SST_DONOR_REJECTS_QUERIES OFF
  593. WSREP_SST_METHOD rsync
  594. WSREP_SST_RECEIVE_ADDRESS AUTO
  595. WSREP_START_POSITION 00000000-0000-0000-0000-000000000000:-1
  596. WSREP_SYNC_WAIT 0
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement