Advertisement
HosniMansour

Untitled

Aug 24th, 2022
344
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 23.87 KB | None | 0 0
  1. Variable_name,Value
  2. alter_algorithm,DEFAULT
  3. analyze_sample_percentage,100.000000
  4. aria_block_size,8192
  5. aria_checkpoint_interval,30
  6. aria_checkpoint_log_activity,1048576
  7. aria_encrypt_tables,OFF
  8. aria_force_start_after_recovery_failures,0
  9. aria_group_commit,none
  10. aria_group_commit_interval,0
  11. aria_log_file_size,1073741824
  12. aria_log_purge_type,immediate
  13. aria_max_sort_file_size,9223372036853727232
  14. aria_page_checksum,ON
  15. aria_pagecache_age_threshold,300
  16. aria_pagecache_buffer_size,134217728
  17. aria_pagecache_division_limit,100
  18. aria_pagecache_file_hash_size,512
  19. aria_recover_options,"BACKUP,QUICK"
  20. aria_repair_threads,1
  21. aria_sort_buffer_size,268434432
  22. aria_stats_method,nulls_unequal
  23. aria_sync_log_dir,NEWFILE
  24. aria_used_for_temp_tables,ON
  25. auto_increment_increment,1
  26. auto_increment_offset,1
  27. autocommit,ON
  28. automatic_sp_privileges,ON
  29. back_log,900
  30. basedir,/rdsdbbin/mysql/
  31. big_tables,OFF
  32. bind_address,
  33. binlog_annotate_row_events,ON
  34. binlog_cache_size,32768
  35. binlog_checksum,CRC32
  36. binlog_commit_wait_count,0
  37. binlog_commit_wait_usec,100000
  38. binlog_direct_non_transactional_updates,OFF
  39. binlog_expire_logs_seconds,0
  40. binlog_file_cache_size,16384
  41. binlog_format,MIXED
  42. binlog_optimize_thread_scheduling,ON
  43. binlog_row_image,FULL
  44. binlog_row_metadata,NO_LOG
  45. binlog_stmt_cache_size,32768
  46. bulk_insert_buffer_size,8388608
  47. character_set_client,utf8mb4
  48. character_set_connection,utf8mb4
  49. character_set_database,utf8mb3
  50. character_set_filesystem,binary
  51. character_set_results,utf8mb4
  52. character_set_server,latin1
  53. character_set_system,utf8mb3
  54. character_sets_dir,/rdsdbbin/mariadb-10.6.8.R1/share/charsets/
  55. check_constraint_checks,ON
  56. collation_connection,utf8mb4_general_ci
  57. collation_database,utf8mb3_general_ci
  58. collation_server,latin1_swedish_ci
  59. column_compression_threshold,100
  60. column_compression_zlib_level,6
  61. column_compression_zlib_strategy,DEFAULT_STRATEGY
  62. column_compression_zlib_wrap,OFF
  63. completion_type,NO_CHAIN
  64. concurrent_insert,AUTO
  65. connect_timeout,7200
  66. core_file,OFF
  67. datadir,/rdsdbdata/db/
  68. date_format,%Y-%m-%d
  69. datetime_format,"%Y-%m-%d %H:%i:%s"
  70. deadlock_search_depth_long,15
  71. deadlock_search_depth_short,4
  72. deadlock_timeout_long,7200
  73. deadlock_timeout_short,10000
  74. debug_no_thread_alarm,OFF
  75. default_master_connection,
  76. default_password_lifetime,0
  77. default_regex_flags,
  78. default_storage_engine,InnoDB
  79. default_tmp_storage_engine,
  80. default_week_format,0
  81. delay_key_write,ON
  82. delayed_insert_limit,100
  83. delayed_insert_timeout,300
  84. delayed_queue_size,1000
  85. disconnect_on_expired_password,OFF
  86. div_precision_increment,4
  87. encrypt_binlog,OFF
  88. encrypt_tmp_disk_tables,OFF
  89. encrypt_tmp_files,OFF
  90. enforce_storage_engine,
  91. eq_range_index_dive_limit,200
  92. error_count,0
  93. event_scheduler,OFF
  94. expensive_subquery_limit,100
  95. expire_logs_days,0.000000
  96. explicit_defaults_for_timestamp,OFF
  97. external_user,
  98. extra_max_connections,1
  99. extra_port,0
  100. flush,OFF
  101. flush_time,0
  102. foreign_key_checks,ON
  103. ft_boolean_syntax,"+ -><()~*:""&|"
  104. ft_max_word_len,84
  105. ft_min_word_len,4
  106. ft_query_expansion_limit,20
  107. ft_stopword_file,(built-in)
  108. general_log,OFF
  109. general_log_file,/rdsdbdata/log/general/mysql-general.log
  110. group_concat_max_len,1048576
  111. gtid_binlog_pos,0-826979191-96027912425
  112. gtid_binlog_state,"0-303926702-43783454745,0-1428645245-91797308607,0-826979191-96027912425"
  113. gtid_cleanup_batch_size,64
  114. gtid_current_pos,0-826979191-96027912425
  115. gtid_domain_id,0
  116. gtid_ignore_duplicates,OFF
  117. gtid_pos_auto_engines,
  118. gtid_seq_no,0
  119. gtid_slave_pos,
  120. gtid_strict_mode,OFF
  121. have_compress,YES
  122. have_crypt,YES
  123. have_dynamic_loading,YES
  124. have_geometry,YES
  125. have_openssl,YES
  126. have_profiling,YES
  127. have_query_cache,YES
  128. have_rtree_keys,YES
  129. have_ssl,YES
  130. have_symlink,YES
  131. histogram_size,254
  132. histogram_type,DOUBLE_PREC_HB
  133. host_cache_size,1403
  134. hostname,ip-172-27-0-219
  135. identity,0
  136. idle_readonly_transaction_timeout,1800
  137. idle_transaction_timeout,1800
  138. idle_write_transaction_timeout,1800
  139. ignore_builtin_innodb,OFF
  140. ignore_db_dirs,#rocksdb
  141. in_predicate_conversion_threshold,1000
  142. in_transaction,0
  143. init_connect,
  144. init_file,
  145. init_slave,
  146. innodb_adaptive_flushing,ON
  147. innodb_adaptive_flushing_lwm,10.000000
  148. innodb_adaptive_hash_index,OFF
  149. innodb_adaptive_hash_index_parts,8
  150. innodb_autoextend_increment,64
  151. innodb_autoinc_lock_mode,1
  152. innodb_buf_dump_status_frequency,0
  153. innodb_buffer_pool_chunk_size,134217728
  154. innodb_buffer_pool_dump_at_shutdown,ON
  155. innodb_buffer_pool_dump_now,OFF
  156. innodb_buffer_pool_dump_pct,25
  157. innodb_buffer_pool_filename,ib_buffer_pool
  158. innodb_buffer_pool_load_abort,OFF
  159. innodb_buffer_pool_load_at_startup,ON
  160. innodb_buffer_pool_load_now,OFF
  161. innodb_buffer_pool_size,197568495616
  162. innodb_change_buffer_max_size,25
  163. innodb_change_buffering,none
  164. innodb_checksum_algorithm,full_crc32
  165. innodb_cmp_per_index_enabled,OFF
  166. innodb_compression_algorithm,zlib
  167. innodb_compression_default,OFF
  168. innodb_compression_failure_threshold_pct,5
  169. innodb_compression_level,6
  170. innodb_compression_pad_pct_max,50
  171. innodb_data_file_path,ibdata1:12M:autoextend
  172. innodb_data_home_dir,/rdsdbdata/db/innodb
  173. innodb_deadlock_detect,ON
  174. innodb_deadlock_report,full
  175. innodb_default_encryption_key_id,1
  176. innodb_default_row_format,dynamic
  177. innodb_defragment,OFF
  178. innodb_defragment_fill_factor,0.900000
  179. innodb_defragment_fill_factor_n_recs,20
  180. innodb_defragment_frequency,40
  181. innodb_defragment_n_pages,7
  182. innodb_defragment_stats_accuracy,0
  183. innodb_disable_sort_file_cache,OFF
  184. innodb_doublewrite,ON
  185. innodb_encrypt_log,OFF
  186. innodb_encrypt_tables,OFF
  187. innodb_encrypt_temporary_tables,OFF
  188. innodb_encryption_rotate_key_age,1
  189. innodb_encryption_rotation_iops,100
  190. innodb_encryption_threads,0
  191. innodb_fast_shutdown,1
  192. innodb_fatal_semaphore_wait_threshold,600
  193. innodb_file_per_table,ON
  194. innodb_fill_factor,100
  195. innodb_flush_log_at_timeout,1
  196. innodb_flush_log_at_trx_commit,0
  197. innodb_flush_method,O_DIRECT
  198. innodb_flush_neighbors,0
  199. innodb_flush_sync,ON
  200. innodb_flushing_avg_loops,30
  201. innodb_force_primary_key,OFF
  202. innodb_force_recovery,0
  203. innodb_ft_aux_table,
  204. innodb_ft_cache_size,8000000
  205. innodb_ft_enable_diag_print,OFF
  206. innodb_ft_enable_stopword,ON
  207. innodb_ft_max_token_size,84
  208. innodb_ft_min_token_size,3
  209. innodb_ft_num_word_optimize,2000
  210. innodb_ft_result_cache_limit,2000000000
  211. innodb_ft_server_stopword_table,
  212. innodb_ft_sort_pll_degree,2
  213. innodb_ft_total_cache_size,640000000
  214. innodb_ft_user_stopword_table,
  215. innodb_immediate_scrub_data_uncompressed,OFF
  216. innodb_instant_alter_column_allowed,add_drop_reorder
  217. innodb_io_capacity,2000
  218. innodb_io_capacity_max,4000
  219. innodb_lock_wait_timeout,7200
  220. innodb_log_buffer_size,33554432
  221. innodb_log_file_size,17179869184
  222. innodb_log_group_home_dir,/rdsdbdata/log/innodb
  223. innodb_log_write_ahead_size,8192
  224. innodb_lru_flush_size,32
  225. innodb_lru_scan_depth,1536
  226. innodb_max_dirty_pages_pct,95.000000
  227. innodb_max_dirty_pages_pct_lwm,0.000000
  228. innodb_max_purge_lag,0
  229. innodb_max_purge_lag_delay,0
  230. innodb_max_purge_lag_wait,4294967295
  231. innodb_max_undo_log_size,10485760
  232. innodb_monitor_disable,
  233. innodb_monitor_enable,
  234. innodb_monitor_reset,
  235. innodb_monitor_reset_all,
  236. innodb_numa_interleave,OFF
  237. innodb_old_blocks_pct,37
  238. innodb_old_blocks_time,1000
  239. innodb_online_alter_log_max_size,134217728
  240. innodb_open_files,6000
  241. innodb_optimize_fulltext_only,OFF
  242. innodb_page_size,16384
  243. innodb_prefix_index_cluster_optimization,OFF
  244. innodb_print_all_deadlocks,OFF
  245. innodb_purge_batch_size,300
  246. innodb_purge_rseg_truncate_frequency,128
  247. innodb_purge_threads,4
  248. innodb_random_read_ahead,OFF
  249. innodb_read_ahead_threshold,56
  250. innodb_read_io_threads,8
  251. innodb_read_only,OFF
  252. innodb_read_only_compressed,OFF
  253. innodb_rollback_on_timeout,OFF
  254. innodb_sort_buffer_size,1048576
  255. innodb_spin_wait_delay,4
  256. innodb_stats_auto_recalc,ON
  257. innodb_stats_include_delete_marked,OFF
  258. innodb_stats_method,nulls_equal
  259. innodb_stats_modified_counter,0
  260. innodb_stats_on_metadata,OFF
  261. innodb_stats_persistent,ON
  262. innodb_stats_persistent_sample_pages,20
  263. innodb_stats_traditional,ON
  264. innodb_stats_transient_sample_pages,8
  265. innodb_status_output,OFF
  266. innodb_status_output_locks,OFF
  267. innodb_strict_mode,OFF
  268. innodb_sync_spin_loops,30
  269. innodb_table_locks,ON
  270. innodb_temp_data_file_path,ibtmp1:12M:autoextend
  271. innodb_tmpdir,
  272. innodb_undo_directory,./
  273. innodb_undo_log_truncate,OFF
  274. innodb_undo_tablespaces,0
  275. innodb_use_atomic_writes,ON
  276. innodb_use_native_aio,ON
  277. innodb_version,10.6.8
  278. innodb_write_io_threads,8
  279. insert_id,0
  280. interactive_timeout,7200
  281. join_buffer_size,262144
  282. join_buffer_space_limit,2097152
  283. join_cache_level,2
  284. keep_files_on_create,OFF
  285. key_buffer_size,16777216
  286. key_cache_age_threshold,300
  287. key_cache_block_size,1024
  288. key_cache_division_limit,100
  289. key_cache_file_hash_size,512
  290. key_cache_segments,0
  291. large_files_support,ON
  292. large_page_size,0
  293. large_pages,OFF
  294. last_gtid,
  295. last_insert_id,0
  296. lc_messages,en_US
  297. lc_messages_dir,
  298. lc_time_names,en_US
  299. license,GPL
  300. local_infile,ON
  301. lock_wait_timeout,7200
  302. locked_in_memory,OFF
  303. log_bin,ON
  304. log_bin_basename,/rdsdbdata/log/binlog/mysql-bin-changelog
  305. log_bin_compress,OFF
  306. log_bin_compress_min_len,256
  307. log_bin_index,/rdsdbdata/log/binlog/mysql-bin-changelog.index
  308. log_bin_trust_function_creators,ON
  309. log_disabled_statements,sp
  310. log_error,/rdsdbdata/log/error/mysql-error.log
  311. log_output,FILE
  312. log_queries_not_using_indexes,OFF
  313. log_slave_updates,ON
  314. log_slow_admin_statements,ON
  315. log_slow_disabled_statements,sp
  316. log_slow_filter,"admin,filesort,filesort_on_disk,filesort_priority_queue,full_join,full_scan,query_cache,query_cache_miss,tmp_table,tmp_table_on_disk"
  317. log_slow_rate_limit,1
  318. log_slow_slave_statements,ON
  319. log_slow_verbosity,"innodb,query_plan,explain"
  320. log_tc_size,24576
  321. log_warnings,2
  322. long_query_time,10.000000
  323. low_priority_updates,OFF
  324. lower_case_file_system,OFF
  325. lower_case_table_names,0
  326. master_verify_checksum,OFF
  327. max_allowed_packet,268435456
  328. max_binlog_cache_size,18446744073709547520
  329. max_binlog_size,134217728
  330. max_binlog_stmt_cache_size,18446744073709547520
  331. max_connect_errors,100
  332. max_connections,16000
  333. max_delayed_threads,20
  334. max_digest_length,1024
  335. max_error_count,64
  336. max_heap_table_size,423054278656
  337. max_insert_delayed_threads,20
  338. max_join_size,18446744073709551615
  339. max_length_for_sort_data,1024
  340. max_password_errors,4294967295
  341. max_prepared_stmt_count,16382
  342. max_recursive_iterations,1000
  343. max_relay_log_size,134217728
  344. max_rowid_filter_size,131072
  345. max_seeks_for_key,4294967295
  346. max_session_mem_used,9223372036854775807
  347. max_sort_length,1024
  348. max_sp_recursion_depth,0
  349. max_statement_time,7200.000000
  350. max_tmp_tables,32
  351. max_user_connections,0
  352. max_write_lock_count,4294967295
  353. metadata_locks_cache_size,1024
  354. metadata_locks_hash_instances,8
  355. min_examined_row_limit,0
  356. mrr_buffer_size,262144
  357. myisam_block_size,1024
  358. myisam_data_pointer_size,6
  359. myisam_max_sort_file_size,9223372036853727232
  360. myisam_mmap_size,18446744073709551615
  361. myisam_recover_options,"BACKUP,QUICK"
  362. myisam_repair_threads,1
  363. myisam_sort_buffer_size,134216704
  364. myisam_stats_method,NULLS_UNEQUAL
  365. myisam_use_mmap,OFF
  366. mysql56_temporal_format,ON
  367. net_buffer_length,16384
  368. net_read_timeout,120
  369. net_retry_count,10
  370. net_write_timeout,120
  371. old,OFF
  372. old_alter_table,DEFAULT
  373. old_mode,UTF8_IS_UTF8MB3
  374. old_passwords,OFF
  375. open_files_limit,112095
  376. optimizer_max_sel_arg_weight,32000
  377. optimizer_prune_level,1
  378. optimizer_search_depth,62
  379. optimizer_selectivity_sampling_limit,100
  380. 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=on,table_elimination=on,extended_keys=on,exists_to_in=on,orderby_uses_equalities=on,condition_pushdown_for_derived=on,split_materialized=on,condition_pushdown_for_subquery=on,rowid_filter=on,condition_pushdown_from_having=on,not_null_range_scan=off"
  381. optimizer_trace,enabled=off
  382. optimizer_trace_max_mem_size,1048576
  383. optimizer_use_condition_selectivity,4
  384. performance_schema,ON
  385. performance_schema_accounts_size,-1
  386. performance_schema_digests_size,10000
  387. performance_schema_events_stages_history_long_size,10000
  388. performance_schema_events_stages_history_size,10
  389. performance_schema_events_statements_history_long_size,10000
  390. performance_schema_events_statements_history_size,10
  391. performance_schema_events_transactions_history_long_size,10000
  392. performance_schema_events_transactions_history_size,10
  393. performance_schema_events_waits_history_long_size,10000
  394. performance_schema_events_waits_history_size,10
  395. performance_schema_hosts_size,-1
  396. performance_schema_max_cond_classes,90
  397. performance_schema_max_cond_instances,-1
  398. performance_schema_max_digest_length,1024
  399. performance_schema_max_file_classes,80
  400. performance_schema_max_file_handles,32768
  401. performance_schema_max_file_instances,-1
  402. performance_schema_max_index_stat,-1
  403. performance_schema_max_memory_classes,320
  404. performance_schema_max_metadata_locks,-1
  405. performance_schema_max_mutex_classes,210
  406. performance_schema_max_mutex_instances,-1
  407. performance_schema_max_prepared_statements_instances,-1
  408. performance_schema_max_program_instances,-1
  409. performance_schema_max_rwlock_classes,50
  410. performance_schema_max_rwlock_instances,-1
  411. performance_schema_max_socket_classes,10
  412. performance_schema_max_socket_instances,-1
  413. performance_schema_max_sql_text_length,1024
  414. performance_schema_max_stage_classes,160
  415. performance_schema_max_statement_classes,222
  416. performance_schema_max_statement_stack,10
  417. performance_schema_max_table_handles,-1
  418. performance_schema_max_table_instances,-1
  419. performance_schema_max_table_lock_stat,-1
  420. performance_schema_max_thread_classes,50
  421. performance_schema_max_thread_instances,-1
  422. performance_schema_session_connect_attrs_size,512
  423. performance_schema_setup_actors_size,-1
  424. performance_schema_setup_objects_size,-1
  425. performance_schema_users_size,-1
  426. pid_file,/rdsdbdata/log/mysql-3306.pid
  427. plugin_dir,/rdsdbbin/mariadb-10.6.8.R1/lib/plugin/
  428. plugin_maturity,gamma
  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. proxy_protocol_networks,
  436. proxy_user,
  437. pseudo_slave_mode,OFF
  438. pseudo_thread_id,989214
  439. query_alloc_block_size,16384
  440. query_cache_limit,0
  441. query_cache_min_res_unit,4096
  442. query_cache_size,0
  443. query_cache_strip_comments,OFF
  444. query_cache_type,OFF
  445. query_cache_wlock_invalidate,OFF
  446. query_prealloc_size,24576
  447. rand_seed1,907258234
  448. rand_seed2,30352913
  449. range_alloc_block_size,4096
  450. read_binlog_speed_limit,0
  451. read_buffer_size,262144
  452. read_only,OFF
  453. read_rnd_buffer_size,524288
  454. relay_log,/rdsdbdata/log/relaylog/relaylog
  455. relay_log_basename,/rdsdbdata/log/relaylog/relaylog
  456. relay_log_index,/rdsdbdata/log/relaylog/relaylog.index
  457. relay_log_info_file,relay-log.info
  458. relay_log_purge,ON
  459. relay_log_recovery,ON
  460. relay_log_space_limit,0
  461. replicate_annotate_row_events,ON
  462. replicate_do_db,
  463. replicate_do_table,
  464. replicate_events_marked_for_skip,REPLICATE
  465. replicate_ignore_db,
  466. replicate_ignore_table,"mysql.rds_sysinfo,mysql.rds_configuration,mysql.rds_replication_status,mysql.rds_history"
  467. replicate_wild_do_table,
  468. replicate_wild_ignore_table,
  469. report_host,
  470. report_password,
  471. report_port,3306
  472. report_user,
  473. require_secure_transport,OFF
  474. rocksdb_access_hint_on_compaction_start,1
  475. rocksdb_advise_random_on_open,ON
  476. rocksdb_allow_concurrent_memtable_write,OFF
  477. rocksdb_allow_mmap_reads,OFF
  478. rocksdb_allow_mmap_writes,OFF
  479. rocksdb_allow_to_start_after_corruption,OFF
  480. rocksdb_blind_delete_primary_key,OFF
  481. rocksdb_block_cache_size,536870912
  482. rocksdb_block_restart_interval,16
  483. rocksdb_block_size,4096
  484. rocksdb_block_size_deviation,10
  485. rocksdb_bulk_load,OFF
  486. rocksdb_bulk_load_allow_sk,OFF
  487. rocksdb_bulk_load_allow_unsorted,OFF
  488. rocksdb_bulk_load_size,1000
  489. rocksdb_bytes_per_sync,0
  490. rocksdb_cache_dump,ON
  491. rocksdb_cache_high_pri_pool_ratio,0.000000
  492. rocksdb_cache_index_and_filter_blocks,ON
  493. rocksdb_cache_index_and_filter_with_high_priority,ON
  494. rocksdb_checksums_pct,100
  495. rocksdb_collect_sst_properties,ON
  496. rocksdb_commit_in_the_middle,OFF
  497. rocksdb_commit_time_batch_for_recovery,ON
  498. rocksdb_compact_cf,
  499. rocksdb_compaction_readahead_size,0
  500. rocksdb_compaction_sequential_deletes,0
  501. rocksdb_compaction_sequential_deletes_count_sd,OFF
  502. rocksdb_compaction_sequential_deletes_file_size,0
  503. rocksdb_compaction_sequential_deletes_window,0
  504. rocksdb_create_checkpoint,
  505. rocksdb_create_if_missing,ON
  506. rocksdb_create_missing_column_families,OFF
  507. rocksdb_datadir,./#rocksdb
  508. rocksdb_db_write_buffer_size,0
  509. rocksdb_deadlock_detect,OFF
  510. rocksdb_deadlock_detect_depth,50
  511. rocksdb_debug_manual_compaction_delay,0
  512. rocksdb_debug_optimizer_no_zero_cardinality,ON
  513. rocksdb_debug_ttl_ignore_pk,OFF
  514. rocksdb_debug_ttl_read_filter_ts,0
  515. rocksdb_debug_ttl_rec_ts,0
  516. rocksdb_debug_ttl_snapshot_ts,0
  517. rocksdb_default_cf_options,
  518. rocksdb_delayed_write_rate,0
  519. rocksdb_delete_cf,
  520. rocksdb_delete_obsolete_files_period_micros,21600000000
  521. rocksdb_enable_2pc,ON
  522. rocksdb_enable_bulk_load_api,ON
  523. rocksdb_enable_insert_with_update_caching,ON
  524. rocksdb_enable_thread_tracking,ON
  525. rocksdb_enable_ttl,ON
  526. rocksdb_enable_ttl_read_filtering,ON
  527. rocksdb_enable_write_thread_adaptive_yield,OFF
  528. rocksdb_error_if_exists,OFF
  529. rocksdb_error_on_suboptimal_collation,ON
  530. rocksdb_flush_log_at_trx_commit,1
  531. rocksdb_force_compute_memtable_stats,ON
  532. rocksdb_force_compute_memtable_stats_cachetime,60000000
  533. rocksdb_force_flush_memtable_and_lzero_now,OFF
  534. rocksdb_force_flush_memtable_now,OFF
  535. rocksdb_force_index_records_in_range,0
  536. rocksdb_git_hash,
  537. rocksdb_hash_index_allow_collision,ON
  538. rocksdb_ignore_datadic_errors,0
  539. rocksdb_ignore_unknown_options,ON
  540. rocksdb_index_type,kBinarySearch
  541. rocksdb_info_log_level,error_level
  542. rocksdb_io_write_timeout,0
  543. rocksdb_is_fd_close_on_exec,ON
  544. rocksdb_keep_log_file_num,10
  545. rocksdb_large_prefix,OFF
  546. rocksdb_lock_scanned_rows,OFF
  547. rocksdb_lock_wait_timeout,1
  548. rocksdb_log_dir,/rdsdbdata/log/error_rocksdb
  549. rocksdb_log_file_time_to_roll,60
  550. rocksdb_manifest_preallocation_size,4194304
  551. rocksdb_manual_compaction_threads,0
  552. rocksdb_manual_wal_flush,ON
  553. rocksdb_master_skip_tx_api,OFF
  554. rocksdb_max_background_jobs,2
  555. rocksdb_max_latest_deadlocks,5
  556. rocksdb_max_log_file_size,104857600
  557. rocksdb_max_manifest_file_size,1073741824
  558. rocksdb_max_manual_compactions,10
  559. rocksdb_max_open_files,56047
  560. rocksdb_max_row_locks,1048576
  561. rocksdb_max_subcompactions,1
  562. rocksdb_max_total_wal_size,0
  563. rocksdb_merge_buf_size,67108864
  564. rocksdb_merge_combine_read_size,1073741824
  565. rocksdb_merge_tmp_file_removal_delay_ms,0
  566. rocksdb_new_table_reader_for_compaction_inputs,OFF
  567. rocksdb_no_block_cache,OFF
  568. rocksdb_override_cf_options,
  569. rocksdb_paranoid_checks,ON
  570. rocksdb_pause_background_work,OFF
  571. rocksdb_perf_context_level,0
  572. rocksdb_persistent_cache_path,
  573. rocksdb_persistent_cache_size_mb,0
  574. rocksdb_pin_l0_filter_and_index_blocks_in_cache,ON
  575. rocksdb_print_snapshot_conflict_queries,OFF
  576. rocksdb_rate_limiter_bytes_per_sec,0
  577. rocksdb_records_in_range,0
  578. rocksdb_remove_mariabackup_checkpoint,OFF
  579. rocksdb_reset_stats,OFF
  580. rocksdb_rollback_on_timeout,OFF
  581. rocksdb_seconds_between_stat_computes,3600
  582. rocksdb_signal_drop_index_thread,OFF
  583. rocksdb_sim_cache_size,0
  584. rocksdb_skip_bloom_filter_on_read,OFF
  585. rocksdb_skip_fill_cache,OFF
  586. rocksdb_skip_unique_check_tables,.*
  587. rocksdb_sst_mgr_rate_bytes_per_sec,0
  588. rocksdb_stats_dump_period_sec,600
  589. rocksdb_stats_level,0
  590. rocksdb_stats_recalc_rate,0
  591. rocksdb_store_row_debug_checksums,OFF
  592. rocksdb_strict_collation_check,ON
  593. rocksdb_strict_collation_exceptions,
  594. rocksdb_supported_compression_types,Zlib
  595. rocksdb_table_cache_numshardbits,6
  596. rocksdb_table_stats_sampling_pct,10
  597. rocksdb_tmpdir,/rdsdbdata/tmp
  598. rocksdb_trace_sst_api,OFF
  599. rocksdb_two_write_queues,ON
  600. rocksdb_unsafe_for_binlog,OFF
  601. rocksdb_update_cf_options,
  602. rocksdb_use_adaptive_mutex,OFF
  603. rocksdb_use_clock_cache,OFF
  604. rocksdb_use_direct_io_for_flush_and_compaction,OFF
  605. rocksdb_use_direct_reads,OFF
  606. rocksdb_use_fsync,OFF
  607. rocksdb_validate_tables,1
  608. rocksdb_verify_row_debug_checksums,OFF
  609. rocksdb_wal_bytes_per_sync,0
  610. rocksdb_wal_dir,/rdsdbdata/log/rocksdb
  611. rocksdb_wal_recovery_mode,1
  612. rocksdb_wal_size_limit_mb,0
  613. rocksdb_wal_ttl_seconds,0
  614. rocksdb_whole_key_filtering,ON
  615. rocksdb_write_batch_max_bytes,0
  616. rocksdb_write_disable_wal,OFF
  617. rocksdb_write_ignore_missing_column_families,OFF
  618. rocksdb_write_policy,write_committed
  619. rowid_merge_buff_size,8388608
  620. rpl_semi_sync_master_enabled,OFF
  621. rpl_semi_sync_master_timeout,10000
  622. rpl_semi_sync_master_trace_level,32
  623. rpl_semi_sync_master_wait_no_slave,ON
  624. rpl_semi_sync_master_wait_point,AFTER_COMMIT
  625. rpl_semi_sync_slave_delay_master,OFF
  626. rpl_semi_sync_slave_enabled,OFF
  627. rpl_semi_sync_slave_kill_conn_timeout,5
  628. rpl_semi_sync_slave_trace_level,32
  629. secure_auth,ON
  630. secure_file_priv,/secure_file_priv_dir/
  631. secure_timestamp,NO
  632. server_id,826979191
  633. session_track_schema,ON
  634. session_track_state_change,OFF
  635. session_track_system_variables,"autocommit,character_set_client,character_set_connection,character_set_results,time_zone"
  636. session_track_transaction_info,OFF
  637. skip_external_locking,ON
  638. skip_name_resolve,ON
  639. skip_networking,OFF
  640. skip_parallel_replication,OFF
  641. skip_replication,OFF
  642. skip_show_database,OFF
  643. slave_compressed_protocol,OFF
  644. slave_ddl_exec_mode,IDEMPOTENT
  645. slave_domain_parallel_threads,0
  646. slave_exec_mode,STRICT
  647. slave_load_tmpdir,/rdsdbdata/tmp
  648. slave_max_allowed_packet,1073741824
  649. slave_net_timeout,60
  650. slave_parallel_max_queued,131072
  651. slave_parallel_mode,optimistic
  652. slave_parallel_threads,0
  653. slave_parallel_workers,0
  654. slave_run_triggers_for_rbr,NO
  655. slave_skip_errors,OFF
  656. slave_sql_verify_checksum,ON
  657. slave_transaction_retries,10
  658. slave_transaction_retry_errors,"1158,1159,1160,1161,1205,1213,1429,2013,12701"
  659. slave_transaction_retry_interval,0
  660. slave_type_conversions,
  661. slow_launch_time,2
  662. slow_query_log,ON
  663. slow_query_log_file,/rdsdbdata/log/slowquery/mysql-slowquery.log
  664. socket,/tmp/mysql.sock
  665. sort_buffer_size,2097152
  666. sql_auto_is_null,OFF
  667. sql_big_selects,ON
  668. sql_buffer_result,OFF
  669. sql_if_exists,OFF
  670. sql_log_bin,ON
  671. sql_log_off,OFF
  672. sql_mode,NO_ENGINE_SUBSTITUTION
  673. sql_notes,ON
  674. sql_quote_show_create,ON
  675. sql_safe_updates,OFF
  676. sql_select_limit,18446744073709551615
  677. sql_slave_skip_counter,0
  678. sql_warnings,OFF
  679. ssl_ca,/rdsdbdata/rds-metadata/ca-cert.pem
  680. ssl_capath,
  681. ssl_cert,/rdsdbdata/rds-metadata/server-cert.pem
  682. ssl_cipher,ECDHE-RSA-AES256-GCM-SHA384:ECDHE-RSA-AES128-GCM-SHA256:ECDHE-RSA-AES256-SHA384:ECDHE-RSA-AES128-SHA256:ECDHE-RSA-AES256-SHA:ECDHE-RSA-AES128-SHA:AES256-GCM-SHA384:AES128-GCM-SHA256:AES256-SHA:AES128-SHA:DHE-RSA-AES128-SHA:DHE-RSA-AES256-SHA:DHE-DSS-AES128-SHA:DHE-DSS-AES256-SHA
  683. ssl_crl,
  684. ssl_crlpath,
  685. ssl_key,/rdsdbdata/rds-metadata/server-key.pem
  686. standard_compliant_cte,ON
  687. storage_engine,InnoDB
  688. stored_program_cache,256
  689. strict_password_validation,ON
  690. sync_binlog,0
  691. sync_frm,ON
  692. sync_master_info,10000
  693. sync_relay_log,10000
  694. sync_relay_log_info,10000
  695. system_time_zone,UTC
  696. system_versioning_alter_history,ERROR
  697. system_versioning_asof,DEFAULT
  698. table_definition_cache,400
  699. table_open_cache,6000
  700. table_open_cache_instances,8
  701. tcp_keepalive_interval,0
  702. tcp_keepalive_probes,0
  703. tcp_keepalive_time,0
  704. tcp_nodelay,ON
  705. thread_cache_size,256
  706. thread_handling,one-thread-per-connection
  707. thread_pool_dedicated_listener,OFF
  708. thread_pool_exact_stats,OFF
  709. thread_pool_idle_timeout,60
  710. thread_pool_max_threads,65536
  711. thread_pool_oversubscribe,3
  712. thread_pool_prio_kickup_timer,1000
  713. thread_pool_priority,auto
  714. thread_pool_size,64
  715. thread_pool_stall_limit,500
  716. thread_stack,262144
  717. time_format,%H:%i:%s
  718. time_zone,UTC
  719. timestamp,1661342169.921250
  720. tls_version,"TLSv1.1,TLSv1.2,TLSv1.3"
  721. tmp_disk_table_size,18446744073709551615
  722. tmp_memory_table_size,134217728
  723. tmp_table_size,134217728
  724. tmpdir,/rdsdbdata/tmp
  725. transaction_alloc_block_size,8192
  726. transaction_prealloc_size,4096
  727. tx_isolation,READ-COMMITTED
  728. tx_read_only,OFF
  729. unique_checks,ON
  730. updatable_views_with_limit,YES
  731. use_stat_tables,PREFERABLY_FOR_QUERIES
  732. userstat,ON
  733. version,10.6.8-MariaDB-log
  734. version_comment,"managed by https://aws.amazon.com/rds/"
  735. version_compile_machine,x86_64
  736. version_compile_os,Linux
  737. version_malloc_library,"jemalloc 0.0.0-0-g0000000000000000000000000000000000000000"
  738. version_source_revision,
  739. version_ssl_library,"OpenSSL 1.1.1o 3 May 2022"
  740. wait_timeout,7200
  741. warning_count,0
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement