如何在Mac OS上的MySQL中更改innodb

本文介绍了如何在Mac OS上的MySQL中更改innodb_buffer_pool_size的值?的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！ 问题描述

我试图增加MySQL 5.1中的innodb_buffer_pool_size的大小，因为我一直遇到以下错误，指示我表锁空间不足.

I am trying to increase the size of the innodb_buffer_pool_size in MySQL 5.1 as I keep running into the following error indicating I have run out of space for the table locks.

ERROR: The total number of locks exceeds the lock table size Error Code: 1206

我已经阅读了文档，并从我收集的内容中，我需要更新/etc/myf文件中的innodb_buffer_pool_size.我当前的价值是8M但是，即使在创建该文件并添加以下行以设置值之后，它也不会在MySQL中更新.

I have gone through the documentation and from what I gather, I need to update innodb_buffer_pool_size in the /etc/myf file. My current value is 8M. However, even after creating that file and adding the following line to set the value it is not updating in MySQL.

set-variable=innodb_buffer_pool_size=256M

对如何在Mac上的MySQL中调整此值有任何建议吗?还有其他建议吗?

Does have any advice on how I can adjust this value in MySQL on my mac? Any other advice or suggestions?

推荐答案

将此添加到您的myf

add this to your myf

innodb_buffer_pool_size=1G

重新启动mysql以使其生效

restart your mysql to make it effect