{"id":1061,"date":"2010-03-05T11:21:00","date_gmt":"2010-03-05T03:21:00","guid":{"rendered":"\/?p=1061"},"modified":"2010-03-05T11:21:00","modified_gmt":"2010-03-05T11:21:00","slug":"1061","status":"publish","type":"post","link":"https:\/\/blog.vimge.com\/archives\/mysql\/1061.html","title":{"rendered":"\u540c\u4e00\u673a\u5b50\u4e0a\u4e0d\u540c\u7aef\u53e3\u540c\u65f6\u8fd0\u884c\u4e24\u4e2amysql \u5e76\u542f\u7528InnoDB"},"content":{"rendered":"

\u4fee\u6539   my.ini   \u914d\u7f6e\u6587\u4ef6,  
\u5efa\u7acb   [mysqld]   \u4e0e   [mysqld2]   \u8282  
\u4e3a\u5b83\u4eec\u8bbe\u7f6e\u76f8\u4e92\u4e0d\u540c\u7684   basedir,   datadir,   port   <\/p>\n

—   \u6ce8\u610f\u6211\u5173\u95ed\u4e86   InnoDB   \u8868\u7684\u652f\u6301,  
\u5982\u679c\u9700\u8981   InnoDB   \u8868,  
\u4f60\u9700\u8981\u81ea\u884c\u5728   [mysqld]   \u4e0e   [mysqld2]   \u8282\u4e2d\u52a0\u5165   InnoDB   \u6570\u636e\u6587\u4ef6\u7684\u8bbe\u7f6e,  
\u800c\u4e14\u5fc5\u987b\u5982    basedir   \u90a3\u6837,\u662f\u5b8c\u5168\u72ec\u7acb\u7684\u4e24\u4e2a\u6570\u636e\u6587\u4ef6   
—   MySQL   \u7a0b\u5e8f\u662f\u5206\u522b\u653e\u5728\u4e24\u4e2a\u4e0d\u540c\u7684\u76ee\u5f55\u4e0b\u7684   <\/p>\n

[mysqld]  
skip-innodb  
local-infile=1  
basedir=F:\/WXQ\/mysql  
datadir=F:\/WXQ\/mysql\/data  
port=3306   <\/p>\n

[mysqld2]  
skip-innodb  
basedir   =   F:\/WXQ\/mysql2  
datadir   =   F:\/WXQ\/mysql2\/data\/  
port   =   3307   <\/p>\n

[WinMySQLadmin]  
Server=F:\/WXQ\/mysql\/bin\/mysqld-nt.exe  
user=root  
password=    <\/p>\n

=============================================  
\u4ee5\u4e0b\u662f   \u63a7\u5236\u53f0   \u64cd\u4f5c   <\/p>\n

Microsoft   Windows   2000   [Version   5.00.2195]  
(C)   \u7248\u6743\u6240\u6709   1985-2000   Microsoft   Corp.   <\/p>\n

C:\\>f:   <\/p>\n

F:\\>cd   wxq\\mysql2\\bin   <\/p>\n

F:\\WXQ\\mysql2\\bin>mysqld-nt    –install   mysqld2  
Service   successfully   installed.   <\/p>\n

F:\\WXQ\\mysql2\\bin>net   start   mysql  
MySql   \u670d\u52a1\u6b63\u5728\u542f\u52a8   .  
MySql   \u670d\u52a1\u5df2\u7ecf\u542f\u52a8\u6210\u529f\u3002   <\/p>\n

F:\\WXQ\\mysql2\\bin>net   start   mysqld2  
mysqld2   \u670d\u52a1\u6b63\u5728\u542f\u52a8   .  
mysqld2   \u670d\u52a1\u5df2\u7ecf\u542f\u52a8\u6210\u529f\u3002   <\/p>\n

F:\\WXQ\\mysql2\\bin>  
F:\\WXQ\\mysql2\\bin>netstat   -a   <\/p>\n

Active   Connections   <\/p>\n

Proto    Local   Address            Foreign   Address          State  
TCP      javdev05:http            ********.*******.com:0    LISTENING  
TCP      javdev05:epmap           ********.*******.com:0    LISTENING  
TCP      javdev05:https           ********.*******.com:0    LISTENING  
TCP      javdev05:1044            ********.*******.com:0    LISTENING  
TCP      javdev05:1075            ********.*******.com:0    LISTENING  
TCP      javdev05:1101            ********.*******.com:0    LISTENING  
TCP      javdev05:1128            ********.*******.com:0    LISTENING  
TCP      javdev05:1594            ********.*******.com:0    LISTENING  
TCP      javdev05:1595            ********.*******.com:0    LISTENING  
TCP      javdev05:3306            ********.*******.com:0    LISTENING      —-   \u670d\u52a1  
TCP      javdev05:3307            ********.*******.com:0    LISTENING      —-   \u670d\u52a1  
TCP      javdev05:netbios-ssn     ********.*******.com:0    LISTENING  
TCP      javdev05:1101            baym-cs59.msgr.hotmail.com:1863    ESTABLISHED  
TCP      javdev05:1594            **.***.**.***:ms-sql-s    ESTABLISHED  
TCP      javdev05:1595            **.***.**.***:ms-sql-s    ESTABLISHED  
TCP      javdev05:1700            *********:netbios-ssn    TIME_WAIT<\/p>\n

[\u4ee5\u4e0b\u4e3a\u5f00\u542fInnoDB\u914d\u7f6e]<\/strong><\/p>\n

[mysqld2]
port=3309
basedir="C:\/Program Files\/MySQL\/MySQL Server 5.0\/"
datadir="C:\/Program Files\/MySQL\/MySQL Server 5.0\/Data2\/"
default-character-set=utf8
default-storage-engine=INNODB
sql-mode="STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"
max_connections=100
query_cache_size=15M
table_cache=256
tmp_table_size=18M
thread_cache_size=8<\/p>\n

#*** MyISAM Specific options
myisam_max_sort_file_size=100G
myisam_sort_buffer_size=35M
key_buffer_size=23M
read_buffer_size=64K
read_rnd_buffer_size=256K
sort_buffer_size=256K<\/p>\n

#*** INNODB Specific options ***
innodb_additional_mem_pool_size=2M
innodb_flush_log_at_trx_commit=1
innodb_log_buffer_size=1M
innodb_buffer_pool_size=42M
innodb_log_file_size=10M
innodb_thread_concurrency=8<\/p>\n","protected":false},"excerpt":{"rendered":"

\u4fee\u6539   my.ini   \u914d\u7f6e\u6587\u4ef6,  
\u5efa\u7acb   [mysqld]   \u4e0e   [mysqld2]   \u8282  
\u4e3a\u5b83\u4eec\u8bbe\u7f6e\u76f8\u4e92\u4e0d\u540c\u7684   basedir,   datadir,   port   <\/p>\n

—   \u6ce8\u610f\u6211\u5173\u95ed\u4e86   InnoDB   \u8868\u7684\u652f\u6301,  
\u5982\u679c\u9700\u8981   InnoDB   \u8868,  
\u4f60\u9700\u8981\u81ea\u884c\u5728   [mysqld]   \u4e0e   [mysqld2]   \u8282\u4e2d\u52a0\u5165   InnoDB   \u6570\u636e\u6587\u4ef6\u7684\u8bbe\u7f6e,  
\u800c\u4e14\u5fc5\u987b\u5982    basedir   \u90a3\u6837,\u662f\u5b8c\u5168\u72ec\u7acb\u7684\u4e24\u4e2a\u6570<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[7],"tags":[],"_links":{"self":[{"href":"https:\/\/blog.vimge.com\/wp-json\/wp\/v2\/posts\/1061"}],"collection":[{"href":"https:\/\/blog.vimge.com\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blog.vimge.com\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blog.vimge.com\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/blog.vimge.com\/wp-json\/wp\/v2\/comments?post=1061"}],"version-history":[{"count":0,"href":"https:\/\/blog.vimge.com\/wp-json\/wp\/v2\/posts\/1061\/revisions"}],"wp:attachment":[{"href":"https:\/\/blog.vimge.com\/wp-json\/wp\/v2\/media?parent=1061"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.vimge.com\/wp-json\/wp\/v2\/categories?post=1061"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.vimge.com\/wp-json\/wp\/v2\/tags?post=1061"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}