Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB
ÈÈÃűêÇ©£º c c# c++ asp asp.net linux php jsp java vb Python Ruby mysql sql access Sqlite sqlserver delphi javascript Oracle ajax wap mssql html css flash flex dreamweaver xml
 ×îÐÂÎÄÕ :

Ubuntu9.10_server_ϰ²×°Mysql 5.5.0 M2

×÷Õߣº°½Ê¿Î°
Mysql ÓõÄÊÇLinux (non RPM packages)
Ò»¡¢½«mysql-5.5.0-m2-linux-i686-glibc23.tar.gzÏÂÔØµ½/home/ikmb ²¢ÔÚµ±Ç°Ä¿Â¼½âѹ£»
……..
mysql-5.5.0-m2-linux-i686-glibc23/data/mysql/
mysql-5.5.0-m2-linux-i686-glibc23/data/test/
…………
¶þ¡¢´´½¨MySQL×飬½¨Á¢MySQLÓû§²¢¼ÓÈëµ½mysql×éÖÐ
ikmb@ikmb-desktop:~/mysql-5.5.0-m2-linux-i686-glibc23/bin$ sudo groupadd mysql
ikmb@ikmb-desktop:~/mysql-5.5.0-m2-linux-i686-glibc23/bin$ sudo useradd -g mysql mysql
Èý¡¢½øÈëĿ¼/usr/local£¬½âѹËõÃâ°²×°°æ£¬²¢ÔÚ´ËĿ¼Öн¨Á¢ÃûΪmysqlµÄÈíÁ´½Ó
ikmb@ikmb-desktop:~/mysql-5.5.0-m2-linux-i686-glibc23/bin$ cd /usr/local 
ikmb@ikmb-desktop:/usr/local$ sudo ln -s /home/ikmb/mysql-5.5.0-m2-linux-i686-glibc23 mysql
ËÄ¡¢É趨Ŀ¼·ÃÎÊȨÏÞ£¬ÓÃmysql_install_db´´½¨MySQLÊÚȨ±í³õʼ»¯£¬²¢ÉèÖÃmysql,rootÕʺŷÃÎÊȨÏÞ
ikmb@ikmb-desktop:/usr/local$ sudo chown 777 -R mysql
ikmb@ikmb-desktop:/usr/local$ sudo chown -R mysql .
ikmb@ikmb-desktop:/usr/local$ sudo chgrp -R mys ......

Mysql EngineÀàÐÍ

¿´MySQL²Î¿¼ÊÖ²á ·¢ÏÖCREATE TABLE ʱÓжàÖÖÊý¾Ý¿â´æ´¢ÒýÇæ£º
TYPE = {BDB | HEAP | ISAM | InnoDB | MERGE | MRG_MYISAM | MYISAM }
ÍøÉϲéÁËϾÝ˵MyISAM¡¢InnoDBÁ½ÖÖÒýÇæ³£ÓÃ
´óÖÁÇø±ðÈçÏÂ[²»ÖªÊÇ·ñ׼ȷ]£º
¸ß¼¶´¦Àí:
MyISAMÀàÐͲ»Ö§³ÖÊÂÎñ´¦ÀíµÈ¸ß¼¶´¦Àí£¬¶øInnoDBÀàÐÍÖ§³Ö¡£
Ö´ÐÐËÙ¶È:
MyISAMÀàÐ͵ıíÇ¿µ÷µÄÊÇÐÔÄÜ£¬ÆäÖ´ÐÐÊý¶È±ÈInnoDBÀàÐ͸ü¿ì¡£
ÒÆÖµÐÔ:
MyISAMÀàÐ͵Ķþ½øÖÆÊý¾ÝÎļþ¿ÉÒÔÔÚ²»Í¬²Ù×÷ϵͳÖÐÇ¨ÒÆ¡£Ò²¾ÍÊÇ¿ÉÒÔÖ±½Ó´ÓWindowsϵͳ¿½±´µ½linuxϵͳÖÐʹÓá£
·         MyISAM£ºÄ¬ÈϵÄMySQL²å¼þʽ´æ´¢ÒýÇæ£¬ËüÊÇÔÚWeb¡¢Êý¾Ý²Ö´¢ºÍÆäËûÓ¦Óû·¾³ÏÂ×ʹÓõĴ洢ÒýÇæÖ®Ò»¡£×¢Ò⣬ͨ¹ý¸ü¸ÄSTORAGE_ENGINEÅäÖñäÁ¿£¬Äܹ»·½±ãµØ¸ü¸ÄMySQL·þÎñÆ÷µÄĬÈÏ´æ´¢ÒýÇæ¡£
·         InnoDB£ºÓÃÓÚÊÂÎñ´¦ÀíÓ¦ÓóÌÐò£¬¾ßÓÐÖÚ¶àÌØÐÔ£¬°üÀ¨ACIDÊÂÎñÖ§³Ö¡£
·         BDB£º¿ÉÌæ´úInnoDBµÄÊÂÎñÒýÇæ£¬Ö§³ÖCOMMIT¡¢ROLLBACKºÍÆäËûÊÂÎñÌØÐÔ¡£
·        &nbs ......

