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

mysql·ÖÇø±í·¾¶ÉèÖõÄÎÊÌâ

ÔÚÍøÉÏ¿´µ½½éÉÜ·ÖÇø±íµÄÎÄÕÂ
CREATE TABLE users (
    uid INT UNSIGNED NOT NULL PRIMARY KEY,
    name VARCHAR(30) NOT NULL DEFAULT '',
    email VARCHAR(30) NOT NULL DEFAULT ''
)
PARTITION BY RANGE (uid) (
    PARTITION p0 VALUES LESS THAN (3000000)
    DATA DIRECTORY = '/data0/data'
    INDEX DIRECTORY = '/data1/idx',

    PARTITION p1 VALUES LESS THAN (6000000)
    DATA DIRECTORY = '/data2/data'
    INDEX DIRECTORY = '/data3/idx',

    PARTITION p2 VALUES LESS THAN (9000000)
    DATA DIRECTORY = '/data4/data'
    INDEX DIRECTORY = '/data5/idx',

    PARTITION p3 VALUES LESS THAN MAXVALUE
    DATA DIRECTORY = '/data6/data'
    INDEX DIRECTORY = '/data7/idx'
);
˵£º¡°Ã¿¸ö·ÖÇø¶¼ÓÐ×Ô¼º¶ÀÁ¢µÄÊý¾Ý¡¢Ë÷ÒýÎļþµÄ´æ·ÅĿ¼£¬Óë´Ëͬʱ£¬ÕâЩĿ¼ËùÔÚµÄÎïÀí´ÅÅÌ·ÖÇø¿ÉÄÜÒ²¶¼ÊÇÍêÈ«¶ÀÁ¢µÄ£¬¿ÉÒÔ¶à´óÌá¸ßÁË´ÅÅÌIOÍÌÍÂÁ¿¡£¡±

ÇëÎÊÏ DATA DIRECTORY ºÍ INDEX DIRECTORY Õâ¸öÁ½¸öÊôÐÔËùÉèÖõÄĿ¼ ÔÚmy.iniÖиÃÈçºÎÉèÖà ËùʹÓõÄÊý¾Ý¿â´æ´¢ÒýÇæÓ¦¸ÃÊÇmyisam »¹ÊÇ innodb

ÒýÓÃ
windows ÏÂÕâÁ½¸ö²ÎÊý²»Æð×÷ÓÃ.

·ÖÇø±í²»Ö§³Ö innodb ´æ´¢ÒýÇæ.


·Ç³£¸Ðл


Ïà¹ØÎÊ´ð£º

ÓйØmysqlµÄÎÊÌ⣡ - Java / Web ¿ª·¢

ÎÒµÄmysqlÔõôûÓа취дÈëÖÐÎÄÊý¾Ý£¿Ö»ÒªÊÇÊý¾ÝдÈëÊý¾Ý¿âʱ ¾Í»á±ä³ÉÈý¸öÎʺŠ£¿Çë½Ì¸ßÈË£¡£¡
linux? ÔõôдÈëµÄ

ÔÚmysqlÖÐÖ´ÐÐ show variables like 'character%'Ìù½á¹û³öÀ´¡£

ÔÚ°²×°MYSLQʱ½«Êý¾Ý¿âµÄ×Ö· ......

mysqlÁ¬½Ótomcat - Java / Web ¿ª·¢

ÎÒÒѾ­°´Õս̳ÌÉÏÅäÖÃtomcatµÄserver.xml
<Context path = "/POS" docBase = "POS" debug = "5" reloadable = "true" crossContext = "true" workDir = &quo ......

ÈçºÎʹÓÃMySQL - MS-SQL Server / »ù´¡Àà

¸Õ¸Õ½Ó´¥MySQL,²»ÖªµÀ¸ÃÈçºÎÈ¥²é¿´Êý¾Ý£¬²åÈëÊý¾Ý£¬´´½¨Êý¾Ý¿â¡¢±í£¬ÓÃÄÄΪǰ±²ÄÜÖ¸½ÌÒ»¶þ£¿

MySQL 5.1²Î¿¼ÊÖ²á

ÒýÓÃ
ÐÖµÜÄã»á½áÌùÂð£¿
mysql ²Î¿¼ÊÖ²á

baidu

MySQL¹Ù·½Îĵµ http://dev.mysql.com/doc ......

ÈçºÎÔÚC#ÀïʵÏÖMYSQL±¸·Ý¹¦ÄܵÄÖ÷´ÓÇл»£¨Ò»Ö÷Ò»´Ó£©

ÈçÌâ
²¹³äÏ£º
  ÎÞ³ÌÐò£¬¸øË¼Â·Ò²ÐУ»


1. ÏÈÅжÏ֮ǰµÄͬ²½ÊÇ·ñÍê³ÉÁË¡£ ###ÈçºÎÅжϣ¿
2. ½øÐÐCHANGE MASTER TO ²Ù×÷¡£###ÎÒÖªµÀ¿ÉÒÔÇл»³É±¸·Ý»ú£¬µ«ÊDz»ÖªµÀÈçºÎÇл»»ØÖ÷·þÎñÆ÷£¬
ÎÒµÄÓÊÏäÊÇdo ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