Linux Enterprise5 ÏÂ×Ô¶¯Æô¶¯ Mysql ºÍApacheµÄÅäÖÃ
1. Mysql ×Ô¶¯Æô¶¯µÄÅäÖÃ
ÔÚMySQL°²×°³ÌÐòµÄ½âѹ°ü
/usr/local/mysql/support-files
myslq.serverµÄÆô¶¯½Å±¾³ÌÐò=¡· ¸´ÖÆ/etc/rc.d/init.dĿ¼
[root@localhost ~]# cd /etc/rc.d/init.d
¸´ÖƲ¢ÖØÃüÃûΪmysql
[root@localhost init.d]# cp /usr/local/mysql/support-files/mysql.server mysql
¸ü¸ÄÊôÐÔ¸ÄΪ“x”£¨executable£¬¿ÉÖ´ÐУ©
[root@localhost init.d]# chmod +x mysql
Ìí¼Óµ½ÏµÍ³µÄÆô¶¯·þÎñ×éÖÐ
chkconfig --add mysql
Æô¶¯·þÎñ
service mysql start
Áí£ºÈ·ÈÏ
chkconfig --list [name] ÓÃÀ´Áбí·þÎñ À´È·ÈÏ
chkconfig --list [mysql] »ò chkconfig --list
chkconfig --add name Ìí¼Ó·þÎñ
chkconfig --del name ɾ³ý·þÎñ
2. Apache ×Ô¶¯Æô¶¯µÄÅäÖÃ
·½·¨Ò»£º
apachectlÃüÁ±´ÖÁ/etc/rc.d/init.dĿ¼Ï£¬¸ÄÃûΪhttpd
ʹÓÃ±à¼Æ÷´ò¿ªhttpdÎļþ£¬²¢ÔÚµÚÒ»ÐÐ#!/bin/shÏÂÔö¼ÓÁ½ÐÐÎÄ×ÖÈçÏÂ
# chkconfig: 35 70 30
# description: Apache
½Ó×Å×¢²á¸Ã·þÎñ
chkconfig --add httpd
service httpd start
ÆäÖÐËùÔö¼ÓµÄµÚ¶þÐÐÖÐÈý¸öÊý×ÖµÚÒ»¸ö±íʾÔÚÔËÐм¶±ð3ºÍ5ÏÂÆô¶¯apache£¬
µÚ¶þ¡¢ÈýÊǹØÓÚÆô¶¯ºÍÍ£Ö¹µÄÓÅÏȼ¶ÅäÖã¬Î޹ؽôÒª
·½·¨¶þ£º ÔÚ/etc/rc.d/rc.localÖÐÔö¼ÓÆô¶¯apacheµÄÃüÁÀýÈ磺/usr/local/httpd/bin/apachectl start
Æô¶¯·þÎñ
Ïà¹ØÎĵµ£º
1. HCI²ãÐÒé¸ÅÊö£º
HCIÌṩһÌ×ͳһµÄ·½·¨À´·ÃÎÊBluetoothµ×²ã¡£ÈçͼËùʾ£º
´ÓͼÉÏ¿ÉÒÔ¿´³ö£¬Host Controller Interface(HCI) ¾ÍÊÇÓÃÀ´¹µÍ¨HostºÍModule¡£Hostͨ³£¾ÍÊÇPC£¬ ModuleÔòÊÇÒÔ¸÷ÖÖÎïÀíÁ¬½ÓÐÎʽ£¨USB,serial,pc-cardµÈ£©Á¬½Óµ½PCÉϵÄbluetooth Dongle¡£
ÔÚHostÕâÒ»¶Ë£ºapplication,SDP,L2capµÈÐÒé ......
Service Discovery Protocol(SDP)ÌṩһÖÖÄÜÁ¦£¬ÈÃÓ¦ÓóÌÐòÓз½·¨·¢ÏÖÄÄÖÖ·þÎñ¿ÉÓÃÒÔ¼°ÕâÖÖ·þÎñµÄÌØÐÔ¡£
·þÎñ·¢ÏÖÐÒé(SDP»òBluetooth SDP)ÔÚÀ¶ÑÀÐÒéÕ»ÖжÔÀ¶ÑÀ»·¾³ÖеÄÓ¦ÓóÌÐòÓÐÌØÊâµÄº¬Ò⣬·¢ÏÖÄĸö·þÎñÊÇ¿ÉÓõĺÍÈ·¶¨ÕâЩ¿ÉÓ÷þÎñµÄÌØÕ÷¡£SDP¶¨ÒåÁËbluetooth client·¢ÏÖ¿ÉÓÃbluetooth server·þÎñºÍËüÃǵÄÌØÕ÷µÄ·½·¨¡£ ......
¿´MySQL²Î¿¼ÊÖ²á ·¢ÏÖCREATE TABLE ʱÓжàÖÖÊý¾Ý¿â´æ´¢ÒýÇæ£º
TYPE = {BDB | HEAP | ISAM | InnoDB | MERGE | MRG_MYISAM | MYISAM }
ÍøÉϲéÁËϾÝ˵MyISAM¡¢InnoDBÁ½ÖÖÒýÇæ³£ÓÃ
´óÖÁÇø±ðÈçÏÂ[²»ÖªÊÇ·ñ׼ȷ]£º
¸ß¼¶´¦Àí:
MyISAMÀàÐͲ»Ö§³ÖÊÂÎñ´¦ÀíµÈ¸ß¼¶´¦Àí£¬¶øInnoDBÀàÐÍÖ§³Ö¡£
Ö´ÐÐËÙ¶È:
MyISAMÀàÐ͵ıíÇ¿µ÷µÄÊÇÐ ......
InnoDB ¸ø MySQL ÌṩÁ˾ßÓÐÊÂÎñ(commit)¡¢»Ø¹ö(rollback)ºÍ±ÀÀ£ÐÞ¸´ÄÜÁ¦(crash recovery capabilities)¡¢¶à°æ±¾²¢·¢¿ØÖÆ(multi-versioned concurrency control)µÄÊÂÎñ°²È«(transaction-safe (ACID compliant))ÐÍ±í¡£InnoDB ÌṩÁËÐм¶Ëø(locking on row level)£¬ÌṩÓë Oracle ÀàËÆµÄ²»¼ÓËø¶ÁÈ¡(non-locking read in SELEC ......
ÔÚMySQLÖУ¬¼ÓÃܺÍѹËõº¯Êý·µ»Ø¶þ½øÖÆ´®¡£¶ÔÆäÖеÄÐí¶àº¯Êý¶øÑÔ£¬½á¹û¿ÉÄܰüº¬ÈÎÒâµÄ×Ö½ÚÖµ£¬Èç¹ûÏë´æ´¢ÕâЩ½á¹û£¬ÄãÓ¦¸ÃʹÓÃÒ»
¸ö¾ßÓÐvarbinary»òÕßblob¶þ½øÖÆ´®Êý¾ÝÀàÐ͵ÄÁУ¬Õâ¿É±ÜÃâDZÔÚµÄɾ³ýβ²¿¿Õ°×ÎÊÌâ»òÕß×Ö·û¼¯×ª»»ÎÊÌâ¡£ÕâЩÎÊÌâ¿ÉÄܵ¼ÖÂÊý¾ÝÖµµÄ¸Ä±ä¡£Ò»°ã¶øÑÔ£¬ÉÏÊöÎÊÌâ¿ÉÄÜÔÚÄãʹÓ÷Ƕþ½øÖÆ´®Êý¾ÝÀàÐÍ£¨Èçch ......