Hi all
watching demo server error logs gives me impression that something is wrong with charsets handling:
PHP Fatal error: Allowed memory size of 134217728 bytes exhausted (tried to allocate 10199 bytes) in master-config/libraries/mysql_charsets.lib.php on line 129#012
On more investigation, it seems to happen almost every time with tbl_create.php. To be honest, I fail to see what could consume so much memory there.
Michal Čihař a écrit :
Hi all
watching demo server error logs gives me impression that something is wrong with charsets handling:
PHP Fatal error: Allowed memory size of 134217728 bytes exhausted (tried to allocate 10199 bytes) in master-config/libraries/mysql_charsets.lib.php on line 129#012
On more investigation, it seems to happen almost every time with tbl_create.php. To be honest, I fail to see what could consume so much memory there.
Michal, With the following patch on master I traced peak memory usage when creating a table. Let's say I ask for 10 columns; then on my server the trace shows an increasing peak usage, from 1773912 (first column) to 2014112. This is with PHP 5.3.3, mysqli and mysqlnd.
Can you try on your server?
diff --git a/libraries/mysql_charsets.lib.php b/libraries/mysql_charsets.lib.php index db31ece..acaeba4 100644 --- a/libraries/mysql_charsets.lib.php +++ b/libraries/mysql_charsets.lib.php @@ -137,7 +137,7 @@ function PMA_generateCharsetDropdownBox($type = PMA_CSDROPDOWN_COLLATION, } } $return_str .= '</select>' . "\n"; - +echo 'trace (' . memory_get_peak_usage() . ')'; return $return_str; }
Hi
Dne Wed, 25 Aug 2010 08:03:12 -0400 Marc Delisle marc@infomarc.info napsal(a):
With the following patch on master I traced peak memory usage when creating a table. Let's say I ask for 10 columns; then on my server the trace shows an increasing peak usage, from 1773912 (first column) to 2014112. This is with PHP 5.3.3, mysqli and mysqlnd.
Can you try on your server?
Yes, even with 200 rows, I'm somewhere around 10872096, so I fail to see how somebody could get to so high values. Unfortunately it is POST request, which is not logged so I have no chance to reproduce it.