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
Ïà¹ØÎĵµ£º
£¨L2CAPÐÒé¼ò½é£¬L2CAPÔÚBlueZÖеÄʵÏÖÒÔ¼°L2CAP±à³Ì½Ó¿Ú£©
Ò»£ºL2CAPÐÒé¼ò½é£º
Logical Link Control and Adaptation Protocol(L2CAP)
Âß¼Á¬½Ó¿ØÖƺÍÊÊÅäÐÒé (L2CAP) ΪÉϲãÐÒéÌṩÃæÏòÁ¬½ÓºÍÎÞÁ¬½ÓµÄÊý¾Ý·þÎñ£¬²¢Ìṩ¶àÐÒ鹦ÄܺͷָîÖØ×é²Ù×÷¡£L2CAP ³äÐíÉϲãÐÒéºÍÓ¦ÓÃÈí¼þ´«ÊäºÍ½ÓÊÕ×î´ó³¤¶ÈΪ 64K µÄ 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 ......
Ð޸ĺͱ¸·Ý¡¢Åú´¦Àí
ÓÐʱÎÒÃÇÒª¶ÔÊý¾Ý¿â±íºÍÊý¾Ý¿â½øÐÐÐ޸ĺÍɾ³ý£¬¿ÉÒÔÓÃÈçÏ·½·¨ÊµÏÖ£º
1¡¢Ôö¼ÓÒ»ÁУº
ÈçÔÚÇ°ÃæÀý×ÓÖеÄmytable±íÖÐÔö¼ÓÒ»ÁбíʾÊÇ·ñµ¥Éísingle:
mysql> alter table mytable add column single char(1);
2¡¢Ð޸ļǼ
½«abccsµÄsingle¼Ç¼ÐÞ¸ÄΪ“y”£º
mysql> ......
ÔÚ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 ......
±ÊÕߣ¨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 ......