Re: Solution for slow MySQL database performance
> SET GLOBAL innodb_buffer_pool_size = 134217728
> MySQL said: Documentation
> #1238 - Variable 'innodb_buffer_pool_size' is a read only variable.
It can be set only in my.cnf under [mysqld]. It can be set to something like 24576M or 2G. Best set to 70-75% of available RAM.
Subject
Written By
Posted
February 05, 2015 02:09PM
February 05, 2015 03:56PM
February 05, 2015 07:18PM
February 06, 2015 06:18AM
February 06, 2015 07:01AM
February 06, 2015 01:34PM
Re: Solution for slow MySQL database performance
February 06, 2015 11:52AM
February 09, 2015 04:23AM
February 09, 2015 09:21AM
February 10, 2015 08:09AM
February 10, 2015 12:19PM
February 11, 2015 04:36AM
February 11, 2015 12:32PM
February 13, 2015 05:39AM
February 13, 2015 02:20PM
February 16, 2015 08:38AM
February 16, 2015 09:08AM
February 12, 2015 11:12PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.