MySQLÊý¾Ý¿âÎļþ½éÉÜ
±¾ÎÄÁ´½Óhttp://www.chysoft.net/files/article_234.htm ¸ü¶à×ÊѶÇë½øÈëwww.chysoft.net
mysqlµÄÊý¾Ý´¢´æÄ¿Â¼ÔÚmysqlµÄÅäÖÃÎļþmy.iniÎļþÉèÖ㬸ñʽÈçÏ£º
# Uncomment the following rows if you move the MySQL distribution to another
# location
basedir = d:/cyoa/mysql_cy/
datadir = d:/cyoa/mysql_cy/data/
ÆäÖÐdatadirĿ¼¶¨ÒåÁËmysqlµÄÊý¾Ý´æ´¢Î»Öã¬MySQLµÄÿ¸öÊý¾Ý¿â¶¼¶ÔÓ¦´æ·ÅÔÚÒ»¸öÓëÊý¾Ý¿âͬÃûµÄÎļþ¼ÐÖÐ(¸ÃĿ¼ÏÂdatadir²ÎÊý¶ÔÓ¦µÄĿ¼ÏÂ)£¬MySQLÊý¾Ý¿âÎļþ°üÀ¨MySQLËù½¨Êý¾Ý¿âÎļþºÍMySQLËùÓô洢ÒýÇæ´´½¨µÄÊý¾Ý¿âÎļþ¡£
MySQLÈç¹ûʹÓÃMyISAM´æ´¢ÒýÇæ£¬Êý¾Ý¿âÎļþÀàÐ;ͰüÀ¨.frm¡¢.MYD¡¢.MYI
MySQLÈç¹ûʹÓÃInnoDB´æ´¢ÒýÇæ£¬Êý¾Ý¿âÎļþÀàÐ;ͰüÀ¨.frm¡¢ibdata1¡¢.ibd£¬´æ·ÅλÖÃÓÐÁ½¸ö£¬ibdata1¡¢.ibdÎļþĬÈÏ´æ·ÅλÖÃÊÇMySQL°²×°Ä¿Â¼ÏµÄdataÎļþ¼Ð
1¡¢MySQL´´½¨²¢¹ÜÀíµÄÊý¾Ý¿âÎļþ£º
.frmÎļþ£º´æ´¢Êý¾Ý±íµÄ¿ò¼Ü½á¹¹£¬ÎļþÃûÓë±íÃûÏàͬ£¬Ã¿¸ö±í¶ÔÓ¦Ò»¸öͬÃûfrmÎļþ£¬Óë²Ù×÷ϵͳºÍ´æ´¢ÒýÇæÎ޹أ¬¼´²»¹ÜMySQLÔËÐÐÔÚºÎÖÖ²Ù×÷ϵͳÉÏ£¬Ê¹ÓúÎÖÖ´æ´¢ÒýÇæ£¬¶¼ÓÐÕâ¸öÎļþ¡£
³ýÁ˱ØÓеÄ.frmÎļþ£¬¸ù¾ÝMySQLËùʹÓõĴ洢ÒýÇæµÄ²»Í¬£¨MySQL³£ÓõÄÁ½¸ö´æ´¢ÒýÇæÊÇMyISAMºÍInnoDB£©£¬´æ´¢ÒýÇæ»á´´½¨¸÷×Ô²»Í¬µÄÊý¾Ý¿âÎļþ¡£
.MYDÎļþ£º¼´MY Data£¬±íÊý¾ÝÎļþ
.MYIÎļþ£º¼´MY Index£¬Ë÷ÒýÎļþ
.logÎļþ£ºÈÕÖ¾Îļþ
2¡¢InnoDB²ÉÓñí¿Õ¼ä£¨tablespace£©À´¹ÜÀíÊý¾Ý£¬´æ´¢±íÊý¾ÝºÍË÷Òý£¬
InnoDBÊý¾Ý¿âÎļþ£¨¼´InnoDBÎļþ¼¯£¬ib-file set£©,¸ÃÎļþÒ»°ã´æÔÚÔÚmysqlµÄÊý¾ÝĿ¼Ï£¬È磺ibdata1¡¢ibdata2µÈϵͳ±í¿Õ¼äÎļþ£¬´æ´¢InnoDBϵͳÐÅÏ¢ºÍÓû§Êý¾Ý¿â±íÊý¾ÝºÍË÷Òý£¬ËùÓÐ±í¹²ÓÃ.ibdÎļþ£ºµ¥±í±í¿Õ¼äÎļþ£¬Ã¿¸ö±íʹÓÃÒ»¸ö±í¿Õ¼äÎļþ£¨file per table£©£¬´æ·ÅÓû§Êý¾Ý¿â±íÊý¾ÝºÍË÷Òý¡£
3¡¢ÈÕÖ¾Îļþ£º ib_logfile1¡¢ib_logfile2
¸ü¶à>>
Ïà¹ØÎĵµ£º
ÔÚÉè¼Æ¹ØÏµÊý¾Ý¿âʱÊÇÒª×ñÊØÒ»¶¨µÄ¹æÔòµÄ¡£ÓÈÆäÊÇÊý¾Ý¿âÉè¼Æ·¶Ê½ÏÖ¼òµ¥½éÉÜ1NF£¨µÚÒ»·¶Ê½£©£¬2NF£¨µÚ¶þ·¶Ê½£©£¬3NF£¨µÚÈý·¶Ê½£©ºÍBCNF£¬ÁíÓеÚËÄ·¶Ê½ºÍµÚÎ巶ʽÁôµ½ÒÔºóÔÙ½éÉÜ¡£ÔÚÄãÉè¼ÆÊý¾Ý¿â֮ʱ£¬ÈôÄÜ·ûºÏÕ⼸¸ö·¶Ê½£¬Äã¾ÍÊÇÊý¾Ý¿âÉè¼ÆµÄ¸ßÊÖ¡£
µÚÒ»·¶Ê½£¨1NF£©£ºÔÚ¹ØÏµÄ£Ê½RÖеÄÿһ¸ö¾ßÌå¹ØÏµrÖУ¬Èç¹ûÿ¸öÊôÐÔÖµ¶¼Ê ......
MySQL5.X¶¼ÒѾ·¢²¼ºÃ¾ÃÁË£¬µ«ÊÇ»¹ÓкܶàÈËÈÏΪMySQLÊDz»Ö§³ÖÊÂÎñ´¦ÀíµÄ£¬Õâ²»µÃ²»¹ÖËûÃÇÊǹª¹ÑÎŵ쬯äʵ£¬Ö»ÒªÄãµÄMySQL°æ±¾
Ö§³ÖBDB»òInnoDB±íÀàÐÍ£¬ÄÇôÄãµÄMySQL¾Í¾ßÓÐÊÂÎñ´¦ÀíµÄÄÜÁ¦¡£ÕâÀïÃæ£¬ÓÖÒÔInnoDB±íÀàÐÍÓõÄ×î¶à£¬ËäÈ»ºóÀ´·¢ÉúÁËÖîÈçOracleÊÕ
¹ºInnoDBµÈÁîMySQL²»Ë¬µÄÊÂÇ飬µ«ÄÇЩÉÌÒµÉϵĶ·ÕùÓë¼¼ÊõÎÞ¹ ......
·Ç³£³£Óõģº¾µäµÄMYSQLÓï¾ä…… php¿ªÔ´
ÕâÕæÊÇÒ»¸öºÃ¶«Î÷£ºÑ§Ï°ºÃÁ˺ÜÊÜÓõÄŶ……
SQL·ÖÀࣺ
DDL—Êý¾Ý¶¨ÒåÓïÑÔ(Create£¬Alter£¬Drop£¬DECLARE)
DML—Êý¾Ý²Ù×ÝÓïÑÔ(Select£¬Delete£¬Update£¬Insert)
DCL—Êý¾Ý¿ØÖÆÓïÑÔ(GRANT£¬REVOKE£¬COMMIT£¬ROLLBACK)php¿ªÔ´
Ê×ÏÈ,¼òÒ ......
MySQLµÄdatetimeÉèÖõ±Ç°Ê±¼äΪĬÈÏÖµ
ÓÉÓÚMySQLĿǰ×ֶεÄĬÈÏÖµ²»Ö§³Öº¯Êý£¬ËùÒÔÓÃ
create_time datetime default now()
µÄÐÎʽÉèÖÃĬÈÏÖµÊDz»¿ÉÄܵġ£
´úÌæµÄ·½°¸ÊÇʹÓÃTIMESTAMPÀàÐÍ´úÌæDATETIMEÀàÐÍ¡£
CURRENT_TIMESTAMP £ºµ±ÎÒ¸üÐÂÕâÌõ¼Ç¼µÄʱºò£¬ÕâÌõ¼Ç¼µÄÕâ¸ö×ֶβ»»á¸Ä±ä
¡£
CURRENT_TIMESTAMP O ......
¾Ý¹úÍâýÌ屨µÀ£¬MySQLÊý¾Ý¿âµÄ¿ª·¢ÕßMichael WideniusÒÔ¼°²¿·ÖÏà¹ØÈËÊ¿½üÈÕÏòÅ·ÖÞ¡¢ÖйúÓë¶íÂÞ˹µÄ¼à¹Ü»ú¹¹Ìá½»Á˶Լ׹ÇÎÄ-Sun½»Ò׵ķ´¶ÔÒâ¼û£¬ÓдóÔ¼14000ÈËÔÚ¸ÃÒâ¼ûÉÏÇ©×Ö±íʾËûÃǶԴËÊÕ¹ºµÄ·´¶Ô¡£Å·ÃËίԱ»á´ËÇ°Ôø·´¶Ô¼×¹ÇÎÄÊÕ¹ºSun£¬µ«Õâһ¢¶ÏÉó²é»ú¹¹ÔÚ12ÔÂÓֳƣ¬¶Ô´Ë½»Ò×´ï³ÉÒ»¸öÂúÒâµÄ½á¹û±íʾÀÖ¹Û¡£Å·ÃËίԱ»á½«Ô ......