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

CentOSÏÂMySql 5.0.xµÄ°²×°¡¢ÓÅ»¯¼°°²È«ÉèÖÃ

 groupadd mysql
н¨Ò»¸öÃûΪmysqlµÄÓû§×é
useradd -g mysql mysql
ÔÚmysqlÓû§×éÏÂн¨Ò»¸öÃûΪmysqlµÄÓû§
gunzip ½âѹÏÂÔص½µÄ.gzÎļþ
cd mysql-VERSION
½øÈë½âѹºóµÄĿ¼
CFLAGS="-O3 -mcpu=pentium4" CXX=gcc CXXFLAGS="-O3 -march=pentium4 -felide-constructors -fno-exceptions -fno-rtti" ./configure --prefix=/home/mysql/ --without-debug    --with-unix-socket-path=/home/mysql/tmp/mysql.sock --with-client-ldflags=-all-static --with-mysqld-ldflags=-all-static --enable-assembler --with-extra-charsets=gbk,gb2312,utf8 --without-innodb --without-isam --with-pthread --enable-thread-safe-client 
ÅäÖÃmysql
gccµÄÏà¹Ø²ÎÊý£º
-O3 \
-O
-O1
      ÓÅ»¯.¶ÔÓÚ´óº¯Êý,ÓÅ»¯±àÒëÕ¼ÓÃÉÔ΢¶àµÄʱ¼äºÍÏ൱´óµÄÄÚ´æ.
      ²»Ê¹ÓÃ`-O'Ñ¡Ïîʱ,±àÒëÆ÷µÄÄ¿±êÊǼõÉÙ±àÒëµÄ¿ªÏú,ʹ±àÒë½á¹ûÄܹ»µ÷ÊÔ.Óï¾äÊǶÀÁ¢µÄ:Èç¹ûÔÚ Á½ÌõÓï¾äÖ®¼äÓöϵãÖÐÖ¹³ÌÐò,Äã¿ÉÒÔ¶ÔÈκαäÁ¿ÖØи³Öµ,»òÕßÔÚº¯ÊýÌåÄڰѳÌÐò¼ÆÊýÆ÷Ö¸µ½ÆäËûÓï¾ä,ÒÔ¼°´ÓÔ´³ÌÐòÖÐ ¾«È·µØ»ñÈ¡ÄãÆÚ´ýµÄ½á¹û.
      ²»Ê¹ÓÃ`-O'Ñ¡Ïîʱ,Ö»ÓÐÉùÃ÷ÁËregisterµÄ±äÁ¿²Å·ÖÅäʹÓüĴæÆ÷.±àÒë½á¹û±È²»Óà `-O'Ñ¡ÏîµÄPCCÒªÂÔÑ·Ò»³ï.
      Ê¹ÓÃÁË`-O'Ñ¡Ïî,±àÒëÆ÷»áÊÔͼ¼õÉÙÄ¿±êÂëµÄ´óСºÍÖ´ÐÐʱ¼ä.
      Èç¹ûÖ¸¶¨ÁË`-O'Ñ¡Ïî, `-fthread-jumps'ºÍ`-fdefer-pop'Ñ¡Ï±» ´ò¿ª.ÔÚÓÐdelay slotµÄ»úÆ÷ÉÏ, `-fdelayed-branch'Ñ¡Ï±»´ò¿ª.ÔÚ¼´Ê¹Ã»ÓÐÖ¡Ö¸Õë (frame pointer)Ò²Ö§³Öµ÷ÊԵĻúÆ÷ÉÏ, `-fomit-frame-pointer'Ñ¡Ï±»´ò¿ª.ijЩ»úÆ÷ÉÏ »¹¿ÉÄÜ»á´ò¿ªÆäËûÑ¡Ïî.
