#217 Memory limit bug in large result sets

3.3.3
closed-fixed
Jakub Vrána
MySQL (65)
5
2012-06-29
2012-01-09
Anonymous
No

A query that returns a large result set (> 600 000 rows) repeatedly results in:
'Fatal error: Allowed memory size of 11237896 bytes exhausted (tried to allocate 5216808 bytes) in /home/apache/dev/adminer.php on line 1273 '

The query offset (LIMIT) has to be set manually to fix the problem. My VPS's PHP memory limit is 2GB (= way over 5216808 bytes) and I performed the same query both in command line and phpMyAdmin without issue.

cheers

Discussion

  • Jakub Vrána
    Jakub Vrána
    2012-06-29

    This is fixed in Adminer 3.3.4 which doesn't decrease the original memory limit.

     
  • Jakub Vrána
    Jakub Vrána
    2012-06-29

    • status: open --> closed-fixed