×¢²á | µÇ¼ Íü¼ÇÃÜÂ룿 51ctoÊ×Ò³ | ²©¿Í | ÂÛ̳ | ÕÐÆ¸
ÈȵãÎÄÕ »ñÈ¡µ±Ç°Ò³ÃæÂ·¾¶,ʵÏÖȨ..
¡¡°ïÖú
2008-03-03 21:28:31



2008-03-03 21:26:47



2008-03-03 21:25:12
19£©  ´´½¨±í
CREATE [TEMPORARY] TABLE [IF NOT EXISTS] table
  (create_clause, ¡­)
  [table_options]
  [[IGNORE | REPLACE] select]
CREATE [TEMPORARY] TABLE [IF NOT EXISTS] table LIKE old_table
¸ÃÃüÁîÓÃÀ´¶¨ÒåÊý¾Ý¿âÖбíµÄ½á¹¹¡£Èç¹ûʹÓÃÁËTEMPORARY¹Ø¼ü×Ö£¬¸Ã±íÖ»ÔÚµ±Ç°¿Í»§¶ËÁ¬½Ó´æÔÚʱ´æÔÚ¡£¶øIF NOT EXISTS±íʾMySQL½öÔÚ±í²»´æÔÚʱ²Å´´½¨£¬Èç¹û±í´æÔÚ£¬¶øÓÖûÓÐÖ¸¶¨IF NOT EXISTSºÍTEMPORARY£¬Ôòϵͳ»á±¨´í¡£Èç¹ûÖ¸¶¨ÁËTEMPORARYûָ¶¨IF NOT EXISTS£¬¶ø±íÓÖ´æÔÚ£¬ÄÇô´ËʱÒÑ´æÔÚµÄ±í½«¶Ôµ±Ç°¿Í»§¶ËÒþ²Ø¡£
CREATE×Ó¾ä¿ÉÒÔ¶¨ÒåÌØ¶¨ÁеĽṹ£¬Ò²¿ÉÒÔ¶¨Òå¸ÃÁеÄÔª½á¹¹¡£¶¨ÒåÁеÄ×Ó¾ä°üº¬ÈÎÒâÊýÄ¿µÄ×ֶζ¨Ò壬ÆäÓï·¨ÈçÏ£º
column type [NOT NULL | NULL] [DEFAULT value] [AUTO_INCREMENT] [PRIMARY KEY] [reference]
Æä±êʶ·ûº¬ÒåÈçÏ£º
¢ÅAUTO_INCREMENT£º±íʾÁÐʹÓÃÆäµ±Ç°×î´óÖµ×ÔÔö£¬Ö»ÓÐÊýÖµÐÍÁвÅÊÊÓá£
¢ÆDEFAULT value£ºÎª×ֶηÖÅäĬÈÏÖµ¡£
¢ÇNOT NULL£º±£Ö¤Ã¿¸öÖµ¶¼²»Îª¿Õ¡£
¢ÈNULL£º±íʾ×ֶοɰüº¬¿ÕÖµ£¬Èç¹û×Ö¶ÎÊÇÖ÷¹Ø¼ü×Ö»òSPATIALË÷Òý£¬Ôò²»ÄÜʹÓøÃÑ¡Ïî¡£
¢ÉPRIMARY KEY£º±íʾ¸Ã×Ö¶ÎÊÇÖ÷¹Ø¼ü×Ö¡£
¢ÊREFEREN..



2008-03-03 21:23:40
16£©  ´´½¨º¯Êý
CREATE [DEFINER={user | CURRENT_USER}] FUNCTION sp_name ([params]) RETURNS type
  function_definition
