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


·Ç³£¸Ðл


Ïà¹ØÎÊ´ð£º

c,c++Á¬½Ómysql ÕÒ²»µ½Í·²¿Îļþ£¨ÐÂÊÖ£©

±àÒëÆ÷£ºC-Free4
mysql µ¥¶À°²×°µÄ£¬ÏÖÔÚΪapache+php+mysql¿ÉÒÔʹÓá£
×î½üÔÚÁ·Ï°c£¬c++£»ÏëÓÃc£¬c++Á¬½ÓÏÂÎÒµÄmysql£¬ºÃ¶àµØ·½¶à˵mysql.hÕÒ²»µ½¡£¶øÇÒÎÒmysqlûÓÐËùνµÄincludeÎļþ¼Ð°¡¡£
Íü¸ßÊÖÖ¸µãÒ»¶ ......

ÈçºÎ¶¨ÆÚɾ³ýmysqlÊý¾Ý - PHP / »ù´¡±à³Ì

ÇëÎÊÏÂÄܲ»ÄÜÔÙwindows϶¨ÆÚÇå¿ÕmysqlÒ»¸ö±íÖеÄÈ«²¿Êý¾Ý£¬ÓÃPHPʵÏÖ£¡
лл¸÷λÁË
¾Í±ÈÈçÒ»¸öÐÇÆÚÇå¿ÕÒ»´Î
±ÈÈçÿ¸öÐÇÆÚÁùÁãµãÇå¿ÕÒ»´Î£¡
ллÁË

¼Æ»®ÈÎÎñ...php....sql...truncate....OK

Äã¾ÍÕâ½ÓÔÚҳà ......

ÓйØ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Êý¾Ý¿â - Java / JavaÏà¹Ø

CREATE DATABASE ADDRESSLIST;
USE ADDRESSLIST;
DROP TABLE IF EXISTS FRIEND;
CREATE TABLE FRIEND
  (FRIEND_ID INTEGER NOT NULL AUTO_INCREMENT PRIMARY KEY ,
FRIEND_NAME VARCHAR(20) NOT N ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