mysql ENGINE=InnoDB

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 SELECTs)¡£InnoDBËø¶¨ÔÚÐм¶²¢ÇÒÒ²ÔÚSELECTÓï¾äÌṩһ¸öOracle·ç¸ñÒ»ÖµķÇËø¶¨¶Á¡£ÕâÐ©ÌØÉ«Ôö¼ÓÁ˶àÓû§²¿ÊðºÍÐÔÄÜ¡£Ã»ÓÐÔÚInnoDBÖÐÀ©´óËø¶¨µÄÐèÒª£¬ÒòΪÔÚInnoDBÖÐÐм¶Ëø¶¨ÊʺϷdz£Ð¡µÄ¿Õ¼ä¡£InnoDBÒ²Ö§³ÖFOREIGN KEYÇ¿ÖÆ¡£ÔÚSQL²éѯÖУ¬Äã¿ÉÒÔ×ÔÓɵؽ«InnoDBÀàÐ͵ıíÓëÆäËüMySQLµÄ±íµÄÀàÐÍ»ìºÏÆðÀ´£¬ÉõÖÁÔÚͬһ¸ö²éѯÖÐÒ²¿ÉÒÔ»ìºÏ¡£ÕâÐ©ÌØÐÔ¾ùÌá¸ßÁ˶àÓû§²¢·¢²Ù×÷µÄÐÔÄܱíÏÖ¡£ÔÚInnoDB±íÖв»ÐèÒªÀ©´óËø¶¨(lock escalation)£¬ÒòΪ InnoDB µÄÐм¶Ëø¶¨(row level locks)ÊÊÒ˷dz£Ð¡µÄ¿Õ¼ä¡£InnoDB ÊÇ MySQL ÉϵÚÒ»¸öÌṩÍâ¼üÔ¼Êø(FOREIGN KEY constraints)µÄ±íÒýÇæ¡£
¡¡¡¡InnoDBÊÇΪ´¦Àí¾Þ´óÊý¾ÝÁ¿Ê±µÄ×î´óÐÔÄÜÉè¼Æ¡£ËüµÄCPUЧÂÊ¿ÉÄÜÊÇÈÎºÎÆäËü»ùÓÚ´ÅÅ̵ĹØÏµÊý¾Ý¿âÒýÇæËù²»ÄÜÆ¥µÐµÄ¡£
¡¡¡¡InnoDB´æ´¢ÒýÇæ±»ÍêÈ«ÓëMySQL·þÎñÆ÷ÕûºÏ£¬InnoDB´æ´¢ÒýÇæÎªÔÚÖ÷ÄÚ´ ......

MySQL .Íâ¼üÔ¼Êø

InnoDBÒ²Ö§³ÖÍâ¼üÔ¼Êø¡£InnoDBÖжÔÍâ¼üÔ¼Êø¶¨ÒåµÄÓï·¨¿´ÆðÀ´ÈçÏ£º
[CONSTRAINT symbol] FOREIGN KEY [id] (index_col_name, ...)
    REFERENCES tbl_name (index_col_name, ...)
    [ON DELETE {RESTRICT | CASCADE | SET NULL | NO ACTION}]
    [ON UPDATE {RESTRICT | CASCADE | SET NULL | NO ACTION}]
