Linux Ô´Âë°²×°Mysql5.5
¹«Ë¾µÄ·þÎñÆ÷ÊÇCentOS 5.4(Final)°æµÄ£¬½ñÌìÔÚÉÏÃæ°²×°ÁËÒ»»Ømysql5.5£¬¼Ç¼ÈçÏ£º
1¡¢´Óhttp://blog.s135.com/soft/linux/nginx_php/mysql/mysql-5.5.2-m2.tar.gz ÏÂÔØÔ´Âë°²×°°üµ½/usr/local/src
2¡¢tar zxvf mysql-5.5.2-m2.tar.gz ½âѹµ½/usr/local/src/mysql-5.5.2-m2ÏÂ
cd mysql-5.5.2-m2/
./configure --prefix=/home/mysql/ --enable-assembler --with-extra-charsets=complex --enable-thread-safe-client --with-big-tables --with-readline --with-ssl --with-embedded-server --enable-local-infile --with-plugins=partition,innobase,myisammrg
£¨ÔÚÁíÍâһ̨·þÎñÆ÷°²×°Ê±£¬³öÏÖconfigure: error: No curses/termcap library found´íÎ󣬼ÓÉÏ--with-named-curses-libs=/usr/lib/libncursesw.so.5²ÎÊý¿ÉÒÔ½â¾ö£¬»òÕßÔÙÓÃyum°²×°ncurses-develÒ²¿É£©
make
make install
ÔÚmake installµÄºó°ë¹ý³Ì£¬ÓÐÒ»¶Î±È½Ï³¤Ê±¼äµÄÍ£¶Ù£¬²»Òªµ£ÐÄËÀµôÁË£¬Êµ¼ÊÉÏËü»¹»î×Å£¬ÄÍÐĵĵȴý£¬×îÖջᰲװÍê±Ï¡£
3¡¢Èç¹û»¹Ã»ÓÐmysqlÓû§£¬´´½¨£º
groupadd mysql
useradd mysql -g mysql
4¡¢ÐÞ¸ÄĿ¼ȨÏÞ£º
chmod +w /home/mysql
chown -R mysql:mysql /home/mysql
5¡¢´´½¨Êý¾ÝĿ¼£¨mysql5.5ĬÈÏÒѾûÓÐdataĿ¼ÁË£©
mkdir /home/mysql/data
6¡¢³õʼ»¯Êý¾Ý¿â£º
/home/mysql/bin/mysql_install_db --basedir=/home/mysql --datadir=/home/mysql/data --user=mysql
7¡¢´´½¨mysqlÅäÖÃÎļþ£º/etc/my.cnf
[mysqld]
datadir=/home/mysql/data
socket=/tmp/mysql.sock
user=mysql
log=/home/mysql/sql.log
log_slow_queries=ON
log_slow_queries=/home/mysql/sql_slow.log
long_query_time=2
[client]
port = 3306
socket = /tmp/mysql.sock
8¡¢Æô¶¯mysql
/home/mysql/bin/mysqld_safe &
´ó¹¦¸æ³É£¡
²»¹ý£¬ÕâÖ»ÊÇ×î¼òµ¥µÄ°²×°ÅäÖùý³Ì£¬mysql5ÒѾ֧³ÖÊý¾Ý¿â¼¯ÈºµÈºÜ¶à¸ß¼¶¹¦ÄÜ£¬´ýÒÔºóÔÙÉîÈëÑо¿¡£
Ïà¹ØÎĵµ£º
dd if=/dev/zero of=/dev/rd/1 bs=1k count=9216
mke2fs -vm0 /dev/rd/1 9216
mount /dev/rd/1 /tmp/
umount -v /tmp
ÒÔÏÂÊÇתÔØ×Ôhttp://www.cublog.cn/u1/59740/showart_472783.html
linux RamDisk
ʹÓüò½é
1
¡¢
Ram Disk
½éÉÜ
1.1
ʲôÊÇRam Disk
Ram Disk
¾ÍÊǽ«ÄÚ´æÖеÄÒ»¿éÇøÓò× ......
ÔÚTimesTenµÄÓÅ»¯ÖУ¬Èç¹ûÉæ¼°µ½ Replication »òÕßCache GroupµÄ»°£¬ÄÇôÕë¶Ô TCP/IPÏà¹ØµÄ²ÎÊýµÄÓÅ»¯¶ÔÐÔÄÜÊÇÓÐÒæµÄ¡£ÒòΪËüÃÇÁ©¶¼ÊÇͨ¹ýTCP/IPÐÒé½øÐÐÊý¾Ý½»»¥µÄ¡£ÔÚ°²×°Îĵµ(install.pdf)µÄ39Ò³ÓоßÌåµÄ˵Ã÷£º
For replication, TCP send and receive buffers should be increased to a minimum of 512KB. To ......
=======================================================================
һЩ¹ØÓÚLinuxµÄ×ÊÔ´Õ¾µã£¬Ï£Íû¶Ô´ó¼ÒÓаïÖú
http://www.linux.org/ ;
Linux¹Ù·½ÐÂÎźÍÐÅÏ¢ÍøÕ¾¡£
http://freesoft.cei.gov.cn/ ;
ÖйúÈí¼þÐÐҵлá¹ú¼Ê×ÔÓÉÈí¼þÓ¦ÓÃÑо¿·¢Õ¹·Ö»áµÄ×ÔÓÉÈí¼þ¿â£¬ÉÏÃæÌṩÓи÷ÖÖLinuxÈí¼þ¿É¹©ÏÂÔØ£¬²¢ÓÐLinux ......
Ò»¡¢Ðźż°ÐźÅÀ´Ô´
Ðźű¾ÖÊ
ÐźÅÊÇÔÚÈí¼þ²ã´ÎÉ϶ÔÖжϻúÖƵÄÒ»ÖÖÄ£Ä⣬ÔÚÔÀíÉÏ£¬Ò»¸ö½ø³ÌÊÕµ½Ò»¸öÐźÅÓë´¦ÀíÆ÷ÊÕµ½Ò»¸öÖжÏÇëÇó¿ÉÒÔ˵ÊÇÒ»ÑùµÄ¡£ÐźÅÊÇÒì²½µÄ£¬Ò»¸ö½ø³Ì²»±Øͨ¹ýÈκβÙ×÷À´µÈ´ýÐźŵĵ½´ï£¬ÊÂʵÉÏ£¬½ø³ÌÒ²²»ÖªµÀÐźŵ½µ×ʲôʱºòµ½´ï¡£
ÐźÅÊǽø³Ì¼äͨÐÅ»úÖÆÖÐΨһµÄÒ첽ͨÐÅ»úÖÆ£¬¿ÉÒÔ¿´×÷ÊÇÒì²½Í¨Ö ......