Linux ±àÒë°²×° MYSQL 5.1 Óë Innodb

Linux ±àÒë°²×° MYSQL 5.1 Óë Innodb
±àÒëmysql5
´úÂë:
./configure \
--prefix=/usr/local/mysql \
--localstatedir=/usr/local/mysql/data \
--with-unix-socket-path=/usr/local/mysql/tmp/mysql.sock \
--with-extra-charsets=all \
--with-charset=utf8 \
--with-client-ldflags=-all-static \
--with-mysqld-ldflags=-all-static \
--with-plugins=all \
--with-pthread \
--enable-thread-safe-client

groupadd mysql
useradd -g mysql mysql
cp support-files/my-medium.cnf /etc/my.cnf
ÔÚmy.cnfÀïÔö¼Óuser=mysql
´úÂë:
cd /usr/local/mysql
bin/mysql_install_db --user=mysql
chown -R root . ; chown -R mysql data ;chgrp -R mysql .
bin/mysqld_safe --user=mysql &
mysqladmin -uroot password 'new-password'
Æô¶¯mysql:
´úÂë:
/usr/local/mysql/bin/mysqld_safe &
¹Ø±Õmysql:
´úÂë:
/usr/local/mysql/bin/mysqladmin shutdown
´úÂë:
cp ./support-files/mysql.server /etc/rc.d/init.d/mysqld
¿ÉÒÔʹÓÃserver mysqld restartÆô¶¯
debianÏ°²×°mysqlµÄ×¢ÒâÊÂÏî--innodb
Èç¹û´ÓÔ´´úÂë±àÒë°²×°mysql,ȱʡ°²×°Ê±,ÊÇûÓÐinnodbÒýÇæµÄ.ËùÒÔ,ÔÚconfigureµÄʱºò,Òª¼ÓÈë--with- plugins=all(»òÕßmax),ÕâÑù²Å»áÖ§³Öinnodb.ÔÚmysqlÀï¿ÉÒÔÖ´ÐÐshow enginesÃüÁîÀ´²é¿´µ±Ç°µÄmysql·þÎñÆ÷ËùÖ§³ÖµÄ´æ´¢ÒýÇæ.
http://www.mysqlperformanceblog.com/...iled-mysql-51/
¶àÏß³ÌÖ§³Ö·½ÃæֻҪעÒâÑ¡Ôñ--with-pthreadºÍ--enable-thread-safe-clientÑ¡Ïî¾Í¿ÉÒÔÁË¡£µÚÒ»Ïî¿ÉÒÔÖ¸Ã÷ʹÓà posixỊ̈߳¨unixµÄ±àÒ뷽ʽ¿ÉÄÜ»áÓÐЩ²»Ò»Ñù£¬ÒòΪunixµÄÄÚºËÏ̹߳¤×÷·½Ê½ÓëlinuxÏ̹߳¤×÷·½Ê½ÓбȽϴóµÄÇø±ð£¬ÓÈÆäfreebsd£©¡£
my-small.cnf ×îСÅäÖð²×°£¬ÄÚ´æ<=64M£¬Êý¾ÝÊýÁ¿×îÉÙ
my-large.cnf ÄÚ´æ=512M
my-medium.cnf 32M<ÄÚ´æ<64M£¬»òÕßÄÚ´æÓÐ128M£¬µ«ÊÇÊý¾Ý¿âÓëweb·þÎñÆ÷¹«ÓÃÄÚ´æ
my-huge.cnf 1G<ÄÚ´æ<2G£¬·þÎñÆ÷Ö÷ÒªÔËÐÐmysql
my-innodb-heavy-4G.cnf ×î´óÅäÖð²×°£¬ÄÚ´æÖÁÉÙ4G
´úÂë:
delete from mysql.user where User='';
delete from mysql.user where Host='127.0.0.1';
delete from mysql.user where Host='localhost.localdomain';
update user set Host='%';
mysql ²Ù×÷:
²é¿´mysq