sun's longitude:08 30 37 
¡¤ ÀÚÀ¯°Ô½ÃÆÇ ¡¤ ¹¯°í´äÇϱ⠡¤ ¾ËÆĹ®¼­ ¡¤ RPMS list
¡¤ »ç¿ëÀÚ¹®¼­ ¡¤ ÆÁ/FAQ¸ðÀ½ ¡¤ ¸®´ª½ºLinks ¡¤ ÀÚ·á½Ç
¡¤ ¼­¹öÁ¤º¸ ¡¤ ¿î¿µÀÚ ¡¤ Books/FAQ ¡¤ FreeBSD
 
/mysql.php:¼Ò½ºº¸±â   
mysql status Ver. 20041230
MY DATABASE STATUS (connected by UNIX socket)
Å×À̺í À̸§ Å×À̺í ŸÀÔ ·¹ÄÚµå ¼ö ·¹ÄÚµå Æò±Õ Å©±â »ç¿ë·® Index Å©±â
agony 14 884 Bytes 12 KB 4 KB
alpha 361 1 KB 457 KB 26 KB
annon 45 454 Bytes 20 KB 2 KB
cache_times 11 20 Bytes 228 Bytes 1 KB
denylist 44,836 258 Bytes 11 MB 399 KB
free 505 689 Bytes 340 KB 31 KB
freebsd 50 2 KB 89 KB 4 KB
freshmeat 11 60 Bytes 664 Bytes 1 KB
gaggle 12 192 Bytes 2 KB 6 KB
gametome 11 62 Bytes 692 Bytes 1 KB
gimpnews 3 66 Bytes 200 Bytes 1 KB
gnomenews 10 70 Bytes 704 Bytes 1 KB
kdenews 8 78 Bytes 628 Bytes 1 KB
linuxtoday 10 121 Bytes 1 KB 1 KB
mozilla 21 88 Bytes 2 KB 1 KB
mozillazine 30 101 Bytes 3 KB 1 KB
mstatus 24 16 Bytes 384 Bytes 1 KB
news 3 204 Bytes 612 Bytes 2 KB
qna 6,993 2 KB 12 MB 361 KB
referer 12,868 186 Bytes 2 MB 750 KB
rpmlist 0 0 Bytes 0 Bytes 1 KB
san3 22 686 Bytes 15 KB 4 KB
screen 12,428 216 Bytes 3 MB 1 MB
screen_heap 0 767 Bytes 0 Bytes 0 Bytes
screen_myisam 0 0 Bytes 0 Bytes 1 KB
segfault 15 100 Bytes 1 KB 1 KB
slashdot 10 92 Bytes 928 Bytes 1 KB
spambox 213 2 KB 359 KB 5 KB
linuxchannel2 28 tables 78,514 394 Bytes 29 MB 3 MB

SUMMARY OF DATABASE STATUS (connected by UNIX socket)
µ¥ÀÌÅͺ£À̽º À̸§ Å×ÀÌºí °³¼ö ·¹ÄÚµå ¼ö(°è) ·¹ÄÚµå Æò±Õ Å©±â »ç¿ë·®(°è) Index Å©±â(°è)
linuxchannel2 28 tables 78,514 394 Bytes 29 MB 3 MB