CREATE [AGGREGATE] FUNCTION name RETURNS return_type SONAME library
MySQLÓÐÁ½ÖÖ½ØÈ»²»Í¬µÄº¯Êý¸ÅÄî¡£µÚÒ»ÖÖÓï·¨´´½¨µÄÊÇ´æ´¢º¯Êý¡£Ëùν´æ´¢º¯Êý£¬Óë´æ´¢¹ý³ÌºÜÏàËÆ£¬Ö»ÊÇÄã¿ÉÒÔ½«Æä×÷Ϊ²éѯµÄÒ»²¿·Ö½øÐе÷Óᣴ洢º¯Êý½ÓÊÜÈÎÒâ¸öÊýµÄIN²ÎÊý²¢·µ»ØÒ»¸ö·µ»ØÖµ¡£µÚ¶þÖÖÓï·¨´´½¨µÄÊǿ⺯Êý£¬¿âº¯ÊýÓÖ³ÆÎªÓû§¶¨Ò庯Êý£¨UDF£©£¬MySQLÖ÷ÒªÓÃËüÀ´×÷ΪÍⲿ±à³ÌÓïÑԵĽӿڡ£º¯ÊýµÄ·µ»ØÖµ¿ÉΪSTRING¡¢REAL»òINTEGER¡£°üº¬º¯ÊýµÄ¿âÎļþ±ØÐëÊDZê×¼¹²Ïí¿âÎļþ£¬ÕâÑùMySQL²ÅÄܽ«Æä¶¯Ì¬Á´½Óµ½·þÎñÆ÷¡£
ʾÀý£º     CREATE FUNCTION multiply RETURNS REAL SONAME myexample.so
17£©  ´´½¨Ë÷Òý
CREATE [UNIQUE | FULLTEXT | SPATIAL] INDEX name ON table (column[(length)], ¡­)
´´½¨Ë÷ÒýÓï¾äÖ÷ÒªÓÃÀ´ÓëÆäËüSQLʵÏÖ¼æÈÝ¡£ÔÚÀϵÄSQL°æ±¾ÖУ¬¸ÃÓï¾ä²¢²»ÆðÈκÎ×÷Óá£ËüÏ൱ÓÚALTER TABLE ADD INDEXÓï¾ä¡£Òª´´½¨Ë÷Òý£¬±ØÐëÓжԱíµÄINDEXȨÏÞ¡£
UNIQUE¹Ø¼ü×Ö±íʾË÷ÒýÁеÄÖµ±ØÐëΨһ¡£FULLTEXT¹Ø¼ü×Ö¿Éʹ¹Ø¼ü×ÖµÄËÑË÷..



2008-03-03 21:21:35



2008-03-03 21:19:35
11£©  ÐÞ¸ÄÁ¬½ÓÖ÷·þÎñÆ÷²ÎÊý
CHANGE MASTER TO param = value [, param = value] ¡­
ÔÚ¸´Öƹý³ÌÖÐÐ޸ĴӷþÎñÆ÷Á¬½Óµ½Ö÷·þÎñÆ÷µÄ²ÎÊý¡£²ÎÊý¸öÊýÈÎÒâÖ¸¶¨£¬¿ÉÓõIJÎÊýÓУº
¢ÅMASTER_CONNECT_RETRY
Ö¸¶¨Á¬½Óʧ°Üºó´Ó·þÎñÆ÷³¢ÊԵĴÎÊý¡£
¢ÆMASTER_HOST
Ö¸¶¨Ö÷·þÎñÆ÷µÄIPµØÖ·¡£
¢ÇMASTER_LOG_FILE
Ö¸¶¨¶ÁÈ¡¸´ÖÆÊý¾ÝµÄÖ÷·þÎñÆ÷É϶þ½øÖÆÈÕÖ¾ÎļþÃû¡£
¢ÈMASTER_LOG_POS
ÓÉSHOW MASTER STATUSÖ¸¶¨µÄÊÂÎñµãλÖ㬿ÉÓÃÓÚÖ÷´Ó·þÎñÆ÷ͬ²½¡£
¢ÉMASTER_PASSWORD
Ö¸¶¨Á¬½ÓÖ÷·þÎñÆ÷µÄÓû§ÃÜÂë¡£
¢ÊMASTER_PORT
Èç¹ûÖ÷·þÎñÆ÷¼àÌýµÄÊǷDZê×¼¶Ë¿Ú£¬´ËÑ¡Ïî¿ÉÓÃÀ´Ö¸¶¨¸Ã¶Ë¿Ú¡£
¢ËMASTER_SSL
Èç¹ûÖ÷·þÎñÆ÷ÒªÇóʹÓÃSSL£¬ÔòÉèÖÃΪ1£¬·ñÔòΪ0¡£
¢ÌMASTER_SSL_CA
Ö¸¶¨Ö§³ÖSSLµÄCAÎļþ¡£
¢ÍMASTER_SSL_CA_PATH
Ö¸¶¨CAÎļþËù´æ·ÅµÄĿ¼¡£
¢ÎMASTER_SSL_CERT
Ö¸¶¨Ö§³ÖSSLµÄÖ¤ÊéÎļþ¡£
¢ÏMASTER_SSL_CIPHER
Ö¸¶¨Ö§³ÖSSLµÄÃÜÂëÁÐ±í¡£
¢ÐMASTER_SSL_KEY
Ö¸¶¨Ö§³ÖSSLµÄÃÜÔ¿ÎļþÃû¡£
¢ÑMASTER_USER
Ö¸¶¨Á¬½ÓÖ÷·þÎñÆ÷µÄ£¨ÓµÓÐREPLICATION SLAVEȨÏ޵ģ©Óû§Ãû¡£
¢ÒRELAY_LOG_FILE
Ö¸¶¨Öм̴«ÊäµÄÈÕÖ¾ÎļþÃû¡£
¢ÓRELAY_LOG_POS
Ö¸¶¨ÖмÌÈÕÖ¾µÄͬ²½Î»Öá£
ʾÀý£º &nbs..



