16hot 的博客

16hot 的博客 http://16hot.blog.isyi.com 16hot 一心想要建设一个公共平台给所有有需要的朋友使用。但是，在这里留给自己一块空间，抒发自己的心情。 16hot 2008-11-19T19:55:53Z SQLite Optimization FAQ http://16hot.blog.isyi.com/post/1/811 原文地址： http://web.utk.edu/~jplyon/sqlite/SQLite_optimization_FAQ.html  General 2008-03-22T19:08:44Z 16hot Language Structure http://16hot.blog.isyi.com/post/1/133 <pre>able names. If this were not true (that is, if two different types of structured variables could share</pre><pre>component member names), it would not be clear which default structured variable to use for refer </pre><pre>ences to member names that are not qualified by an instance name.</pre><pre>If a structured variable instance name is not legal as an unquoted identifier, refer to it as a quoted</pre><pre>identifier using backticks. For example,</pre><pre>hot cache</pre><pre>is not legal, but</pre><pre> hot cache </pre><pre>is.</pre><pre>global</pre><pre>,</pre><pre>session</pre><pre>, and</pre><pre>local</pre><pre>are not legal instance names. This avoids a conflict with notation</pre><pre>such as</pre><pre>@@global.</pre><pre>var_name</pre><pre>for referring to non structured system variables.</pre><pre>At the moment, the first two rules have no possibility of being violated because the only structured vari </pre><pre>able type is the one for key caches. These rules assume greater significance if some other type of struc </pre><pre>tured variable is created in the future.</pre><pre>With one exception, it is allowable to refer to structured variable components using compound names in</pre><pre>any context where simple variable names can occur. For example, you can assign a value to a structured</pre><pre>variable using a command line option:</pre><pre>shell> mysqld hot_cache.key_buffer_size=64K</pre><pre>In an option file, do this:</pre><pre>[mysqld]</pre><pre>hot_cache.key_buffer_size=64K</pre><pre>If you start the server with such an option, it creates a key cache named</pre><pre>hot_cache</pre><pre>with a size of</pre><pre>64KB in addition to the default key cache that has a default size of 8MB.</pre><pre>Suppose that you start the server as follows:</pre><pre>shell> mysqld key_buffer_size=256K </pre><pre> extra_cache.key_buffer_size=128K </pre><pre> extra_cache.key_cache_block_size=2048</pre><pre>In this case, the server sets the size of the default key cache to 256KB. (You could also have written</pre><pre> default.key_buffer_size=256K</pre><pre>.) In addition, the server creates a second key cache named</pre><pre>extra_cache</pre><pre>that has a size of 128KB, with the size of block buffers for caching table index blocks</pre><pre>set to 2048 bytes.</pre><pre>The following example starts the server with three different key caches having sizes in a 3:1:1 ratio:</pre><pre>shell> mysqld key_buffer_size=6M </pre><pre> hot_cache.key_buffer_size=2M </pre><pre> cold_cache.key_buffer_size=2M</pre><pre>Structured variable values may be set and retrieved at runtime as well. For example, to set a key cache</pre><pre>named</pre><pre>hot_cache</pre><pre>to a size of 10MB, use either of these statements:</pre><pre>mysql> SET GLOBAL hot_cache.key_buffer_size = 10*1024*1024;</pre><pre>mysql> SET @@global.hot_cache.key_buffer_size = 10*1024*1024;</pre><pre>To retrieve the cache size, do this:</pre><pre>mysql> SELECT @@global.hot_cache.key_buffer_size;</pre><pre>556</pre><pre><html /><head></head><meta content="Microsoft FrontPage 5.0" name="GENERATOR" /><meta content="FrontPage.Editor.Document" name="ProgId" /><div align="center"></div></pre> General 2005-10-04T07:42:02Z 16hot MySQL memory used http://16hot.blog.isyi.com/post/1/132 MySQL memory used = key_buffer + max_connections * (join_buffer + record_buffer + sort_buffer + thread_stack + tmp_table_size) General 2005-10-04T07:34:53Z 16hot 终于支持三级域名访问了 http://16hot.blog.isyi.com/post/1/29 终于支持三级域名访问了经过调试后，发现在后台设置支持三级域名后，不能访问首页了。后来发现原来是有个地方需要修改下。现在已经改好了，已经支持三级域名访问了。哈哈<a href="http://16hot.blog.isyi.com">http://16hot.blog.isyi.com</a> General 2005-07-14T23:32:00Z 16hot 发表文章来测试 http://16hot.blog.isyi.com/post/1/2 发表文章来测试发表文章来测试 General 2005-07-10T05:57:07Z 16hot 祝贺您 http://16hot.blog.isyi.com/post/1/1 如果您阅读到这篇文章，这就意味着您注册的博客已经申请成功。 General 2005-07-09T21:53:24Z 16hot