Íâ¼ü¶¨Òå·þ´ÓÏÂÁÐÇé¿ö£º
·         ËùÓÐtables±ØÐëÊÇInnoDBÐÍ£¬ËüÃDz»ÄÜÊÇÁÙʱ±í¡£
·         ÔÚÒýÓñíÖУ¬±ØÐëÓÐÒ»¸öË÷Òý£¬Íâ¼üÁÐÒÔͬÑùµÄ˳Ðò±»ÁÐÔÚÆäÖÐ×÷ΪµÚÒ»ÁС£ÕâÑùÒ»¸öË÷ÒýÈç¹û²»´æÔÚ£¬Ëü±ØÐëÔÚÒýÓñíÀï±»×Ô¶¯´´½¨¡£
·         ÔÚÒýÓñíÖУ¬±ØÐëÓÐÒ»¸öË÷Òý£¬±»ÒýÓõÄÁÐÒÔͬÑùµÄ˳Ðò±»ÁÐÔÚÆäÖÐ×÷ΪµÚÒ»ÁС£
·         ²»Ö§³Ö¶ÔÍâ¼üÁеÄË÷Òýǰ׺¡£ÕâÑùµÄºó¹ûÖ®Ò»ÊÇBLOBºÍTEXTÁв»±»°üÀ¨ÔÚÒ»¸öÍâ¼üÖУ¬ÕâÊÇÒòΪ¶ÔÕâЩÁеÄË÷Òý±ØÐë×ÜÊǰüº¬Ò»¸öǰ׺³¤¶È¡£
·    & ......

mysql×Ö·û±àÂëµÄËѼ¯

mysql×Ö·û¼¯±àÂëÏòÀ´ÊÇÒ»¸öÄÑÌ⣬ÒòΪÓÐʱºòΪ´ó¶àÊýÈËÏëµÄUTF8¿ÉÒÔ½â¾öһЩÄÑÌ⣬²»¹ý²»ÒªÌ«ÀíÏ뻯ÁË£¬ÓÐʱºòÔÚwindow¿Í»§¶ËÏ Ð޸ijÉutf8£¬mysqlÊDz»Ö§³ÖµÄ£¬ËùÒÔ»¹µÃ¾ßÌåÎÊÌâ¾ßÌå·ÖÎö£¬¿ÉÊÇÕâ¸ö»¹ÕæµÃÐèÒªÄ㻨µãʱ¼äÀ´Ñо¿
ÏÂÃæÊÇһЩ±ðÈ˵ÄÎÄÕ£¬ÔÚ´ËÏÈлÁË
             mysql·þÎñÆ÷ÖÐÓÐÁù¸ö¹Ø¼üλÖÃʹÓÃÁË×Ö·û¼¯µÄ¸ÅÄËûÃÇÊÇ£ºclient¡¢connection¡¢database¡¢results¡¢server¡¢system¡£
             a¡¢ÆäÖÐclientÊǿͻ§¶ËʹÓõÄ×Ö·û¼¯£¬Ï൱ÓÚÍøÒ³ÖеÄ×Ö·û¼¯ÉèÖÃÈçÏÂ
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">¡£
b¡¢ÆäÖеÄconnectionÊÇÁ¬½ÓÊý¾Ý¿âµÄ×Ö·û¼¯ÉèÖÃÀàÐÍ£¬Èç¹ûphpûÓÐÖ¸Ã÷Á¬½ÓÊý¾Ý¿âʹÓõÄ×Ö·û¼¯ÀàÐÍ
¾Í°´ÕÕ·þÎñÆ÷¶ËĬÈϵÄ×Ö·û¼¯ÉèÖá£
c¡¢ÆäÖÐdatabaseÊÇÊý¾Ý¿â·þÎñÆ÷ÖÐij¸ö¿âʹÓõÄ×Ö·û¼¯É趨£¬Èç¹û½¨¿âʱûÓÐÖ¸Ã÷£¬½«Ê¹Ó÷þÎñÆ÷°²×°
ʱָ¶¨µÄ×Ö·û¼¯ÉèÖá£
d¡¢resultsÊÇÊý¾Ý¿â¸ø¿Í»§¶Ë·µ»ØÊ±Ê¹ÓõÄ×Ö·û¼¯É趨£¬Èç¹ûûÓÐÖ¸Ã÷£¬Ê¹Ó÷þÎñÆ÷ĬÈϵÄ×Ö·û¼¯¡£
e¡¢serverÊÇ·þÎñÆ÷°²×°Ê±Ö ......

