关于如何设置 InfiniDB 选项的指南?
我一直在尝试找出如何最好地设置这些设置,但无法找到有关它们的太多信息。其中一些我以前在常规 MySQL 安装中见过,但另一些我还没有见过:
## InfiniDB Specific options
sort_buffer_size = 4M
read_buffer_size = 4M
read_rnd_buffer_size = 16M
thread_cache_size = 8
query_cache_size = 0
thread_stack = 512K
join_buffer_size = 128M
#infinidb_compression_type=0
任何人都可以指导我正确的方向吗?
I've been trying to find out how to best set these settings, but haven't been able to find much info on them. Some of them I've seen before with regular MySQL installations, but some others I haven't:
## InfiniDB Specific options
sort_buffer_size = 4M
read_buffer_size = 4M
read_rnd_buffer_size = 16M
thread_cache_size = 8
query_cache_size = 0
thread_stack = 512K
join_buffer_size = 128M
#infinidb_compression_type=0
Can anyone guide me in the right direction?
如果你对这篇内容有疑问,欢迎到本站社区发帖提问 参与讨论,获取更多帮助,或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱,如果其他用户或者作者回复了您的评论,将不能在第一时间通知您!
发布评论
评论(1)
InfiniDb是建立在MySql之上的,这些值都是标准的MySql系统变量。在决定它们的值时,请参考 MySql 文档。
描述可以在这里找到:
http://dev.mysql.com/doc/refman /5.1/en/server-system-variables.html
InfiniDb is built upon MySql, and these values are all standard MySql system variables. When deciding on their values, reference the MySql documentation.
Descriptions can be found here:
http://dev.mysql.com/doc/refman/5.1/en/server-system-variables.html