Advertisement
Guest User

Untitled

a guest
Jan 12th, 2016
91
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 15.13 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_pagecache_file_hash_size = 512
  15. aria_recover = NORMAL
  16. aria_repair_threads = 1
  17. aria_sort_buffer_size = 268434432
  18. aria_stats_method = nulls_unequal
  19. aria_sync_log_dir = NEWFILE
  20. aria_used_for_temp_tables = ON
  21. auto_increment_increment = 1
  22. auto_increment_offset = 1
  23. autocommit = ON
  24. automatic_sp_privileges = ON
  25. back_log = 150
  26. basedir = /usr
  27. big_tables = OFF
  28. binlog_annotate_row_events = OFF
  29. binlog_cache_size = 32768
  30. binlog_checksum = NONE
  31. binlog_commit_wait_count = 0
  32. binlog_commit_wait_usec = 100000
  33. binlog_direct_non_transactional_updates = OFF
  34. binlog_format = STATEMENT
  35. binlog_optimize_thread_scheduling = ON
  36. binlog_stmt_cache_size = 32768
  37. bulk_insert_buffer_size = 8388608
  38. character_set_client = utf8
  39. character_set_connection = utf8
  40. character_set_database = utf8mb4
  41. character_set_filesystem = binary
  42. character_set_results = utf8
  43. character_set_server = latin1
  44. character_set_system = utf8
  45. character_sets_dir = /usr/share/mysql/charsets/
  46. collation_connection = utf8_general_ci
  47. collation_database = utf8mb4_unicode_ci
  48. collation_server = latin1_swedish_ci
  49. completion_type = NO_CHAIN
  50. concurrent_insert = AUTO
  51. connect_timeout = 10
  52. datadir = /var/lib/mysql/
  53. date_format = %Y-%m-%d
  54. datetime_format = %Y-%m-%d %H:%i:%s
  55. deadlock_search_depth_long = 15
  56. deadlock_search_depth_short = 4
  57. deadlock_timeout_long = 50000000
  58. deadlock_timeout_short = 10000
  59. debug_no_thread_alarm = OFF
  60. default_master_connection =
  61. default_regex_flags =
  62. default_storage_engine = InnoDB
  63. default_week_format = 0
  64. delay_key_write = ON
  65. delayed_insert_limit = 100
  66. delayed_insert_timeout = 300
  67. delayed_queue_size = 1000
  68. div_precision_increment = 4
  69. error_count = 0
  70. event_scheduler = OFF
  71. expensive_subquery_limit = 100
  72. expire_logs_days = 0
  73. external_user =
  74. extra_max_connections = 1
  75. extra_port = 0
  76. flush = OFF
  77. flush_time = 0
  78. foreign_key_checks = ON
  79. "ft_boolean_syntax","+ -><()~*:""""&|"
  80. ft_max_word_len = 84
  81. ft_min_word_len = 4
  82. ft_query_expansion_limit = 20
  83. ft_stopword_file = (built-in)
  84. general_log = ON
  85. general_log_file = /var/log/mysqld/query.log
  86. group_concat_max_len = 1024
  87. gtid_binlog_pos =
  88. gtid_binlog_state =
  89. gtid_current_pos =
  90. gtid_domain_id = 0
  91. gtid_ignore_duplicates = OFF
  92. gtid_seq_no = 0
  93. gtid_slave_pos =
  94. gtid_strict_mode = OFF
  95. have_compress = YES
  96. have_crypt = YES
  97. have_dynamic_loading = YES
  98. have_geometry = YES
  99. have_openssl = YES
  100. have_profiling = YES
  101. have_query_cache = YES
  102. have_rtree_keys = YES
  103. have_ssl = DISABLED
  104. have_symlink = DISABLED
  105. histogram_size = 0
  106. histogram_type = SINGLE_PREC_HB
  107. host_cache_size = 128
  108. hostname = master.privatedomain
  109. identity = 0
  110. ignore_builtin_innodb = OFF
  111. ignore_db_dirs =
  112. in_transaction = 0
  113. init_connect =
  114. init_file =
  115. init_slave =
  116. innodb_adaptive_flushing = ON
  117. innodb_adaptive_flushing_lwm = 10.000000
  118. innodb_adaptive_hash_index = ON
  119. innodb_adaptive_hash_index_partitions = 1
  120. innodb_adaptive_max_sleep_delay = 150000
  121. innodb_additional_mem_pool_size = 8388608
  122. innodb_api_bk_commit_interval = 5
  123. innodb_api_disable_rowlock = OFF
  124. innodb_api_enable_binlog = OFF
  125. innodb_api_enable_mdl = OFF
  126. innodb_api_trx_level = 0
  127. innodb_autoextend_increment = 64
  128. innodb_autoinc_lock_mode = 1
  129. innodb_buffer_pool_dump_at_shutdown = OFF
  130. innodb_buffer_pool_dump_now = OFF
  131. innodb_buffer_pool_filename = ib_buffer_pool
  132. innodb_buffer_pool_instances = 8
  133. innodb_buffer_pool_load_abort = OFF
  134. innodb_buffer_pool_load_at_startup = OFF
  135. innodb_buffer_pool_load_now = OFF
  136. innodb_buffer_pool_populate = OFF
  137. innodb_buffer_pool_size = 134217728
  138. innodb_change_buffer_max_size = 25
  139. innodb_change_buffering = all
  140. innodb_checksum_algorithm = innodb
  141. innodb_checksums = ON
  142. innodb_cleaner_lsn_age_factor = high_checkpoint
  143. innodb_cmp_per_index_enabled = OFF
  144. innodb_commit_concurrency = 0
  145. innodb_compression_failure_threshold_pct = 5
  146. innodb_compression_level = 6
  147. innodb_compression_pad_pct_max = 50
  148. innodb_concurrency_tickets = 5000
  149. innodb_corrupt_table_action = assert
  150. innodb_data_file_path = ibdata1:12M:autoextend
  151. innodb_data_home_dir =
  152. innodb_disable_sort_file_cache = OFF
  153. innodb_doublewrite = ON
  154. innodb_empty_free_list_algorithm = backoff
  155. innodb_fake_changes = OFF
  156. innodb_fast_shutdown = 1
  157. innodb_file_format = Antelope
  158. innodb_file_format_check = ON
  159. innodb_file_format_max = Antelope
  160. innodb_file_per_table = ON
  161. innodb_flush_log_at_timeout = 1
  162. innodb_flush_log_at_trx_commit = 1
  163. innodb_flush_method =
  164. innodb_flush_neighbors = 1
  165. innodb_flushing_avg_loops = 30
  166. innodb_force_load_corrupted = OFF
  167. innodb_force_recovery = 0
  168. innodb_foreground_preflush = exponential_backoff
  169. innodb_ft_aux_table =
  170. innodb_ft_cache_size = 8000000
  171. innodb_ft_enable_diag_print = OFF
  172. innodb_ft_enable_stopword = ON
  173. innodb_ft_max_token_size = 84
  174. innodb_ft_min_token_size = 3
  175. innodb_ft_num_word_optimize = 2000
  176. innodb_ft_result_cache_limit = 2000000000
  177. innodb_ft_server_stopword_table =
  178. innodb_ft_sort_pll_degree = 2
  179. innodb_ft_total_cache_size = 640000000
  180. innodb_ft_user_stopword_table =
  181. innodb_io_capacity = 200
  182. innodb_io_capacity_max = 2000
  183. innodb_kill_idle_transaction = 0
  184. innodb_large_prefix = OFF
  185. innodb_lock_wait_timeout = 50
  186. innodb_locking_fake_changes = ON
  187. innodb_locks_unsafe_for_binlog = OFF
  188. innodb_log_arch_dir = ./
  189. innodb_log_arch_expire_sec = 0
  190. innodb_log_archive = OFF
  191. innodb_log_block_size = 512
  192. innodb_log_buffer_size = 8388608
  193. innodb_log_checksum_algorithm = innodb
  194. innodb_log_compressed_pages = ON
  195. innodb_log_file_size = 50331648
  196. innodb_log_files_in_group = 2
  197. innodb_log_group_home_dir = ./
  198. innodb_lru_scan_depth = 1024
  199. innodb_max_bitmap_file_size = 104857600
  200. innodb_max_changed_pages = 1000000
  201. innodb_max_dirty_pages_pct = 75.000000
  202. innodb_max_dirty_pages_pct_lwm = 0.001000
  203. innodb_max_purge_lag = 0
  204. innodb_max_purge_lag_delay = 0
  205. innodb_mirrored_log_groups = 1
  206. innodb_monitor_disable =
  207. innodb_monitor_enable =
  208. innodb_monitor_reset =
  209. innodb_monitor_reset_all =
  210. innodb_old_blocks_pct = 37
  211. innodb_old_blocks_time = 1000
  212. innodb_online_alter_log_max_size = 134217728
  213. innodb_open_files = 300
  214. innodb_optimize_fulltext_only = OFF
  215. innodb_page_size = 16384
  216. innodb_print_all_deadlocks = OFF
  217. innodb_purge_batch_size = 300
  218. innodb_purge_threads = 1
  219. innodb_random_read_ahead = OFF
  220. innodb_read_ahead_threshold = 56
  221. innodb_read_io_threads = 4
  222. innodb_read_only = OFF
  223. innodb_replication_delay = 0
  224. innodb_rollback_on_timeout = OFF
  225. innodb_rollback_segments = 128
  226. innodb_sched_priority_cleaner = 19
  227. innodb_show_locks_held = 10
  228. innodb_show_verbose_locks = 0
  229. innodb_simulate_comp_failures = 0
  230. innodb_sort_buffer_size = 1048576
  231. innodb_spin_wait_delay = 6
  232. innodb_stats_auto_recalc = ON
  233. innodb_stats_method = nulls_equal
  234. innodb_stats_modified_counter = 0
  235. innodb_stats_on_metadata = OFF
  236. innodb_stats_persistent = ON
  237. innodb_stats_persistent_sample_pages = 20
  238. innodb_stats_sample_pages = 8
  239. innodb_stats_traditional = ON
  240. innodb_stats_transient_sample_pages = 8
  241. innodb_status_output = OFF
  242. innodb_status_output_locks = OFF
  243. innodb_strict_mode = OFF
  244. innodb_support_xa = ON
  245. innodb_sync_array_size = 1
  246. innodb_sync_spin_loops = 30
  247. innodb_table_locks = ON
  248. innodb_thread_concurrency = 0
  249. innodb_thread_sleep_delay = 10000
  250. innodb_track_changed_pages = OFF
  251. innodb_undo_directory = .
  252. innodb_undo_logs = 128
  253. innodb_undo_tablespaces = 0
  254. innodb_use_atomic_writes = OFF
  255. innodb_use_fallocate = OFF
  256. innodb_use_global_flush_log_at_trx_commit = ON
  257. innodb_use_native_aio = ON
  258. innodb_use_stacktrace = OFF
  259. innodb_use_sys_malloc = ON
  260. innodb_version = 5.6.26-74.0
  261. innodb_write_io_threads = 4
  262. insert_id = 0
  263. interactive_timeout = 28800
  264. join_buffer_size = 131072
  265. join_buffer_space_limit = 2097152
  266. join_cache_level = 2
  267. keep_files_on_create = OFF
  268. key_buffer_size = 16777216
  269. key_cache_age_threshold = 300
  270. key_cache_block_size = 1024
  271. key_cache_division_limit = 100
  272. key_cache_file_hash_size = 512
  273. key_cache_segments = 0
  274. large_files_support = ON
  275. large_page_size = 0
  276. large_pages = OFF
  277. last_gtid =
  278. last_insert_id = 0
  279. lc_messages = en_US
  280. lc_messages_dir =
  281. lc_time_names = en_US
  282. license = GPL
  283. local_infile = ON
  284. lock_wait_timeout = 31536000
  285. locked_in_memory = OFF
  286. log_bin = OFF
  287. log_bin_trust_function_creators = OFF
  288. log_error = /var/log/mysqld/mysqld.log
  289. log_output = FILE
  290. log_queries_not_using_indexes = OFF
  291. log_slave_updates = OFF
  292. log_slow_filter = admin,filesort,filesort_on_disk,full_join,full_scan,query_cache,query_cache_miss,tmp_table,tmp_table_on_disk
  293. log_slow_rate_limit = 1
  294. log_slow_verbosity =
  295. log_warnings = 1
  296. long_query_time = 10.000000
  297. low_priority_updates = OFF
  298. lower_case_file_system = OFF
  299. lower_case_table_names = 0
  300. master_verify_checksum = OFF
  301. max_allowed_packet = 33554432
  302. max_binlog_cache_size = 18446744073709547520
  303. max_binlog_size = 1073741824
  304. max_binlog_stmt_cache_size = 18446744073709547520
  305. max_connect_errors = 100
  306. max_connections = 151
  307. max_delayed_threads = 20
  308. max_digest_length = 1024
  309. max_error_count = 64
  310. max_heap_table_size = 16777216
  311. max_insert_delayed_threads = 20
  312. max_join_size = 18446744073709551615
  313. max_length_for_sort_data = 1024
  314. max_long_data_size = 33554432
  315. max_prepared_stmt_count = 16382
  316. max_relay_log_size = 1073741824
  317. max_seeks_for_key = 4294967295
  318. max_sort_length = 1024
  319. max_sp_recursion_depth = 0
  320. max_tmp_tables = 32
  321. max_user_connections = 0
  322. max_write_lock_count = 4294967295
  323. metadata_locks_cache_size = 1024
  324. metadata_locks_hash_instances = 8
  325. min_examined_row_limit = 0
  326. mrr_buffer_size = 262144
  327. multi_range_count = 256
  328. myisam_block_size = 1024
  329. myisam_data_pointer_size = 6
  330. myisam_max_sort_file_size = 9223372036853727232
  331. myisam_mmap_size = 18446744073709551615
  332. myisam_recover_options = DEFAULT
  333. myisam_repair_threads = 1
  334. myisam_sort_buffer_size = 8388608
  335. myisam_stats_method = nulls_unequal
  336. myisam_use_mmap = OFF
  337. net_buffer_length = 8192
  338. net_read_timeout = 30
  339. net_retry_count = 10
  340. net_write_timeout = 60
  341. old = OFF
  342. old_alter_table = OFF
  343. old_mode =
  344. old_passwords = OFF
  345. open_files_limit = 1024
  346. optimizer_prune_level = 1
  347. optimizer_search_depth = 62
  348. optimizer_selectivity_sampling_limit = 100
  349. 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
  350. optimizer_use_condition_selectivity = 1
  351. performance_schema = OFF
  352. performance_schema_accounts_size = -1
  353. performance_schema_digests_size = -1
  354. performance_schema_events_stages_history_long_size = -1
  355. performance_schema_events_stages_history_size = -1
  356. performance_schema_events_statements_history_long_size = -1
  357. performance_schema_events_statements_history_size = -1
  358. performance_schema_events_waits_history_long_size = -1
  359. performance_schema_events_waits_history_size = -1
  360. performance_schema_hosts_size = -1
  361. performance_schema_max_cond_classes = 80
  362. performance_schema_max_cond_instances = -1
  363. performance_schema_max_digest_length = 1024
  364. performance_schema_max_file_classes = 50
  365. performance_schema_max_file_handles = 32768
  366. performance_schema_max_file_instances = -1
  367. performance_schema_max_mutex_classes = 200
  368. performance_schema_max_mutex_instances = -1
  369. performance_schema_max_rwlock_classes = 40
  370. performance_schema_max_rwlock_instances = -1
  371. performance_schema_max_socket_classes = 10
  372. performance_schema_max_socket_instances = -1
  373. performance_schema_max_stage_classes = 150
  374. performance_schema_max_statement_classes = 180
  375. performance_schema_max_table_handles = -1
  376. performance_schema_max_table_instances = -1
  377. performance_schema_max_thread_classes = 50
  378. performance_schema_max_thread_instances = -1
  379. performance_schema_session_connect_attrs_size = -1
  380. performance_schema_setup_actors_size = 100
  381. performance_schema_setup_objects_size = 100
  382. performance_schema_users_size = -1
  383. pid_file = /var/run/mysqld/mysqld.pid
  384. plugin_dir = /usr/lib64/mysql/plugin/
  385. plugin_maturity = unknown
  386. port = 3306
  387. preload_buffer_size = 32768
  388. profiling = OFF
  389. profiling_history_size = 15
  390. progress_report_time = 5
  391. protocol_version = 10
  392. proxy_user =
  393. pseudo_slave_mode = OFF
  394. pseudo_thread_id = 194
  395. query_alloc_block_size = 8192
  396. query_cache_limit = 1048576
  397. query_cache_min_res_unit = 4096
  398. query_cache_size = 0
  399. query_cache_strip_comments = OFF
  400. query_cache_type = ON
  401. query_cache_wlock_invalidate = OFF
  402. query_prealloc_size = 8192
  403. rand_seed1 = 0
  404. rand_seed2 = 0
  405. range_alloc_block_size = 4096
  406. read_buffer_size = 262144
  407. read_only = OFF
  408. read_rnd_buffer_size = 524288
  409. relay_log =
  410. relay_log_index =
  411. relay_log_info_file = relay-log.info
  412. relay_log_purge = ON
  413. relay_log_recovery = OFF
  414. relay_log_space_limit = 0
  415. replicate_annotate_row_events = OFF
  416. replicate_do_db =
  417. replicate_do_table =
  418. replicate_events_marked_for_skip = replicate
  419. replicate_ignore_db =
  420. replicate_ignore_table =
  421. replicate_wild_do_table =
  422. replicate_wild_ignore_table =
  423. report_host =
  424. report_password =
  425. report_port = 3306
  426. report_user =
  427. rowid_merge_buff_size = 8388608
  428. rpl_recovery_rank = 0
  429. secure_auth = OFF
  430. secure_file_priv =
  431. server_id = 1
  432. skip_external_locking = ON
  433. skip_name_resolve = OFF
  434. skip_networking = OFF
  435. skip_replication = OFF
  436. skip_show_database = OFF
  437. slave_compressed_protocol = OFF
  438. slave_ddl_exec_mode = IDEMPOTENT
  439. slave_domain_parallel_threads = 0
  440. slave_exec_mode = STRICT
  441. slave_load_tmpdir = /var/tmp
  442. slave_max_allowed_packet = 1073741824
  443. slave_net_timeout = 3600
  444. slave_parallel_max_queued = 131072
  445. slave_parallel_threads = 0
  446. slave_skip_errors = OFF
  447. slave_sql_verify_checksum = ON
  448. slave_transaction_retries = 10
  449. slave_type_conversions =
  450. slow_launch_time = 2
  451. slow_query_log = ON
  452. slow_query_log_file = /var/log/mysqld/slow.log
  453. socket = /var/lib/mysql/mysql.sock
  454. sort_buffer_size = 524288
  455. sql_auto_is_null = OFF
  456. sql_big_selects = ON
  457. sql_buffer_result = OFF
  458. sql_log_bin = ON
  459. sql_log_off = OFF
  460. sql_mode =
  461. sql_notes = ON
  462. sql_quote_show_create = ON
  463. sql_safe_updates = OFF
  464. sql_select_limit = 18446744073709551615
  465. sql_slave_skip_counter = 0
  466. sql_warnings = OFF
  467. ssl_ca =
  468. ssl_capath =
  469. ssl_cert =
  470. ssl_cipher =
  471. ssl_crl =
  472. ssl_crlpath =
  473. ssl_key =
  474. storage_engine = InnoDB
  475. stored_program_cache = 256
  476. sync_binlog = 0
  477. sync_frm = ON
  478. sync_master_info = 0
  479. sync_relay_log = 0
  480. sync_relay_log_info = 0
  481. system_time_zone = PST
  482. table_definition_cache = 400
  483. table_open_cache = 64
  484. thread_cache_size = 0
  485. thread_concurrency = 10
  486. thread_handling = one-thread-per-connection
  487. thread_pool_idle_timeout = 60
  488. thread_pool_max_threads = 500
  489. thread_pool_oversubscribe = 3
  490. thread_pool_size = 8
  491. thread_pool_stall_limit = 500
  492. thread_stack = 294912
  493. time_format = %H:%i:%s
  494. time_zone = SYSTEM
  495. timed_mutexes = OFF
  496. timestamp = 1452504899.822080
  497. tmp_table_size = 16777216
  498. tmpdir = /var/tmp
  499. transaction_alloc_block_size = 8192
  500. transaction_prealloc_size = 4096
  501. tx_isolation = REPEATABLE-READ
  502. tx_read_only = OFF
  503. unique_checks = ON
  504. updatable_views_with_limit = YES
  505. use_stat_tables = NEVER
  506. userstat = OFF
  507. version = 10.0.22-MariaDB-log
  508. version_comment = Mageia MariaDB Server
  509. version_compile_machine = x86_64
  510. version_compile_os = Linux
  511. version_malloc_library = system jemalloc
  512. wait_timeout = 28800
  513. warning_count = 0
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement