Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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 ´æ´¢ÒýÇæ.


·Ç³£¸Ðл


Ïà¹ØÎÊ´ð£º

½éÉÜOracleºÍmysqlµÄÊé - Oracle / ·Ç¼¼ÊõÇø

ÎÒ¶ÔSQL SERVERºÍACCESS±È½ÏÊ죬ËùÒÔÊý¾Ý¿âµÄͨÓûù´¡¶«Î÷¿ÉÒÔ˵¶¼ÕÆÎյIJ¶àÁË£¬ÎÒÏÖÔÚÏëÒªµÄ¾ÍÊÇÒÔÉÏÁ½Êý¾Ý¿âµÄ¶ÀÌØÖ®´¦µÄ½éÉܺÍÓ¦ÓýéÉÜ¡£
ÁíÍâÊé×îºÃ¶ÔÓ¦×îа汾 oracleÊÇ11g°É 10µÄÒ²ÐУ»mysqlÊÇ5.1°É
л ......

ÓйØ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 ......

netbeans Á¬mysql - Web ¿ª·¢ / HTML(CSS)

ÎÒÓõÄÊÇÁ¬½Ó³Ø×öµÄ£¬ÅäÁ¬½Ó³ØµÄ·½·¨Ó¦¸ÃûÓÐ´í£¬ÎªÊ²¾ÍÊdzöÏÖÕâÖÖÎÊÌâ
javax.servlet.ServletException: javax.naming.NameNotFoundException: No object bound to name java:comp/env/test
ÇëÎÊ´óÏÀÃÇÕâÊÇÔ ......

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

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


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