Allowed memory size

Question

I'm using PHP MySQLi Database Class and on my local computer everything works without any problem. However, when I upload my project to my host I get the following error:

Fatal error: Allowed memory size of 52428800 bytes exhausted (tried to allocate 50331646 bytes) in /usr/home/data/site/public_html/classes/MysqliDb.php on line 678

Line 678 from MysqliDB.php contains the following command:

call_user_func_array(array($stmt, 'bind_result')`, $parameters);

When I type php_value memory_limit 64M in .htaccess file I get this error:

[Fri May 30 11:03:18 2014] [alert] [client 37.98.159.18] /usr/home/data/site/public_html/.htaccess: Invalid command 'php_value', perhaps misspelled or defined by a module not included in the server configuration, referer: http://example.org/index.php

this might help you - http://stackoverflow.com/questions/8812154/overriding-php-ini-on-server — prava, May 30 '14 at 06:11
it seems you tried to fetch all content at once, it easy drown out the memory, just fetch each row and process instead — Hieu Vo, May 30 '14 at 06:56

Your Common Sense · Accepted Answer · 2020-02-07T15:21:37.150

4

Check out the PHP version and - especially - if mysqli on the host is mysqlnd-based. You can use phpinfo() for this. Change host if it's not.
Don't be greedy in your database table definitions. If you need to store only a page of text, do not define your column as a longblob, make it modest text - earlier versions of mysqli tried to allocate memory for the maximum possible size based on the row definition, not the real data size.
If your query returns way too much rows, and you need all of them, making your query unbuffered will solve the problem.

edited Feb 07 '20 at 15:21

answered May 30 '14 at 06:16

Your Common Sense

156,878
40
214
345

PHP Version 5.2.17 I did not find mysqlnd on phpinfo() table column is mediumtext – Abduhafiz May 30 '14 at 06:34
5.2 is awfully outdated. – Your Common Sense May 30 '14 at 06:35
Thanks. I changed my column type to "TEXT" and error fixed. – Abduhafiz May 30 '14 at 09:31

Santosh Ghimire · Answer 2 · 2020-02-19T09:52:53.660

-1

The cause is because PHP has exhausted the maximum memory limit as set by the configuration value memory_limit.

Typically this PHP configuration value has a very low default of 8MB or 16MB.

So, Increase the memory_limit in the servers php.ini configuration file. You can simply change this value from 64MB to 256M or 512MB depending on your needs(Lesser the size is better).

configuration in php.ini file

memory_limit = 128M
max_execution_time = 19000

Another option is to increase this via .htaccess file to solve this problem. so it should be like below :

php_value memory_limit 128M 
php_value max_execution_time 19000

edited Feb 19 '20 at 09:52

answered Feb 07 '20 at 15:06

Santosh Ghimire

69
2
8

1

Increasing the memory limit is like putting out a fire with gasoline. You need to make your PHP consume less memory, just like the OP did. – Your Common Sense Feb 07 '20 at 15:17
so what is the better solution for this problem? I am also facing the same problem and at last found this simple solution work for me. – Santosh Ghimire Feb 07 '20 at 15:37
Optimize the memory consumption. Select the only data needed, read the information by small chinks, etc. – Your Common Sense Feb 07 '20 at 15:39

Allowed memory size

2 Answers2