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

MySqlµÄ¸÷ÖÖÒýÇæ

1.MemoryÒýÇæ,ÌṩÄÚ´æ±í
   MySql Memory´æ´¢ÒýÇæ£¨Àϰ汾Ҳ½Ð×öheap´æ´¢ÒýÇæ£©£¬¹ËÃû˼ÒåÊÇÔÚÄÚ´æÖд洢ËùÓеÄÊý¾Ý£¬Ëü¾ßÓÐÒÔÏÂÁ½¸öÃ÷ÏÔÌØÕ÷£º   
      ¢ÙÄÚ´æÖд洢Êý¾Ý£¬·Ç³£¸ßËÙ;
      ¢Úmysql¹Ø±ÕºóËùÓÐÊý¾ÝÏûʧ£¬mysqlÆô¶¯Ê±»á´´½¨¿Õ±í;
    memory´æ´¢ÒýÇæÒ²ÊÇÒ»¸ö¾ø¼ÑµÄcache½â¾ö·½°¸£¬±¾Éíjdbc²Ù×÷¾ÍºÜÈÝÒ×±»java³ÌÐòÔ±½ÓÊÜ£»¶øÇÒ¿ÉÒÔ¶ÔÒÑÓеÄһЩ³ÌÐòÔÚ¼«ÉÙ¸Äд´ú
    ÂëµÄÇé¿öÏÂÀ´Ìá¸ßÐÔÄÜ£¬ÀýÈç¶ÔһЩ³£ÓÃ×ÊÔ´µÄ²éѯÈçÊ¡ÊÐÐÅÏ¢£¬Èç¹ûÒÔÍùÊÇͨ¹ýÖ±½Ó²éѯÊý¾Ý£¬ÏÖÔÚ¸ÄΪ´ÓÄÚ´æ±íÖжÁÈ¡£¬¼¸ºõÊÇûÓÐ
    ÈκθÄÔì³É±¾µÄ£»ÇÒmysqlµÄÒ×ÓÃÐÔÒ²ÃâÈ¥ÁË¶ÔÆäËûcache·þÎñÆ÷µÄѧϰ³É±¾¡£
  ×¢Ò⣺
    µ±ÄÚ´æ±íÖеÄÊý¾Ý´óÓÚmax_heap_table_sizeÉ趨µÄÈÝÁ¿´óСʱ£¬mysql»áת»»³¬³öµÄÊý¾Ý´æ´¢µ½´ÅÅÌÉÏ£¬Òò´ËÕâÊÇÐÔÄܾʹó´òÕÛ¿Û
  ÁË£¬ËùÒÔÎÒÃÇ»¹ÐèÒª¸ù¾ÝÎÒÃǵÄʵ¼ÊÇé¿öµ÷Õûmax_heap_table_size£¬ÀýÈçÔÚ.cnfÎļþÖÐ[mysqld]µÄÏÂÃæ¼ÓÈ룺
        max_heap_table_size = 2048M
    ÁíÍâÔÚ½¨±íÓï¾äÖл¹¿ÉÒÔͨ¹ýMAX_ROWSÀ´¿ØÖƱíµÄ¼Ç¼Êý¡£
   ÈçºÎ´´½¨ÄÚ´æ±í£¿
       ´´½¨ÄÚ´æ±í·Ç³£µÄ¼òµ¥£¬Ö»Ðè×¢Ã÷ ENGINE= MEMORY ¼´¿É:
       CREATE TABLE  `tablename` ( `columnName` varchar(256) NOT NUL) ENGINE=MEMORY DEFAULT 
     CHARSET=latin1 MAX_ROWS=100000000;
   2.MyISAM¹ÜÀí·ÇÊÂÎñ±í
      ËüÌṩ¸ßËÙ´æ´¢ºÍ¼ìË÷£¬ÒÔ¼°È«ÎÄËÑË÷ÄÜÁ¦¡£MyISAMÔÚËùÓÐMySQLÅäÖÃÀï±»Ö§³Ö£¬ËüÊÇĬÈϵĴ洢ÒýÇæ£¬³ý·ÇÄãÅäÖÃMySQLĬÈÏʹÓÃ
   ÁíÍâÒ»¸öÒýÇæ
   3.InnoDBºÍBDB´æ´¢ÒýÇæÌṩÊÂÎñ°²È«±í
   4.EXAMPLE´æ´¢ÒýÇæÊÇÒ»¸ö“´æ¸ù”ÒýÇæ
      Ëü²»×öʲô¡£Äã¿ÉÒÔÓÃÕâ¸öÒýÇæ´´½¨±í£¬µ«Ã»ÓÐÊý¾Ý±»´æ´¢ÓÚÆäÖлò´ÓÆäÖмìË÷¡£Õâ¸öÒýÇæµÄÄ¿µÄÊÇ·þÎñ£¬ÔÚMySQLÔ´´úÂëÖеÄÒ»¸öÀý
   ×Ó£¬ËüÑÝʾ˵Ã÷ÈçºÎ¿ªÊ¼±àдд洢ÒýÇæ¡£Í¬Ñù£¬ËüµÄÖ÷ÒªÐËȤÊǶԿª·¢Õß