2008-02-12 13:34:32



2008-02-12 13:31:49
5£©  ¸ü¸Ä±í
ALTER [IGNORE] TABLE table action_list
¸ü¸Ä±í½á¹¹¡£¿É¶Ô±í½øÐÐÐí¶à¸ü¸Ä²Ù×÷£¬ÈçÌí¼Ó/ɾ³ýÁС¢É¾³ýË÷ÒýµÈ¡£ÆäÖ´ÐÐÔ­ÀíÈçÏ£ºMySQL´´½¨Ò»¸ö±íµÄ¸±±¾²¢¶ÔÆä½øÐÐÐ޸ģ¬Í¬Ê±½«ËùÓиü¸Ä²Ù×÷Èë¶Ó£¬µ±ÐÞ¸ÄÍê³Éʱ£¬Ô­±í¼´É¾³ý²¢ÓÃбíÌæ»»£¬´ËʱÕâЩ¸ü¸Ä²Ù×÷Ö´ÐÐÍê±Ï¡£Èç¹ûÕâЩÈë¶ÓµÄ²Ù×÷ÒýÈëÁËÖØ¸´µÄ¹Ø¼ü×Ö£¬ALTERÓï¾ä»á¹ö»Ø²¢È¡Ïû¡£Èç¹ûÉèÖÃÁËIGNORE¹Ø¼ü×Ö£¬ALTERÓï¾ä»á¼ÌÐøÖ´ÐС£
action_list¿ÉÄܵÄÑ¡ÏîÓУº
¢ÅADD [COLUMN] create_clause [FIRST | AFTER column]
  ADD [COLUMN] (create_clause, create_clause, ¡­)
ÃèÊö£ºÔÚ±íÖÐÌí¼ÓеÄÒ»ÁС£ÕâÀïµÄcreate_clause¶¨ÒåÁËÁÐÔÚ±íÖд´½¨µÄSQL£¨²Î¿´CREATE TABLE£©¡£Èç¹ûʹÓÃÁËFIRST¹Ø¼ü×Ö£¬¸ÃÁд´½¨Îª±íµÄµÚÒ»ÁУ»Èç¹ûʹÓÃÁËAFTER¹Ø¼ü×Ö£¬Ôò±íʾд´½¨µÄÁÐÔÚijÁÐÖ®ºó£»Èç¹ûÕâÁ½¸ö¹Ø¼ü×Ö¶¼Ã»ÓУ¬Ð´´½¨µÄÁÐĬÈÏΪ±íµÄ×îºóÒ»ÁС£Ò²¿ÉÒÔͬʱÌí¼Ó¶à¸öÁС£
¢ÆADD [CONSTRAINT symbol] FOREIGN KEY name (column, ¡­) [reference]
ÃèÊö£º½ö¶ÔInnoDB±í£¨¿ÉÖ§³ÖÍâ¹Ø¼ü×Ö£©ÊÊÓã¬Ëü»áÔÚ±íÖÐÌí¼ÓÒ»¸öÍâ¹Ø¼ü×ÖÒýÓá£
¢ÇADD FULLTEXT [name] (column, ¡­)
ÃèÊö£ºÌí¼ÓÒ»¸öʹÓÃÖ¸¶¨ÁеÄÍêÈ«Îı¾Ë÷Òý¡£
¢ÈAD..



