<?xml version="1.0" encoding="UTF-8" ?>
<rss version="2.0">
<channel>
<title><![CDATA[gOxiA=苏繁=SuFan Blog]]></title> 
<link>https://maytide.net/index.php</link> 
<description><![CDATA[gOxiA,苏繁,sufan,Microsoft MVP]]></description> 
<language>zh-cn</language> 
<copyright><![CDATA[gOxiA=苏繁=SuFan Blog]]></copyright>
<item>
<link>https://maytide.net/read.php/725.htm</link>
<title><![CDATA[MySQL 4.1.x noinstall模式下my.ini配置]]></title> 
<author>gOxiA &lt;sufan_cn@msn.com&gt;</author>
<category><![CDATA[技术备忘]]></category>
<pubDate>Mon, 11 Jul 2005 03:16:18 +0000</pubDate> 
<guid>https://maytide.net/read.php/725.htm</guid> 
<description>
<![CDATA[ 
	<p><div class="code"># Example MySQL config file for small systems.<br />#<br /># This is for a system with little memory (&lt;= 64M) where MySQL is only used<br /># from time to time and it's important that the mysqld daemon<br /># doesn't use much resources.<br />#<br /># You can copy this file to<br /># /etc/my.cnf to set global options,<br /># mysql-data-dir/my.cnf to set server-specific options (in this<br /># installation this directory is /usr/local/var) or<br /># ~/.my.cnf to set user-specific options.<br />#<br /># In this file, you can use all long options that a program supports.<br /># If you want to know which options a program supports, run the program<br /># with the &quot;--help&quot; option.</p><p># The following options will be passed to all MySQL clients<br />[client]<br />#password = your_password<br />port  = 3306<br />socket  = /tmp/mysql.sock</p><p># Here follows entries for some specific programs</p><p># The MySQL server<br />[mysqld]<br /><font color=\"#ff6000\"><font color=\"#c00000\">old_password<br />basedir=C:/mysql<br />datadir=C:/mysql/data</font><br /></font>port  = 3306<br />socket  = /tmp/mysql.sock<br />skip-locking<br />key_buffer = 16K<br />max_allowed_packet = 1M<br />table_cache = 4<br />sort_buffer_size = 64K<br />read_buffer_size = 256K<br />read_rnd_buffer_size = 256K<br />net_buffer_length = 2K<br />thread_stack = 64K</p><p># Don't listen on a TCP/IP port at all. This can be a security enhancement,<br /># if all processes that need to connect to mysqld run on the same host.<br /># All interaction with mysqld must be made via Unix sockets or named pipes.<br /># Note that using this option without enabling named pipes on Windows<br /># (using the &quot;enable-named-pipe&quot; option) will render mysqld useless!<br /># <br />#skip-networking<br />server-id = 1</p><p># Uncomment the following if you want to log updates<br />#log-bin</p><p># Uncomment the following if you are NOT using BDB tables<br />#skip-bdb</p><p># Uncomment the following if you are using InnoDB tables<br />#innodb_data_home_dir = /usr/local/var/<br />#innodb_data_file_path = ibdata1:10M:autoextend<br />#innodb_log_group_home_dir = /usr/local/var/<br />#innodb_log_arch_dir = /usr/local/var/<br /># You can set .._buffer_pool_size up to 50 - 80 %<br /># of RAM but beware of setting memory usage too high<br />#innodb_buffer_pool_size = 16M<br />#innodb_additional_mem_pool_size = 2M<br /># Set .._log_file_size to 25 % of buffer pool size<br />#innodb_log_file_size = 5M<br />#innodb_log_buffer_size = 8M<br />#innodb_flush_log_at_trx_commit = 1<br />#innodb_lock_wait_timeout = 50</p><p>[mysqldump]<br />quick<br />max_allowed_packet = 16M</p><p>[mysql]<br />no-auto-rehash<br /># Remove the next comment character if you are not familiar with SQL<br />#safe-updates</p><p>[isamchk]<br />key_buffer = 8M<br />sort_buffer_size = 8M</p><p>[myisamchk]<br />key_buffer = 8M<br />sort_buffer_size = 8M</p><p>[mysqlhotcopy]<br />interactive-timeout</div></p><p>实际上最主要的就是添加红色部分的设置。</p>
]]>
</description>
</item>
</channel>
</rss>