Where else can I access the innodb_buffer_pool_size variable other than my.cnf?

Question

I installed MAMP and have the latest phpMyAdmin on my Mac. I do not have my.cnf and my.ini file. Yes, I have included all invisible files.

I heard that the free version of MAMP does not allow you, but this does not seem to be correct. I know that MAMPPro has a drop-down list, but I do not buy it.

What else can cause the file?

EDIT: I used grep to search for innodb_buffer_pool_size in the entire MAMP folder, and the only files that had this variable inside assigned it an array, not just a size. Only for greater completeness on this subject.

Answer 1

You can do the following:

MySQL 5.0+

 SHOW VARIABLES LIKE 'innodb_buffer_pool_size'; 

MySQL 5.1+

 SELECT variable_value FROM information_schema.global_variables WHERE variable_name = 'innodb_buffer_pool_size'; 

To install it for MySQL, you must have physically manifest my.cnf or my.ini

Add this to the configuration file

 [mysqld] innodb_buffer_pool_size = 1G 

and restart mysql

You can try placing my.cnf in /etc and restart mysql

Please keep in mind that 128M is the default value for innodb_buffer_pool_size in MySQL 5.5 . As soon as you get my.cnf in the right place on the database server and restart mysql, everything will be different.

Answer 2

If you have a configuration file for MySQL from MAMP, it will be located in /Applications/MAMP/db/mysql/my.cnf.

If the configuration file is missing, the default value is 8 MB.