1

I tried to resize parameters using

set global parameter_name=size

from command line ,but it gives me error as

Error Code: 1238. Variable 'innodb_buffer_pool_size' is a read only variable
Oldskool
  • 34,211
  • 7
  • 53
  • 66
Gajanan Gadam
  • 65
  • 5
  • 1
    http://stackoverflow.com/questions/5696857/how-to-change-value-for-innodb-buffer-pool-size-in-mysql-on-mac-os – Saty Jun 05 '15 at 13:13
  • possible duplicate of [How to set global innodb\_buffer\_pool\_size?](http://stackoverflow.com/questions/19534144/how-to-set-global-innodb-buffer-pool-size) – Phil Ross Jun 05 '15 at 13:15
  • i already checked these two links and made changes in my.ini file.that is ok, but i want resize through command line – Gajanan Gadam Jun 05 '15 at 13:28
  • i have also tried SET sort_buffer_size=10000; SET @@local.sort_buffer_size=10000; SET GLOBAL sort_buffer_size=1000000, SESSION sort_buffer_size=1000000; SET @@sort_buffer_size=1000000; SET @@global.sort_buffer_size=1000000, @@local.sort_buffer_size=1000000; – Gajanan Gadam Jun 05 '15 at 13:28
  • @oldskool,@philRoss but it gives me same error. – Gajanan Gadam Jun 05 '15 at 13:29

1 Answers1

0

'read only' variables are read only. That means, their values can't be changed dynamically by any means. You need to go to your my.cnf, change the initial value there and restart mysql process.

Axel Amthor
  • 10,980
  • 1
  • 25
  • 44