about phpMyAdmin

[rotan]

when i submit a query "select * from table_name where 1 limit 0,1000" on phpMyAdmin, it very slow and show me "Fatal error: Allowed memory size of 8388608 bytes exhausted (tried to allocate 40 bytes) in /var/www/html/test/php/php/libraries/mysql_wrappers.lib.php on line 42"
my sever OS is Linux RedHat 7.3.

i dont know why.
help me

 

[Gonzo]

This is because the result of your query is very large. PHP has a problem returning large querys to one page.

You can change the limit to show less rows, limit 0, 100
then when you want to see the next rows you can go, limit 101, 200