알리구매 가죽 프레스

저작자표시 비영리 변경금지

'기타' 카테고리의 다른 글

3.5파이 이어폰 단자  (0) 2023.03.16
[배터리] 18650 vs 14500 규격(사이즈)  (0) 2023.03.12
Nifi / Python을 Windows Service 로 실행  (0) 2022.02.21
Zotac egpu 와 2018 LG gram 연결 정보  (0) 2021.01.08
마우스 스위치 모음  (0) 2020.02.15

 

 

 

 

저작자표시 비영리 변경금지

'기타 > WoodWorking' 카테고리의 다른 글

[웍스][WORX] WX531  (0) 2023.03.12

- Show Global variables like '%%';

Variable_name Value Description
activate_all_roles_on_login OFF  
admin_address ""  
admin_port 33062  
admin_ssl_ca ""  
admin_ssl_capath ""  
admin_ssl_cert ""  
admin_ssl_cipher ""  
admin_ssl_crl ""  
admin_ssl_crlpath ""  
admin_ssl_key ""  
admin_tls_ciphersuites ""  
admin_tls_version TLSv1,TLSv1.1,TLSv1.2,TLSv1.3  
auto_generate_certs ON  
auto_increment_increment 1 ✔️ Auto increment 컬럼의 증가값을 결정
auto_increment_offset 1 ✔️ Auto increment 컬럼의 초기 시작값을 지정
autocommit ON  
automatic_sp_privileges ON  
avoid_temporal_upgrade OFF  
back_log 80  
basedir C:\Program Files\MySQL\MySQL Server 8.0\  
big_tables OFF  
bind_address *  
binlog_cache_size 32768  
binlog_checksum CRC32  
binlog_direct_non_transactional_updates OFF  
binlog_encryption OFF  
binlog_error_action ABORT_SERVER  
binlog_expire_logs_seconds 2592000  
binlog_format ROW ✔️ Replication Slave 서버는 이벤트를 지정된 포맷으로 읽는다.
✔️ STATEMENT(1): 명령문 기반 리플리케이션
✔️ ROW(2): 열 기반 리플리케이션
✔️ MIXED(3): 혼합 기반 리플리케이션
binlog_group_commit_sync_delay 0  
binlog_group_commit_sync_no_delay_count 0  
binlog_gtid_simple_recovery ON  
binlog_max_flush_queue_time 0  
binlog_order_commits ON  
binlog_rotate_encryption_master_key_at_startup OFF  
binlog_row_event_max_size 8192  
binlog_row_image FULL  
binlog_row_metadata MINIMAL  
binlog_row_value_options ""  
binlog_rows_query_log_events OFF  
binlog_stmt_cache_size 32768  
binlog_transaction_compression OFF  
binlog_transaction_compression_level_zstd 3  
binlog_transaction_dependency_history_size 25000  
binlog_transaction_dependency_tracking COMMIT_ORDER  
block_encryption_mode aes-128-ecb  
bulk_insert_buffer_size 8388608  
caching_sha2_password_auto_generate_rsa_keys ON  
caching_sha2_password_digest_rounds 5000  
caching_sha2_password_private_key_path private_key.pem  
caching_sha2_password_public_key_path public_key.pem  
character_set_client utf8mb4  
character_set_connection utf8mb4  
character_set_database utf8mb4  
character_set_filesystem binary  
character_set_results utf8mb4  
character_set_server utf8mb4  
character_set_system utf8mb3  
character_sets_dir C:\Program Files\MySQL\MySQL Server 8.0\share\charsets\  
check_proxy_users OFF  
collation_connection utf8mb4_0900_ai_ci  
collation_database utf8mb4_0900_ai_ci  
collation_server utf8mb4_0900_ai_ci  
completion_type NO_CHAIN  
concurrent_insert AUTO  
connect_timeout 10 ✔️ mysqld 서버가 불량 핸드셰이크로 응답하기 전에 연결 패킷을 기다리는 시간(초)입니다.
✔️ 기본값은 10초입니다.
✔️ 클라이언트에서 MySQL 서버에 대한 연결이 'XXX'에서 손실된 경우, 시스템 오류: errno 형식의 오류가 자주 발생하는 경우 connect_timeout 값을 증가시키면 도움이 될 수 있습니다.
core_file OFF  
create_admin_listener_thread OFF  
cte_max_recursion_depth 1000  
datadir d:\MySQL\MySQL Server 8.0_25004\Data\  
default_authentication_plugin mysql_native_password  
default_collation_for_utf8mb4 utf8mb4_0900_ai_ci  
default_password_lifetime 0  
default_storage_engine InnoDB  
default_table_encryption OFF  
default_tmp_storage_engine InnoDB  
default_week_format 0  
delay_key_write ON  
delayed_insert_limit 100  
delayed_insert_timeout 300  
delayed_queue_size 1000  
disabled_storage_engines ""  
disconnect_on_expired_password ON  
div_precision_increment 4  
end_markers_in_json OFF  
enforce_gtid_consistency OFF  
eq_range_index_dive_limit 200  
event_scheduler ON  
expire_logs_days 0  
explicit_defaults_for_timestamp ON  
flush OFF  
flush_time 0  
foreign_key_checks ON  
ft_boolean_syntax "+ -><()~*:""""&|"  
ft_max_word_len 84  
ft_min_word_len 4  
ft_query_expansion_limit 20  
ft_stopword_file (built-in)  
general_log OFF  
general_log_file DEV-DB133.log  
generated_random_password_length 20  
group_concat_max_len 1024  
group_replication_consistency EVENTUAL  
gtid_executed ""  
gtid_executed_compression_period 0  
gtid_mode OFF  
gtid_owned ""  
gtid_purged ""  
have_compress YES  
have_dynamic_loading YES  
have_geometry YES  
have_openssl YES  
have_profiling YES  
have_query_cache NO  
have_rtree_keys YES  
have_ssl YES  
have_statement_timeout YES  
have_symlink DISABLED  
histogram_generation_max_mem_size 20000000  
host_cache_size 628  
hostname DEV-DB133  
information_schema_stats_expiry 86400  
init_connect ""  
init_file ""  
init_replica ""  
init_slave ""  
innodb_adaptive_flushing ON  
innodb_adaptive_flushing_lwm 10  
innodb_adaptive_hash_index ON  
innodb_adaptive_hash_index_parts 8  
innodb_adaptive_max_sleep_delay 150000  
innodb_api_bk_commit_interval 5  
innodb_api_disable_rowlock OFF  
innodb_api_enable_binlog OFF  
innodb_api_enable_mdl OFF  
innodb_api_trx_level 0  
innodb_autoextend_increment 64  
innodb_autoinc_lock_mode 2  
innodb_buffer_pool_chunk_size 8388608  
innodb_buffer_pool_dump_at_shutdown ON  
innodb_buffer_pool_dump_now OFF  
innodb_buffer_pool_dump_pct 25  
innodb_buffer_pool_filename ib_buffer_pool  
innodb_buffer_pool_in_core_file ON  
innodb_buffer_pool_instances 1  
innodb_buffer_pool_load_abort OFF  
innodb_buffer_pool_load_at_startup ON  
innodb_buffer_pool_load_now OFF  
innodb_buffer_pool_size 8388608  
innodb_change_buffer_max_size 25  
innodb_change_buffering all  
innodb_checksum_algorithm crc32  
innodb_cmp_per_index_enabled OFF  
innodb_commit_concurrency 0  
innodb_compression_failure_threshold_pct 5  
innodb_compression_level 6  
innodb_compression_pad_pct_max 50  
innodb_concurrency_tickets 5000  
innodb_data_file_path ibdata1:12M:autoextend  
innodb_data_home_dir ""  
innodb_deadlock_detect ON  
innodb_dedicated_server OFF  
innodb_default_row_format dynamic  
innodb_directories ""  
innodb_disable_sort_file_cache OFF  
innodb_doublewrite ON  
innodb_doublewrite_batch_size 0  
innodb_doublewrite_dir ""  
innodb_doublewrite_files 2  
innodb_doublewrite_pages 4  
innodb_extend_and_initialize ON  
innodb_fast_shutdown 1  
innodb_file_per_table ON  
innodb_fill_factor 100  
innodb_flush_log_at_timeout 1  
innodb_flush_log_at_trx_commit 1  
innodb_flush_method unbuffered  
innodb_flush_neighbors 0  
innodb_flush_sync ON  
innodb_flushing_avg_loops 30  
innodb_force_load_corrupted OFF  
innodb_force_recovery 0  
innodb_fsync_threshold 0  
innodb_ft_aux_table ""  
innodb_ft_cache_size 8000000  
innodb_ft_enable_diag_print OFF  
innodb_ft_enable_stopword ON  
innodb_ft_max_token_size 84  
innodb_ft_min_token_size 3  
innodb_ft_num_word_optimize 2000  
innodb_ft_result_cache_limit 2000000000  
innodb_ft_server_stopword_table ""  
innodb_ft_sort_pll_degree 2  
innodb_ft_total_cache_size 640000000  
innodb_ft_user_stopword_table ""  
innodb_idle_flush_pct 100  
innodb_io_capacity 200  
innodb_io_capacity_max 2000  
innodb_lock_wait_timeout 50  
innodb_log_buffer_size 1048576  
innodb_log_checksums ON  
innodb_log_compressed_pages ON  
innodb_log_file_size 50331648  
innodb_log_files_in_group 2  
innodb_log_group_home_dir .\  
innodb_log_spin_cpu_abs_lwm 80  
innodb_log_spin_cpu_pct_hwm 50  
innodb_log_wait_for_flush_spin_hwm 400  
innodb_log_write_ahead_size 8192  
innodb_log_writer_threads ON  
innodb_lru_scan_depth 1024  
innodb_max_dirty_pages_pct 90.000000  
innodb_max_dirty_pages_pct_lwm 10.000000  
innodb_max_purge_lag 0  
innodb_max_purge_lag_delay 0  
innodb_max_undo_log_size 1073741824  
innodb_monitor_disable ""  
innodb_monitor_enable ""  
innodb_monitor_reset ""  
innodb_monitor_reset_all ""  
innodb_old_blocks_pct 37  
innodb_old_blocks_time 1000  
innodb_online_alter_log_max_size 134217728  
innodb_open_files 300  
innodb_optimize_fulltext_only OFF  
innodb_page_cleaners 1  
innodb_page_size 16384  
innodb_parallel_read_threads 4  
innodb_print_all_deadlocks OFF  
innodb_print_ddl_logs OFF  
innodb_purge_batch_size 300  
innodb_purge_rseg_truncate_frequency 128  
innodb_purge_threads 4  
innodb_random_read_ahead OFF  
innodb_read_ahead_threshold 56  
innodb_read_io_threads 4  
innodb_read_only OFF  
innodb_redo_log_archive_dirs ""  
innodb_redo_log_encrypt OFF  
innodb_replication_delay 0  
innodb_rollback_on_timeout OFF  
innodb_rollback_segments 128  
innodb_segment_reserve_factor 12.500000  
innodb_sort_buffer_size 1048576  
innodb_spin_wait_delay 6  
innodb_spin_wait_pause_multiplier 50  
innodb_stats_auto_recalc ON  
innodb_stats_include_delete_marked OFF  
innodb_stats_method nulls_equal  
innodb_stats_on_metadata OFF  
innodb_stats_persistent ON  
innodb_stats_persistent_sample_pages 20  
innodb_stats_transient_sample_pages 8  
innodb_status_output OFF  
innodb_status_output_locks OFF  
innodb_strict_mode ON  
innodb_sync_array_size 1  
innodb_sync_spin_loops 30  
innodb_table_locks ON  
innodb_temp_data_file_path ibtmp1:12M:autoextend  
innodb_temp_tablespaces_dir .\#innodb_temp\  
innodb_thread_concurrency 17  
innodb_thread_sleep_delay 0  
innodb_tmpdir ""  
innodb_undo_directory .\  
innodb_undo_log_encrypt OFF  
innodb_undo_log_truncate ON  
innodb_undo_tablespaces 2  
innodb_use_fdatasync OFF  
innodb_use_native_aio ON  
innodb_validate_tablespace_paths ON  
innodb_version 8.0.26  
innodb_write_io_threads 4  
interactive_timeout 28800  
internal_tmp_mem_storage_engine TempTable  
join_buffer_size 262144  
keep_files_on_create OFF  
key_buffer_size 8388608  
key_cache_age_threshold 300  
key_cache_block_size 1024  
key_cache_division_limit 100  
keyring_operations ON  
large_files_support ON  
large_page_size 0  
large_pages OFF  
lc_messages en_US  
lc_messages_dir C:\Program Files\MySQL\MySQL Server 8.0\share\  
lc_time_names en_US  
license GPL  
local_infile OFF  
lock_wait_timeout 31536000 ✔️ lock 이 걸린 테이블에 질의를 할때 락이 풀리기 까지 대기할 시간
✔️ innodb 테이블 에서도 본 시간에 따라  lock wait 후 "Lock wait timeout exceeded; try restarting transaction" 오류 발생
log_bin ON  
log_bin_basename d:\MySQL\MySQL Server 8.0_25004\Data\DEV-DB133-bin  
log_bin_index d:\MySQL\MySQL Server 8.0_25004\Data\DEV-DB133-bin.index  
log_bin_trust_function_creators OFF  
log_bin_use_v1_row_events OFF  
log_error .\DEV-DB133.err  
log_error_services log_filter_internal; log_sink_internal  
log_error_suppression_list ""  
log_error_verbosity 2  
log_output FILE  
log_queries_not_using_indexes OFF ✔️ 인덱스를 사용하지 않은 쿼리도 slow query log에 기록함
log_raw OFF  
log_replica_updates ON  
log_slave_updates ON  
log_slow_admin_statements OFF  
log_slow_extra OFF  
log_slow_replica_statements OFF  
log_slow_slave_statements OFF  
log_statements_unsafe_for_binlog ON  
log_throttle_queries_not_using_indexes 0  
log_timestamps UTC  
long_query_time 1.000000  
low_priority_updates OFF  
lower_case_file_system ON  
lower_case_table_names 1  
mandatory_roles ""  
master_info_repository TABLE  
master_verify_checksum OFF  
max_allowed_packet 4194304  
max_binlog_cache_size 18446744073709547520  
max_binlog_size 1073741824  
max_binlog_stmt_cache_size 18446744073709547520  
max_connect_errors 100 ✔️ 호스트 연속 연결 요청이 연결에 성공하지 못한 상태에서 중단되면 서버는 해당 호스트를 추가 연결에서 차단합니다. 
✔️ 이전 연결이 중단된 후 max_connect_errors 시도 횟수보다 적은 시간 내에 호스트로부터의 연결이 성공적으로 설정된 경우 호스트의 오류 수는 0으로 지워집니다.
✔️ 차단된 호스트의 차단을 해제하려면 호스트 캐시를 플러시합니다.
max_connections 500 ✔️ 최대 동시 클라이언트 연결 수입니다.
max_delayed_threads 20  
max_digest_length 1024  
max_error_count 1024  
max_execution_time 0  
max_heap_table_size 16777216  
max_insert_delayed_threads 20  
max_join_size 18446744073709551615  
max_length_for_sort_data 4096  
max_points_in_geometry 65536  
max_prepared_stmt_count 16382  
max_relay_log_size 0  
max_seeks_for_key 4294967295  
max_sort_length 1024  
max_sp_recursion_depth 0  
max_user_connections 0 ✔️ 지정된 MySQL 사용자 계정에 허용된 최대 동시 연결 수입니다.
✔️ 값이 0(기본값)이면 "제한 없음"을 의미합니다.
✔️ 이 변수는 서버 시작 또는 런타임에 설정할 수 있는 전역 값을 가집니다. 또한 현재 세션과 연결된 계정에 적용되는 유효한 동시 연결 제한을 나타내는 읽기 전용 세션 값도 있습니다.
✔️ 세션 값은 다음과 같이 초기화됩니다.
- 사용자 계정에 0이 아닌 MAX_USER_CONNECTION 리소스 제한이 있는 경우 세션 max_user_connections 값이 해당 제한으로 설정됩니다.
그렇지 않으면 세션 max_user_connections 값이 글로벌 값으로 설정됩니다.
- 계정 리소스 제한은 CREATE USER 또는 ALTER USER 문을 사용하여 지정됩니다.
max_write_lock_count 4294967295  
min_examined_row_limit 0  
myisam_data_pointer_size 6  
myisam_max_sort_file_size 107374182400  
myisam_mmap_size 18446744073709551615  
myisam_recover_options OFF  
myisam_repair_threads 1  
myisam_sort_buffer_size 52428800  
myisam_stats_method nulls_unequal  
myisam_use_mmap OFF  
mysql_native_password_proxy_users OFF  
mysqlx_bind_address *  
mysqlx_compression_algorithms DEFLATE_STREAM,LZ4_MESSAGE,ZSTD_STREAM  
mysqlx_connect_timeout 30  
mysqlx_deflate_default_compression_level 3  
mysqlx_deflate_max_client_compression_level 5  
mysqlx_document_id_unique_prefix 0  
mysqlx_enable_hello_notice ON  
mysqlx_idle_worker_thread_timeout 60  
mysqlx_interactive_timeout 28800  
mysqlx_lz4_default_compression_level 2  
mysqlx_lz4_max_client_compression_level 8  
mysqlx_max_allowed_packet 67108864  
mysqlx_max_connections 100  
mysqlx_min_worker_threads 2  
mysqlx_port 33060  
mysqlx_port_open_timeout 0  
mysqlx_read_timeout 30  
mysqlx_socket /tmp/mysqlx.sock  
mysqlx_ssl_ca ""  
mysqlx_ssl_capath ""  
mysqlx_ssl_cert ""  
mysqlx_ssl_cipher ""  
mysqlx_ssl_crl ""  
mysqlx_ssl_crlpath ""  
mysqlx_ssl_key ""  
mysqlx_wait_timeout 28800  
mysqlx_write_timeout 60  
mysqlx_zstd_default_compression_level 3  
mysqlx_zstd_max_client_compression_level 11  
named_pipe OFF  
named_pipe_full_access_group ""  
net_buffer_length 16384  
net_read_timeout 30  
net_retry_count 10  
net_write_timeout 60  
new OFF  
ngram_token_size 2  
offline_mode OFF  
old OFF  
old_alter_table OFF  
open_files_limit 6558  
optimizer_prune_level 1  
optimizer_search_depth 62  
optimizer_switch 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,duplicateweedout=on,subquery_materialization_cost_based=on,use_index_extensions=on,condition_fanout_filter=on,derived_merge=on,use_invisible_indexes=off,skip_scan=on,hash_join=on,subquery_to_derived=off,prefer_ordering_index=on,hypergraph_optimizer=off,derived_condition_pushdown=on  
optimizer_trace enabled=off,one_line=off  
optimizer_trace_features greedy_search=on,range_optimizer=on,dynamic_range=on,repeated_subselect=on  
optimizer_trace_limit 1  
optimizer_trace_max_mem_size 1048576  
optimizer_trace_offset -1  
parser_max_mem_size 18446744073709551615  
partial_revokes OFF  
password_history 0  
password_require_current OFF  
password_reuse_interval 0  
performance_schema ON  
performance_schema_accounts_size -1  
performance_schema_digests_size 10000  
performance_schema_error_size 4946  
performance_schema_events_stages_history_long_size 10000  
performance_schema_events_stages_history_size 10  
performance_schema_events_statements_history_long_size 10000  
performance_schema_events_statements_history_size 10  
performance_schema_events_transactions_history_long_size 10000  
performance_schema_events_transactions_history_size 10  
performance_schema_events_waits_history_long_size 10000  
performance_schema_events_waits_history_size 10  
performance_schema_hosts_size -1  
performance_schema_max_cond_classes 100  
performance_schema_max_cond_instances -1  
performance_schema_max_digest_length 1024  
performance_schema_max_digest_sample_age 60  
performance_schema_max_file_classes 80  
performance_schema_max_file_handles 32768  
performance_schema_max_file_instances -1  
performance_schema_max_index_stat -1  
performance_schema_max_memory_classes 450  
performance_schema_max_metadata_locks -1  
performance_schema_max_mutex_classes 300  
performance_schema_max_mutex_instances -1  
performance_schema_max_prepared_statements_instances -1  
performance_schema_max_program_instances -1  
performance_schema_max_rwlock_classes 60  
performance_schema_max_rwlock_instances -1  
performance_schema_max_socket_classes 10  
performance_schema_max_socket_instances -1  
performance_schema_max_sql_text_length 1024  
performance_schema_max_stage_classes 175  
performance_schema_max_statement_classes 218  
performance_schema_max_statement_stack 10  
performance_schema_max_table_handles -1  
performance_schema_max_table_instances -1  
performance_schema_max_table_lock_stat -1  
performance_schema_max_thread_classes 100  
performance_schema_max_thread_instances -1  
performance_schema_session_connect_attrs_size 512  
performance_schema_setup_actors_size -1  
performance_schema_setup_objects_size -1  
performance_schema_show_processlist OFF  
performance_schema_users_size -1  
persist_only_admin_x509_subject ""  
persisted_globals_load ON  
pid_file d:\MySQL\MySQL Server 8.0_25004\Data\DEV-DB133.pid  
plugin_dir C:\Program Files\MySQL\MySQL Server 8.0\lib\plugin\  
port 25004  
preload_buffer_size 32768  
print_identified_with_as_hex OFF  
profiling OFF  
profiling_history_size 15  
protocol_compression_algorithms zlib,zstd,uncompressed  
protocol_version 10  
query_alloc_block_size 8192  
query_prealloc_size 8192  
range_alloc_block_size 4096  
range_optimizer_max_mem_size 8388608  
rbr_exec_mode STRICT  
read_buffer_size 65536  
read_only OFF  
read_rnd_buffer_size 262144  
regexp_stack_limit 8000000  
regexp_time_limit 32  
relay_log DEV-DB133-relay-bin  
relay_log_basename d:\MySQL\MySQL Server 8.0_25004\Data\DEV-DB133-relay-bin  
relay_log_index d:\MySQL\MySQL Server 8.0_25004\Data\DEV-DB133-relay-bin.index  
relay_log_info_file relay-log.info  
relay_log_info_repository TABLE  
relay_log_purge ON  
relay_log_recovery OFF  
relay_log_space_limit 0  
replica_allow_batching OFF  
replica_checkpoint_group 512  
replica_checkpoint_period 300  
replica_compressed_protocol OFF  
replica_exec_mode STRICT  
replica_load_tmpdir C:\Windows\SERVIC~1\NETWOR~1\AppData\Local\Temp  
replica_max_allowed_packet 1073741824  
replica_net_timeout 60  
replica_parallel_type DATABASE  
replica_parallel_workers 0  
replica_pending_jobs_size_max 134217728  
replica_preserve_commit_order OFF  
replica_skip_errors OFF  
replica_sql_verify_checksum ON  
replica_transaction_retries 10  
replica_type_conversions ""  
replication_optimize_for_static_plugin_config OFF  
replication_sender_observe_commit_only OFF  
report_host ""  
report_password ""  
report_port 25004  
report_user ""  
require_secure_transport OFF  
rpl_read_size 8192  
rpl_stop_replica_timeout 31536000  
rpl_stop_slave_timeout 31536000  
schema_definition_cache 256  
secondary_engine_cost_threshold 100000.000000  
secure_file_priv d:\MySQL\MySQL Server 8.0_25004\Uploads\  
select_into_buffer_size 131072  
select_into_disk_sync OFF  
select_into_disk_sync_delay 0  
server_id 1  
server_id_bits 32  
server_uuid 29f4b9a  
session_track_gtids OFF  
session_track_schema ON  
session_track_state_change OFF  
session_track_system_variables time_zone,autocommit,character_set_client,character_set_results,character_set_connection  
session_track_transaction_info OFF  
sha256_password_auto_generate_rsa_keys ON  
sha256_password_private_key_path private_key.pem  
sha256_password_proxy_users OFF  
sha256_password_public_key_path public_key.pem  
shared_memory OFF  
shared_memory_base_name MYSQL  
show_create_table_verbosity OFF  
show_old_temporals OFF  
skip_external_locking ON  
skip_name_resolve OFF  
skip_networking OFF  
skip_replica_start OFF  
skip_show_database OFF  
skip_slave_start OFF  
slave_allow_batching OFF  
slave_checkpoint_group 512  
slave_checkpoint_period 300  
slave_compressed_protocol OFF  
slave_exec_mode STRICT  
slave_load_tmpdir C:\Windows\SERVIC~1\NETWOR~1\AppData\Local\Temp  
slave_max_allowed_packet 1073741824  
slave_net_timeout 60  
slave_parallel_type DATABASE  
slave_parallel_workers 0  
slave_pending_jobs_size_max 134217728  
slave_preserve_commit_order OFF  
slave_rows_search_algorithms INDEX_SCAN,HASH_SCAN  
slave_skip_errors OFF  
slave_sql_verify_checksum ON  
slave_transaction_retries 10  
slave_type_conversions ""  
slow_launch_time 2  
slow_query_log ON  
slow_query_log_file DEV-DB133-slow.log  
socket MySQL  
sort_buffer_size 262144  
source_verify_checksum OFF  
sql_auto_is_null OFF  
sql_big_selects ON  
sql_buffer_result OFF  
sql_log_off OFF  
sql_mode STRICT_TRANS_TABLES,NO_ENGINE_SUBSTITUTION  
sql_notes ON  
sql_quote_show_create ON  
sql_replica_skip_counter 0  
sql_require_primary_key OFF  
sql_safe_updates OFF  
sql_select_limit 18446744073709551615  
sql_slave_skip_counter 0  
sql_warnings OFF  
ssl_ca ca.pem  
ssl_capath ""  
ssl_cert server-cert.pem  
ssl_cipher ""  
ssl_crl ""  
ssl_crlpath ""  
ssl_fips_mode OFF  
ssl_key server-key.pem  
stored_program_cache 256  
stored_program_definition_cache 256  
super_read_only OFF  
sync_binlog 1  
sync_master_info 10000  
sync_relay_log 10000  
sync_relay_log_info 10000  
sync_source_info 10000  
system_time_zone ""  
table_definition_cache 1400  
table_encryption_privilege_check OFF  
table_open_cache 2000  
table_open_cache_instances 16  
tablespace_definition_cache 256  
temptable_max_mmap 1073741824  
temptable_max_ram 1073741824  
temptable_use_mmap ON  
terminology_use_previous NONE  
thread_cache_size 10  
thread_handling one-thread-per-connection  
thread_stack 286720  
time_zone SYSTEM  
tls_ciphersuites ""  
tls_version TLSv1,TLSv1.1,TLSv1.2,TLSv1.3  
tmp_table_size 30408704  
tmpdir C:\Windows\SERVIC~1\NETWOR~1\AppData\Local\Temp  
transaction_alloc_block_size 8192  
transaction_isolation REPEATABLE-READ  
transaction_prealloc_size 4096  
transaction_read_only OFF  
transaction_write_set_extraction XXHASH64  
unique_checks ON  
updatable_views_with_limit YES  
version 8.0.26  
version_comment MySQL Community Server - GPL  
version_compile_machine x86_64  
version_compile_os Win64  
version_compile_zlib 1.2.11  
wait_timeout 28800 ✔️ 접속한 후 쿼리가 들어올 때까지 대기하는 시간.
✔️ 연결 후 지정된 사간동안 쿼리가 수신되지 않으면 해당 연결을 강제로 종료함
✔️ 접속이 많은 데이터베이스 시스템 에서는 이 값을 낮춰 Sleep 상태의 클라이언트들을 접속 해제하여 성능 향상을 볼 수 있다.
✔️ wait_timeout 에 걸려 접속이 해제되면 aborted_client 수가 상승하게 됨
✔️ node.js 처럼 Connection Pool을 사용하는 시스템은 해당 값을 늘리는게 연결이 몰릴때 이점이 있음
✔️ 단위: 초, default=8시간
windowing_use_high_precision ON  

 

저작자표시 비영리 변경금지

'Database & Data > MYSQL' 카테고리의 다른 글

[MySQL][8.0.26] Global Status 설명  (0) 2023.02.03
MariaDB / MySQL 5.7 / MySQL 8.0 information_schema 의 Table 목록 비교  (0) 2022.10.02
MariaDB / MySQL 5.7 / MySQL 8.0 performance_schema 환경변수 비교  (2) 2022.09.24
MariaDB / MySQL 5.7 / MySQL 8.0 performance_schema 비교  (0) 2022.09.24
[MySQL] str_to_date 함수 설명(오류 내용)  (0) 2022.07.04

Dashboard에 여러개의 그래프를 표시하는 경우

A그래프의 마우스 위치에 표시되는 지시선이 B, C, D 그래프에도 동일한 위치에 표시되어야

그래프를 통한 분석이 편리합니다. 

기본 설정은 마우스가 위치한 대상 그래프에만 지시선이 표시되기 때문에 설정을 수정해 주셔야 합니다.

기본 설정 상태입니다.

 

저작자표시 비영리 변경금지
  • flush status;   -- 상태정보 초기화 쿼리
Variable Name Value(Example) Description
Aborted_clients 0 ≫ 클라이언트 프로그램이 비 정상적으로 종료된 수
≫ max_allowed_packet을 초과하는 쿼리는 비정상 적으로 중단된다. (default 4194304 byte)
≫ MySQL 연결을 닫지 않은 상태에서 Wait_timeout 설정에 의해 클라이언트와의 연결을 강제 종료한 경우 증가
≫ 
Aborted_connects 0 ≫ MySQL 서버에 접속이 실패된 수
≫ 값이 지속적으로 증가하면 해킹 시도를 의심해야 함
≫ 실패 사유 : 계정정보 오류, 유효하지 않은 DB명 입력, 컨넥션 부족
≫ 서버 재시작 시 초기화됨
Acl_cache_items_count 0  
Binlog_cache_disk_use 0  
Binlog_cache_use 0  
Binlog_stmt_cache_disk_use 0  
Binlog_stmt_cache_use 0  
Bytes_received 65418  
Bytes_sent 1177448  
Caching_sha2_password_rsa_public_key "-----BEGIN PUBLIC KEY----- -----END PUBLIC KEY-----"  
Com_admin_commands 11 ≫ Com:서버가 실행된 후 각 명령어가 실행된 횟수
≫ show status 명령어 실행시 마다 3~4씩 증가
Com_assign_to_keycache 0  
Com_alter_db 0 ≫ alter db명령어가 실행된 횟수
Com_alter_event 0  
Com_alter_function 0  
Com_alter_instance 0  
Com_alter_procedure 0  
Com_alter_resource_group 0  
Com_alter_server 0  
Com_alter_table 0  
Com_alter_tablespace 0  
Com_alter_user 0  
Com_alter_user_default_role 0  
Com_analyze 0  
Com_begin 0  
Com_binlog 0  
Com_call_procedure 0  
Com_change_db 2  
Com_change_master 0  
Com_change_repl_filter 0  
Com_change_replication_source 0  
Com_check 0  
Com_checksum 0  
Com_clone 0  
Com_commit 0  
Com_create_db 1 ≫ create database 실행 횟수
≫ 서버 재시작 시 초기화됨
Com_create_event 0 ≫ create event 실행 횟수
Com_create_function 0  
Com_create_index 0  
Com_create_procedure 0  
Com_create_role 0  
Com_create_server 0  
Com_create_table 34 ≫ create table 실행 횟수
≫ 서버 재시작 시 초기화됨
Com_create_resource_group 0  
Com_create_trigger 0  
Com_create_udf 0  
Com_create_user 0  
Com_create_view 0  
Com_create_spatial_reference_system 0  
Com_dealloc_sql 0  
Com_delete 0  
Com_delete_multi 0  
Com_do 0  
Com_drop_db 0  
Com_drop_event 0  
Com_drop_function 0  
Com_drop_index 0  
Com_drop_procedure 0  
Com_drop_resource_group 0  
Com_drop_role 0  
Com_drop_server 0  
Com_drop_spatial_reference_system 0  
Com_drop_table 0  
Com_drop_trigger 0  
Com_drop_user 0  
Com_drop_view 0  
Com_empty_query 0  
Com_execute_sql 0  
Com_explain_other 0  
Com_flush 1 ≫ flush status; 등의 명령을 수행한 횟수
Com_get_diagnostics 0  
Com_grant 0  
Com_grant_roles 0  
Com_ha_close 0  
Com_ha_open 0  
Com_ha_read 0  
Com_help 0  
Com_import 0  
Com_insert 0  
Com_insert_select 0  
Com_install_component 0  
Com_install_plugin 0  
Com_kill 0  
Com_load 0  
Com_lock_instance 0  
Com_lock_tables 0  
Com_optimize 0  
Com_preload_keys 0  
Com_prepare_sql 0  
Com_purge 0  
Com_purge_before_date 0  
Com_release_savepoint 0  
Com_rename_table 0  
Com_rename_user 0  
Com_repair 0  
Com_replace 0  
Com_replace_select 0  
Com_reset 0  
Com_resignal 0  
Com_restart 0  
Com_revoke 0  
Com_revoke_all 0  
Com_revoke_roles 0  
Com_rollback 0  
Com_rollback_to_savepoint 0  
Com_savepoint 0  
Com_select 89  
Com_set_option 385  
Com_set_password 0  
Com_set_resource_group 0  
Com_set_role 0  
Com_signal 0  
Com_show_binlog_events 0  
Com_show_binlogs 0  
Com_show_charsets 0  
Com_show_collations 0  
Com_show_create_db 0  
Com_show_create_event 0  
Com_show_create_func 22  
Com_show_create_proc 26  
Com_show_create_table 79  
Com_show_create_trigger 2  
Com_show_databases 0  
Com_show_engine_logs 0  
Com_show_engine_mutex 0  
Com_show_engine_status 0  
Com_show_events 0  
Com_show_errors 0  
Com_show_fields 0  
Com_show_function_code 0  
Com_show_function_status 0  
Com_show_grants 0  
Com_show_keys 0  
Com_show_master_status 0  
Com_show_open_tables 0  
Com_show_plugins 0  
Com_show_privileges 0  
Com_show_procedure_code 0  
Com_show_procedure_status 0  
Com_show_processlist 0  
Com_show_profile 0  
Com_show_profiles 0  
Com_show_relaylog_events 0  
Com_show_replicas 0  
Com_show_slave_hosts 0  
Com_show_replica_status 0  
Com_show_slave_status 0  
Com_show_status 2  
Com_show_storage_engines 0  
Com_show_table_status 0  
Com_show_tables 0  
Com_show_triggers 0  
Com_show_variables 2  
Com_show_warnings 413  
Com_show_create_user 0  
Com_shutdown 0  
Com_replica_start 0  
Com_slave_start 0  
Com_replica_stop 0  
Com_slave_stop 0  
Com_group_replication_start 0  
Com_group_replication_stop 0  
Com_stmt_execute 0  
Com_stmt_close 0  
Com_stmt_fetch 0  
Com_stmt_prepare 0  
Com_stmt_reset 0  
Com_stmt_send_long_data 0  
Com_truncate 0  
Com_uninstall_component 0  
Com_uninstall_plugin 0  
Com_unlock_instance 0  
Com_unlock_tables 0  
Com_update 0  
Com_update_multi 0  
Com_xa_commit 0  
Com_xa_end 0  
Com_xa_prepare 0  
Com_xa_recover 0  
Com_xa_rollback 0  
Com_xa_start 0  
Com_stmt_reprepare 0  
Connection_errors_accept 0 ≫ 수신 포트에서 수락 호출 중에 발생한 오류 수입니다.
≫ 서버 재시작 시 초기화됨
Connection_errors_internal 0 ≫ 새 스레드를 시작하지 못했거나 메모리 부족 상태와 같은 서버 내부 오류로 인해 거부된 연결 수입니다.
≫ 서버 재시작 시 초기화됨
Connection_errors_max_connections 0 ≫ 서버 max_connections 제한에 도달했기 때문에 거부된 연결 수입니다.
≫ 서버 재시작 시 초기화됨
Connection_errors_peer_address 0 ≫ 클라이언트 IP 주소를 연결하는 동안 발생한 오류 수입니다.
≫ 서버 재시작 시 초기화됨
Connection_errors_select 0 ≫ 수신 포트에서 select() 또는 pool()를 호출하는 동안 발생한 오류 수입니다.
≫ 이 작업이 실패했다고 해서 클라이언트 연결이 반드시 거부된 것은 아닙니다.
Connection_errors_tcpwrap 0 ≫ libwrap 라이브러리에서 거부된 연결 수입니다.
Connections 9 ≫ 서버 가동 후 연결 시도된 횟수
≫ 실제 접속이 되지 않고 시도만 해도 값 증가
≫ Access denied 이 되어도 수치 증가
Created_tmp_disk_tables 4 ≫ 임시테이블을 디스크에 생성한 횟수
≫ 이 수치가 높으면 쿼리 처리를 위해 디스크를 많이 사용하고 있다는 뜻(성능 하락)
Created_tmp_files 4 ≫ 임시파일 생성 횟수
Created_tmp_tables 81 ≫ 임시 테이블 생성 횟수
Current_tls_ca ca.pem  
Current_tls_capath ""  
Current_tls_cert server-cert.pem  
Current_tls_cipher ""  
Current_tls_ciphersuites ""  
Current_tls_crl ""  
Current_tls_crlpath ""  
Current_tls_key server-key.pem  
Current_tls_version TLSv1,TLSv1.1,TLSv1.2,TLSv1.3  
Delayed_errors 0  
Delayed_insert_threads 0 ≫ 사용중인 insert handler threads가 지연되고 있는 수
Delayed_writes 0 ≫ INSERT DELAYED로 쓰여진 rows수
Error_log_buffered_bytes 147912 ≫ performance_schema.error_log 의 Byte수
≫ MySQL 8.0.22에서 추가
Error_log_buffered_events 1032 ≫ performance_schema.error_log 의 Row 수
Error_log_expired_events 0  
Error_log_latest_write 1675386451298063 ≫ performance_schema.error_log 테이블에 마지막으로 기록한 시간
Flush_commands 3  
Handler_commit 2369  
Handler_delete 0  
Handler_discover 0  
Handler_external_lock 15409  
Handler_mrr_init 0  
Handler_prepare 0  
Handler_read_first 114  
Handler_read_key 11478  
Handler_read_last 0  
Handler_read_next 17529  
Handler_read_prev 0  
Handler_read_rnd 3991  
Handler_read_rnd_next 9840  
Handler_rollback 0  
Handler_savepoint 0  
Handler_savepoint_rollback 0  
Handler_update 318  
Handler_write 6208  
Innodb_buffer_pool_dump_status Dumping of buffer pool not started  
Innodb_buffer_pool_load_status Buffer pool(s) load completed at 230203 10:07:31  
Innodb_buffer_pool_resize_status ""  
Innodb_buffer_pool_pages_data 2267  
Innodb_buffer_pool_bytes_data 37142528  
Innodb_buffer_pool_pages_dirty 0  
Innodb_buffer_pool_bytes_dirty 0  
Innodb_buffer_pool_pages_flushed 217  
Innodb_buffer_pool_pages_free 259829  
Innodb_buffer_pool_pages_misc 48  
Innodb_buffer_pool_pages_total 262144  
Innodb_buffer_pool_read_ahead_rnd 0  
Innodb_buffer_pool_read_ahead 0  
Innodb_buffer_pool_read_ahead_evicted 0  
Innodb_buffer_pool_read_requests 63821  
Innodb_buffer_pool_reads 2123  
Innodb_buffer_pool_wait_free 0  
Innodb_buffer_pool_write_requests 1958  
Innodb_data_fsyncs 125  
Innodb_data_pending_fsyncs 0  
Innodb_data_pending_reads 0  
Innodb_data_pending_writes 0  
Innodb_data_read 34853888  
Innodb_data_reads 2149  
Innodb_data_writes 372  
Innodb_data_written 3638272  
Innodb_dblwr_pages_written 72  
Innodb_dblwr_writes 29  
Innodb_log_waits 0  
Innodb_log_write_requests 812  
Innodb_log_writes 77  
Innodb_os_log_fsyncs 59  
Innodb_os_log_pending_fsyncs 0  
Innodb_os_log_pending_writes 0  
Innodb_os_log_written 64000  
Innodb_page_size 16384  
Innodb_pages_created 146  
Innodb_pages_read 2122  
Innodb_pages_written 217  
Innodb_redo_log_enabled ON  
Innodb_row_lock_current_waits 0  
Innodb_row_lock_time 0  
Innodb_row_lock_time_avg 0  
Innodb_row_lock_time_max 0  
Innodb_row_lock_waits 0  
Innodb_rows_deleted 0  
Innodb_rows_inserted 0  
Innodb_rows_read 0  
Innodb_rows_updated 0  
Innodb_system_rows_deleted 0  
Innodb_system_rows_inserted 38  
Innodb_system_rows_read 22621  
Innodb_system_rows_updated 318  
Innodb_sampled_pages_read 0  
Innodb_sampled_pages_skipped 0  
Innodb_num_open_files 19  
Innodb_truncated_status_writes 0  
Innodb_undo_tablespaces_total 2  
Innodb_undo_tablespaces_implicit 2  
Innodb_undo_tablespaces_explicit 0  
Innodb_undo_tablespaces_active 2  
Key_blocks_not_flushed 0  
Key_blocks_unused 6698  
Key_blocks_used 0  
Key_read_requests 0  
Key_reads 0  
Key_write_requests 0  
Key_writes 0  
Locked_connects 0  
Max_execution_time_exceeded 0  
Max_execution_time_set 0  
Max_execution_time_set_failed 0  
Max_used_connections 1 최대로 동시에 접속한 수
Max_used_connections_time 2023-02-03 13:58:30 최대로 동시에 접속한 시각
Mysqlx_aborted_clients 0  
Mysqlx_address ::  
Mysqlx_bytes_received 0  
Mysqlx_bytes_received_compressed_payload 0  
Mysqlx_bytes_received_uncompressed_frame 0  
Mysqlx_bytes_sent 0  
Mysqlx_bytes_sent_compressed_payload 0  
Mysqlx_bytes_sent_uncompressed_frame 0  
Mysqlx_compression_algorithm ""  
Mysqlx_compression_level ""  
Mysqlx_connection_accept_errors 0  
Mysqlx_connection_errors 0  
Mysqlx_connections_accepted 0  
Mysqlx_connections_closed 0  
Mysqlx_connections_rejected 0  
Mysqlx_crud_create_view 0  
Mysqlx_crud_delete 0  
Mysqlx_crud_drop_view 0  
Mysqlx_crud_find 0  
Mysqlx_crud_insert 0  
Mysqlx_crud_modify_view 0  
Mysqlx_crud_update 0  
Mysqlx_cursor_close 0  
Mysqlx_cursor_fetch 0  
Mysqlx_cursor_open 0  
Mysqlx_errors_sent 0  
Mysqlx_errors_unknown_message_type 0  
Mysqlx_expect_close 0  
Mysqlx_expect_open 0  
Mysqlx_init_error 0  
Mysqlx_messages_sent 0  
Mysqlx_notice_global_sent 0  
Mysqlx_notice_other_sent 0  
Mysqlx_notice_warning_sent 0  
Mysqlx_notified_by_group_replication 0  
Mysqlx_port 33060  
Mysqlx_prep_deallocate 0  
Mysqlx_prep_execute 0  
Mysqlx_prep_prepare 0  
Mysqlx_rows_sent 0  
Mysqlx_sessions 0  
Mysqlx_sessions_accepted 0  
Mysqlx_sessions_closed 0  
Mysqlx_sessions_fatal_error 0  
Mysqlx_sessions_killed 0  
Mysqlx_sessions_rejected 0  
Mysqlx_socket UNDEFINED  
Mysqlx_ssl_accepts 0  
Mysqlx_ssl_active    
Mysqlx_ssl_cipher    
Mysqlx_ssl_cipher_list    
Mysqlx_ssl_ctx_verify_depth 18446744073709551615  
Mysqlx_ssl_ctx_verify_mode 5  
Mysqlx_ssl_finished_accepts 0  
Mysqlx_ssl_server_not_after Sep 25 01:18:46 2031 GMT  
Mysqlx_ssl_server_not_before Sep 27 01:18:46 2021 GMT  
Mysqlx_ssl_verify_depth    
Mysqlx_ssl_verify_mode    
Mysqlx_ssl_version    
Mysqlx_stmt_create_collection 0  
Mysqlx_stmt_create_collection_index 0  
Mysqlx_stmt_disable_notices 0  
Mysqlx_stmt_drop_collection 0  
Mysqlx_stmt_drop_collection_index 0  
Mysqlx_stmt_enable_notices 0  
Mysqlx_stmt_ensure_collection 0  
Mysqlx_stmt_execute_mysqlx 0  
Mysqlx_stmt_execute_sql 0  
Mysqlx_stmt_execute_xplugin 0  
Mysqlx_stmt_get_collection_options 0  
Mysqlx_stmt_kill_client 0  
Mysqlx_stmt_list_clients 0  
Mysqlx_stmt_list_notices 0  
Mysqlx_stmt_list_objects 0  
Mysqlx_stmt_modify_collection_options 0  
Mysqlx_stmt_ping 0  
Mysqlx_worker_threads 2  
Mysqlx_worker_threads_active 0  
Not_flushed_delayed_rows 0  
Ongoing_anonymous_transaction_count 0  
Open_files 3  
Open_streams 0  
Open_table_definitions 209  
Open_tables 164  
Opened_files 3  
Opened_table_definitions 246  
Opened_tables 299  
Performance_schema_accounts_lost 0  
Performance_schema_cond_classes_lost 0  
Performance_schema_cond_instances_lost 0  
Performance_schema_digest_lost 0  
Performance_schema_file_classes_lost 0  
Performance_schema_file_handles_lost 0  
Performance_schema_file_instances_lost 0  
Performance_schema_hosts_lost 0  
Performance_schema_index_stat_lost 0  
Performance_schema_locker_lost 0  
Performance_schema_memory_classes_lost 0  
Performance_schema_metadata_lock_lost 0  
Performance_schema_mutex_classes_lost 0  
Performance_schema_mutex_instances_lost 0  
Performance_schema_nested_statement_lost 0  
Performance_schema_prepared_statements_lost 0  
Performance_schema_program_lost 0  
Performance_schema_rwlock_classes_lost 0  
Performance_schema_rwlock_instances_lost 0  
Performance_schema_session_connect_attrs_longest_seen 131  
Performance_schema_session_connect_attrs_lost 0  
Performance_schema_socket_classes_lost 0  
Performance_schema_socket_instances_lost 0  
Performance_schema_stage_classes_lost 0  
Performance_schema_statement_classes_lost 0  
Performance_schema_table_handles_lost 0  
Performance_schema_table_instances_lost 0  
Performance_schema_table_lock_stat_lost 0  
Performance_schema_thread_classes_lost 0  
Performance_schema_thread_instances_lost 0  
Performance_schema_users_lost 0  
Prepared_stmt_count 0  
Queries 1030  
Questions 1018  
Replica_open_temp_tables 0  
Rsa_public_key "-----BEGIN PUBLIC KEY----- -----END PUBLIC KEY-----"  
Secondary_engine_execution_count 0  
Select_full_join 18  
Select_full_range_join 0  
Select_range 0  
Select_range_check 0  
Select_scan 84  
Slave_open_temp_tables 0  
Slow_launch_threads 0  
Slow_queries 0  
Sort_merge_passes 0  
Sort_range 0  
Sort_rows 4003  
Sort_scan 24  
Ssl_accept_renegotiates 0  
Ssl_accepts 2  
Ssl_callback_cache_hits 0  
Ssl_cipher TLS_AES_256_GCM_SHA384  
Ssl_cipher_list TLS_AES_256_GCM_SHA384  
Ssl_client_connects 0  
Ssl_connect_renegotiates 0  
Ssl_ctx_verify_depth 4294967295  
Ssl_ctx_verify_mode 5  
Ssl_default_timeout 7200  
Ssl_finished_accepts 2  
Ssl_finished_connects 0  
Ssl_server_not_after Sep 25 01:18:46 2031 GMT  
Ssl_server_not_before Sep 27 01:18:46 2021 GMT  
Ssl_session_cache_hits 0  
Ssl_session_cache_misses 0  
Ssl_session_cache_mode SERVER  
Ssl_session_cache_overflows 0  
Ssl_session_cache_size 128  
Ssl_session_cache_timeouts 0  
Ssl_sessions_reused 0  
Ssl_used_session_cache_entries 0  
Ssl_verify_depth 4294967295  
Ssl_verify_mode 5  
Ssl_version TLSv1.3  
Table_locks_immediate 4 즉식 획득한 테이블 락 횟수
Table_locks_waited 0 테이블 락을 즉시 획득하지 못하고 대기한 횟수
Table_open_cache_hits 7686  
Table_open_cache_misses 299  
Table_open_cache_overflows 54  
Tc_log_max_pages_used 0  
Tc_log_page_size 0  
Tc_log_page_waits 0  
Threads_cached 0 Thread Cache의 Thread 수
Threads_connected 1 현재 연결된 Thread 수
Threads_created 1 접속을 위해 생성된 Thread 수
Threads_running 2 Sleeping 되어 있지 않은 Thread 수
Uptime 13895 MySQL이 가동중인 시간
Uptime_since_flush_status 13895  
저작자표시 비영리 변경금지

'Database & Data > MYSQL' 카테고리의 다른 글

[MySQL][8.0.26] Global Variables 설명  (0) 2023.02.17
MariaDB / MySQL 5.7 / MySQL 8.0 information_schema 의 Table 목록 비교  (0) 2022.10.02
MariaDB / MySQL 5.7 / MySQL 8.0 performance_schema 환경변수 비교  (2) 2022.09.24
MariaDB / MySQL 5.7 / MySQL 8.0 performance_schema 비교  (0) 2022.09.24
[MySQL] str_to_date 함수 설명(오류 내용)  (0) 2022.07.04

✅ JMeter 설치 방법 : https://devse.tistory.com/104

 

1. Jmeter 설치 (Open JDK 설치)

✅ Jmeter 다운로드 사이트 https://jmeter.apache.org/download_jmeter.cgi ✅ Jmeter 5.5 다운로드 https://dlcdn.apache.org//jmeter/binaries/apache-jmeter-5.5.zip ✅ 다운받은 Jmeter 압축파일을 원하는 폴더에 압축 해제 ✅ Open J

devse.tistory.com

 

✅ Node.js로 제작한 서버를 테스트하기 위하여 JMeter를 사용합니다. 

 

✅ JMeter의 Test Plan 설정 예시 입니다. 

  • 본 게시물에서 설명했던 JMeter 설정파일을 첨부하였습니다.

HttpGet_20230131.jmx
0.01MB

 

✅ 1. HttpGet(Test Plan) 하위에 Thread Group을 추가합니다. 

  • Thread Group : 하위 작업을 반복하는 컨트롤러 입니다.

 

✅ 2. Thread Group의 하위에 HTTP Request 샘플러를 추가합니다.

  • HTTP Request : Http 요청을 위한 컨트롤러 입니다.

 

✅ 3. HttpGet(Test Plan) 하위에 View Results Tree 리스너를 추가합니다.

  • View Results Tree : 각 Http Request 작업에 대한 요청 및 결과를 확인하기 위한 컨트롤러 입니다.

 

✅ 4. HttpGet(Test Plan) 하위에 Summary Report 리스너를 추가합니다.

  • Summary Report : 총 요청 결과에 대한 요약 정보 컨트롤러 입니다.

 

✅ 5. Thread Group 을 설정합니다.

  • 총 100개의 Thread를 생성하고 Thread당 100번의 하위 작업을 실행합니다.

 

✅ 6.   Http Request를 설정합니다.

  • Node.js Express 서버를 띄워놓았습니다.

 

✅ 7.   Start 버튼을 눌러 작업을 시작합니다.

 

✅ 8.  작업이 완료된 후

 View Results Tree를 통해서 처리(요청)결과를 확인하고 오류가 있을 경우 세부 내역을 확인할 수 있습니다.

Summary Report를 통해서 처리량(성능)을 측정할 수 있습니다.

저작자표시 비영리 변경금지

'테스트 & 자동화 > Jmeter' 카테고리의 다른 글

Jmeter를 이용하여 대량의 폴더를 생성하고 파일을 복사하는 방법  (0) 2024.03.01
1. Jmeter 설치 (Open JDK 설치)  (0) 2023.01.30

+ Recent posts

티스토리툴바