title: How to change value for innodb_buffer_pool_size in MySQL on Mac OS?
body: <p>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. </p>
  
  <pre><code>ERROR: The total number of locks exceeds the lock table size
  Error
  Code: 1206
  </code></pre>
  
  <p>I have gone through the documentation and from what I gather, I need to update innodb_buffer_pool_size in the /etc/my.cnf 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. </p>
  
  <pre><code>set-variable=innodb_buffer_pool_size=256M
  </code></pre>
  
  <p>Does have any advice on how I can adjust this value in MySQL on my mac? Any other advice or suggestions? </p>