Menu

#1658 (ok 4.5) Better Performance

Needs_decision
resolved
None
Normal
2015-07-13
2015-04-19
No

pMA4 feels quite slow, especially compared to pMA3. Could performance be improved?

Discussion

  • Marc Delisle

    Marc Delisle - 2015-04-19

    Please describe your environment:

    phpMyAdmin exact version
    PHP version
    MySQL server version
    MySQL client library or mysqlnd
    Extension used
    Web server
    Which sample database and table
    Which storage engine

     
  • Olaf van der Spek

    pMA 4.2.2
    PHP 5.6.7-1
    MariaDB 10.0.17-MariaDB-1 - (Debian)
    Database client version: libmysql - 5.5.42
    PHP extension: mysqli
    nginx/1.6.2
    No sample DB, just real DB and tables
    MyISAM storage engine

    Is it possible to have pMA (or my web browser) log performance data so it's easier to investigate what's slow?

     
  • Marc Delisle

    Marc Delisle - 2015-04-20

    Please have a look at http://demo.phpmyadmin.net/QA_4_4 (choosing MariaDB). This server has many points in common to yours:
    phpMyAdmin 4.4.4-dev
    PHP 5.4.39
    MariaDB 10.0.14
    libmysql - 5.5.41
    mysqli
    libmysql - 5.5.41

    With the sample db "sakila", when I test with Chrome 42 (Win 7) it does not feel slow to me (for example, browsing the actor table).

    We don't have performance data, apart from Status > Monitor that shows some graphs, and Settings > Features > Developer that would show which queries are generated.

    It would be very interesting to see the behavior of the sakila sample database in your environment.

     
  • Olaf van der Spek

    Can't find Developer in Settings > Features.
    It's not about performance of the DBMS but of pMA itself.

    Perhaps you could add profiling code to pMA?
    Have an option to log the total duration of each script.

     
  • Marc Delisle

    Marc Delisle - 2015-05-13
    • assigned_to: Madhura Jayaratne
     
  • Isaac Bennetch

    Isaac Bennetch - 2015-05-13

    We'll do some testing about this and continue discussion in this tracker.

     
  • Isaac Bennetch

    Isaac Bennetch - 2015-05-13
     
  • Madhura Jayaratne

    Here is a link to the discussion on developers' mailing list about the performance and improvements dones. https://sourceforge.net/p/phpmyadmin/mailman/message/34122135/

     
  • Madhura Jayaratne

    • summary: Better Performance --> (ok 4.5) Better Performance
    • status: open --> resolved