Ïà¹ØÎĵµ£º

PHPºÍMySQL Web¿ª·¢ (Ô­ÊéµÚ4°æ) »úе¹¤Òµ

http://www.xhsd.com.cn/books/views.asp?plucode=711126281
Õâ±¾Êé±»³ÆÎªPHPºÍMySQLµÄ“Ê¥¾­”£¬×Ðϸ¿´ÁËһϣ¬µÄÈ·Óкܶà¶Àµ½µÄµØ·½¡£
Ê×ÏÈ£¬ÄÚÈÝÃ÷È·Í»³ö¡£Õâ±¾ÊéµÄÄ¿µÄÊǶÔPHPºÍMySQL×öÉîÈëdz³öµÄ·ÖÎö£¬¶ÔÆäWebÓ¦ÓÃ×öÁ˽ÏÈ«ÃæµÄ²ûÊö£¬Àý×Ó¾­µäʵÓá£
Æä´Î£¬Ð¡£PHP5.3£¬MySQLµÄ´æ´¢¹ý³ÌºÍ´æ´¢ÒýÇæ£¬Ajax¼¼ ......

MySQL·À×¢Èë


·ÀÖ¹×¢ÈëµÄ¼¸ÖÖ°ì·¨
 
ÆäʵԭÀ´¾ÍÊÇÎÒÃÇÐèÒª¹ýÂËһЩÎÒÃdz£¼ûµÄ¹Ø¼ü×ֺͷûºÏÈ磺
Select£¬insert£¬update£¬delete£¬and£¬*£¬µÈµÈ
function inject_check($sql_str) {
   return eregi('select|insert|update|delete|\'|\/\*|\*|\.\.\/|\.\/|union|into|load_file
|outfile', $sql_str); & ......

MySQL ¹ØÓÚ½¨Á¢Íâ¼üʧ°ÜµÄÎÊÌâ

½ñÌ죬ÓÃNavicatΪÁ½ÕÅ±í½¨Á¢Í⽡¹ØÏµ£¬×ÜÊÇÌáʾ´´½¨Ê§°ÜÐÅÏ¢£¬·¢ÏÖÊÇÁ½ÕÅ±í¹ØÁªµÄ×Ö¶ÎÀàÐÍÎÊÌ⣬µ«Á½¸ö×ֶζ¼ÊÇintÐÍÁ¨£¬Ôõô»á»¹»áÀàÐͲ»Ò»ÖÂÄØ£¬×îºó·¢ÏÖµ½Ò»¸öµØ·½Óе㲻һÑù£¬¾ÍÊÇÔÚ“Éè¼Æ±í”½çÃæÏ·½Óиö“ÎÞ·ûºÅ”µÄ¸´Ñ¡¿ò£¬Á½ÕűíµÄÖ÷¼ü×Ö¶ÎÆäÖÐÒ»¸öû¹´Ñ¡ÉÏÕâ¸ö¸´Ñ¡¿ò¶øµ¼ÖÂËäÈ»¶¼ÊÇintÀàÐÍ£ ......

MysqlÖд´½¨Óû§ÕÊ»§µÄ·½·¨

1.CREATE USER
CREATE USER user [IDENTIFIED BY [PASSWORD] 'password']
    [, user [IDENTIFIED BY [PASSWORD] 'password']] ...
CREATE USERÓÃÓÚ´´½¨ÐµÄMySQLÕË»§¡£ÒªÊ¹ÓÃCREATE USER£¬Äú±ØÐëÓµÓÐmysqlÊý¾Ý¿âµÄÈ«¾ÖCREATE USERȨÏÞ£¬»òÓµÓÐINSERTȨÏÞ¡£¶ÔÓÚÿ¸öÕË»§£¬CREATE USER»áÔÚûÓÐȨÏÞµÄmysq ......

mysqlµÄ±¸·ÝºÍ»¹Ô­µÄ±àÂëÎÊÌâ½â¾ö


½ñÌìÐèÒª´ÓÔ¶³Ì·þÎñÆ÷downÒ»¸öuchomeµÄÊý¾Ý¿âÏÂÀ´£¬ÔÚ±¾µØ»¹Ô­¡£
·¢ÏÖÒ»¸öºÜ²»Ë¬µÄÊÂÇ飺Զ³Ì8G£¬NºËµÄlinux»úÆ÷£¬±¸·Ý»¹Ô­²Ù×÷˳ÁïÁïµÄ£¬¿ÉÊÇÔÚ±¾µØµÄwindows£¬2GÆÕͨPCÉÏ£¬²Å100MµÄÎļþ£¬ÓÃuchome×Ô´øµÄ·Ö¾í±¸·Ý»¹Ô­£¬»ù±¾ÉÏÖм䶼»á¶Ïµô£¬ÒªÃ´Ìáʾ“Ö´ÐÐʱ¼ä¹ý³¤”£¨¸Ä³É200Ã룬·Ö¾íΪ20M¶¼²»ÐУ©£¬ÒªÃ´¾ÍÊ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