MYSQL SERVER STATUS (connected by UNIX socket)
Ç׸ñ STATUS commnets, [***] Ç¥½Ã´Â ¼º´É Çâ»ó°ú °ü·ÃµÊ
TOTAL_STATUS 0.00 normal (1ÃÊ´ç Æò±Õ Äõ¸® ¿äû¼ö)
CRITICAL_LIFE_TIME 73ÃÊ Ä¿³Ø¼Ç´ç Æò±ÕÀûÀÎ(Ãß¼¼) ÀÓ°è life time(CUR)
CRITICAL_LIFE_TIME_MAX 251ÃÊ Ä¿³Ø¼Ç´ç Æò±ÕÀûÀÎ(ÃÖ´ë) ÀÓ°è life time(EXP)
All_databases 2 or more µ¥ÀÌÅͺ£À̽º ¼ö
Aborted_clients 184 ¿¬°á Ãë¼Ò Clients ¼ö, refer 5(5ÃÊ)[wait_timeout] and 5(5ÃÊ)[interactive_timeout]
Aborted_connects 217,855 ¿¬°á ½ÇÆмö, refer 5(5ÃÊ)[connect_timeout]
Aborted_clients_percent 0.02% ¿¬°á Ãë¼ÒÀ², Á¤»ó[Âü°í]
Aborted_connects_percent 18.59% ¿¬°á ½ÇÆÐÀ²,
À߸øµÈ(fail) Á¢¼Ó ¿äûÀÌ ¸¹½À´Ï´Ù(¿¬°á ½ÇÆÐ)(±âÁØ 1 %). 5(5ÃÊ)(connect_timeout)º¸´Ù ±ä ¿¬°á ¿äû, Ʋ¸° ¾ÏÈ£, Á¢±Ù ±ÇÇÑ ¹®Á¦.
Bytes_received 497 Bytes ¼ö½Å·®(ÃÑ)
Bytes_sent 6 KB Àü¼Û·®(ÃÑ)
Bytes_per_rs 11.63 ¹Þ°í(1) º¸³»´Â(x) ºñÀ², 1:x
Bytes_sent_per_sec 0 Bytes Àü¼Û·®(ÃÊ´ç)
Bytes_sent_per_min 0 Bytes Àü¼Û·®(ºÐ´ç)
Bytes_sent_per_hour 11 Bytes Àü¼Û·®(½Ã°£´ç)
Bytes_sent_per_day 255 Bytes Àü¼Û·®(ÇÏ·çÆò±Õ)
Com_delete 0.00% DELETE Äõ¸® »ç¿ëÀ²(Àüü DB Åë°è)
Com_insert 0.00% INSERT Äõ¸® »ç¿ëÀ²(Àüü DB Åë°è)
Com_select 41.67% SELECT Äõ¸® »ç¿ëÀ²(Àüü DB Åë°è)
Com_update 0.00% UPDATE Äõ¸® »ç¿ëÀ²(Àüü DB Åë°è)
Com_replace 0.00% REPLACE Äõ¸® »ç¿ëÀ²(Àüü DB Åë°è)
Com_lock_tables 0.00% LOCK TABLES Äõ¸® »ç¿ëÀ²(Àüü DB Åë°è)
Connections 1,172,175 ÃÑ connections ¼ö
Connections_per_sec 0.60 ÃÊ´ç connections ¼ö
Created_tmp_tables 3 ¸Þ¸ð¸®¿¡ »ý¼ºµÈ Àӽà Å×ÀÌºí ¼ö
Created_tmp_disk_tables 0 DISK¿¡ »ý¼ºµÈ Àӽà Å×ÀÌºí ¼ö, 33,554,432(32 MB)[tmp_table_size]º¸´Ù ¸¹Àº ¸Þ¸ð¸®¸¦ ¿ä±¸ÇÏ´Â SQL ±¸¹®À» ½ÇÇà½Ã ´©°èµÊ
Create_tmp_disk_tables_per 0.00% DISK¿¡ »ý¼ºµÈ Àӽà Å×ÀÌºí »ç¿ë ºñÀ²
Created_tmp_files 5,909 mysqld °¡ »ý¼ºÇÑ Àӽà ÆÄÀÏ ¼ö
Delayed_writes 547 INSERT DELAYED ±¸¹®À¸·Î ±â·ÏµÈ rows ¼ö
Delayed_errors 29 INSERT DELAYED ±¸¹®À¸·Î ±â·Ï½Ã ¿¡·¯(duplicate key Æ÷ÇÔ)³­ rows ¼ö(¾ø¾î¾ß ÀÛ¾Æ¾ß Á¤»ó)
Delayed_errors_per 0.05% INSERT DELAYED ¿¡·¯ ºñÀ²(0À̰ųª ÀÛ¾Æ¾ß Á¤»ó)
Intervals_of_connection 1.667 Ä¿³Ø¼Ç ÁÖ±â(ÃÊ)
Intervals_of_question 162838.333 Äõ¸® ÁÖ±â(ÃÊ)
Key_reads 1,290,578 DISK¿¡¼­ Key ÀÐÀº ¼ö
Key_read_requests 661,969,411 ij½Ã¿¡¼­ Key Àб⠿äû¼ö
Key_writes 1,883,410 DISK¿¡ Key¸¦ ¾´ ¼ö
Key_write_requests 5,361,976 ij½Ã¿¡ Key ¾²±â ¿äû¼ö
Key_reads_per_request 0.00% DISK¿¡¼­ Key¸¦ Àд ºñÀ², Á¤»ó
Key_writes_per_request 0.35% DISK¿¡ Key¸¦ ¾²´Â ºñÀ², º¸Åë 1¿¡ °¡±î¿ö¾ß Á¤»ó
Max_used_connections 86 µ¿½Ã¿¡ ¿¬°áµÈ ÃÖ´ë°ª, Á¤»ó
Open_tables 1,024 ÇöÀç ¿­·ÁÀÖ´Â Tables ¼ö
Opened_tables 17 ¿­·È´ø Tables ¼ö, refer 1,024[table_cache], 0.00/Connection
Qcache_queries_in_cache 7,003 query cache: µî·ÏµÈ Äõ¸® ¼ö
Qcache_inserts 2,836,788 query cache: Ãß°¡µÈ Äõ¸® ¼ö
Qcache_hits 11,988,996 query cache: hit ¼ö
Qcache_lowmem_prunes 638,820 query cache: ÀÛÀº ¸Þ¸ð¸®(refer 33,554,432(32 MB)[query_cache_size]) ¶§¹®¿¡ Áö¿öÁø Äõ¸® ¼ö, ÀÌ °ªÀÌ ÀÛ¾Æ¾ß Á¤»ó
Qcache_not_cached 1,246,965 query cache: non-cached Äõ¸® ¼ö, not cachable, refer [query_cache_type]
Qcache_free_memory 9,437,800(9 MB) query cache: ³²¾Æ ÀÖ´Â query cache ¸Þ¸ð¸® ¾ç, refer 33,554,432(32 MB)[query_cache_size]
Qcache_free_blocks 2,422 query cache: ³²¾Æ ÀÖ´Â query cache blocks ¼ö
Qcache_total_blocks 17,758 query cache: ÃÑ query cache blocks ¼ö
Questions 12 ÇöÀç±îÁö Äõ¸® ¿äû¼ö
Questions_per_connect 0.00 Ä¿³Ø¼Ç´ç Æò±Õ Äõ¸® ¿äû¼ö
Select_full_join 0 Key ¾øÀÌ FULL-JOIN Ƚ¼ö
Slow_queries 0 10(10ÃÊ)[long_query_time]ÃÊ º¸´Ù Å« Äõ¸® ¿äû¼ö
Table_locks_waited 2½Ã°£ 45ºÐ 56ÃÊ Lock wait Ãѽð£
Threads_cached 7 ij½ÃµÈ ¾²·¹µå¼ö, 8[thread_cache_size]º¸´Ù Ç×»ó ÀÛÀ½
Threads_connected 1 ÇöÀç ¿­·ÁÀÖ´Â Ä¿³Ø¼Ç ¼ö
Threads_created 2,236 ÇöÀç±îÁö handle Ä¿³Ø¼Ç¿¡ »ý¼ºµÈ ¾²·¹µå ¼ö
Threads_running 1 ÇöÀç ±¸µ¿ÁßÀÎ ¾²·¹µå ¼ö(not sleeping)
Threads_created_per 0.00% Ä¿³Ø¼Ç´ç »ý¼ºµÈ Æò±Õ ¾²·¹µå ¼ö(±âÁØ 0.01%), Á¤»ó[Âü°í]
Uptime 22ÀÏ 14½Ã°£ 47ºÐ 40ÃÊ ÃÖ±Ù MySQL ¼­¹ö ±¸µ¿ ½Ã°£

