欢迎来到天天文库
浏览记录
ID:14426138
大小:50.00 KB
页数:20页
时间:2018-07-28
《mysql-noinstall安装指南》由会员上传分享,免费在线阅读,更多相关内容在行业资料-天天文库。
1、mysql-noinstall安装指南mysql-noinstall安装指南#ExampleMySQLconfigfileforsmallsystems.##Thisisforasystemwithlittlememory(<=64M)whereMySQLisonlyused#fromtimetotimeandit'simportantthatthemysqlddaemon#doesn'tusemuchresources.##Youcancopythisfileto#/etc/my.cnftosetglobaloptions,#mysql-data-dir/my.cnftosetserve
2、r-specificoptions(inthis#installationthisdirectoryis/usr/local/var)or#~/.my.cnftosetuser-specificoptions.##Inthisfile,youcanusealllongoptionsthataprogramsupports.#Ifyouwanttoknowwhichoptionsaprogramsupports,runtheprogram#withthe"--help"option.#ThefollowingoptionswillbepassedtoallMySQLclients[clien
3、t]#password=your_passwordport=3306socket=/tmp/mysql.sock#这里是我们增加的内容#设置客户端字符集default-character-set=gbk#Herefollowsentriesforsomespecificprograms#TheMySQLserver[mysqld]port=3306socket=/tmp/mysql.sockskip-lockingkey_buffer=16Kmax_allowed_packet=1Mtable_cache=4sort_buffer_size=64Kread_buffer_size=256K
4、read_rnd_buffer_size=256Knet_buffer_length=2Kthread_stack=64K#这里是我们修改的内容basedir=D:DevelopToolsmysql-5.0.22-win32#设置mysql数据库的数据的存放目录,必须是data,或者是\xxxdatadatadir=D:DevelopToolsmysql-5.0.22-win32data#设置mysql服务器的字符集default-character-set=utf8#Don'tlistenonaTCP/IPportatall.Thiscanbeasecurityenhanc
5、ement,#ifallprocessesthatneedtoconnecttomysqldrunonthesamehost.#AllinteractionwithmysqldmustbemadeviaUnixsocketsornamedpipes.#NotethatusingthisoptionwithoutenablingnamedpipesonWindows#(usingthe"enable-named-pipe"option)willrendermysqlduseless!##skip-networkingserver-id=1#Uncommentthefollowingifyou
6、wanttologupdates#log-bin=mysql-bin#UncommentthefollowingifyouareNOTusingBDBtables#skip-bdb#UncommentthefollowingifyouareusingInnoDBtables#innodb_data_home_dir=/usr/local/var/#innodb_data_file_path=ibdata1:10M:autoextend#innodb_log_group_home_dir=/usr/local/var/#innodb_log_arch_dir=/usr/local/var/#
7、Youcanset.._buffer_pool_sizeupto50-80%#ofRAMbutbewareofsettingmemoryusagetoohigh#innodb_buffer_pool_size=16M#innodb_additional_mem_pool_size=2M#Set.._log_file_sizeto25%ofbufferpoolsize#innodb_log_file_size=5M#inn
此文档下载收益归作者所有