2008-02-12 13:30:05



2008-02-12 13:28:07



2008-02-12 13:25:43



2008-02-12 13:23:04



2008-02-11 16:58:31



2008-02-11 16:56:06
MySQLÖ§³ÖËùÓÐANSI SQL2ÊýÖµÀàÐÍ£¬·ÖΪÈý´óÀࣺÕûÐÍ¡¢Ð¡ÊýÐͺ͸¡µãÐÍ£¬Ã¿ÀàÓÖ°´Æä´æ´¢´óСÔÙϸ·Ö¡£ÊýÖµÀàÐÍ¿ÉÒÔÖ¸¶¨ÏÔʾ´óС£¬ÕâÓ°Ïì×ÅMySQLÏÔʾµÄ½á¹û£¬µ«ÓëÄÚ²¿´æ´¢´óСÎ޹ء£¶ÔÓÚСÊýÐͺ͸¡µãÐÍ£¬»¹¿ÉÒÔÖ¸¶¨Ð¡ÊýµãºóµÄλÊý£¨0µ½30Ö®¼ä£¬ÇÒÖÁÉÙӦСÓÚÕû¸öÊýµÄλÊý¼õ2£¬Èç¹û²»ÊÇÕâÑù£¬MySQL»á×Ô¶¯×ª»»£¬ÈçFLOAT(6,5)¸ÄΪFLOAT(7,5)£©¡£Èç¹ûÖµµÄ´æ´¢´óС´óÓÚÊý¾ÝÀàÐÍËùÒªÇóµÄ×î´óÖµ£¬Ëü»á×Ô¶¯½Ø¶Ï£¬MySQLͬʱ»á¸ø³öÒ»Ìõ¾¯¸æÐÅÏ¢¡£AUTO_INCREMENTÊôÐÔ¿ÉÓÃÓÚÕûÐÍÊý¾Ý£¬UNSIGNEDÊôÐÔ¿ÉÓÃÓÚËùÓÐÊýÖµÀàÐÍ£¬ZEROFILLÊôÐÔ±íʾ¶Ô¸Ã×Ö¶ÎÊý¾ÝÌî³ä0£¬Æä0µÄ¸öÊýÈ¡¾öÓÚ¸Ã×ֶεÄÏÔʾ¿í¶È¡£¾ßÌåÊýÖµÐÍÈçÏ£º
1£©  BIGINT
BIGINT[(display_size)] [AUTO_INCREMENT] [UNSIGNED] [ZEROFILL]
´æ´¢´óС£º8×Ö½Ú
ÃèÊö£º×î´óÕûÊýÀàÐÍ£¨-9223372036854775808µ½9223372036854775807£¬ÎÞ·ûºÅΪ0µ½18446744073709551615£©¡£
2£©  BIT
BIT[(bits)]
´æ´¢´óС£ºbitsλÊý+7»ò8λ
ÃèÊö£º´æ´¢Ö¸¶¨Î»ÊýµÄλͼֵ¡£
3£©  DEC
ÓëDECIMALͬÒå¡£
4£©  DECIMAL
DECIMAL[(precision, [scale])] [UNSIGNED] [ZEROFILL]
´æ´¢´óС£º²»È·¶¨
ÃèÊö£º´æ´¢¾«¶ÈÖØÒªµÄ¸¡µãÊý£¬Èç»õ±ÒÖµµÈ¡£Ð..



