title: Changing InnoDB pool size without impacting the local server - MySQL windows
body: <p>Firstly, I have tried looking for various solutions to the issue I am describing below but nothing really worked hence I am posting my own question.</p>
  
  <p>My issue began with trying to modify the datatype of a column in a table with ~9,5 mil rows.
  I got the 1206 error code and after a quick search understood I need to change the pool size in the settings files and did it in the my.ini file (changed from 8 to 64 MB).
  After restarting my PC the workbench couldn't connect as the local server stopped running.
  When I tried to restart the server via services it kept stopping all the time.</p>
  
  <p>After I switched the my.ini file to the old and original version and restarting the PC the workbench is working and the server is running but my original problem continues.</p>
  
  <p>Your help and advice will be much appreciated.</p>
  
  <p>Thanks,
  Michael</p>