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.
Log in to post a comment.