-O2
      ¶àÓÅ»¯Ò»Ð©.³ýÁËÉæ¼°¿Õ¼äºÍËٶȽ»»»µÄÓÅ»¯Ñ¡Ïî,Ö´Ðм¸ºõËùÓеÄÓÅ»¯¹¤×÷.ÀýÈç²»½øÐÐÑ­»·Õ¹¿ª(loop unrolling)ºÍº¯ÊýÄÚǶ(inlining).ºÍ-OÑ¡Ïî±È½Ï,Õâ¸öÑ¡Ïî¼ÈÔö¼ÓÁ˱àÒëʱ¼ä,Ò²Ìá¸ßÁËÉú³É´úÂëµÄ ÔËÐÐЧ¹û.
-O3
      ÓÅ»¯µÄ¸ü¶à.³ýÁË´ò¿ª-O2Ëù×öµÄÒ»ÇÐ,Ëü»¹´ò¿ªÁË-finline-functionsÑ¡Ïî.
-O0
      ²»ÓÅ»¯.
Èç¹ûÖ¸¶¨Á˶à¸ö-OÑ¡Ï²»¹Ü´ø²»´øÊý×Ö£¬×îºóÒ»¸öÑ¡Ïî²ÅÊÇÉúЧµÄÑ¡Ïî¡£
-mcpu=pentium4 \¸ù¾ÝCPUÀàÐÍÓÅ»¯±àÒ룬¿ÉÒÔÈÃÄãµÄmysq±íÏÖ¸üºÃ£¡¿ÉÑ¡ÏîÄ¿ºÜ¶à£ºi386, i486, i586, i686, pentium, pentium-m


Ïà¹ØÎĵµ£º

CentOSÏÂMySQLÊý¾Ý¿â·þÎñÆ÷µÄ¹¹½¨·½·¨

 ÕâÀ½éÉÜÒ»ÏÂCentOSÏÂMySQLÊý¾Ý¿â·þÎñÆ÷µÄ¹¹½¨·½·¨¡£

°²×°MySQL¼°Ïà¹Ø×é¼þ
¡¡¡¡Ê×ÏÈ£¬°²×°MySQL¡£
[root@sample ~]#
yum
-y install mysql-server
¡¡ ← °²×°MySQL
Setting up Install Process
Setting up repositories
dag 100% |=========================| 1.1 kB 00:00
update ......

MySQL ÃüÁîÐÐ

 MySQL ÃüÁîÐÐ
µÚÒ»ÕС¢mysql·þÎñµÄÆô¶¯ºÍÍ£Ö¹
net stop mysql
net start mysql
µÚ¶þÕС¢µÇ½mysql
Óï·¨ÈçÏ£º mysql -uÓû§Ãû -pÓû§ÃÜÂë
¼üÈëÃüÁîmysql -uroot -p£¬ »Ø³µºóÌáʾÄãÊäÈëÃÜÂ룬ÊäÈë12345£¬È»ºó»Ø³µ¼´¿É½øÈëµ½mysqlÖÐÁË£¬mysqlµÄÌáʾ·ûÊÇ£º
mysql>
×¢Ò⣬Èç¹ûÊÇÁ¬½Óµ½ÁíÍâµÄ»úÆ÷ÉÏ£¬ÔòÐèÒª¼ÓÈ ......

MyEclipse Á¬½ÓÔ¶³ÌµÄ MYSQL

mysql Êý¾Ý¿âĬÈϵÄÁ¬½ÓÖ»ÄÜÔÚ±¾»úÁ¬½Ó£¬Ô¶³ÌÁ¬½Ó±ØÐëÊÚȨ¡£
´úÂë: È«Ñ¡
¡¡GRANT ALL PRIVILEGES ON *.* TO 'myuser'@'%'IDENTIFIED
BY 'mypassword' WITH GRANT
OPTION;Èç¹ûÄãÏëÔÊÐíÓû§myuser´ÓipΪ192.168.1.6µÄÖ÷»úÁ¬½Óµ½mysql·þÎñÆ÷£¬²¢Ê¹ÓÃ
mypassword×÷ΪÃÜÂë
´úÂë:      GRANT ALL PR ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