Advertisement
Guest User

Untitled

a guest
Oct 30th, 2016
229
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 13.71 KB | None | 0 0
  1. "aria_block_size" "8192"
  2. "aria_checkpoint_interval" "30"
  3. "aria_checkpoint_log_activity" "1048576"
  4. "aria_force_start_after_recovery_failures" "0"
  5. "aria_group_commit" "none"
  6. "aria_group_commit_interval" "0"
  7. "aria_log_file_size" "1073741824"
  8. "aria_log_purge_type" "immediate"
  9. "aria_max_sort_file_size" "9223372036853727232"
  10. "aria_page_checksum" "ON"
  11. "aria_pagecache_age_threshold" "300"
  12. "aria_pagecache_buffer_size" "134217728"
  13. "aria_pagecache_division_limit" "100"
  14. "aria_recover" "NORMAL"
  15. "aria_repair_threads" "1"
  16. "aria_sort_buffer_size" "134217728"
  17. "aria_stats_method" "nulls_unequal"
  18. "aria_sync_log_dir" "NEWFILE"
  19. "aria_used_for_temp_tables" "ON"
  20. "auto_increment_increment" "1"
  21. "auto_increment_offset" "1"
  22. "autocommit" "ON"
  23. "automatic_sp_privileges" "ON"
  24. "back_log" "50"
  25. "basedir" "/usr"
  26. "big_tables" "OFF"
  27. "binlog_annotate_row_events" "OFF"
  28. "binlog_cache_size" "32768"
  29. "binlog_checksum" "NONE"
  30. "binlog_direct_non_transactional_updates" "OFF"
  31. "binlog_format" "STATEMENT"
  32. "binlog_optimize_thread_scheduling" "ON"
  33. "binlog_stmt_cache_size" "32768"
  34. "bulk_insert_buffer_size" "8388608"
  35. "character_set_client" "utf8mb4"
  36. "character_set_connection" "utf8mb4"
  37. "character_set_database" "latin1"
  38. "character_set_filesystem" "binary"
  39. "character_set_results" "utf8mb4"
  40. "character_set_server" "latin1"
  41. "character_set_system" "utf8"
  42. "character_sets_dir" "/usr/share/mysql/charsets/"
  43. "collation_connection" "utf8mb4_general_ci"
  44. "collation_database" "latin1_swedish_ci"
  45. "collation_server" "latin1_swedish_ci"
  46. "completion_type" "NO_CHAIN"
  47. "concurrent_insert" "AUTO"
  48. "connect_timeout" "10"
  49. "datadir" "/db/mysql/"
  50. "date_format" "%Y-%m-%d"
  51. "datetime_format" "%Y-%m-%d %H:%i:%s"
  52. "deadlock_search_depth_long" "15"
  53. "deadlock_search_depth_short" "4"
  54. "deadlock_timeout_long" "50000000"
  55. "deadlock_timeout_short" "10000"
  56. "debug_no_thread_alarm" "OFF"
  57. "default_storage_engine" "InnoDB"
  58. "default_week_format" "0"
  59. "delay_key_write" "ON"
  60. "delayed_insert_limit" "100"
  61. "delayed_insert_timeout" "300"
  62. "delayed_queue_size" "1000"
  63. "div_precision_increment" "4"
  64. "engine_condition_pushdown" "OFF"
  65. "error_count" "0"
  66. "event_scheduler" "OFF"
  67. "expensive_subquery_limit" "100"
  68. "expire_logs_days" "0"
  69. "external_user" ""
  70. "extra_max_connections" "1"
  71. "extra_port" "0"
  72. "flush" "OFF"
  73. "flush_time" "0"
  74. "foreign_key_checks" "ON"
  75. "ft_boolean_syntax" "+ -><()~*:""""&|"
  76. "ft_max_word_len" "84"
  77. "ft_min_word_len" "4"
  78. "ft_query_expansion_limit" "20"
  79. "ft_stopword_file" "(built-in)"
  80. "general_log" "OFF"
  81. "general_log_file" "localhost.log"
  82. "group_concat_max_len" "1024"
  83. "have_compress" "YES"
  84. "have_crypt" "YES"
  85. "have_csv" "YES"
  86. "have_dynamic_loading" "YES"
  87. "have_geometry" "YES"
  88. "have_innodb" "YES"
  89. "have_ndbcluster" "NO"
  90. "have_openssl" "DISABLED"
  91. "have_partitioning" "YES"
  92. "have_profiling" "YES"
  93. "have_query_cache" "YES"
  94. "have_rtree_keys" "YES"
  95. "have_ssl" "DISABLED"
  96. "have_symlink" "YES"
  97. "hostname" "localhost.localdomain"
  98. "identity" "0"
  99. "ignore_builtin_innodb" "OFF"
  100. "ignore_db_dirs" ""
  101. "in_transaction" "0"
  102. "init_connect" ""
  103. "init_file" ""
  104. "init_slave" ""
  105. "innodb_adaptive_flushing" "ON"
  106. "innodb_adaptive_flushing_method" "estimate"
  107. "innodb_adaptive_hash_index" "ON"
  108. "innodb_adaptive_hash_index_partitions" "1"
  109. "innodb_additional_mem_pool_size" "8388608"
  110. "innodb_autoextend_increment" "8"
  111. "innodb_autoinc_lock_mode" "1"
  112. "innodb_blocking_buffer_pool_restore" "OFF"
  113. "innodb_buffer_pool_instances" "2"
  114. "innodb_buffer_pool_populate" "OFF"
  115. "innodb_buffer_pool_restore_at_startup" "0"
  116. "innodb_buffer_pool_shm_checksum" "ON"
  117. "innodb_buffer_pool_shm_key" "0"
  118. "innodb_buffer_pool_size" "6442450944"
  119. "innodb_change_buffering" "all"
  120. "innodb_checkpoint_age_target" "0"
  121. "innodb_checksums" "ON"
  122. "innodb_commit_concurrency" "0"
  123. "innodb_concurrency_tickets" "500"
  124. "innodb_corrupt_table_action" "assert"
  125. "innodb_data_file_path" "ibdata1:10M:autoextend"
  126. "innodb_data_home_dir" ""
  127. "innodb_dict_size_limit" "0"
  128. "innodb_doublewrite" "ON"
  129. "innodb_doublewrite_file" ""
  130. "innodb_fake_changes" "OFF"
  131. "innodb_fast_checksum" "OFF"
  132. "innodb_fast_shutdown" "0"
  133. "innodb_file_format" "Antelope"
  134. "innodb_file_format_check" "ON"
  135. "innodb_file_format_max" "Antelope"
  136. "innodb_file_per_table" "ON"
  137. "innodb_flush_log_at_trx_commit" "2"
  138. "innodb_flush_method" "O_DIRECT"
  139. "innodb_flush_neighbor_pages" "area"
  140. "innodb_force_load_corrupted" "OFF"
  141. "innodb_force_recovery" "0"
  142. "innodb_ibuf_accel_rate" "100"
  143. "innodb_ibuf_active_contract" "1"
  144. "innodb_ibuf_max_size" "3221209088"
  145. "innodb_import_table_from_xtrabackup" "0"
  146. "innodb_io_capacity" "200"
  147. "innodb_kill_idle_transaction" "0"
  148. "innodb_large_prefix" "OFF"
  149. "innodb_lazy_drop_table" "0"
  150. "innodb_lock_wait_timeout" "50"
  151. "innodb_locking_fake_changes" "ON"
  152. "innodb_locks_unsafe_for_binlog" "OFF"
  153. "innodb_log_block_size" "512"
  154. "innodb_log_buffer_size" "8388608"
  155. "innodb_log_file_size" "5242880"
  156. "innodb_log_files_in_group" "2"
  157. "innodb_log_group_home_dir" "./"
  158. "innodb_max_bitmap_file_size" "104857600"
  159. "innodb_max_changed_pages" "1000000"
  160. "innodb_max_dirty_pages_pct" "0"
  161. "innodb_max_purge_lag" "0"
  162. "innodb_merge_sort_block_size" "1048576"
  163. "innodb_mirrored_log_groups" "1"
  164. "innodb_old_blocks_pct" "37"
  165. "innodb_old_blocks_time" "0"
  166. "innodb_open_files" "300"
  167. "innodb_page_size" "16384"
  168. "innodb_print_all_deadlocks" "OFF"
  169. "innodb_purge_batch_size" "20"
  170. "innodb_purge_threads" "1"
  171. "innodb_random_read_ahead" "OFF"
  172. "innodb_read_ahead" "linear"
  173. "innodb_read_ahead_threshold" "56"
  174. "innodb_read_io_threads" "4"
  175. "innodb_recovery_stats" "OFF"
  176. "innodb_recovery_update_relay_log" "OFF"
  177. "innodb_replication_delay" "0"
  178. "innodb_rollback_on_timeout" "OFF"
  179. "innodb_rollback_segments" "128"
  180. "innodb_show_locks_held" "10"
  181. "innodb_show_verbose_locks" "0"
  182. "innodb_simulate_comp_failures" "0"
  183. "innodb_spin_wait_delay" "6"
  184. "innodb_stats_auto_update" "1"
  185. "innodb_stats_method" "nulls_equal"
  186. "innodb_stats_modified_counter" "0"
  187. "innodb_stats_on_metadata" "ON"
  188. "innodb_stats_sample_pages" "8"
  189. "innodb_stats_traditional" "ON"
  190. "innodb_stats_update_need_lock" "1"
  191. "innodb_strict_mode" "OFF"
  192. "innodb_support_xa" "ON"
  193. "innodb_sync_spin_loops" "30"
  194. "innodb_table_locks" "ON"
  195. "innodb_thread_concurrency" "0"
  196. "innodb_thread_concurrency_timer_based" "OFF"
  197. "innodb_thread_sleep_delay" "10000"
  198. "innodb_track_changed_pages" "OFF"
  199. "innodb_use_atomic_writes" "OFF"
  200. "innodb_use_fallocate" "OFF"
  201. "innodb_use_global_flush_log_at_trx_commit" "ON"
  202. "innodb_use_native_aio" "ON"
  203. "innodb_use_stacktrace" "OFF"
  204. "innodb_use_sys_malloc" "ON"
  205. "innodb_use_sys_stats_table" "OFF"
  206. "innodb_version" "5.5.49-MariaDB-37.9"
  207. "innodb_write_io_threads" "4"
  208. "insert_id" "0"
  209. "interactive_timeout" "28800"
  210. "join_buffer_size" "131072"
  211. "join_buffer_space_limit" "2097152"
  212. "join_cache_level" "2"
  213. "keep_files_on_create" "OFF"
  214. "key_buffer_size" "134217728"
  215. "key_cache_age_threshold" "300"
  216. "key_cache_block_size" "1024"
  217. "key_cache_division_limit" "100"
  218. "key_cache_segments" "0"
  219. "large_files_support" "ON"
  220. "large_page_size" "0"
  221. "large_pages" "OFF"
  222. "last_insert_id" "0"
  223. "lc_messages" "en_US"
  224. "lc_messages_dir" ""
  225. "lc_time_names" "en_US"
  226. "license" "GPL"
  227. "local_infile" "ON"
  228. "lock_wait_timeout" "31536000"
  229. "locked_in_memory" "OFF"
  230. "log" "OFF"
  231. "log_bin" "OFF"
  232. "log_bin_trust_function_creators" "OFF"
  233. "log_error" "/var/log/mariadb/mariadb.log"
  234. "log_output" "FILE"
  235. "log_queries_not_using_indexes" "OFF"
  236. "log_slave_updates" "OFF"
  237. "log_slow_filter" "admin,filesort,filesort_on_disk,full_join,full_scan,query_cache,query_cache_miss,tmp_table,tmp_table_on_disk"
  238. "log_slow_queries" "OFF"
  239. "log_slow_rate_limit" "1"
  240. "log_slow_verbosity" ""
  241. "log_warnings" "1"
  242. "long_query_time" "10.000000"
  243. "low_priority_updates" "OFF"
  244. "lower_case_file_system" "OFF"
  245. "lower_case_table_names" "0"
  246. "master_verify_checksum" "OFF"
  247. "max_allowed_packet" "1048576"
  248. "max_binlog_cache_size" "18446744073709547520"
  249. "max_binlog_size" "1073741824"
  250. "max_binlog_stmt_cache_size" "18446744073709547520"
  251. "max_connect_errors" "10"
  252. "max_connections" "151"
  253. "max_delayed_threads" "20"
  254. "max_error_count" "64"
  255. "max_heap_table_size" "16777216"
  256. "max_insert_delayed_threads" "20"
  257. "max_join_size" "18446744073709551615"
  258. "max_length_for_sort_data" "1024"
  259. "max_long_data_size" "1048576"
  260. "max_prepared_stmt_count" "16382"
  261. "max_relay_log_size" "0"
  262. "max_seeks_for_key" "4294967295"
  263. "max_sort_length" "1024"
  264. "max_sp_recursion_depth" "0"
  265. "max_tmp_tables" "32"
  266. "max_user_connections" "0"
  267. "max_write_lock_count" "4294967295"
  268. "metadata_locks_cache_size" "1024"
  269. "min_examined_row_limit" "0"
  270. "mrr_buffer_size" "262144"
  271. "multi_range_count" "256"
  272. "myisam_block_size" "1024"
  273. "myisam_data_pointer_size" "6"
  274. "myisam_max_sort_file_size" "9223372036853727232"
  275. "myisam_mmap_size" "18446744073709551615"
  276. "myisam_recover_options" "DEFAULT"
  277. "myisam_repair_threads" "1"
  278. "myisam_sort_buffer_size" "8388608"
  279. "myisam_stats_method" "nulls_unequal"
  280. "myisam_use_mmap" "OFF"
  281. "net_buffer_length" "16384"
  282. "net_read_timeout" "30"
  283. "net_retry_count" "10"
  284. "net_write_timeout" "60"
  285. "old" "OFF"
  286. "old_alter_table" "OFF"
  287. "old_mode" ""
  288. "old_passwords" "OFF"
  289. "open_files_limit" "1024"
  290. "optimizer_prune_level" "1"
  291. "optimizer_search_depth" "62"
  292. "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=off"
  293. "performance_schema" "OFF"
  294. "performance_schema_events_waits_history_long_size" "10000"
  295. "performance_schema_events_waits_history_size" "10"
  296. "performance_schema_max_cond_classes" "80"
  297. "performance_schema_max_cond_instances" "1000"
  298. "performance_schema_max_file_classes" "50"
  299. "performance_schema_max_file_handles" "32768"
  300. "performance_schema_max_file_instances" "10000"
  301. "performance_schema_max_mutex_classes" "200"
  302. "performance_schema_max_mutex_instances" "1000000"
  303. "performance_schema_max_rwlock_classes" "30"
  304. "performance_schema_max_rwlock_instances" "1000000"
  305. "performance_schema_max_table_handles" "100000"
  306. "performance_schema_max_table_instances" "50000"
  307. "performance_schema_max_thread_classes" "50"
  308. "performance_schema_max_thread_instances" "1000"
  309. "pid_file" "/var/run/mariadb/mariadb.pid"
  310. "plugin_dir" "/usr/lib64/mysql/plugin/"
  311. "plugin_maturity" "unknown"
  312. "port" "3306"
  313. "preload_buffer_size" "32768"
  314. "profiling" "OFF"
  315. "profiling_history_size" "15"
  316. "progress_report_time" "5"
  317. "protocol_version" "10"
  318. "proxy_user" ""
  319. "pseudo_slave_mode" "OFF"
  320. "pseudo_thread_id" "11589"
  321. "query_alloc_block_size" "8192"
  322. "query_cache_limit" "1048576"
  323. "query_cache_min_res_unit" "4096"
  324. "query_cache_size" "0"
  325. "query_cache_strip_comments" "OFF"
  326. "query_cache_type" "OFF"
  327. "query_cache_wlock_invalidate" "OFF"
  328. "query_prealloc_size" "8192"
  329. "rand_seed1" "0"
  330. "rand_seed2" "0"
  331. "range_alloc_block_size" "4096"
  332. "read_buffer_size" "131072"
  333. "read_only" "OFF"
  334. "read_rnd_buffer_size" "262144"
  335. "relay_log" ""
  336. "relay_log_index" ""
  337. "relay_log_info_file" "relay-log.info"
  338. "relay_log_purge" "ON"
  339. "relay_log_recovery" "OFF"
  340. "relay_log_space_limit" "0"
  341. "replicate_annotate_row_events" "OFF"
  342. "replicate_do_db" ""
  343. "replicate_do_table" ""
  344. "replicate_events_marked_for_skip" "replicate"
  345. "replicate_ignore_db" ""
  346. "replicate_ignore_table" ""
  347. "replicate_wild_do_table" ""
  348. "replicate_wild_ignore_table" ""
  349. "report_host" ""
  350. "report_password" ""
  351. "report_port" "3306"
  352. "report_user" ""
  353. "rowid_merge_buff_size" "8388608"
  354. "rpl_recovery_rank" "0"
  355. "secure_auth" "OFF"
  356. "secure_file_priv" ""
  357. "server_id" "0"
  358. "skip_external_locking" "ON"
  359. "skip_name_resolve" "OFF"
  360. "skip_networking" "OFF"
  361. "skip_replication" "OFF"
  362. "skip_show_database" "OFF"
  363. "slave_compressed_protocol" "OFF"
  364. "slave_exec_mode" "STRICT"
  365. "slave_load_tmpdir" "/var/tmp"
  366. "slave_max_allowed_packet" "1073741824"
  367. "slave_net_timeout" "3600"
  368. "slave_skip_errors" "OFF"
  369. "slave_sql_verify_checksum" "ON"
  370. "slave_transaction_retries" "10"
  371. "slave_type_conversions" ""
  372. "slow_launch_time" "2"
  373. "slow_query_log" "OFF"
  374. "slow_query_log_file" "localhost-slow.log"
  375. "socket" "/db/mysql/mysql.sock"
  376. "sort_buffer_size" "2097152"
  377. "sql_auto_is_null" "OFF"
  378. "sql_big_selects" "ON"
  379. "sql_big_tables" "OFF"
  380. "sql_buffer_result" "OFF"
  381. "sql_log_bin" "ON"
  382. "sql_log_off" "OFF"
  383. "sql_low_priority_updates" "OFF"
  384. "sql_max_join_size" "18446744073709551615"
  385. "sql_mode" ""
  386. "sql_notes" "ON"
  387. "sql_quote_show_create" "ON"
  388. "sql_safe_updates" "OFF"
  389. "sql_select_limit" "18446744073709551615"
  390. "sql_slave_skip_counter" "0"
  391. "sql_warnings" "OFF"
  392. "ssl_ca" ""
  393. "ssl_capath" ""
  394. "ssl_cert" ""
  395. "ssl_cipher" ""
  396. "ssl_key" ""
  397. "storage_engine" "InnoDB"
  398. "stored_program_cache" "256"
  399. "sync_binlog" "0"
  400. "sync_frm" "ON"
  401. "sync_master_info" "0"
  402. "sync_relay_log" "0"
  403. "sync_relay_log_info" "0"
  404. "system_time_zone" "IST"
  405. "table_definition_cache" "400"
  406. "table_open_cache" "400"
  407. "thread_cache_size" "4"
  408. "thread_concurrency" "10"
  409. "thread_handling" "one-thread-per-connection"
  410. "thread_pool_idle_timeout" "60"
  411. "thread_pool_max_threads" "500"
  412. "thread_pool_oversubscribe" "3"
  413. "thread_pool_size" "4"
  414. "thread_pool_stall_limit" "500"
  415. "thread_stack" "294912"
  416. "time_format" "%H:%i:%s"
  417. "time_zone" "SYSTEM"
  418. "timed_mutexes" "OFF"
  419. "timestamp" "1477835733.175965"
  420. "tmp_table_size" "16777216"
  421. "tmpdir" "/var/tmp"
  422. "transaction_alloc_block_size" "8192"
  423. "transaction_prealloc_size" "4096"
  424. "tx_isolation" "REPEATABLE-READ"
  425. "unique_checks" "ON"
  426. "updatable_views_with_limit" "YES"
  427. "userstat" "OFF"
  428. "version" "5.5.50-MariaDB"
  429. "version_comment" "MariaDB Server"
  430. "version_compile_machine" "x86_64"
  431. "version_compile_os" "Linux"
  432. "wait_timeout" "28800"
  433. "warning_count" "0"
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement