mysqli::stat 함수는 MySQL 서버의 통계를 얻기 위한 함수입니다. 이 함수를 사용하여 MySQL 서버의 통계를 얻으려면 다음과 같은 방법을 사용할 수 있습니다.
```php
$mysqli = new mysqli("호스트 이름", "사용자 이름", "비밀번호", "데이터베이스 이름");
$result = $mysqli->stat;
echo "MySQL 서버의 통계:\n";
echo "Uptime: " . $result['Uptime'] . "\n";
echo "Threads_connected: " . $result['Threads_connected'] . "\n";
echo "Threads_running: " . $result['Threads_running'] . "\n";
echo "Aborted_connects: " . $result['Aborted_connects'] . "\n";
echo "Open_tables: " . $result['Open_tables'] . "\n";
echo "Open_files: " . $result['Open_files'] . "\n";
echo "Max_used_connections: " . $result['Max_used_connections'] . "\n";
echo "Com_commit: " . $result['Com_commit'] . "\n";
echo "Com_rollback: " . $result['Com_rollback'] . "\n";
echo "Uptime_since_flush_tables: " . $result['Uptime_since_flush_tables'] . "\n";
echo "Query_cache_type: " . $result['Query_cache_type'] . "\n";
echo "Query_cache_size: " . $result['Query_cache_size'] . "\n";
echo "Query_cache_limit: " . $result['Query_cache_limit'] . "\n";
echo "Open_streams: " . $result['Open_streams'] . "\n";
echo "Open_links: " . $result['Open_links'] . "\n";
echo "Threads_cached: " . $result['Threads_cached'] . "\n";
echo "Query_cache_memory_usage: " . $result['Query_cache_memory_usage'] . "\n";
echo "Max_connections: " . $result['Max_connections'] . "\n";
echo "Temp_tables: " . $result['Temp_tables'] . "\n";
echo "Table_locks_waited: " . $result['Table_locks_waited'] . "\n";
echo "Table_locks_immediate: " . $result['Table_locks_immediate'] . "\n";
echo "Innodb_buffer_pool_pages_total: " . $result['Innodb_buffer_pool_pages_total'] . "\n";
echo "Innodb_buffer_pool_pages_data: " . $result['Innodb_buffer_pool_pages_data'] . "\n";
echo "Innodb_buffer_pool_pages_dirty: " . $result['Innodb_buffer_pool_pages_dirty'] . "\n";
echo "Innodb_buffer_pool_pages_flushed: " . $result['Innodb_buffer_pool_pages_flushed'] . "\n";
echo "Innodb_buffer_pool_pages_free: " . $result['Innodb_buffer_pool_pages_free'] . "\n";
echo "Innodb_buffer_pool_pages_misc: " . $result['Innodb_buffer_pool_pages_misc'] . "\n";
echo "Innodb_buffer_pool_pages_total: " . $result['Innodb_buffer_pool_pages_total'] . "\n";
echo "Innodb_buffer_pool_read_requests: " . $result['Innodb_buffer_pool_read_requests'] . "\n";
echo "Innodb_buffer_pool_reads: " . $result['Innodb_buffer_pool_reads'] . "\n";
echo "Innodb_buffer_pool_write_requests: " . $result['Innodb_buffer_pool_write_requests'] . "\n";
echo "Innodb_data_fsyncs: " . $result['Innodb_data_fsyncs'] . "\n";
echo "Innodb_data_read: " . $result['Innodb_data_read'] . "\n";
echo "Innodb_data_written: " . $result['Innodb_data_written'] . "\n";
echo "Innodb_dblwr_pages_written: " . $result['Innodb_dblwr_pages_written'] . "\n";
echo "Innodb_dblwr_writes: " . $result['Innodb_dblwr_writes'] . "\n";
echo "Innodb_log_waits: " . $result['Innodb_log_waits'] . "\n";
echo "Innodb_log_write_requests: " . $result['Innodb_log_write_requests'] . "\n";
echo "Innodb_os_log_fsyncs: " . $result['Innodb_os_log_fsyncs'] . "\n";
echo "Innodb_os_log_merged_rec: " . $result['Innodb_os_log_merged_rec'] . "\n";
echo "Innodb_os_log_merged_xa: " . $result['Innodb_os_log_merged_xa'] . "\n";
echo "Innodb_os_log_written: " . $result['Innodb_os_log_written'] . "\n";
echo "Innodb_page_compression: " . $result['Innodb_page_compression'] . "\n";
echo "Innodb_page_size: " . $result['Innodb_page_size'] . "\n";
echo "Innodb_pages_created: " . $result['Innodb_pages_created'] . "\n";
echo "Innodb_pages_read: " . $result['Innodb_pages_read'] . "\n";
echo "Innodb_pages_written: " . $result['Innodb_pages_written'] . "\n";
echo "Innodb_row_lock_current_waits: " . $result['Innodb_row_lock_current_waits'] . "\n";
echo "Innodb_row_lock_time: " . $result['Innodb_row_lock_time'] . "\n";
echo "Innodb_row_lock_time_avg: " . $result['Innodb_row_lock_time_avg'] . "\n";
echo "Innodb_row_lock_time_max: " . $result['Innodb_row_lock_time_max'] . "\n";
echo "Innodb_row_lock_waits: " . $result['Innodb_row_lock_waits'] . "\n";
echo "Innodb_rows_deleted: " . $result['Innodb_rows_deleted'] . "\n";
echo "Innodb_rows_inserted: " . $result['Innodb_rows_inserted'] . "\n";
echo "Innodb_rows_read: " . $result['Innodb_rows_read'] . "\n";
echo "Innodb_rows_updated: " . $result['Innodb_rows_updated'] . "\n";
echo "Innodb_truncated_history: " . $result['Innodb_truncated_history'] . "\n";
echo "Innodb_truncated_history_days: " . $result['Innodb_truncated_history_days'] . "\n";
echo "Innodb_xa_recover: " . $result['Innodb_xa_recover'] . "\n";
echo "Key_blocks_not_flushed: " . $result['Key_blocks_not_flushed'] . "\n";
echo "Key_blocks_unused: " . $result['Key_blocks_unused'] . "\n";
echo "Key_blocks_used: " . $result['Key_blocks_used'] . "\n";
echo "Key_read_requests: " . $result['Key_read_requests'] . "\n";
echo "Key_reads: " . $result['Key_reads'] . "\n";
echo "Key_write_requests: " . $result['Key_write_requests'] . "\n";
echo "Key_writes: " . $result['Key_writes'] . "\n";
echo "Last_query_cost: " . $result['Last_query_cost'] . "\n";
echo "Last_query_time: " . $result['Last_query_time'] . "\n";
echo "Max_used_connections: " . $result['Max_used_connections'] . "\n";
echo "Open_files: " . $result['Open_files'] . "\n";
echo "Open_streams: " . $result['Open_streams'] . "\n";
echo "Open_tables: " . $result['Open_tables'] . "\n";
echo "Opened_tables: " . $result['Opened_tables'] . "\n";
echo "Performance_schema_max_digest_length: " . $result['Performance_schema_max_digest_length'] . "\n";
echo "Performance_schema_max_digests: " . $result['Performance_schema_max_digests'] . "\n";
echo "Performance_schema_max_digests_history: " . $result['Performance_schema_max_digests_history'] . "\n";
echo "Performance_schema_max_digests_history_size: " . $result['Performance_schema_max_digests_history_size'] . "\n";
echo "Performance_schema_max_digests_size: " . $result['Performance_schema_max_digests_size'] . "\n";
echo "Performance_schema_max_digests: " . $result['Performance_schema_max_digests'] . "\n";
echo "Performance_schema_max_digests_history: " . $result['Performance_schema_max_digests_history'] . "\n";
echo "Performance_schema_max_digests_history_size: " . $result['Performance_schema_max_digests_history_size'] . "\n";
echo "Performance_schema_max_digests_size: " . $result['Performance_schema_max_digests_size'] . "\n";
echo "Performance_schema_max_digests: " . $result['Performance_schema_max_digests'] . "\n";
echo "Performance_schema_max_digests_history: " . $result['Performance_schema_max_digests_history'] . "\n";
2025-03-15 18:12