¾È³çÇϼ¼¿ä. Á¤ÂùÈ£ÀÔ´Ï´Ù.~
¿À´Ã ¼Ò°³ÇÒ °ÍÀº mysqltunerÀÔ´Ï´Ù.
»çÀÌÆ®¸¦ µÑ·¯º¸´Ï ¿ÀǵÇÁö´Â ¾ó¸¶ µÇÁö ¾Ê¾Ò´Âµ¥, zabbix °ø½Ä »çÀÌÆ®¿¡ ¾ð±ÞÀÌ µÇ°í ÀÖ´Â °Í º¸´Ï »ó´çÈ÷ À¯¿ëÇÑ °Í °°½À´Ï´Ù..
ÀÚ¼¼ÇÑ °ÍÀº °ø½Ä »çÀÌÆ® ã¾Æº¸°í½Ã¸é µÉ °Í °°½À´Ï´Ù.
- mysqltuner.pl·Î ±¸¼ºµÇ¾î ÀÖ½À´Ï´Ù.
- mysql configurationÀ» º¸Á¶Çϸç (¼º´É/¾ÈÁ¤¼º)À» À§ÇØ °³¹ßµÇ¾ú½À´Ï´Ù.
- ¼³Ä¡µÇ¾î ÀÖ´Â DB »óÅÂ(Åë°è)¸¦ ·¹Æ÷ÆÃÇÏ¸ç ¼º´É Çâ»óÀ» À§ÇØ ÄÚ¸àÆ®¸¦ ÇØ ÁÝ´Ï´Ù.
mysqltuner´Â mysqltuner.pl ½ºÅ©¸³Æ®¸¦ ÅëÇØ ÇöÀç ±¸µ¿ÁßÀÎ mysqlÀÇ ¼º´ÉÀ» ÃÖÀûÈÇϴµ¥ ¸ñÀûÀ» µÎ°í ÀÖ½À´Ï´Ù.
(1) °ø½Ä »çÀÌÆ® : http://blog.mysqltuner.com/
(2) release : MySQLTuner v1.1.0 released
(3) System Requirements
- Perl 5.6 or later
- MySQL 3.23 or later (fully supported: 3.23, 4.0, 4.1, 5.0, 5.1; partially supported: 6.0)
- A Unix/Linux based operating system (tested on Linux, BSD variants, and Solaris)
- Unrestricted read access to the MySQL server (OS root access is recommended for MySQL versions before 5.0)
(4) ¼³Ä¡ ¹æ¹ý : ½©¿¡¼ °£´ÜÇÏ°Ô ¾Æ·¡Ã³·³ÇÏ¸é ½±°Ô ´Ù¿î·Îµå °¡´ÉÇÕ´Ï´Ù.
[[email protected] ~]# wget mysqltuner.pl
23:23:01 (56.00 KB/s) - `mysqltuner.pl' saved [39054/39054]