MYSQL information_schema

Posted on 2009-02-15
Last Modified: 2012-05-06
I run a following query but return me empty, I thoughtr it should return me at least a values where is my data or log restored ? what is actually this tables use for ? according from the linke it refer to "NDB" data which I do not know what is this

mysql> select * from information_schema.files;
Empty set (0.00 sec)

Question by:motioneye
    LVL 39

    Accepted Solution

    NDB is mysql cluster engine

    To find the mysql data direcotry, issue this sql statement:

    show variables like 'datadir';

    To find the error log, use this:

    show variables like 'log_error';
    LVL 12

    Assisted Solution

    The query you're using is meaningful only if you're using the NDB engine, which used for managing clustered MYSQL databases. Use the commands provided by cxr to find the information you're looking for.
    LVL 12

    Assisted Solution

    Sorry . I meant to add a link to information about clusters, just to complete the answer.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    How your wiki can always stay up-to-date

    Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
    - Increase transparency
    - Onboard new hires faster
    - Access from mobile/offline

    Foreword In the years since this article was written, numerous hacking attacks have targeted password-protected web sites.  The storage of client passwords has become a subject of much discussion, some of it useful and some of it misguided.  Of cou…
    Does the idea of dealing with bits scare or confuse you? Does it seem like a waste of time in an age where we all have terabytes of storage? If so, you're missing out on one of the core tools in every professional programmer's toolbox. Learn how to …
    Hi everyone! This is Experts Exchange customer support.  This quick video will show you how to change your primary email address.  If you have any questions, then please Write a Comment below!
    This video discusses moving either the default database or any database to a new volume.

    761 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    11 Experts available now in Live!

    Get 1:1 Help Now