mysqlÇý¶¯Ñо¿Ö®Í¨ÓÃÊý¾Ýת·¢Æ÷

   Õâ¶Îʱ¼äÔÚѧϰC#,ÒªÁ¬½ÓmysqlÊý¾Ý¿â,²»ÖªµÀÔõôÁ¬½Ó ,ºóÀ´gooleÁËÏÂ,·¢ÏÖÒªÏÂÔØÇý¶¯,˳±ã¿´ÁËÏÂÁ¬½ÓµÄexample code
  ´úÂëºÍjavaÀïÃæµÄ²îºÜ¶à,֮ǰһֱÔÚѧC++ Ҳѧ¹ýÒ»¶Îʱ¼äµÄÇý¶¯¿ª·¢,Ò»ÌýmysqlÇý¶¯,ҲûÔÚÒâ, Çý¶¯ÔÚÐÄÀïÒ»Ö±¶¼ÊǺÜÄÑ
²¢ÇÒÈÝÒ×Ôì³ÉÀ¶ÆÁ,Êý¾Ý½á¹¹¸´ÔӵĴúÃû´Ê,Ò²¾ÍûÔÚÒâ,µ«ÊǺóÀ´ÔÚʹÓÃmysql.exe½øÐÐÃüÁîÐеǽµÄʱºò·¢ÏÖ´ËÇý¶¯·Ç±ËÇý¶¯
¾Í¾ö¶¨Ñо¿ÏÂ,¾õµÃmysql.exeÖ»ÊÇʹÓÃÌ×½Ó×ÖÁ¬½ÓÁË3306¶Ë¿Ú,È»ºó·¢ËÍÁËһЩÊý¾Ý È»ºóµÃµ½ÁËÁíÍâһЩÊý¾Ý,Òò´ËÖ»ÒªµÃµ½Í¨ÐŵÄЭÒé
¾Í¿ÉÒÔ×Ô¼ºÐ´³ö×Ô¼ºµÄmysqlÇý¶¯ ÉõÖÁÊÇÃâÇý¶¯µÄÊý¾Ý¿â²Ù×÷Èí¼þ,ËìÄÃÆðƽÈÕÀïÃæÐ­Òé·ÖÎöÀûÆ÷Ethernet À´¼àÌý3306¶Ë¿ÚÀ´ÍùµÄÊý¾Ý
°ü,ÉèÖÃfilterΪ tcp.port==3306 ,È»ºóÓÃmysql¿Í»§¶ËµÇ½ ,·¢ÏÖ¸ù±¾ÎÞ·¨µÃµ½ÈκÎÊý¾Ý,ºóÀ´»»¹ú²úµÄ¿ÆÀ´¾ÖÓòÍø×¥°ü¹¤¾ß
ͬÑùµÃ²»µ½Ê²Ã´Êý¾Ý,ºóÀ´
Sniffer,
Wildpackets Etherpeek ÂÖ·¬ÉÏÕó¶¼×¥²»µ½ÈκÎ3306¶Ë¿ÚµÄÊý¾Ý,µ«Êǰ취ÊÇÈËÏë
³öÀ´µÄ,ºóÀ´×Ô¼ºÐ´ÁËÒ»¸öͨÓõĶ˿ÚÊý¾Ýת·¢¹¤¾ß,×÷ΪÖмä´úÀíÖ»¼Ç¼ͨÐÅÊý¾Ý,Êý¾Ý²»×ö´¦Àí Ö±½Óת·¢.
   ÏÂÔØµØÖ·:http://download.csdn.net/source/1914921
......
×ܼǼÊý:40319; ×ÜÒ³Êý:6720; ÿҳ6 Ìõ; Ê×Ò³ ÉÏÒ»Ò³ [4635] [4636] [4637] [4638] 4639 [4640] [4641] [4642] [4643] [4644]  ÏÂÒ»Ò³ βҳ
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