title: How to set innodb_thread_concurrency in MYSQL
body: <p>My MYSQL DB is very slow but when I change the innodb_thread_concurrency value from the default 33 to 0 selects per second rise from 30-40 to 600-700. I would like to set this value every time the DB starts. I usually change variables in my.ini. There are 3 my.ini files on my system but the one in use (listed in MYSQL Workbench) is in the programdata directory. I have tried adding the variable to all 3 but it makes no difference. I must be getting the syntax wrong but I've tried several variations:
      innodb_thread_concurrency=0
      set-variable=innodb_thread_concurrency=0
  Neither seem to work. Whenever I look at the system variable (in MYSQL Workbench) the innodb_thread_concurrency is 33 until I start a session and enter : 
      set global innodb_thread_concurrency=0;
  On Unix systems they talk about my.cnf but no such file exists on my W10 system.</p>
  
  <p>What do I need to do to have this variable correctly set at startup?</p>