Re: Solution for slow MySQL database performance
Thank you both for taking the trouble to look into my problem.
First of all, yes, I use InnoDB.
In phpadmin when I want to change the number for the InnoDB_buffer_pool_size, it gives me the number 128 Mib. When I want to change it; I get an error:
SET GLOBAL innodb_buffer_pool_size = 134217728
MySQL said: Documentation
#1238 - Variable 'innodb_buffer_pool_size' is a read only variable.
The same number I get when I go via webadmin to the MySQL System Variables:
innodb_buffer_pool_size 134217728
So, I try to change it in the my.cnf, where I entered the number 24576M (I have 32Gig of ram at that server) but it looks that it doesn't want to accept that number, even not after a reboot of the server.
I could not follow the other steps that you advised, because here I already encounter a problem.
Subject
Written By
Posted
February 05, 2015 02:09PM
February 05, 2015 03:56PM
February 05, 2015 07:18PM
Re: Solution for slow MySQL database performance
February 06, 2015 06:18AM
February 06, 2015 07:01AM
February 06, 2015 01:34PM
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