¾È³çÇϼ¼¿ä.
°©Àڱ⠺Ҿ¦ ±Û¾²°Ô µÈÁ¡ Á˼ÛÇÏ°Ô »ý°¢ ÇÕ´Ï´Ù.
´Ù¸§ÀÌ ¾Æ´Ï¶ó, ÀúÈñ db ¼¹ö°¡ À̹ø¿¡ ºÎÇÏ°¡ ¾öû³ª°Ô ÀϾ¼ ã´Ù ã´Ù ÀÌ°÷±îÁö
¿À°Ô µÇ¾ú½À´Ï´Ù.
¿ö³« ¸¹Àº µ¥ÀÌŸ¸¦ º¸¿©ÁÖ·Á´Ù º¸´Ï, ºÎÇÏ°¡ ¸¹À»¼ö ¹Û¿¡ ¾ø´Â °÷À̱ä ÇÕ´Ï´Ù.
ÀúÈñ db ¼¹ö¸¦ ¾î¶»°Ô ÇØ¾ß µÉÁö Á¶¾ð ÁÖ½Ã¸é °¨»çÇÏ°Ú½À´Ï´Ù.
=============================================================================
MYSQL SERVER STATUS (connected by TCP/IP), ´©ÀûµÈ
Åë°èÀÚ·á°¡ ³Ê¹« Àû½À´Ï´Ù.
Ç׸ñ |
STATUS |
commnets, [***] Ç¥½Ã´Â ¼º´É Çâ»ó°ú °ü·ÃµÊ |
TOTAL_STATUS |
327.35 |
hot busy (1ÃÊ´ç Æò±Õ Äõ¸® ¿äû¼ö) |
CRITICAL_LIFE_TIME |
13ÃÊ |
Ä¿³Ø¼Ç´ç Æò±ÕÀûÀÎ(Ãß¼¼) ÀÓ°è life time(CUR) |
CRITICAL_LIFE_TIME_MAX |
17ÃÊ |
Ä¿³Ø¼Ç´ç Æò±ÕÀûÀÎ(ÃÖ´ë) ÀÓ°è life time(EXP) |
All_databases |
3 or more |
µ¥ÀÌÅͺ£À̽º ¼ö |
Aborted_clients |
19,722 |
¿¬°á Ãë¼Ò Clients ¼ö, refer 3(3ÃÊ)[wait_timeout]
and 28,800(8½Ã°£ 0ÃÊ)[interactive_timeout] |
Aborted_connects |
31,879 |
¿¬°á ½ÇÆмö, refer 10(10ÃÊ)[connect_timeout] |
Aborted_clients_percent |
1.07% |
¿¬°á Ãë¼ÒÀ², ¿¬°á
Ãë¼Ò°¡ ¸¹½À´Ï´Ù(±âÁØ 1%). 3(3ÃÊ)(wait_timeout)Ãʳª
28,800(8½Ã°£ 0ÃÊ)(interactive_timeout)Ãʺ¸´Ù
´Ê°Ô close Çϰųª ¿¬°áÀ» ²÷Áö ¾Ê´Â °æ¿ì°¡ ¸¹½À´Ï´Ù.[Âü°í] |
Aborted_connects_percent |
1.72% |
¿¬°á ½ÇÆÐÀ², À߸øµÈ(fail)
Á¢¼Ó ¿äûÀÌ ¸¹½À´Ï´Ù(¿¬°á ½ÇÆÐ)(±âÁØ 1 %). 10(10ÃÊ)(connect_timeout)º¸´Ù
±ä ¿¬°á ¿äû, Ʋ¸° ¾ÏÈ£, Á¢±Ù ±ÇÇÑ ¹®Á¦. |
Bytes_received |
806 MB |
¼ö½Å·®(ÃÑ) |
Bytes_sent |
2.5 GB |
Àü¼Û·®(ÃÑ) |
Bytes_per_rs |
3.17 |
¹Þ°í(1) º¸³»´Â(x) ºñÀ², 1:x |
Bytes_sent_per_sec |
44 KB |
Àü¼Û·®(ÃÊ´ç) |
Bytes_sent_per_min |
3 MB |
Àü¼Û·®(ºÐ´ç) |
Bytes_sent_per_hour |
155 MB |
Àü¼Û·®(½Ã°£´ç) |
Bytes_sent_per_day |
3.6 GB |
Àü¼Û·®(ÇÏ·çÆò±Õ), ¿¹»ó¼öÄ¡ |
Com_delete |
0.03% |
DELETE Äõ¸® »ç¿ëÀ²(Àüü DB Åë°è) |
Com_insert |
0.11% |
INSERT Äõ¸® »ç¿ëÀ²(Àüü DB Åë°è) |
Com_select |
45.10% |
SELECT Äõ¸® »ç¿ëÀ²(Àüü DB Åë°è) |
Com_update |
1.43% |
UPDATE Äõ¸® »ç¿ëÀ²(Àüü DB Åë°è) |
Com_replace |
0.00% |
REPLACE Äõ¸® »ç¿ëÀ²(Àüü DB Åë°è) |
Com_lock_tables |
0.00% |
LOCK TABLES Äõ¸® »ç¿ëÀ²(Àüü DB Åë°è) |
Connections |
1,849,471 |
ÃÑ connections ¼ö |
Connections_per_sec |
31.20 |
ÃÊ´ç connections ¼ö |
Created_tmp_tables |
1,218,737 |
¸Þ¸ð¸®¿¡ »ý¼ºµÈ Àӽà Å×ÀÌºí ¼ö |
Created_tmp_disk_tables |
1,191,002 |
DISK¿¡ »ý¼ºµÈ Àӽà Å×ÀÌºí ¼ö, 33,554,432(32 MB)[tmp_table_size]º¸´Ù
¸¹Àº ¸Þ¸ð¸®¸¦ ¿ä±¸ÇÏ´Â SQL ±¸¹®À» ½ÇÇà½Ã ´©°èµÊ |
Create_tmp_disk_tables_per |
97.72% |
DISK¿¡ »ý¼ºµÈ Àӽà Å×ÀÌºí »ç¿ë ºñÀ² |
Intervals_of_connection |
0.032 |
Ä¿³Ø¼Ç ÁÖ±â(ÃÊ) |
Intervals_of_question |
0.003 |
Äõ¸® ÁÖ±â(ÃÊ) |
Key_reads |
48,220 |
DISK¿¡¼ Key ÀÐÀº ¼ö |
Key_read_requests |
156,098,528 |
ij½Ã¿¡¼ Key Àб⠿äû¼ö |
Key_writes |
92,708 |
DISK¿¡ Key¸¦ ¾´ ¼ö |
Key_write_requests |
343,619 |
ij½Ã¿¡ Key ¾²±â ¿äû¼ö |
Key_reads_per_request |
0.00% |
DISK¿¡¼ Key¸¦ Àд ºñÀ², Á¤»ó |
Key_writes_per_request |
0.27% |
DISK¿¡ Key¸¦ ¾²´Â ºñÀ², º¸Åë 1¿¡ °¡±î¿ö¾ß Á¤»ó |
Max_used_connections |
740 |
µ¿½Ã¿¡ ¿¬°áµÈ ÃÖ´ë°ª, Á¤»ó |
Open_tables |
1,024 |
ÇöÀç ¿·ÁÀÖ´Â Tables ¼ö |
Opened_tables |
1,503 |
¿·È´ø Tables ¼ö, refer 1,024[table_cache], 1,024[table_cache]°ªÀ»
2048 Á¤µµ·Î ¿Ã¸®¼¼¿ä. |
Questions |
19,407,667 |
ÇöÀç±îÁö Äõ¸® ¿äû¼ö |
Questions_per_connect |
10.49 |
Ä¿³Ø¼Ç´ç Æò±Õ Äõ¸® ¿äû¼ö |
Select_full_join |
0 |
Key ¾øÀÌ FULL-JOIN Ƚ¼ö |
Slow_queries |
9,200 |
3(3ÃÊ)(long_query_time)ÃÊ
º¸´Ù Å« Äõ¸® ¿äû¼ö |
Table_locks_waited |
3ÀÏ 3½Ã°£ 55ºÐ 34ÃÊ |
Lock wait Ãѽð£ |
Threads_cached |
0 |
ij½ÃµÈ ¾²·¹µå¼ö, 0[thread_cache_size]º¸´Ù
Ç×»ó ÀÛÀ½ |
Threads_connected |
15 |
ÇöÀç ¿·ÁÀÖ´Â Ä¿³Ø¼Ç ¼ö |
Threads_created |
1,849,470 |
ÇöÀç±îÁö handle Ä¿³Ø¼Ç¿¡ »ý¼ºµÈ ¾²·¹µå ¼ö |
Threads_running |
8 |
ÇöÀç ±¸µ¿ÁßÀÎ ¾²·¹µå ¼ö(not sleeping) |
Threads_created_per |
1.00% |
Ä¿³Ø¼Ç´ç »ý¼ºµÈ Æò±Õ ¾²·¹µå ¼ö(±âÁØ 0.01%), 0[thread_cache_size]°ªÀ»
¿Ã¸®¼¼¿ä.[Âü°í] |
Uptime |
16½Ã°£ 28ºÐ 7ÃÊ |
ÃÖ±Ù MySQL ¼¹ö ±¸µ¿ ½Ã°£ |
|
MYSQL SERVER VARIABLES (connected by TCP/IP), ´©ÀûµÈ
Åë°èÀÚ·á°¡ ³Ê¹« Àû½À´Ï´Ù.
Ç׸ñ |
VARIABLES |
commnets, [***] Ç¥½Ã´Â ¼º´É Çâ»ó°ú °ü·ÃµÊ |
back_log |
50 |
man 2 listen, net.ipv4.tcp_max_syn_backlog |
connect_timeout |
10(10ÃÊ) |
bad handshake timeout(ÃÊ), À߸øµÈ(fail)
Á¢¼Ó ¿äûÀÌ ¸¹½À´Ï´Ù(¿¬°á ½ÇÆÐ)(±âÁØ 1 %). 10(10ÃÊ)(connect_timeout)º¸´Ù
±ä ¿¬°á ¿äû, Ʋ¸° ¾ÏÈ£, Á¢±Ù ±ÇÇÑ ¹®Á¦. |
join_buffer_size |
268,431,360(256 MB) |
[***] FULL-JOIN¿¡ »ç¿ëµÇ´Â ¸Þ¸ð¸® |
key_buffer_size |
524,283,904(500 MB) |
[***] INDEX key buffer¿¡ »ç¿ëµÇ´Â ¸Þ¸ð¸®, refer [Key_xxx],
Á¤»ó |
log |
OFF |
·Î±× ±â·Ï ¿©ºÎ |
log_update |
OFF |
UPDATE ·Î±× ±â·Ï ¿©ºÎ |
log_bin |
OFF |
binary ·Î±× ±â·Ï ¿©ºÎ |
long_query_time |
3(3ÃÊ) |
refer 9,200[Slow_queries] |
lower_case_table_names |
0 |
Å×ÀÌºí ´ë¼Ò¹®ÀÚ ±¸º°À¯¹«(0 ±¸º°) |
max_allowed_packet |
16,776,192(16 MB) |
ÃÖ´ë Çã¿ëÇÒ ÆÐŶ |
max_connections |
1,024 |
[***] ÃÖ´ë µ¿½Ã Á¢¼Ó Ä¿³Ø¼Ç ¼ö, refer 740[Max_used_connections], Á¤»ó |
max_delayed_threads |
20 |
ÃÖ´ë delayed ¾²·¹µå ¼ö, INSERT DELAYED ±¸¹®°ú °ü·ÃµÊ |
max_join_size |
4,294,967,295(4.0 GB) |
JOIN¿¡ »ç¿ëµÉ ÃÖ´ë Å©±â(¸Þ¸ð¸® ¾Æ´Ô) |
max_sort_length |
1,024(1 KB) |
TEXT, BLOBÀÇ Á¤·Ä¿¡ »ç¿ëµÇ´Â ÃÖ´ë Å©±â |
max_user_connections |
500 |
ÃÖ´ë µ¿½Ã user ¼ö(0Àº Á¦ÇѾøÀ½) |
myisam_max_extra_sort_file_size |
8,388,608(8,192.0 GB) |
ºü¸¥ INDEX¸¦ »ý¼º½Ã »ç¿ëµÇ´Â ÃÖ´ë Àӽà ÆÄÀÏ Å©±â |
myisam_max_sort_file_size |
2,047(2.0 GB) |
REPAIR, ALTER, LOAD...µî INDEX¸¦ Àç»ý¼º½Ã »ç¿ëµÇ´Â Àӽà ÆÄÀÏ Å©±â |
myisam_sort_buffer_size |
134,217,728(128 MB) |
[***] REPAIR, INDEX, ALTER Á¤·Ä¿¡ »ç¿ëÇÏ´Â ¸Þ¸ð¸® |
open_files_limit |
0 |
ÆÄÀÏ open Á¦ÇÑ ¼ö(0Àº Á¦ÇѾøÀ½) |
record_buffer |
4,186,112(4 MB) |
[***] ¼øÂ÷ÀûÀÎ °Ë»ö¿¡ »ç¿ëµÇ´Â ¸Þ¸ð¸®(read_buffer_size) |
record_rnd_buffer |
4,186,112(4 MB) |
[***] ORDER BY Á¤·Ä¿¡ »ç¿ëµÇ´Â ¸Þ¸ð¸®(to avoid a disk seeks) |
safe_show_database |
ON |
Á¦ÇÑÀûÀÎ SHOW DATABASE ±¸¹® »ç¿ë ¿©ºÎ, Á¤»ó |
skip_locking |
ON |
¿ÜºÎ lock À» »ç¿ëÇÑ´Ù¸é OFF·Î ¼³Á¤. |
skip_networking |
OFF |
TCP/IP ¿¬°á ¿©ºÎ(ONÀº UNIX domain socket, OFF´Â TCP/IP ¿¬°á), Á¤»ó |
skip_show_database |
OFF |
SHOW DATABASES ±¸¹® »ç¿ë ¿©ºÎ(ONÀº ¿øõºÀ¼â, OFF´Â »ç¿ë°¡´É) |
sort_buffer |
33,554,424(32 MB) |
[***] ORDER BY, GROUP BY Á¤·Ä¿¡ »ç¿ëµÇ´Â ¸Þ¸ð¸® |
table_cache |
1,024 |
[***] Çѹø¿¡(all thread) ¿ ¼ö ÀÖ´Â Å×ÀÌºí ¼ö, refer 1,503[Opened_tables] |
thread_cache_size |
0 |
[***] ¾²·¹µå ij½Ã Àç»ç¿ë ¼ö, refer 1,849,471[Connections],
1,849,470[Threads_created], °è»êµÈ ÃßÁ¤°ª(ÃÖ¼Ò:32, ±ÇÀå:65, ÃÖ´ë:98), 0[thread_cache_size]°ªÀ»
¿Ã¸®¼¼¿ä.[Âü°í] |
tmp_table_size |
33,554,432(32 MB) |
[***] º¹ÀâÇÑ GROUP BY Á¤·Ä¿¡ »ç¿ëµÇ´Â ¸Þ¸ð¸®(to avoid a disk seeks), refer
1,191,002[Created_tmp_disk_tables] |
interactive_timeout |
28,800(8½Ã°£ 0ÃÊ) |
interactive -> re-active¿¡ ±â´Ù¸®´Â ½Ã°£(ÀÌÈÄ closed), ¿¬°á
Ãë¼Ò°¡ ¸¹½À´Ï´Ù(±âÁØ 1%). 3(3ÃÊ)(wait_timeout)Ãʳª
28,800(8½Ã°£ 0ÃÊ)(interactive_timeout)Ãʺ¸´Ù
´Ê°Ô close Çϰųª ¿¬°áÀ» ²÷Áö ¾Ê´Â °æ¿ì°¡ ¸¹½À´Ï´Ù.[Âü°í] |
wait_timeout |
3(3ÃÊ) |
none interactive -> re-active¿¡ ±â´Ù¸®´Â ½Ã°£(ÀÌÈÄ closed), °è»êµÈ
ÃßÁ¤°ª(Ãß¼¼:12ÃÊ, ÀÓ°è:16ÃÊ), ¿¬°á
Ãë¼Ò°¡ ¸¹½À´Ï´Ù(±âÁØ 1%). 3(3ÃÊ)(wait_timeout)Ãʳª
28,800(8½Ã°£ 0ÃÊ)(interactive_timeout)Ãʺ¸´Ù
´Ê°Ô close Çϰųª ¿¬°áÀ» ²÷Áö ¾Ê´Â °æ¿ì°¡ ¸¹½À´Ï´Ù.[Âü°í] |
timezone |
KST |
ÇöÀç MySQL ¼¹öÀÇ TIME-ZONE |
version |
3.23.58-log |
ÇöÀç MySQL ¼¹ö ¹öÀü |
|
|