¿ù°£ Àα⠰Խù°

°Ô½Ã¹° 138°Ç
   
MYSQL ÆÛÆ÷¸Õ½º Æ©´× ½ºÅ©¸³Æ®
±Û¾´ÀÌ : ÃÖ°í°ü¸®ÀÚ ³¯Â¥ : 2009-12-09 (¼ö) 09:41 Á¶È¸ : 12077
±ÛÁÖ¼Ò :
                          

Âü°íÆäÀÌÁö
http://day32.com/MySQL/
http://day32.com/MySQL/tuning-primer.sh


This script takes information from "SHOW STATUS LIKE..." and "SHOW VARIABLES LIKE..."
to produce sane recomendations for tuning server variables.
It is compatable with all versions of MySQL 3.23 and higher (including 5.1).

Currently it handles recomendations for the following:

( ÀÌ ½ºÅ©¸³Æ®´Â "SHOW STATUS LIKE..."¿Í "SHOW VARIABLES LIKE..."Á¤º¸¸¦ ¾ò¾î³½´Ù. ÀÌ ¼³Á¤°ª°ú ¿î¿µ¿¡ µû¶ó ³ª¿Â ¼öÄ¡¸¦ ºñ±³ÇÏ¿© ÀûÁ¤ÇÑ °ªÀ» ±ÇÀåÇØÁØ´Ù.

MySQL 3.23 ÀÌ»ó¹öÀü ÀÌ»óÀÌ¸é »ç¿ë°¡´É....
DB¼­¹ö´Â ¹Ýµå½Ã ¿î¿µÁßÀ̾î¾ß Çϸç, ÃÖ¼Ò 2ÀÏ ÀÌ»ó ¿î¿µÇÑ »óŸ¦ ±ÇÀåÇÏ°í ÀÖ´Ù.)


¡Ü Slow Query Log
¡Ü Max Connections
¡Ü Worker Threads
¡Ü Key Buffer
¡Ü Query Cache
¡Ü Sort Buffer
¡Ü Joins
¡Ü Temp Tables
¡Ü Table (Open & Definition) Cache
¡Ü Table Locking
¡Ü Table Scans (read_buffer)
¡Ü Innodb Status


Recent Changes

¡Ü Correct awk display error which formats integers > 4294967296 in scientific notation.
  - Was manfest in MEMORY USAGE section where total system RAM > 4GB.
¡Ü Fixed rounding error where mysql will lose 4K from the join_buffer_size value.
  - Other values may have the same issue but are not yet reported
¡Ü Added support for FreeBSD and MacOS (thanks Sam and Geert)
¡Ü Added support for Solaris
¡Ü Changed how system memory is derived on Linux.
  - Use /proc/meminfo vs free -b and avoid inclusion of swap space.
¡Ü Include note warning of instability when key_buffer_size > 4GB in versions 5.0.51 and lower

 


 


À̸§ Æнº¿öµå
ºñ¹Ð±Û (üũÇÏ¸é ±Û¾´À̸¸ ³»¿ëÀ» È®ÀÎÇÒ ¼ö ÀÖ½À´Ï´Ù.)
¿ÞÂÊÀÇ ±ÛÀÚ¸¦ ÀÔ·ÂÇϼ¼¿ä.
   

 



 
»çÀÌÆ®¸í : ¸ðÁö¸®³× | ´ëÇ¥ : ÀÌ°æÇö | °³ÀÎÄ¿¹Â´ÏƼ : ·©Å°´åÄÄ ¿î¿µÃ¼Á¦(OS) | °æ±âµµ ¼º³²½Ã ºÐ´ç±¸ | ÀüÀÚ¿ìÆí : mojily°ñ¹ðÀÌchonnom.com Copyright ¨Ï www.chonnom.com www.kyunghyun.net www.mojily.net. All rights reserved.