MYSQL SERVER VARIABLES (connected by UNIX socket)
Ç׸ñ VARIABLES commnets, [***] Ç¥½Ã´Â ¼º´É Çâ»ó°ú °ü·ÃµÊ
back_log 50 listen(2), net.ipv4.tcp_max_syn_backlog
connect_timeout 5(5ÃÊ) bad handshake timeout(ÃÊ),
À߸øµÈ(fail) Á¢¼Ó ¿äûÀÌ ¸¹½À´Ï´Ù(¿¬°á ½ÇÆÐ)(±âÁØ 1 %). 5(5ÃÊ)(connect_timeout)º¸´Ù ±ä ¿¬°á ¿äû, Ʋ¸° ¾ÏÈ£, Á¢±Ù ±ÇÇÑ ¹®Á¦.
have_query_cache YES query cache Áö¿ø ¿©ºÎ
query_cache_size 33,554,432(32 MB) query cache Å©±â ¼³Á¤, 0Àº OFF(ÇöÀç:ON) refer [Qcache_xxx]
join_buffer_size 131,072(128 KB) [***] FULL-JOIN¿¡ »ç¿ëµÇ´Â ¸Þ¸ð¸®
key_buffer_size 536,870,912(512 MB) [***] INDEX key buffer¿¡ »ç¿ëµÇ´Â ¸Þ¸ð¸®, refer [Key_xxx], Á¤»ó
log OFF ·Î±× ±â·Ï ¿©ºÎ
log_update UPDATE ·Î±× ±â·Ï ¿©ºÎ
log_bin OFF binary ·Î±× ±â·Ï ¿©ºÎ
long_query_time 10(10ÃÊ) refer 0[Slow_queries]
lower_case_table_names 0 Å×ÀÌºí ´ë¼Ò¹®ÀÚ ±¸º°À¯¹«(0 ±¸º°)
max_allowed_packet 2,097,152(2 MB) ÃÖ´ë Çã¿ëÇÒ ÆÐŶ
max_connections 300 [***] ÃÖ´ë µ¿½Ã Á¢¼Ó Ä¿³Ø¼Ç ¼ö, refer 86[Max_used_connections], Á¤»ó
max_delayed_threads 20 ÃÖ´ë delayed ¾²·¹µå ¼ö, INSERT DELAYED ±¸¹®°ú °ü·ÃµÊ
max_join_size 18,446,744,073,709,551,616(17,179,869,136.0 GB) JOIN¿¡ »ç¿ëµÉ ÃÖ´ë Å©±â(¸Þ¸ð¸® ¾Æ´Ô)
max_sort_length 1,024(1 KB) TEXT, BLOBÀÇ Á¤·Ä¿¡ »ç¿ëµÇ´Â ÃÖ´ë Å©±â
max_user_connections 0 ÃÖ´ë µ¿½Ã user ¼ö(0Àº Á¦ÇѾøÀ½)
myisam_max_extra_sort_file_size 0(0 Bytes) ºü¸¥ INDEX¸¦ »ý¼º½Ã »ç¿ëµÇ´Â ÃÖ´ë Àӽà ÆÄÀÏ Å©±â
myisam_max_sort_file_size 9,223,372,036,853,727,232(8,589,934,568.0 GB) REPAIR, ALTER, LOAD...µî INDEX¸¦ Àç»ý¼º½Ã »ç¿ëµÇ´Â Àӽà ÆÄÀÏ Å©±â
myisam_sort_buffer_size 8,388,608(8 MB) [***] REPAIR, INDEX, ALTER Á¤·Ä¿¡ »ç¿ëÇÏ´Â ¸Þ¸ð¸®
open_files_limit 2,358 ÆÄÀÏ open Á¦ÇÑ ¼ö(0Àº Á¦ÇѾøÀ½)
read_buffer_size 2,097,152(2 MB) [***] ¼øÂ÷ÀûÀÎ °Ë»ö¿¡ »ç¿ëµÇ´Â ¸Þ¸ð¸®(read_buffer_size)
read_rnd_buffer_size 8,388,608(8 MB) [***] ORDER BY Á¤·Ä¿¡ »ç¿ëµÇ´Â ¸Þ¸ð¸®(to avoid a disk seeks)
safe_show_database NA Á¦ÇÑÀûÀÎ SHOW DATABASE ±¸¹® »ç¿ë ¿©ºÎ, 4.0.xx ¿¡¼­´Â ÀÛµ¿Àº ÇÏÁö¸¸ ÀÌ Ç׸ñÀº Ãâ·ÂµÇÁö ¾Ê½À´Ï´Ù.
skip_external_locking ON ¿ÜºÎ lock À» »ç¿ëÇÑ´Ù¸é OFF·Î ¼³Á¤.
skip_networking OFF TCP/IP ¿¬°á ¿©ºÎ(ONÀº UNIX domain socket, OFF´Â TCP/IP ¿¬°á),
ÇöÀç UNIX domain socket(:/tmp/mysql.sock)À» »ç¿ëÇÏ°í ÀÖ½À´Ï´Ù. µ¶¸³µÈ ´Ù¸¥ È£½ºÆ®¿¡¼­ ¿¬°áÇÏ´Â °æ¿ì°¡ ¾ø´Ù¸é ÀÌ ¿É¼ÇÀ» ONÀ¸·Î ¼³Á¤Çϼ¼¿ä
skip_show_database OFF SHOW DATABASES ±¸¹® »ç¿ë ¿©ºÎ(ONÀº ¿øõºÀ¼â, OFF´Â »ç¿ë°¡´É)
sort_buffer_size 8,388,608(8 MB) [***] ORDER BY, GROUP BY Á¤·Ä¿¡ »ç¿ëµÇ´Â ¸Þ¸ð¸®
table_cache 1,024 [***] Çѹø¿¡(all thread) ¿­ ¼ö ÀÖ´Â Å×ÀÌºí ¼ö, refer 17[Opened_tables]
thread_cache_size 8 [***] ¾²·¹µå ij½Ã Àç»ç¿ë ¼ö, refer 1,172,175[Connections], 2,236[Threads_created], °è»êµÈ ÃßÁ¤°ª(ÃÖ¼Ò:1, ±ÇÀå:3, ÃÖ´ë:5), Á¤»ó[Âü°í]
tmp_table_size 33,554,432(32 MB) [***] º¹ÀâÇÑ GROUP BY Á¤·Ä¿¡ »ç¿ëµÇ´Â ¸Þ¸ð¸®(to avoid a disk seeks), refer 0[Created_tmp_disk_tables]
interactive_timeout 5(5ÃÊ) interactive -> re-active¿¡ ±â´Ù¸®´Â ½Ã°£(ÀÌÈÄ closed), Á¤»ó[Âü°í]
wait_timeout 5(5ÃÊ) none interactive -> re-active¿¡ ±â´Ù¸®´Â ½Ã°£(ÀÌÈÄ closed), °è»êµÈ ÃßÁ¤°ª(Ãß¼¼:73ÃÊ, ÀÓ°è:251ÃÊ), Á¤»ó[Âü°í]
timezone ÇöÀç MySQL ¼­¹öÀÇ TIME-ZONE
version 5.0.96 ÇöÀç MySQL ¼­¹ö ¹öÀü


apache lighttpd linuxchannel.net 
Copyright 1997-2024. linuxchannel.net. All rights reserved.

Page loading: 0.44(server) + (network) + (browser) seconds