Skip to content

[Bug]: Unable to render 60k record into phpmyadmin 5.2.3 #20422

Open
Open
[Bug]: Unable to render 60k record into phpmyadmin 5.2.3#20422
Labels
BugA problem or regression with an existing feature

Description

@mahendramcoders
mahendramcoders
opened on Aug 14, 2026

Describe the bug

I have a query that I am trying to run in phpMyAdmin. It involves joins across 9 tables and 2 databases. The query takes a long time to execute and eventually times out. I have already increased the timeout limit to 1800 seconds, but I am still facing the same issue.

The same query works perfectly on my old server, which has the following configuration:

MySQL 5.5
PHP 5.5
phpMyAdmin 4.0
On the old server, the query executes in approximately 6 seconds and successfully displays all 60,000 records in phpMyAdmin.

However, I am facing this issue on my new server, which has the following configuration:

Ubuntu 26.04
MySQL 8.4
PHP 8.5
phpMyAdmin 5.2.3
The query that runs in 6 seconds on the old server is taking much longer on the new server and eventually times out.

When I tried to run query in mysql prompt it is working fine.

Could you please help me identify the reason for this difference and suggest how I can fix the issue? Is there any phpMyAdmin configuration I should check?

Thank you for your help.

How to Reproduce

Image Image

Expected behavior

Can you share and fix that I can do at my send to phpmyadmin redndering issue.

Screenshots

Image Image

Operating System

Linux

Web Server

Apache2

Database Server

MySQL

Database version

Mysql 8.4

PHP version

8.5

phpMyAdmin version

5.2.3

browser

Chrome 151

Additional context

Can you please help me out to fix the issue.

Activity

  1. mahendramcoders
    added
    BugA problem or regression with an existing feature
    on Aug 14, 2026

  2. M393 commented on Aug 14, 2026

    @M393
    M393
    on Aug 14, 2026
    Contributor

    #20353 might have improved the situation, can you try the latest phpMyAdmin 5.2+snapshot?

  3. mahendramcoders commented on Aug 14, 2026

    @mahendramcoders
    mahendramcoders
    on Aug 14, 2026
    Author

    So I need to uninistall current phpmyadmin 5.2.3 and install phpMyAdmin 5.2+snapshot so it will fix my 60K recorder in phpmyamin rendering issue and how to install phpMyAdmin 5.2+snapshot in my ubuntu 26.4.
    Can you please help me out.

  4. M393 commented on Aug 14, 2026

    @M393
    M393
    on Aug 14, 2026
    Contributor

    You don't need to uninstall the old version.

    Download and extract the snapshot, then edit the config.inc.php to configure it for your db.
    Then make it available in your webserver (copy it to your webroot, may be /var/www/html/ or add an alias config to your web server so it is available via url)

  5. M393 commented on Aug 14, 2026

    @M393
    M393
    on Aug 14, 2026
    Contributor

    Alternatively you can manually apply the changes from #20353 to your installed version.

  6. mahendramcoders commented on Aug 14, 2026

    @mahendramcoders
    mahendramcoders
    on Aug 14, 2026
    Author

    Hi Thanks for your reply,
    I have done with phpmyadmin 5.2+snapshot but still have same issue. Can you please share fix so I will resolve the issue.

  7. M393 commented on Aug 14, 2026

    @M393
    M393
    on Aug 14, 2026
    Contributor

    Can you share the query and tables' structure?
    Are you actually trying to show all ~60000 records at once?

    While the query is executing in phpMyAdmin, try running:
    SHOW FULL PROCESSLIST a few times to figure out which query(s) in phpMyAdmin are actually taking so long. Could be one slow query or a lot of smaller ones.

    You can also try this: #18728 (comment)

  8. mahendramcoders commented on Aug 14, 2026

    @mahendramcoders
    mahendramcoders
    on Aug 14, 2026
    Author

    Hi,
    My query is executing quickly in nysql terminal and also executing on phmytadmin also but I need to 60k record in phpmyadmin that html rendering getting issue.
    So can you share fix.

  9. liviuconcioiu commented on Aug 14, 2026

    @liviuconcioiu
    liviuconcioiu
    on Aug 14, 2026
    Contributor

    @mahendramcoders please run this from MySQL console, as @M393 said, while you run your query in phpMyAdmin. This will help to understand what phpMyAdmin appends to your query.

    SHOW FULL PROCESSLIST;

    Also, if you can enable query logging in my.ini:

    [mysqld]
general_log = 1
general_log_file = /var/log/mysql/mysql.log

    Alternatively, if you can share the query and dummy tables if possible would be much better.

    @M393 I suspect there's a COUNT(*) or LIMIT that phpMyAdmin adds to the query, that might run a few thousand times (because his query is not optimized). I ran into it a few times, for example #16808

  10. kamil-tekiela commented on Aug 14, 2026

    @kamil-tekiela
    kamil-tekiela
    on Aug 14, 2026
    Contributor

    Hi, My query is executing quickly in nysql terminal and also executing on phmytadmin also but I need to 60k record in phpmyadmin that html rendering getting issue. So can you share fix.

    So you mean you are not using paging and you are displaying all 60k rows at once?

  11. mahendramcoders commented on Aug 14, 2026

    @mahendramcoders
    mahendramcoders
    on Aug 14, 2026
    Author

    We are using paging and yes

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Metadata

Metadata

Assignees

No one assigned

    Labels

    BugA problem or regression with an existing feature

    Type

    No type

    Projects

    No projects

      Milestone

      No milestone

      Relationships

      None yet

      Development

      No branches or pull requests

      Issue actions