v68 new option to disable information schema searches

[ottdev]

I read the ? on the item in WHM, and I read about information_schema in general on MySQL and MariaDB websites. I still have questions in order to decide to enable this or not!

Does this tweak have effect on both MySQL and MariaDB systems ?

How does an average user use "information_schema searches" ? Does this only come into play if a siteowner manually actively searches in those tables in PHPMyAdmin ? Or is it passively searched to produce the initial display there such that disabling it cause useful info to be missing on first page or in left hand navigation (the db/table "tree" view) ?

What kind of data would he be looking for there - is it what website admin would routinely be interested in or it's rarely used but by a"advanced" DB programmers?

Or is it common for this table to be used within CMS like Wordpress or Joomla?

 

[cPanelMichael]

Hello @ottdev,

Here's the corresponding section from the cPanel 68 Release Notes:

phpMyAdmin performance setting
In cPanel & WHM version 68, we added the Enable phpMyAdmin information schema searches setting to the Software section of WHM's Tweak Settings interface (WHM >> Home >> Server Configuration >> Tweak Settings). If you disable this setting, the system disables information schema searches by phpMyAdmin in MySQL. This may improve phpMyAdmin performance.

It's important to note this option only affects information schema searches by phpMyAdmin as opposed to the applications/databases you host within accounts. It was implemented to help address reports of phpMyAdmin loading slowly (see SOLVED - PHPMyadmin 4.6.x is slow to load).

Does this tweak have effect on both MySQL and MariaDB systems ?

Yes, the option works for both MySQL and MariaDB.

How does an average user use "information_schema searches" ? Does this only come into play if a siteowner manually actively searches in those tables in PHPMyAdmin ? Or is it passively searched to produce the initial display there such that disabling it cause useful info to be missing on first page or in left hand navigation (the db/table "tree" view) ?

The average user does not necessarily use information schema searches. It's simply part of how phpMyAdmin loads data when a user opens phpMyAdmin or dumps a database (a search of a database/table is not required to use it). Disabling information schema searches will not prevent data from appearing in phpMyAdmin.

Thank you.

 

[ottdev]

The average user does not necessarily use information schema searches. It's simply part of how phpMyAdmin loads data when a user opens phpMyAdmin or dumps a database (a search of a database/table is not required to use it). Disabling information schema searches will not prevent data from appearing in phpMyAdmin.

Thank you.

So the average user wouldn't miss it with the benefit that PHPMyAdfmin loads quicker? You mention dumps ... this is in the context of WITHIN PHPMyAdmin only? Does this mean a user can no longer export in PHPMyadmin or it may be slower ?

 

[cPanelMichael]

Hello,

Yes, it's only within the context of phpMyAdmin. Exporting a database (dumping it) via phpMyAdmin will work whether the information schema searches option is disabled or not, however disabling it has shown to help performance in some cases. MySQL documents the technical background information about INFORMATION_SCHEMA itself if you are interested in how it works:

MySQL :: MySQL 5.7 Reference Manual :: 24 INFORMATION_SCHEMA Tables

Thank you.