Memory allocation

[robust]

Hi,

Require help for the memory allocations on php.ini & my.conf.

php.ini
max_execution_time =
max_input_time =
max_input_vars =
post_max_size =
session.gc_maxlifetime =

my.cnf
innodb_buffer_pool_size=
max_allowed_packet=
open_files_limit=
innodb_file_per_table=

Also, suggest other import values require for mumara.

Thank you

 

[wasif]

What is the size of your server and what are your goals for daily email sending? And how large is your contact list?

 

[robust]

Its has 4 core & 16 GB Ram. We will be uploading around 5M list & 2M/day email volume.

 

[wasif]

Give 50% to your MySQL. 2048 to PHP. So something as below

For php.ini
memory_limit = 2048M
max_execution_time = 300 # Although it shouldn't matter as almost all operations run in the background. Set it your own way. If you are uploading larger files, you would need to increase it.
max_input_time = 900
max_input_vars = 100000
post_max_size = 50M # It's totally your own choice. I don't know the maximum filesize of the list your are importing

For my.cnf
innodb_buffer_pool_size=8G


No need for other values unless you know what you are doing.

 

[wasif]

@zeehman

To give more memory to MySQL, find the MySQL config file mostly placed here /etc/my.cnf and add/edit the following lines to it

innodb_buffer_pool_size=8G

where 8G is the 8GB of RAM you are allocating to MySQL. You can modify the value as per your requirement


To give more memory to PHP, find the php.ini file mostly located at /etc/php.ini and modify the following lines

memory_limit = 2048M

Increases memory, where 2048M is 2GB of the RAM allocated to the PHP.

max_input_vars = 100000

The number of inputs you can set when posting forms. Sometimes you select a lot of lists and sending nodes that make the form data huge.

 

[zeehman]

cnf file is empty

 

[zeehman]

This is whats inside etc/my.cnf.d/ folder.
Where do I find innodb_buffer_pool_size=8G?

 

[wasif]

cnf file is empty

Just add the line above the include dir. But make sure you should know what you are doing. If you have 0 technical experience, I would suggest getting an expert on it.