[phpMyAdmin Git] [phpmyadmin/phpmyadmin] 338686: Filter in use tables at MySQL server to improve pe...

[Michal Čihař]

  Branch: refs/heads/master
  Home:   https://github.com/phpmyadmin/phpmyadmin
  Commit: 338686589beec07fb4ae643d444964d5700c0426
      https://github.com/phpmyadmin/phpmyadmin/commit/338686589beec07fb4ae643d444964d5700c0426
  Author: Michal Čihař <michal at cihar.com>
  Date:   2016-04-07 (Thu, 07 Apr 2016)

  Changed paths:
    M libraries/Util.php

  Log Message:
  -----------
  Filter in use tables at MySQL server to improve performance on big servers

Signed-off-by: Michal Čihař <michal at cihar.com>


  Commit: f9ef2eb37e33fba6cda439792d04949c11c70bef
      https://github.com/phpmyadmin/phpmyadmin/commit/f9ef2eb37e33fba6cda439792d04949c11c70bef
  Author: Michal Čihař <michal at cihar.com>
  Date:   2016-04-07 (Thu, 07 Apr 2016)

  Changed paths:
    M ChangeLog
    M libraries/DatabaseInterface.php
    M libraries/Util.php

  Log Message:
  -----------
  Improve performance with SkipLockedTables

We now fetch all table status in one query, so this has pretty much same
speed as SkipLockedTables disabled.

Issue #12129

Signed-off-by: Michal Čihař <michal at cihar.com>


Compare: https://github.com/phpmyadmin/phpmyadmin/compare/e9386bc623ab...f9ef2eb37e33