Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Not a Bug
-
3.4.7
-
None
-
win10; clang++;
Description
# ======================= 1、添加 zlib=======================
|
include(${CMAKE_SOURCE_DIR}/cmake/depend_zlib.cmake)
|
|
|
# ======================= 2、添加 mariadbclient =======================
|
# https://mariadb.com/downloads/connectors/?utm_source=onpagepromo&utm_medium=kb
|
# V3.4.7
|
set(MARIADB_ROOT_PATH "E:/mysoftware/MariaDB_Connector_C_64-bit" CACHE PATH "MariaDB 根目录") |
set(_SQL_CLIENT_TARGET "mariadbclient") |
add_library(${_SQL_CLIENT_TARGET} STATIC IMPORTED)
|
set_target_properties(${_SQL_CLIENT_TARGET} PROPERTIES
|
INTERFACE_INCLUDE_DIRECTORIES "${MARIADB_ROOT_PATH}/include" # inlcude目录 |
IMPORTED_LOCATION "${MARIADB_ROOT_PATH}/lib/${_SQL_CLIENT_TARGET}.lib" |
)
|
|
|
# 3检查库和头文件是否存在（可选，用于提前报错）
|
if(NOT EXISTS "${MARIADB_ROOT_PATH}/include/mysql.h") |
message(FATAL_ERROR " 未找到 mysql.h, 请检查 ${MARIADB_ROOT_PATH}/include/mysql.h 是否正确 ") |
endif()
|
|
|
if(NOT EXISTS "${MARIADB_ROOT_PATH}/lib/${_SQL_CLIENT_TARGET}.lib") |
message(FATAL_ERROR " 未找到 ${_SQL_CLIENT_TARGET}.lib,请检查 MARIADB_ROOT_PATH 是否正确 ") |
endif()
|
|
|
unset(_SQL_CLIENT_TARGET)
|
|
|
# 3、 mariadbclient 依赖的 windows 的库
|
add_library(mariadbclient_sys_deps INTERFACE)
|
target_link_libraries(mariadbclient_sys_deps INTERFACE
|
ws2_32 # Windows 网络库
|
advapi32 # Windows 高级 API 服务库
|
kernel32 # Windows 核心库
|
shlwapi # Windows 外壳轻量 API 库
|
bcrypt # Windows 加密库
|
secur32 # Windows 安全支持库
|
crypt32 # Windows 加密服务库
|
)
|
|
|
add_library(mariadbclient_deps INTERFACE)
|
target_link_libraries(mariadbclient_deps INTERFACE
|
zlib
|
mariadbclient
|
mariadbclient_sys_deps
|
)
|
[mysqld]
|
datadir=E:/mysoftware/MariaDB_11_8/data
|
port=3307 |
innodb_buffer_pool_size=4008M
|
|
|
[client]
|
port=3307 |
plugin-dir=E:/mysoftware/MariaDB_11_8/lib/plugin
|
|
#include <cassert>
|
#include <iostream>
|
#include <cstdio>
|
#include <cstdlib>
|
#include <mysql.h>
|
#include <string_view>
|
#include <winsock2.h>
|
#include <print>
|
|
|
// NOLINTBEGIN
|
|
|
static void show_mysql_error(::MYSQL *mysql, const std::string_view &msg) |
{
|
std::println("error: {} , mysqlinfo: ({}) [{}] \"{}\"", msg, ::mysql_errno(mysql), |
::mysql_sqlstate(mysql), ::mysql_error(mysql));
|
::exit(-1); |
}
|
|
|
/* Helper function to do the waiting for events on the socket. */
|
static int wait_for_mysql(MYSQL *mysql, int status) |
{
|
|
|
fd_set rs, ws, es;
|
int res; |
struct timeval tv, *timeout; |
my_socket s = mysql_get_socket(mysql);
|
FD_ZERO(&rs);
|
FD_ZERO(&ws);
|
FD_ZERO(&es);
|
if (status & MYSQL_WAIT_READ) |
FD_SET(s, &rs);
|
if (status & MYSQL_WAIT_WRITE) |
FD_SET(s, &ws);
|
if (status & MYSQL_WAIT_EXCEPT) |
FD_SET(s, &es);
|
if (status & MYSQL_WAIT_TIMEOUT) |
{
|
tv.tv_sec = mysql_get_timeout_value(mysql);
|
tv.tv_usec = 0;
|
timeout = &tv;
|
std::cout << "timeout: " << tv.tv_sec << '\n'; |
}
|
else |
timeout = NULL;
|
res = select(0, &rs, &ws, &es, timeout);
|
if (res == 0) |
return MYSQL_WAIT_TIMEOUT; |
else if (res == SOCKET_ERROR) |
{
|
/* |
In a real event framework, we should handle errors and re-try the select.
|
*/
|
assert(false && "MYSQL_WAIT_TIMEOUT error"); |
return MYSQL_WAIT_TIMEOUT; |
}
|
else |
{
|
int status = 0; |
if (FD_ISSET(s, &rs)) |
status |= MYSQL_WAIT_READ;
|
if (FD_ISSET(s, &ws)) |
status |= MYSQL_WAIT_WRITE;
|
if (FD_ISSET(s, &es)) |
status |= MYSQL_WAIT_EXCEPT;
|
std::cout << "status: " << status << '\n'; |
return status; |
}
|
}
|
constexpr unsigned long string_size(const std::string_view &s) |
{
|
return static_cast<unsigned long>(s.size()); |
}
|
static void run_query(const char *host, const char *user, const char *password) |
{
|
int err, status; |
MYSQL mysql, *ret;
|
MYSQL_RES *res;
|
MYSQL_ROW row;
|
|
|
mysql_init(&mysql);
|
if (mysql_optionsv(&mysql, MYSQL_OPT_NONBLOCK, 0)) |
show_mysql_error(&mysql, "mysql_optionsv(MYSQL_OPT_NONBLOCK) error"); |
if (mysql_optionsv(&mysql, MYSQL_READ_DEFAULT_GROUP, (char *)"myapp")) |
show_mysql_error(&mysql,
|
"mysql_optionsv(MYSQL_OPT_SSL_VERIFY_SERVER_CERT) error"); |
status =
|
mysql_real_connect_start(&ret, &mysql, host, user, password, NULL, 3307, NULL, 0);
|
while (status) |
{
|
status = wait_for_mysql(&mysql, status);
|
status = mysql_real_connect_cont(&ret, &mysql, status);
|
}
|
if (!ret) |
show_mysql_error(&mysql, "Failed to mysql_real_connect()"); |
|
|
constexpr auto query_sql = "SHOW STATUS"; |
status = mysql_real_query_start(&err, &mysql, query_sql, string_size(query_sql));
|
while (status) |
{
|
status = wait_for_mysql(&mysql, status);
|
status = mysql_real_query_cont(&err, &mysql, status);
|
}
|
if (err) |
show_mysql_error(&mysql, "mysql_real_query() returns error"); |
|
|
/* This method cannot block. */ |
res = mysql_use_result(&mysql);
|
if (!res) |
show_mysql_error(&mysql, "mysql_use_result() returns error"); |
|
|
for (;;) |
{
|
status = mysql_fetch_row_start(&row, res);
|
while (status) |
{
|
status = wait_for_mysql(&mysql, status);
|
status = mysql_fetch_row_cont(&row, res, status);
|
}
|
if (!row) |
break; |
printf("%s: %s\n", row[0], row[1]); |
}
|
if (mysql_errno(&mysql)) |
show_mysql_error(&mysql, "Got error while retrieving rows"); |
mysql_free_result(res);
|
mysql_close(&mysql);
|
}
|
|
|
static const char *my_groups[] = {"client", NULL}; |
|
|
static void run_query_sync(const char *host, const char *user, const char *password) |
{
|
MYSQL mysql;
|
MYSQL_RES *res;
|
MYSQL_ROW row;
|
|
|
if (!mysql_init(&mysql)) |
show_mysql_error(&mysql, "mysql_init() error"); |
|
|
mysql_options(&mysql, MYSQL_OPT_SSL_VERIFY_SERVER_CERT, (char *)"0"); |
|
|
if (!mysql_real_connect(&mysql, host, user, password, NULL, 3307, NULL, 0)) |
show_mysql_error(&mysql, "Failed to mysql_real_connect()"); |
|
|
constexpr auto query_sql = "SHOW STATUS"; |
if (mysql_real_query(&mysql, query_sql, string_size(query_sql))) |
show_mysql_error(&mysql, "mysql_real_query() returns error"); |
|
|
res = mysql_use_result(&mysql);
|
if (!res) |
show_mysql_error(&mysql, "mysql_use_result() returns error"); |
|
|
while ((row = mysql_fetch_row(res)) != NULL) |
printf("%s: %s\n", row[0], row[1]); |
|
|
if (mysql_errno(&mysql)) |
show_mysql_error(&mysql, "Got error while retrieving rows"); |
|
|
mysql_free_result(res);
|
mysql_close(&mysql);
|
}
|
|
|
int main(int argc, char **argv) |
{
|
std::cout << "main in\n"; |
const char *host = "127.0.0.1"; // or "localhost" |
unsigned int port = 3307; |
const char *user = "root"; |
const char *password = "root"; |
const char *database = "test"; |
run_query_sync(host, user, password);
|
|
|
std::cout << "\n=====run_query=======\n"; |
|
|
// NOTE: ???? |
// mysql_library_init(argc, argv, (char **)my_groups); |
run_query(host, user, password);
|
|
|
// mysql_library_end(); |
|
|
std::cout << "hello_maria done\n"; |
return 0; |
}
|
// NOLINTEND |
main in
Aborted_clients: 8
Aborted_connects: 7
Aborted_connects_preauth: 7
Access_denied_errors: 0
Acl_column_grants: 0
Acl_database_grants: 1
Acl_function_grants: 0
Acl_procedure_grants: 0
Acl_package_spec_grants: 0
Acl_package_body_grants: 0
Acl_proxy_users: 4
Acl_role_grants: 0
Acl_roles: 0
Acl_table_grants: 1
Acl_users: 7
Aria_pagecache_blocks_not_flushed: 0
Aria_pagecache_blocks_unused: 15636
Aria_pagecache_blocks_used: 11
Aria_pagecache_read_requests: 16
Aria_pagecache_reads: 13
Aria_pagecache_write_requests: 0
Aria_pagecache_writes: 0
Aria_transaction_log_syncs: 0
Binlog_commits: 0
Binlog_group_commits: 0
Binlog_group_commit_trigger_count: 0
Binlog_group_commit_trigger_lock_wait: 0
Binlog_group_commit_trigger_timeout: 0
Binlog_snapshot_file:
Binlog_snapshot_position: 0
Binlog_bytes_written: 0
Binlog_cache_disk_use: 0
Binlog_cache_use: 0
Binlog_disk_use: 0
Binlog_gtid_index_hit: 0
Binlog_gtid_index_miss: 0
Binlog_stmt_cache_disk_use: 0
Binlog_stmt_cache_use: 0
Busy_time: 0.000000
Bytes_received: 258
Bytes_sent: 313
Column_compressions: 0
Column_decompressions: 0
Com_admin_commands: 0
Com_alter_db: 0
Com_alter_db_upgrade: 0
Com_alter_event: 0
Com_alter_function: 0
Com_alter_procedure: 0
Com_alter_server: 0
Com_alter_sequence: 0
Com_alter_table: 0
Com_alter_user: 0
Com_analyze: 0
Com_assign_to_keycache: 0
Com_backup: 0
Com_backup_lock: 0
Com_begin: 0
Com_binlog: 0
Com_call_procedure: 0
Com_change_db: 0
Com_change_master: 0
Com_check: 0
Com_checksum: 0
Com_commit: 0
Com_compound_sql: 0
Com_create_db: 0
Com_create_event: 0
Com_create_function: 0
Com_create_index: 0
Com_create_package: 0
Com_create_package_body: 0
Com_create_procedure: 0
Com_create_role: 0
Com_create_sequence: 0
Com_create_server: 0
Com_create_table: 0
Com_create_temporary_table: 0
Com_create_trigger: 0
Com_create_udf: 0
Com_create_user: 0
Com_create_view: 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_package: 0
Com_drop_package_body: 0
Com_drop_role: 0
Com_drop_server: 0
Com_drop_sequence: 0
Com_drop_table: 0
Com_drop_temporary_table: 0
Com_drop_trigger: 0
Com_drop_user: 0
Com_drop_view: 0
Com_empty_query: 0
Com_execute_immediate: 0
Com_execute_sql: 0
Com_flush: 0
Com_get_diagnostics: 0
Com_grant: 0
Com_grant_role: 0
Com_ha_close: 0
Com_ha_open: 0
Com_ha_read: 0
Com_help: 0
Com_insert: 0
Com_insert_select: 0
Com_install_plugin: 0
Com_kill: 0
Com_load: 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_revoke: 0
Com_revoke_all: 0
Com_revoke_role: 0
Com_rollback: 0
Com_rollback_to_savepoint: 0
Com_savepoint: 0
Com_select: 0
Com_set_option: 0
Com_show_authors: 0
Com_show_binlog_events: 0
Com_show_binlogs: 0
Com_show_charsets: 0
Com_show_collations: 0
Com_show_contributors: 0
Com_show_create_db: 0
Com_show_create_event: 0
Com_show_create_func: 0
Com_show_create_package: 0
Com_show_create_package_body: 0
Com_show_create_proc: 0
Com_show_create_server: 0
Com_show_create_table: 0
Com_show_create_trigger: 0
Com_show_create_user: 0
Com_show_databases: 0
Com_show_engine_logs: 0
Com_show_engine_mutex: 0
Com_show_engine_status: 0
Com_show_errors: 0
Com_show_events: 0
Com_show_explain: 0
Com_show_analyze: 0
Com_show_fields: 0
Com_show_function_status: 0
Com_show_generic: 0
Com_show_grants: 0
Com_show_keys: 0
Com_show_binlog_status: 0
Com_show_open_tables: 0
Com_show_package_status: 0
Com_show_package_body_status: 0
Com_show_plugins: 0
Com_show_privileges: 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_slave_hosts: 0
Com_show_slave_status: 0
Com_show_status: 1
Com_show_storage_engines: 0
Com_show_table_status: 0
Com_show_tables: 0
Com_show_triggers: 0
Com_show_variables: 0
Com_show_warnings: 0
Com_shutdown: 0
Com_signal: 0
Com_start_all_slaves: 0
Com_start_slave: 0
Com_stmt_close: 0
Com_stmt_execute: 0
Com_stmt_fetch: 0
Com_stmt_prepare: 0
Com_stmt_reprepare: 0
Com_stmt_reset: 0
Com_stmt_send_long_data: 0
Com_stop_all_slaves: 0
Com_stop_slave: 0
Com_truncate: 0
Com_uninstall_plugin: 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
Compression: OFF
Connection_errors_accept: 0
Connection_errors_internal: 0
Connection_errors_max_connections: 0
Connection_errors_peer_address: 0
Connection_errors_select: 0
Connection_errors_tcpwrap: 0
Connections: 18
Cpu_time: 0.000000
Created_tmp_disk_tables: 0
Created_tmp_files: 4
Created_tmp_tables: 0
Delayed_errors: 0
Delayed_insert_threads: 0
Delayed_writes: 0
Delete_scan: 0
Empty_queries: 0
Executed_events: 0
Executed_triggers: 0
Feature_application_time_periods: 0
Feature_check_constraint: 2
Feature_custom_aggregate_functions: 0
Feature_delay_key_write: 0
Feature_dynamic_columns: 0
Feature_fulltext: 0
Feature_gis: 0
Feature_insert_returning: 0
Feature_into_outfile: 0
Feature_into_variable: 0
Feature_invisible_columns: 0
Feature_json: 0
Feature_locale: 0
Feature_subquery: 0
Feature_system_versioning: 0
Feature_timezone: 0
Feature_trigger: 0
Feature_window_functions: 0
Feature_xml: 0
Handler_commit: 0
Handler_delete: 0
Handler_discover: 0
Handler_external_lock: 0
Handler_icp_attempts: 0
Handler_icp_match: 0
Handler_mrr_init: 0
Handler_mrr_key_refills: 0
Handler_mrr_rowid_refills: 0
Handler_prepare: 0
Handler_read_first: 0
Handler_read_key: 0
Handler_read_last: 0
Handler_read_next: 0
Handler_read_prev: 0
Handler_read_retry: 0
Handler_read_rnd: 0
Handler_read_rnd_deleted: 0
Handler_read_rnd_next: 0
Handler_rollback: 0
Handler_savepoint: 0
Handler_savepoint_rollback: 0
Handler_tmp_delete: 0
Handler_tmp_update: 0
Handler_tmp_write: 0
Handler_update: 0
Handler_write: 0
Innodb_adaptive_hash_hash_searches: 0
Innodb_adaptive_hash_non_hash_searches: 0
Innodb_async_reads_pending: 0
Innodb_async_reads_tasks_running: 0
Innodb_async_reads_total_count: 44
Innodb_async_reads_total_enqueues: 0
Innodb_async_reads_queue_size: 0
Innodb_async_reads_wait_slot_sec: 0.000000
Innodb_async_writes_pending: 0
Innodb_async_writes_tasks_running: 0
Innodb_async_writes_total_count: 0
Innodb_async_writes_total_enqueues: 0
Innodb_async_writes_queue_size: 0
Innodb_async_writes_wait_slot_sec: 0.000000
Innodb_background_log_sync: 3738
Innodb_buffer_pool_dump_status:
Innodb_buffer_pool_load_status: Buffer pool(s) load completed at 250904 1:27:48
Innodb_buffer_pool_resize_status:
Innodb_buffer_pool_load_incomplete: OFF
Innodb_buffer_pool_pages_data: 320
Innodb_buffer_pool_bytes_data: 5242880
Innodb_buffer_pool_pages_dirty: 0
Innodb_buffer_pool_bytes_dirty: 0
Innodb_buffer_pool_pages_flushed: 0
Innodb_buffer_pool_pages_free: 253687
Innodb_buffer_pool_pages_made_not_young: 0
Innodb_buffer_pool_pages_made_young: 0
Innodb_buffer_pool_pages_misc: 0
Innodb_buffer_pool_pages_old: 0
Innodb_buffer_pool_pages_total: 254007
Innodb_buffer_pool_pages_lru_flushed: 0
Innodb_buffer_pool_pages_lru_freed: 0
Innodb_buffer_pool_pages_split: 0
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: 769
Innodb_buffer_pool_reads: 189
Innodb_buffer_pool_wait_free: 0
Innodb_buffer_pool_write_requests: 0
Innodb_checkpoint_age: 16
Innodb_checkpoint_max_age: 80819529
Innodb_data_fsyncs: 1
Innodb_data_pending_fsyncs: 0
Innodb_data_pending_reads: 0
Innodb_data_pending_writes: 0
Innodb_data_read: 3096576
Innodb_data_reads: 209
Innodb_data_writes: 0
Innodb_data_written: 0
Innodb_dblwr_pages_written: 0
Innodb_dblwr_writes: 0
Innodb_deadlocks: 0
Innodb_history_list_length: 0
Innodb_log_waits: 0
Innodb_log_write_requests: 0
Innodb_log_writes: 0
Innodb_lsn_current: 564492
Innodb_lsn_flushed: 564492
Innodb_lsn_last_checkpoint: 564476
Innodb_master_thread_active_loops: 0
Innodb_master_thread_idle_loops: 3738
Innodb_max_trx_id: 1183
Innodb_mem_adaptive_hash: 0
Innodb_mem_dictionary: 27799448
Innodb_os_log_written: 0
Innodb_page_size: 16384
Innodb_pages_created: 131
Innodb_pages_read: 189
Innodb_pages_written: 0
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_num_open_files: 14
Innodb_truncated_status_writes: 0
Innodb_available_undo_logs: 128
Innodb_undo_truncations: 0
Innodb_page_compression_saved: 0
Innodb_num_pages_page_compressed: 0
Innodb_num_page_compressed_trim_op: 0
Innodb_num_pages_page_decompressed: 0
Innodb_num_pages_page_compression_error: 0
Innodb_num_pages_encrypted: 0
Innodb_num_pages_decrypted: 0
Innodb_have_lz4: OFF
Innodb_have_lzo: OFF
Innodb_have_lzma: OFF
Innodb_have_bzip2: OFF
Innodb_have_snappy: OFF
Innodb_have_punch_hole: ON
Innodb_instant_alter_column: 0
Innodb_onlineddl_rowlog_rows: 0
Innodb_onlineddl_rowlog_pct_used: 0
Innodb_onlineddl_pct_progress: 0
Innodb_encryption_rotation_pages_read_from_cache: 0
Innodb_encryption_rotation_pages_read_from_disk: 0
Innodb_encryption_rotation_pages_modified: 0
Innodb_encryption_rotation_pages_flushed: 0
Innodb_encryption_rotation_estimated_iops: 0
Innodb_encryption_n_merge_blocks_encrypted: 0
Innodb_encryption_n_merge_blocks_decrypted: 0
Innodb_encryption_n_rowlog_blocks_encrypted: 0
Innodb_encryption_n_rowlog_blocks_decrypted: 0
Innodb_encryption_n_temp_blocks_encrypted: 0
Innodb_encryption_n_temp_blocks_decrypted: 0
Innodb_encryption_num_key_requests: 0
Innodb_bulk_operations: 0
Key_blocks_not_flushed: 0
Key_blocks_unused: 107163
Key_blocks_used: 0
Key_blocks_warm: 0
Key_read_requests: 0
Key_reads: 0
Key_write_requests: 0
Key_writes: 0
Last_query_cost: 0.000000
Master_gtid_wait_count: 0
Master_gtid_wait_time: 0
Master_gtid_wait_timeouts: 0
Max_memory_used: 92824
Max_statement_time_exceeded: 0
Max_tmp_space_used: 0
Max_used_connections: 2
Max_used_connections_time: 2025-09-04 01:37:58
Memory_used: 91808
Memory_used_initial: 4523479536
Not_flushed_delayed_rows: 0
Open_files: 23
Open_streams: 4
Open_table_definitions: 18
Open_tables: 10
Opened_files: 72
Opened_plugin_libraries: 0
Opened_table_definitions: 0
Opened_tables: 0
Opened_views: 0
Optimizer_join_prefixes_check_calls: 0
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_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
Qcache_free_blocks: 1
Qcache_free_memory: 1031344
Qcache_hits: 0
Qcache_inserts: 0
Qcache_lowmem_prunes: 0
Qcache_not_cached: 0
Qcache_queries_in_cache: 0
Qcache_total_blocks: 1
Queries: 44
Query_time: 0.000000
Questions: 1
Resultset_metadata_skipped: 0
Rows_read: 0
Rows_sent: 0
Rows_tmp_read: 0
Rpl_semi_sync_master_clients: 0
Rpl_semi_sync_master_get_ack: 0
Rpl_semi_sync_master_net_avg_wait_time: 0
Rpl_semi_sync_master_net_wait_time: 0
Rpl_semi_sync_master_net_waits: 0
Rpl_semi_sync_master_no_times: 0
Rpl_semi_sync_master_no_tx: 0
Rpl_semi_sync_master_request_ack: 0
Rpl_semi_sync_master_status: OFF
Rpl_semi_sync_master_timefunc_failures: 0
Rpl_semi_sync_master_tx_avg_wait_time: 0
Rpl_semi_sync_master_tx_wait_time: 0
Rpl_semi_sync_master_tx_waits: 0
Rpl_semi_sync_master_wait_pos_backtraverse: 0
Rpl_semi_sync_master_wait_sessions: 0
Rpl_semi_sync_master_yes_tx: 0
Rpl_semi_sync_slave_send_ack: 0
Rpl_semi_sync_slave_status: OFF
Rpl_status: AUTH_MASTER
Rpl_transactions_multi_engine: 0
Select_full_join: 0
Select_full_range_join: 0
Select_range: 0
Select_range_check: 0
Select_scan: 0
Slave_connections: 0
Slave_heartbeat_period: 0.000
Slave_open_temp_tables: 0
Slave_received_heartbeats: 0
Slave_retried_transactions: 0
Slave_running: OFF
Slave_skipped_errors: 0
Slaves_connected: 0
Slaves_running: 0
Slow_launch_threads: 0
Slow_queries: 0
Sort_merge_passes: 0
Sort_priority_queue_sorts: 0
Sort_range: 0
Sort_rows: 0
Sort_scan: 0
Ssl_accept_renegotiates: 0
Ssl_accepts: 15
Ssl_callback_cache_hits: 0
Ssl_cipher: ECDHE-RSA-AES256-GCM-SHA384
Ssl_cipher_list: TLS13-AES128-GCM-SHA256:TLS13-AES256-GCM-SHA384:TLS13-CHACHA20-POLY1305-SHA256:DES-CBC3-SHA:AES128-SHA:AES256-SHA:DHE-RSA-AES128-SHA:DHE-RSA-AES256-SHA:ECDHE-RSA-AES128-SHA:ECDHE-RSA-AES256-SHA:ECDHE-ECDSA-AES128-SHA:ECDHE-ECDSA-AES256-SHA:ECDHE-RSA-DES-CBC3-SHA:ECDHE-ECDSA-DES-CBC3-SHA:AES128-SHA256:AES256-SHA256:DHE-RSA-AES128-SHA256:DHE-RSA-AES256-SHA256:AES128-GCM-SHA256:AES256-GCM-SHA384:DHE-RSA-AES128-GCM-SHA256:DHE-RSA-AES256-GCM-SHA384:ECDHE-RSA-AES128-GCM-SHA256:ECDHE-RSA-AES256-GCM-SHA384:ECDHE-ECDSA-AES128-GCM-SHA256:ECDHE-ECDSA-AES256-GCM-SHA384:ECDHE-RSA-AES128-SHA256:ECDHE-ECDSA-AES128-SHA256:ECDHE-RSA-AES256-SHA384:ECDHE-ECDSA-AES256-SHA384:ECDHE-RSA-CHACHA20-POLY1305:ECDHE-ECDSA-CHACHA20-POLY1305:DHE-RSA-CHACHA20-POLY1305:ECDHE-RSA-CHACHA20-POLY1305-OLD:ECDHE-ECDSA-CHACHA20-POLY1305-OLD:DHE-RSA-CHACHA20-POLY1305-OLD:EDH-RSA-DES-CBC3-SHA
Ssl_client_connects: 0
Ssl_connect_renegotiates: 0
Ssl_ctx_verify_depth: 9
Ssl_ctx_verify_mode: 1
Ssl_default_timeout: 500
Ssl_finished_accepts: 15
Ssl_finished_connects: 0
Ssl_server_not_after: Sep 1 17:27:48 2035 GMT
Ssl_server_not_before: Sep 3 17:27:48 2025 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: 33
Ssl_session_cache_timeouts: 0
Ssl_sessions_reused: 0
Ssl_used_session_cache_entries: 0
Ssl_verify_depth: 9
Ssl_verify_mode: 0
Ssl_version: TLSv1.2
Stack_usage: 10800
Subquery_cache_hit: 0
Subquery_cache_miss: 0
Syncs: 16
Table_locks_immediate: 25
Table_locks_waited: 0
Table_open_cache_active_instances: 1
Table_open_cache_hits: 0
Table_open_cache_misses: 0
Table_open_cache_overflows: 0
Tc_log_max_pages_used: 0
Tc_log_page_size: 4096
Tc_log_page_waits: 0
Threadpool_idle_threads: 0
Threadpool_threads: 1
Threads_cached: 0
Threads_connected: 1
Threads_created: 8
Threads_running: 1
Tmp_space_used: 0
Transactions_gtid_foreign_engine: 0
Transactions_multi_engine: 0
Update_scan: 0
Uptime: 37502
Uptime_since_flush_status: 0
=====run_query=======
status: 2
status: 1
error: Failed to mysql_real_connect() , mysqlinfo: (2013) [HY000] "Lost connection to server at 'reading authorization packet', system error: 2"