Branch: refs/heads/QA_5_2
Home: https://github.com/phpmyadmin/phpmyadmin
Commit: e4d9a1a66ab0b036d7925167a6259ab96d251426
https://github.com/phpmyadmin/phpmyadmin/commit/e4d9a1a66ab0b036d7925167a62…
Author: Nicolas Hervouet <github(a)pico12.fr>
Date: 2023-03-24 (Fri, 03 March 2023) -03:00
Changed paths:
M libraries/classes/DatabaseInterface.php
M libraries/classes/Util.php
Log Message:
-----------
Fix for handle large number of tables in a single database (more than 10k)
getTablesFull was taking too much time, because MySQL do not have a real table where it stores all tables information.
So when it runs a query like select * from information_schema.TABLES ORDER BY Name limit 250 offset 0, MySQL has to read information about all tables to build his in memory table, then sort it by name, and then return 250 first tables.
But reading information about one table takes time, and that's why the query is very slow when you have a lot of tables.
Note that the problem is the same with 'SHOW TABLE STATUS'.
So, in order to speed up this query, we have to limit it to a small list of tables, as it, MySQL has to read table information only for few tables.
Note that SHOW TABLES is not that long, even with a large amount of tables.
The idea here is to use the result of SHOW TABLES query, to apply paging on this table list, and then to run the query on information_schema.TABLES only on tables we want.
Signed-off-by: Nicolas Hervouet <github(a)pico12.fr>
Commit: 64aa5fc7b9ff859b5c90f20b81937e85264e9238
https://github.com/phpmyadmin/phpmyadmin/commit/64aa5fc7b9ff859b5c90f20b819…
Author: Maurício Meneghini Fauth <mauricio(a)fauth.dev>
Date: 2023-03-24 (Fri, 03 March 2023) -03:00
Changed paths:
M libraries/classes/DatabaseInterface.php
M libraries/classes/Util.php
Log Message:
-----------
Merge pull request #17718 from PicoI2/handle-large-number-of-tables-in-database-qa52
Fix for handle large number of tables in a single database (based on QA_5_2)
Branch: refs/heads/master
Home: https://github.com/phpmyadmin/phpmyadmin
Commit: 9d19822fff7f509b08845ab2016c589e97047227
https://github.com/phpmyadmin/phpmyadmin/commit/9d19822fff7f509b08845ab2016…
Author: Maurício Meneghini Fauth <mauricio(a)fauth.dev>
Date: 2023-03-21 (Tue, 03 March 2023) -03:00
Changed paths:
M libraries/classes/Config/ConfigFile.php
M phpstan-baseline.neon
M psalm-baseline.xml
Log Message:
-----------
Remove the _overrides key of the ConfigFile::$cfgDb
It's always empty. It was introduced by 5c658310aab02837d47305f73ccaffe5fd43f397
and its last usage was removed by 2a8962aa95ba5f8b11439bfe3e9ecc88decb2c88
Signed-off-by: Maurício Meneghini Fauth <mauricio(a)fauth.dev>
Commit: 657008904420e156b7b45693a945e5c614d7806a
https://github.com/phpmyadmin/phpmyadmin/commit/657008904420e156b7b45693a94…
Author: Maurício Meneghini Fauth <mauricio(a)fauth.dev>
Date: 2023-03-21 (Tue, 03 March 2023) -03:00
Changed paths:
M libraries/classes/Config/ConfigFile.php
M phpstan-baseline.neon
M psalm-baseline.xml
Log Message:
-----------
Merge pull request #18284 from MauricioFauth/config-overrides
Remove the _overrides key of the ConfigFile::$cfgDb
Branch: refs/heads/master
Home: https://github.com/phpmyadmin/phpmyadmin
Commit: b836ace0f15c04240e169f10dfc2972cc93b5d52
https://github.com/phpmyadmin/phpmyadmin/commit/b836ace0f15c04240e169f10dfc…
Author: Maurício Meneghini Fauth <mauricio(a)fauth.dev>
Date: 2023-03-20 (Mon, 03 March 2023) -03:00
Changed paths:
M libraries/classes/Config/ConfigFile.php
M phpstan-baseline.neon
M psalm-baseline.xml
M test/classes/Config/ConfigFileTest.php
D libraries/config.values.php
Log Message:
-----------
Merge config.values.php with ConfigFile class
This file is only used by the ConfigFile class, so makes sense to this
information to be inside the class.
Signed-off-by: Maurício Meneghini Fauth <mauricio(a)fauth.dev>
Commit: 41847a8fd24be27b908754acd2e8d8eb3521f686
https://github.com/phpmyadmin/phpmyadmin/commit/41847a8fd24be27b908754acd2e…
Author: Maurício Meneghini Fauth <mauricio(a)fauth.dev>
Date: 2023-03-21 (Tue, 03 March 2023) -03:00
Changed paths:
M libraries/classes/Config/ConfigFile.php
M phpstan-baseline.neon
M psalm-baseline.xml
M test/classes/Config/ConfigFileTest.php
D libraries/config.values.php
Log Message:
-----------
Merge pull request #18282 from MauricioFauth/config-values
Merge config.values.php with ConfigFile class