Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

bind+dlz+mysqlʵÏÖÇøÓò¼Ç¼¶¯Ì¬¸üÐÂ


BIND-DLZʵÑé:http://bind-dlz.sourceforge.net/
ʵÑé»·¾³:RHEL4,BIND-9.5.0-P2.tar.gz(9.4.0ÒÔÉϰ汾¶¼ÒѺ¬DLZ²¹¶¡),Mysql-5.0.56.tar.gz
1¡¢°²×°mysql(ÏȰ²×°gccµÈÏà¹ØÈí¼þ°ü)
   #tar zxvf mysql-5.0.56.tar.gz 
   #cd mysql-5.0.56
   #./configure --prefix=/usr/local/mysql --localstatedir=/usr/loal/mysql/data --   libexecdir=/usr/local/mysql/lib --disable-shared
   #make
   #make install
   #cd /usr/local/mysql/
   #groupadd -g 1003 mysql
   #useradd -g 1003 mysql
   #chown -R mysql .
   #chgrp -R mysql .
   #chown -R mysql lib
   #./bin/mysql_install_db --user=mysql //ÒÔmysqlµÄÓû§Éí·Ý°²×°
   #chown -R root .
   #./bin/mysqld_safe --user=mysql & //ÔÚºǫ́Æô¶¯mysql
# cd /root/mysql-5.0.56
# cp support-files/my-medium.cnf /etc/my.cnf
# cp support-files/mysql.server /etc/rc.d/init.d/mysqld
# chmod 700 !$
# chkconfig --add mysqld
# chkconfig --list mysqld
  mysqld 1:off 2:on 3:on 4:on 5:on 6:off
# service mysqld start[restart/reload/stop]
# vi /etc/my.cnf
 add this:(·ÀÖ¹mysql·þÎñÆ÷ÎÞ²éѯºó8Сʱ×Ô¶¯ÖØÁ¬)
wait_timeout = 86400
interactive_timeout = 86400
   #/usr/local/mysql/bin/mysqladmin -uroot password 'aptech'
   #./bin/mysql -uroot -paptech
   #echo "PATH=$PATH:/usr/local/mysql/bin" >> /etc/profile
   #. !$
  
2¡¢°²×°bind
   #tar zxvf bind-9.5.0-P2.tar.gz 
   #cd bind-9.5.0-P2
   #./configure --prefix=/usr/local/bind9 --with-dlz-mysql=/usr/local/mysql --enable-threads=no
   //--with-dlz-mysql=/usr/local/mysql ÒªÇóbind°²×°ÖÐÖ§³ÖDLZ
   //--enable-threads=no ¹Ø±Õ¶àÏ̠߳
   //--disable-openssl-version-check ½ûÖ¹openssl°æ±¾µÄ¼ì²é
   #make
   #make install
3¡¢´´½¨database,table


Ïà¹ØÎĵµ£º

½â¾öÒ³ÃæÊý¾ÝÌá½»µ½mysqlÊý¾Ý¿âºó³öÏÖÖÐÎÄÂÒÂëµÄ·½·¨

1. ÔÚʹÓÃNavicat 8 for MySQL¿Í»§¶Ë´´½¨Êý¾Ý¿âʱ£¬±àÂëµÄÉèÖÃÈçÏÂͼ£º
     
2. ½«°²×°Ä¿Â¼F:\MySQL\MySQL Server 5.1Ï£¬my.iniÎļþÉèÖñäÁ¿Öµdefault-character-set=gbk £¨°üº¬Á½´¦£¬¿É²éÕÒdefault-character-set£©£¬È»ºóÖØÆôMYSQL·þÎñ¡£ ......

myeclipse mysql²»ÈòåÈëÖÐÎÄ

 Ê×ÏÈ¿´¿´ jspÎļþ java³ÌÐòÀïÓÐûÓÐrequest.setCharacterEncoding("UTF-8");
  ×Ö·û±àÂëÎÊÌ⣬Êý¾Ý²åÈë¿âÖÐʱ£¬java±àÂëºÍÊý¾Ý¿â±àÂë²»Ò»Ö£¬µ¼Ö²åÈëÊý¾Ý¿âΪÂÒÂ룬¿´µ½Îª£¿£¿£¿£¿µÄÐÎʽ  
  ½«ÄãµÄjspÒ³Ãæ±àÂë¸ÄΪGBK£¬Êý¾Ý¿â¶ÔÓ¦±íµÄ±àÂëÒ²¸ÄΪGBK
  ±àÂëÒ»Ö£¬¾Í²»»á³öÏÖÂÒÂëÎÊÌâÁ ......

ͨ¹ýrpm°ü°²×°¡¢ÅäÖü°Ð¶ÔØmysqlµÄÏêϸ¹ý³Ì


¡¡¡¡ÒÔMySQL-server-4.0.14-0.i386.rpmΪÀý£¬·ÅÔÚ/dataĿ¼Ï 
¡¡¡¡cd /data 
¡¡¡¡rpm -ivh MySQL-server-4.0.14-0.i386.rpm 
¡¡¡¡°²×°Íê³ÉºóÔÚ/usr/share/mysqlĿ¼ÖлáÓÐÒ»¸ömysqlµÄÆô¶¯½Å±¾mysql.server¼°Ê¾ÀýÅäÖÃÎļþµÈ(Èçmy-huge.cnf¡¢my-large.cnf¡¢my-medium.cnf) 
¡¡¡¡¿½±´Ò»¸öʾÀýÅäÖÃÎ ......

mysql maatkit¹¤¾ß°²×°ºÍʹÓÃ(Ò»)

½ñÌ죬ҪÓÃexplain²é¿´mysqlµÄÖ´Ðй滮£¬µ«ÊǺÍPostgreSQL²»Í¬µÄÊÇ£¬Ö±½ÓÔÚmysqlÀïÃæÖ´ÐеĽá¹û¿É¶ÁÐÔ²»ÊǺܺã¬ÉÏÍøËÑÁËһȦ£¬·¢ÏÖÁËÒ»¸ö¹¤¾ßmaatkit£¬¿ÉÒÔ½²explainµÄ½á¹ûת»¯ÎªÊ÷×´½á¹¹²é¿´£¬ºÇºÇ£¬·½±ãÁ˺ܶà
°²×°°ì·¨£º
1. sudo yum install mysql
2. sudo yum install mysql-server
3. wget http://maatkit.googl ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