Á¤ÂùÈ£

http://www.rootman.co.kr/

http://www.rootman.co.kr/bbs/view.php?id=linux&page=1&sn1=&divpage=1&category=9&sn=off&ss=on&sc=on&select_arrange=headnum&desc=asc&no=1243

¼­¹ö¿¡ Mysql µ¥ÀÌÅÍ ¾çÀÌ ¸¹ÀÌ ½×ÀÌ°í, Äõ¸® ÀÛ¾÷ÀÌ È°¹ßÈ÷ ÀϾ°æ¿ì,
ÀÌ¿¡ µû¸¥ db ÀÇ °ø°£ ºÎ´ãÀ²µµ Ä¿Áö°Ô µË´Ï´Ù.

ÀÌ¿¡ µû¶ó, ¾çÀÌ ¸¹À» °æ¿ì ÇϳªÇϳª ÃÖÀûÈ­¸¦ ÇØÁÙ¼öµµ ¾ø°í,
¾Æ·¡¿Í °°ÀÌ °£·«ÇÏ°Ô ½©À» µ¹·ÁºÃ½À´Ï´Ù.
Àü¿£ php ½©·Î µ¹·È´Âµ¥ ´Ù¼Ò ´À¸°°Í °°´õ±º¿ä.
bash ·Î º¯°æÇØ ºÃ½À´Ï´Ù.

Ȥ, ÇÊ¿äÇϽźеé ÀÖÀ¸½Ã¸é °¡Á®´Ù°¡, ¾²¼¼¿ä.
È­ÀϸíÀ¸·Î ÀúÀåÈÄ ½ÇÇà±ÇÇÑ Áֽðí, /etc/cron.daily ¿¡ ³Ö¾î ÁÖ¼¼¿ä.
ÇÏ·ç¿¡ Çѹø¾¿ µ¹¸®¸é ÁÁÀ»µí Çϳ׿ä.

Á¶±ÝÀÌ¶óµµ µµ¿òÀÌ µÇ¾úÀ¸¸é ÇÏ´Â ¹Ù·¥À¸·Î....

-----------------------------------------------------------------

#!/bin/sh
# 2004/03/20
# http://www.rootman.co.kr
# Á¦¸ñ : mysql Database Å×ÀÌºí ¸ðµÎ ÃÖÀûÈ­Çϱâ
# º¯°æ»çÇ× : mysql root º¯°æ
# --------------------------------------------------
#
DB_cnt=0;
DB_pass="·çÆ®Æнº¿öµå"
Total_Table=0;
DB_str=`mysql -u root -p${DB_pass} -e"show databases"`;
for DB_for in ${DB_str}
do
  if [ ${DB_for}  != "Database" ]; then
     TABLE_cnt=0;
     Table_str=`mysql -u root -p${DB_pass} -e"show tables" ${DB_for}`;
     for TABLE_for in ${Table_str}
     do
        Op_Str=`mysql -u root -p${DB_pass} -e"optimize table $TABLE_for" ${DB_for}`;
        echo " - DB¸í : ${DB_for} --> ${TABLE_for} ";
        let TABLE_cnt=TABLE_cnt+1;
     done
     echo "------------------------------------------> Å×À̺í¸í : ${TABLE_cnt} ÃÖÀûÈ­¿Ï·á.";
     let Total_Table=Total_Table+${TABLE_cnt};
     sleep 1;
     let DB_cnt=DB_cnt+1;
  fi;
done
echo "====================================================================================";
echo "- È£½ºÆ®¸í : `hostname` ¿¡ ´ëÇÑ DB ${DB_cnt}°³, ÅäÅ»Å×À̺í ${Total_Table} ÃÖÀûÈ­ ¿Ï·á.";
echo "====================================================================================";