½ÃÀÛÆäÀÌÁö·Î Áñ°Üã±âÃß°¡
·Î±×ÀÎ
ȸ¿ø°¡ÀÔ l Ã⼮üũ l ¸¶ÀÌÆäÀÌÁö l CGIMALL
ÀÚ·á½Ç »çÀÌÆ®µî·Ï ·©Å·100 ÇÁ·Î±×·¥¸®ºä °ü¸®ÀÚÃßõÀÚ·á Ãʺ¸°¡À̵å
Ä¿¹Â´ÏƼ
Àüü ÆîÃ帱â
Äü¸Þ´º¸µÅ© jquery , CSS , PHP , Javascript , ¹«·áÆùÆ® , ASP
»ó¼¼°Ë»ö
Ȩ > Ä¿¹Â´ÏƼ > °ñµåÆÁ »ó¼¼º¸±â
Ä¿¹Â´ÏƼ ±¸Àα¸Á÷
»çÀÌÆ®µî·Ï
Ŭ¶ó¿ìµåű×
javascript
PHP
HTML
ASP
mysql
CSS
Mobile
image
jquery
slide
¸Þ´º
�޴�
2023
ÇöÀçÁ¢¼ÓÀÚ ¸í »õ·Î°íħ
°Ô½ÃÆÇŸÀÌƲ °ñµåÆÁ / »ó¼¼º¸±â
Æ®À§ÅÍ·Î º¸³»±â
Ãßõ¼ö 488 | Á¶È¸¼ö 7,153 | µî·ÏÀÏ 2004-04-19 16:07:15

´Ð³×ÀÓ

HappyCGI

Á¦¸ñ

[ÆÁ] mysql Database Å×ÀÌºí ¸ðµÎ ÃÖÀûÈ­Çϱâ
³»¿ë
±Û¾´ÀÌ:Á¤ÂùÈ£ mysql Database Å×ÀÌºí ¸ðµÎ ÃÖÀûÈ­Çϱâ Á¶È¸¼ö:1730


Á¤ÂùÈ£


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 "====================================================================================";

 

ÀÚ·áÃâó : http://www.phpschool.com

Ãßõ½ºÅ©·¦¼Ò½ºº¸±â ¸ñ·Ï
ÀÌÀü°Ô½Ã±Û [ÆÁ] °£´ÜÇÑ ¾Õ,µÚ,»õ·Î°íħ ÀÚ¹Ù½ºÅ©¸³Æ® ¸µÅ© 2004-02-06 18:56:22
´ÙÀ½°Ô½Ã±Û °øÂ¥·Î mysql µÇ´Â php °èÁ¤ ¾ò±â 2004-05-09 07:17:44