Please whitelist cPanel in your adblocker so that you’re able to see our version release promotions, thanks!

The Community Forums

Interact with an entire community of cPanel & WHM users!

v68 new option to disable information schema searches

Discussion in 'Database Discussion' started by ottdev, Nov 7, 2017.

Tags:
  1. ottdev

    ottdev Well-Known Member

    Joined:
    Oct 1, 2013
    Messages:
    119
    Likes Received:
    4
    Trophy Points:
    18
    cPanel Access Level:
    Root Administrator
    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?
     
    #1 ottdev, Nov 7, 2017
  2. cPanelMichael

    cPanelMichael Technical Support Community Manager Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    46,375
    Likes Received:
    2,044
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    Twitter:
    Hello @ottdev,

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

    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).

    Yes, the option works for both MySQL and MariaDB.

    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.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
    #2 cPanelMichael, Nov 8, 2017
  3. ottdev

    ottdev Well-Known Member

    Joined:
    Oct 1, 2013
    Messages:
    119
    Likes Received:
    4
    Trophy Points:
    18
    cPanel Access Level:
    Root Administrator
    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 ?
     
    #3 ottdev, Nov 8, 2017
  4. cPanelMichael

    cPanelMichael Technical Support Community Manager Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    46,375
    Likes Received:
    2,044
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    Twitter:
    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.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
    #4 cPanelMichael, Nov 9, 2017
(You must log in or sign up to post here.)
Loading...
Similar Threads - option disable information
  1. grabyourhosting

    SOLVED The store local backup option is disabled and no active transports exist

    grabyourhosting, Feb 18, 2018, in forum: Data Protection
    Replies:
    8
    Views:
    891
    cPanelMichael
    Jul 24, 2018
  2. Carlos Campano

    Permanently disable ForcePassiveIP option

    Carlos Campano, Apr 7, 2017, in forum: General Discussion
    Replies:
    5
    Views:
    2,066
    cPanelMichael
    Aug 17, 2017
  3. ylluminate

    Efficient Ruby and Rails app devops deployment options?

    ylluminate, Feb 14, 2019, in forum: Workarounds and Optimization
    Replies:
    3
    Views:
    127
    cPanelMichael
    Feb 20, 2019
  4. chengkinhung

    SOLVED [CPANEL-25765] SQL is missing from table export options in phpMyAdmin 4.8.4

    chengkinhung, Jan 20, 2019, in forum: Database Discussion
    Replies:
    4
    Views:
    446
    cPanelMichael
    Feb 27, 2019
  5. dolios

    WHMCS option for subdomain creation issue

    dolios, Jan 16, 2019, in forum: General Discussion
    Replies:
    1
    Views:
    202
    cPanelLauren
    Jan 18, 2019

Share This Page

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Accept Learn More...
    Dismiss Notice