2008-02-07 15:54:26
ÓÐһЩMySQLµÄÃüÁîÐй¤¾ß¿ÉÓÃÓÚ½»»¥£¬Ã¿ÌõÃüÁî½ÓÊÜһЩѡÏѡÏîµÄ³¤¸ñʽÊÇÓÃÁ½¸öÁ¬×Ö·û£¨-£©×÷Ϊǰ׺£¬Èçmysql --user=username£¬¶Ì¸ñʽÊǵ¥¸öÁ¬×Ö·û£¬Èçmysql -uusername¡£
MySQLÖ÷ÒªÌṩµÄÃüÁîÐй¤¾ßÈçÏ£º
1£©  msql2mysql
ÓÃÀ´½«mSQL±àдµÄÓ¦ÓÃת»»³ÉMySQL¡£
2£©  myisamchk
ÑéÖ¤MyISAM±íµÄÍêÕûÐÔ²¢ÐÞ¸´Õì²âµ½µÄ´íÎó¡£
3£©  mysql
MySQLµÄSQL½âÊÍÆ÷¡£¿ÉÒÔÔÚ´ËÖ´ÐÐSQL£¬ÒԷֺŻò\g½áÊø¡£
4£©  mysql_upgrade
°²×°ÁËа汾µÄMySQLºó£¬¿ÉÒÔÓÃËü¼ì²é±íÒÔÈ·¶¨ÊÇ·ñÓëа汾¼æÈÝ£¬ÔÚÿ´Î¸üÐÂÉý¼¶MySQLʱ¶¼Ó¦¸ÃÔËÐдËÃüÁî¡£
5£©  mysqladmin
mysqlµÄ¹ÜÀí½Ó¿Ú³ÌÐò¡£Ö÷ÒªÈÎÎñÓУº
¢Åcreate databasename£º´´½¨Ö¸¶¨µÄÊý¾Ý¿â¡£
¢Ædrop databasename£ºÉ¾³ýÖ¸¶¨µÄÊý¾Ý¿â¡£
¢Çextended-status£ºÌṩÀ©Õ¹µÄ״̬ÏûÏ¢¡£
¢Èflush-hosts£ºË¢ÐÂËùÓлº´æµÄÖ÷»ú¡£
¢Éflush-logs£ºË¢ÐÂËùÓÐÈÕÖ¾¡£
¢Êflush-status£ºË¢ÐÂËùÓÐ״̬±äÁ¿¡£
¢Ëflush-tables£ºË¢ÐÂËùÓÐ±í¡£
¢Ìflush-threads£ºË¢ÐÂÏ̻߳º³å¡£
¢Íflush-privileges£ºÇ¿ÖÆÖØÔØËùÓÐÊÚȨ±í¡£
¢Îkill id[,id]£ºÖÕÖ¹Ö¸¶¨µÄÏ̡߳£
¢Ïpassword new_password£ºÉèÖÃеÄÃÜÂë¡£
¢Ðping£ºÑéÖ¤mysql..



2008-02-07 15:52:49
¿ÉÅäÖÃÁ½Ì¨MySQL·þÎñÆ÷ʵÀý½øÐб¸·Ý£¬ÆäÖÐһ̨ΪÖ÷·þÎñÆ÷£¬Áíһ̨Ϊ´Ó·þÎñÆ÷¡£¹ØÓÚ·þÎñÆ÷µÄÅäÖÃÖ÷ÒªÊÇÉèÖÃÈÕÖ¾¼Ç¼ºÍÖ¸¶¨·þÎñÆ÷ID¡£ÉèÖÃÈÕÖ¾¿ÉÒÔ±£´æËùÓÐÊÂÎñµ½¶þ½øÖÆÈÕÖ¾Îļþ£¬´Ó·þÎñÆ÷Ëæºó¿ÉÒÔ¶ÁÈ¡ÈÕÖ¾Îļþ²¢È·¶¨ÄÄЩÊÂÎñÐèÒª½øÐи´ÖÆ¡£
Ö÷·þÎñÆ÷µÄÅäÖãº
ͨ¹ýMySQLÅäÖÃÎļþÀ´Íê³É£¬ÈçÏ£º
[mysqld]
log-bin=mysql-bin
server-id=1
·þÎñÆ÷ID¿ÉΪÈÎÒâÕûÊý£¬µ±È»Ëü±ØÐëÔÚÕû¸ö·þÎñÆ÷½á¹¹ÖÐÊÇΨһµÄ¡£´Ó·þÎñÆ÷ʹÓÃÓµÓÐREPLICATION SLAVEȨÏÞµÄÓÐЧMySQLÓû§À´Á¬½ÓÖ÷·þÎñÆ÷¡£
´Ó·þÎñÆ÷µÄÅäÖãº
ÓëÖ÷·þÎñÆ÷Ò»Ñù£¬ÐèÒªÅäÖÃΨһµÄ·þÎñÆ÷ID¡£
ÔÚÖ÷´Ó·þÎñÆ÷¾ùÒÑÅäÖúõÄÇé¿öÏ£¬»¹Òª×¢Òâ¸´ÖÆÊ±Ò»¶¨Òª±£Ö¤Ã»Óиüз¢Éú£¬Îª´Ë£¬¿É°´Èçϲ½Öè²Ù×÷£º
1£©  ÔÚÖ÷·þÎñÆ÷ÉÏÆô¶¯¿Í»§¶Ë²¢ÊäÈ룺
mysql> FLUSH TABLES WITH READ LOCK;
2£©  ÔÚÁíÒ»´°¿ÚÖÐÔËÐУº
$mysqldump --master-data ¨Curoot ¨Cp DATABASE_TO_REPLICATE > /var/tmp/master.dump
3£©  ½«×ª´¢µÄÎļþ·¢Ë͵½´Ó·þÎñÆ÷¡£
4£©  ±à¼­ÎļþÖеÄCHANGE MASTERÃüÁîÒÔ°üÀ¨ºÏÊʵÄÖ÷·þÎñÆ÷¡¢Óû§ÃûºÍÃÜÂ룬µ«Î»ÖúÍÈÕÖ¾ÎļþÖµ²»Òª¸Ä±ä¡£
5£©  ÔÚ´Ó·þÎñÆ÷ÉÏʹÓÃ--skip-slaveÑ¡ÏîÆô¶¯£¬ÔØÈ..



