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

Linux°²×°Mysql+Apach+PHP+phpMyAdmin

ÎÒµÄϵͳÊÇredhat as5 ½¨Òé´ó¼ÒÍêÈ«°²×°£¬ÒÔÃⰲװʱȱÉÙÏà¹ØµÄ±àÒëÆ÷µÈµÈ¡£
Ò»¡¢°²×°mysql£¨mysql-5.0.21.tar.gz£©  
# tar zxf mysql-5.0.21.tar.gz
# cd mysql-5.0.21
#./configure --prefix=/usr/local/mysql --sysconfdir=/etc --localstatedir=/var/lib/mysql/
˵Ã÷£º
   #prefix=/usr/local/mysql mysql°²×°µÄÄ¿±êĿ¼
   #sysconfdir=/etc my.iniÅäÖÃÎļþµÄ·¾¶
   #localstatedir=/var/lib/mysql Êý¾Ý¿â´æ·ÅµÄ·¾¶
# make
# make install
# groupadd mysql
# useradd mysql -g mysql
# cp support-files/my-medium.cnf /etc/my.cnf
#£¨Õâ¸öÎļþ¼ÐÊÇÔ­À´±àÒëµÄĿ¼Ïµģ©Ñ¯ÎÊÄãÊÇ·ñÒª¸²¸Çʱ£¬ÊäÈë"y"
#/usr/local/mysql/bin/mysql_install_db --user=mysql
# cd /usr/local/mysql      È»ºóÉèÖÃȨÏÞ
# chown -R root .                #É趨rootÄÜ·ÃÎÊ/usr/local/mysql
# chown -R mysql /var/lib/mysql               #É趨mysqlÓû§Äܹ»·ÃÎÊ/var/lib/mysql
# chgrp -R mysql /usr/local/mysql     #É趨mysql×éÄÜ·ÃÎÊ/usr/local/mysql
# /usr/local/mysql/bin/mysqld_safe --user=mysql &             #°²È«Æô¶¯mysql
# PATH=$PATH:/usr/local/mysql/bin        //ÈÃϵͳÕÒµ½mysql
# export PATH
# echo"/usr/local/mysql/lib/mysql">>/etc/ld.so.conf
# ldconfig -v
¿ª»úÆô¶¯
#cp /mysql-5.0.21/support files/mysql.server /etc/rc.d/init.d/mysqld
#chmod 700 /etc/rc.d/init.d/mysqld
#chkconfig --add mysqld
#chkconfig --level 345 mysqld on
¶þ¡¢°²×°apache £¨httpd-2.0.59.tar.gz£©
# tar zxf httpd-2.0.59.tar.gz
# cd httpd-2.0.59
# ./configure --prefix=/usr/local/apache --enable-so --enable-rewrite --enable-mods-shared=most
./configure --prefix=/usr/local/httpd --enable-so --enable-rewrite --with-mpm=worker --enable-expires  --enable-headers --enable-deflate --enable-authn-default --enable-aut


Ïà¹ØÎĵµ£º

ʵսLinux Bluetooth±à³Ì£¨ËÄ£© L2CAP²ã±à³Ì

£¨L2CAPЭÒé¼ò½é£¬L2CAPÔÚBlueZÖеÄʵÏÖÒÔ¼°L2CAP±à³Ì½Ó¿Ú£©
Ò»£ºL2CAPЭÒé¼ò½é£º
Logical Link Control and Adaptation Protocol(L2CAP)
Âß¼­Á¬½Ó¿ØÖƺÍÊÊÅäЭÒé (L2CAP) ΪÉϲãЭÒéÌṩÃæÏòÁ¬½ÓºÍÎÞÁ¬½ÓµÄÊý¾Ý·þÎñ£¬²¢Ìṩ¶àЭÒ鹦ÄܺͷָîÖØ×é²Ù×÷¡£L2CAP ³äÐíÉϲãЭÒéºÍÓ¦ÓÃÈí¼þ´«ÊäºÍ½ÓÊÕ×î´ó³¤¶ÈΪ 64K µÄ L2CAP Ê ......

ʵսLinux Bluetooth±à³Ì(Áù) L2CAP±à³ÌʵÀý

ÀýÒ»£º·¢ËÍSignaling Packet£º
Signaling CommandÊÇ2¸öBluetoothʵÌåÖ®¼äµÄL2CAP²ãÃüÁî´«Êä¡£ËùÒÔµÃSignaling CommandʹÓÃCID 0x0001.
¶à¸öCommand¿ÉÒÔÔÚÒ»¸öC-frame£¨control frame£©Öз¢ËÍ¡£
 Èç¹ûÒªÖ±½Ó·¢ËÍSignaling Command.ÐèÒª½¨Á¢SOCK_RAWÀàÐ͵ÄL2CAPÁ¬½ÓSocket¡£ÕâÑù²ÅÓлú»á×Ô¼ºÌî³äCommand Code£¬Identi ......

mysqlѧϰ5

Ð޸ĺͱ¸·Ý¡¢Åú´¦Àí
   ÓÐʱÎÒÃÇÒª¶ÔÊý¾Ý¿â±íºÍÊý¾Ý¿â½øÐÐÐ޸ĺÍɾ³ý£¬¿ÉÒÔÓÃÈçÏ·½·¨ÊµÏÖ£º
1¡¢Ôö¼ÓÒ»ÁУº
ÈçÔÚÇ°ÃæÀý×ÓÖеÄmytable±íÖÐÔö¼ÓÒ»ÁбíʾÊÇ·ñµ¥Éísingle:
mysql> alter table mytable add column single char(1);
2¡¢Ð޸ļǼ
½«abccsµÄsingle¼Ç¼ÐÞ¸ÄΪ“y”£º
mysql> ......

mysqlµÄslow queryÖеÄÒ»¸öÏÖÏó

ÔÚmysqlµÄslow query logÖУ¬¿ÉÄÜ´æÔÚÀàËÆÕâÑùµÄÌØÊâ¼Ç¼£º
# Time: 100127 23:17:01
# User@Host: root[root] @  [127.0.0.1]
# Query_time: 18446744073709.351562  Lock_time: 0.000129 Rows_sent: 1  Rows_examined: 11030
SET timestamp=1264663021;
SELECT dummy.id AS dummy_id
from dummy&nbs ......

MySQL¼¯ÈºÊµ¼ùÏê½âϵÁÐÖ®¶þ£ºÈçºÎ°²×°Management Node

±ÊÕߣ¨mqboss£©½üÆÚÔÚ×öMySQL¼¯ÈºµÄ¼¼Êõµ÷ÑУ¬»á½Ðø°Ñ×Ô¼ºµÄÐĵÃÌå»áд³öÀ´ºÍ´ó¼Ò·ÖÏí£¬Çë´ó¼Ò¼ÌÐø¹Ø×¢¡£
1.´Ómysq¹Ù·½ÍøÕ¾ÏÂÔØ°²×°Îļþmysql-cluster-gpl-7.0.9-solaris10-sparc-64bit.tar.gz£¬²¢Í¨¹ýFTPÉÏ´«µ½Solaris·þÎñÆ÷ÉÏ£»
2.Ìí¼ÓÓû§×émysqlºÍÓû§mysql(×¢£ºmysqlÓû§ÊôÓÚmysqlÓû§×é)
shell> groupadd mys ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