¸®´ª½º, ÀÚ·á½Ç, ¼º°æ°Ë»ö, Ãß¾ïÀǰÔÀÓ, °íÀü°ÔÀÓ, ¿À¶ô½Ç°ÔÀÓ, rootman, http://www.rootman.co.kr
* 18.205.60.226 *
| Home | Profile | Linux | ÀÚ·á½Ç | zabbix | Mysql 5.6 | °¶·¯¸® | ¼º°æ°Ë»ö | ÇØÇǴϽº | ÀÚÀ¯°Ô½ÃÆÇ | °Ô½Ã¹°°Ë»ö | L | O | R |    

 
[mysql] [mysql] mysqltunner¸¦ ÅëÇÑ mysql optimize
 ÀÛ¼ºÀÚ : rootman
Date : 2010-03-18 23:32  |  Hit : 10,741  


¾È³çÇϼ¼¿ä. Á¤ÂùÈ£ÀÔ´Ï´Ù.~

¿À´Ã ¼Ò°³ÇÒ °ÍÀº 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]



 
 

Total. 645
¹øÈ£ ºÐ·ù Á¦¸ñ ÀÛ¼ºÀÚ µî·ÏÀÏ Á¶È¸¼ö
645 ±âÃʰ­Á NFS server unable to open connection to tcp6/udp6 networks rootman 09-27 3788
644 php [php] mssql ms-sql ÇÑ±Û º¯È¯ ²ôÀûÀÓ.. Á¤¸® rootman 03-29 5300
643 ±âÃʰ­Á java vim ¿¡¼­ Àڹ٠ȯ°æ ¸¸µé±â rootman 02-16 3625
642 »èÁ¦¿¹Á¤ [xencenter] xenserver tool ¼³Ä¡ rootman 08-24 5239
641 mysql [mysql] Creating a File-Per-Table Tablespace Outside the Dat¡¦ rootman 08-03 5512
640 ±âÃʰ­Á Centos Xwindow ¼³Ä¡ rootman 06-16 6868
639 php [php] highlight ÇÔ¼ö rootman 04-01 6674
638 qmail [qmail] qmail-scanner¿¡ filtering µÈ À̸ÞÀÏ Ã³¸® rootman 02-14 7069
637 Shell [³¯Â¥] awk¸¦ ÀÌ¿ëÇÏ¿© unixtimeÀÇ ½Ã°£ Â÷ ±¸Çϱâ rootman 01-27 8230
636 ±âÃʰ­Á centos¿¡ ±×³ð(gnome) ¼³Ä¡Çϱâ rootman 01-10 8094
635 ½©(awk) [awk] shell º¯¼ö »ç¿ëÇϱâ rootman 12-27 7542
634 ±âÃʰ­Á ¼­¹ö ij½Ã ¸Þ¸ð¸® ÃʱâÈ­Çϱâ (drop_caches) rootman 12-11 9041
633 windows tips ±×¸®µå Á¦°Å ¹èÄ¡ ½ºÅ©¸³Æ® rootman 11-28 8188
632 ±âÃʰ­Á ÆÐ½º¿öµå lockgin control rootman 09-06 4
631 windows tips win7 ÀÚµ¿ ·Î±×ÀÎ ¼³Á¤Çϱâ rootman 08-18 9702
 1  2  3  4  5  6  7  8  9  10    
AND OR