2008-02-07 15:50:40



2008-02-07 15:47:37



2008-02-07 15:44:56
MySQL 5µÄ×î´óÌØµãÊÇÆä½áºÏÁËÆóÒµ¼¶Êý¾Ý¿âµÄÌØÐÔ£¬ÓÖ±£ÁôÁËÔ­Êý¾Ý¿âµÄ¼òÒ×ÐԺ͸ßЧÐÔ¡£ÔÚMySQL 5ÖÐгöÏֵįóÒµ¼¶Êý¾Ý¿âÖ§³ÖÓУº
1£©  ÊÓͼ
ËùνÊÓͼ£¬ÊÇÓëÌØ¶¨²éѯÏàÆ¥ÅäµÄ±í½á¹¹µÄÊý¾Ý¿ìÕÕ£¬Í¨¹ýÊÓͼ£¬¿ÉÒÔÔÚµ¥¸ö±íÖбíʾ¸´ÔÓÁ¬½ÓµÄ½á¹û¡£¹ØÓÚÊÓͼµÄÐÂÃüÁîÓУºCREATE VIEW£¬DROP VIEWºÍALTER VIEW¡£
2£©  ´¥·¢Æ÷
¶ÔÊý¾Ý¿âÖÐµÄ±í¶øÑÔ£¬´´½¨´¥·¢Æ÷¿ÉÒÔÓÃÀ´ÔÚÌØ¶¨Ê¼þ·¢ÉúʱִÐУ¬ÀýÈ磬µ±±íÖвåÈëÐÂÐÐʱ´¥·¢Ä³ÏîÐÐΪ¡£¹ØÓÚ´¥·¢Æ÷µÄÐÂÃüÁîÓУºCREATE TRIGGERºÍDROP TRIGGER¡£
3£©  ´æ´¢¹ý³Ì
´æ´¢¹ý³ÌÊÇÆóÒµ¼¶Êý¾Ý¿âÖÐÊ®·ÖÖØÒªµÄÒ»ÏÄÜ¡£Ò»¸ö´æ´¢¹ý³Ì£¬¾ÍÊÇ´´½¨Ò»¸öÍêÈ«ÓÃSQL±àдµÄº¯Êý²¢½«Æä´æ´¢µ½Êý¾Ý¿â¡£´æ´¢¹ý³Ì¶Ô·â×°SQLÓï¾äºÜÓÐÓ᣹ØÓÚ´æ´¢¹ý³ÌµÄÐÂÃüÁîÓУºCREATE PROCEDURE£¬ALTER PROCEDURE£¬DROP PROCEDURE£¬CALLºÍBEGIN/END¡£
4£©  Óαê
ÓαêµÄ×÷ÓÃÊÇÔÚÒ»¸öMySQL´æ´¢¹ý³ÌÖбíʾÕû¸öÊý¾Ý¼¯¡£ÓαêÊDz»Çø·Ö´óСд¡¢Ë³ÐòʹÓÃÇÒÖ»¶ÁµÄ¡£¹ØÓÚÓαêµÄÐÂÃüÁîÓУºOPEN£¬FETCHºÍCLOSE¡£
5£©  еĴ洢ÒýÇæ
MySQLÒÔǰ³£ÓõĴ洢ÒýÇæ£¨Ò²³ÆÎª±íÀàÐÍ£©ÊÇMyISAMºÍInnoDB¡£ÏÖÔÚÓÖ¼ÓÈëÁËһЩеÄÒýÇæ£¬È磺
¢ÙARCHIVE£ºÎÞË÷ÒýµÄ¿ìËÙ´æ´¢ºÍ¼ì..



2008-01-11 18:38:40
FedoraµÄ»ù±¾Ä¿Â¼

¡ô/£º¸ùĿ¼
¡ô/bin£º´æ·Å±Ø²»¿ÉÉÙµÄһЩÃüÁî
¡ô/boot£º´æ·ÅÒýµ¼×°ÔسÌÐòÎļþÒÔ¼°LinuxÄÚºË
¡ô/dev£º´æ·ÅÉ豸Îļþ
¡ô/etc£º´æ·ÅϵͳÅäÖÃÎļþ
¡ô/home£º´æ·ÅÓû§Ö÷Îļþ
¡ô/initrd£º´æ·Å³õʼµÄRAM´ÅÅÌÒýµ¼Ö§³ÖÎļþ£¨Ò»°ãÓÃÓÚϵͳÆô¶¯Ê±£©
¡ô/lib£º´æ·Å¹²Ïí¿âÎļþÒÔ¼°ÄÚºËÄ£¿éÎļþ
¡ô/lost+found£º´æ·Å»Ö¸´µÄÎļþ£¨ÏµÍ³¼ì²âºóÕÒµ½µÄÎļþ£©
¡ô/media£º¿ÉÒÆ¶¯Ã½ÖÊ£¬ÈçDVDºÍÈíÅ̵ĹÒÔØµã
¡ô/mnt£º±¾µØ»òÔ¶³ÌÎļþϵͳµÄ³£ÓùÒÔØµã
¡ô/opt£º´æ·Å¸½¼ÓµÄÈí¼þ°ü
¡ô/proc£º´æ·ÅÄÚºËÐÅÏ¢ÒÔ¼°½ø³Ì¿ØÖÆÐÅÏ¢
¡ô/root£º³¬¼¶Óû§µÄÖ÷Ŀ¼
¡ô/sbin£º´æ·ÅϵͳÃüÁͨ³£ÊÇÖ»ÓÐroot²Å¿ÉʹÓã©
¡ô/selinux£º´æ·ÅSELinux£¨FedoraµÄ°²È«²¿·Ö£©µÄÊý¾Ý
¡ô/sys£º´æ·ÅÄÚºËʹÓÃÉ豸µÄʵʱÐÅÏ¢
¡ô/tmp£º´æ·ÅÁÙʱÎļþ
¡ô/usr£ºÈí¼þ°²×°ºóÎļþµÄÖ÷Òª´æ·ÅµØ
¡ô/var£º´æ·Å¾­³£±ä»¯µÄÊý¾Ý£¨ÈçÈÕÖ¾£©ºÍ»º´æÊý¾Ý
 
²éÕÒÃüÁîËùÔÚλÖõÄÖ÷Òª·½·¨£º
¡ôwhereis ÃüÁîÃû£º·µ»ØÃüÁîµÄλÖÃÒÔ¼°Æä°ïÖú
¡ôwhatis ÃüÁîÃû£º·µ»Ø°ïÖúÖеÄÕªÒªÐÅÏ¢£¨Ò»ÐУ©
¡ôlocate ÎļþÃû£º·µ»ØËùÆ¥ÅäÎļþµÄλÖã¬Ëüͨ¹ýËÑË÷ÎļþË÷ÒýÊý¾Ý¿âÀ´Íê³É£¬ËٶȺܿ죬²»¹ýÒòΪ¸ÃÊý¾Ý¿â£¨/var/lib/sl..



 <<   1   2   >>   Ò³Êý ( 1/2 )