MYSQL information_schema

Posted on 2009-02-15
Medium Priority
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 http://dev.mysql.com/doc/refman/5.1/en/files-table.html. 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
  • 2
LVL 39

Accepted Solution

Roger Baklund earned 800 total points
ID: 23645161
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

by:Hugh Fraser
Hugh Fraser earned 1200 total points
ID: 23645328
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

by:Hugh Fraser
Hugh Fraser earned 1200 total points
ID: 23645332
Sorry . I meant to add a link to information about clusters, just to complete the answer.


Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Load balancing is the method of dividing the total amount of work performed by one computer between two or more computers. Its aim is to get more work done in the same amount of time, ensuring that all the users get served faster.
By, Vadim Tkachenko. In this article we’ll look at ClickHouse on its one year anniversary.
In this video, Percona Solution Engineer Dimitri Vanoverbeke discusses why you want to use at least three nodes in a database cluster. To discuss how Percona Consulting can help with your design and architecture needs for your database and infras…
In this video, Percona Solutions Engineer Barrett Chambers discusses some of the basic syntax differences between MySQL and MongoDB. To learn more check out our webinar on MongoDB administration for MySQL DBA: https://www.percona.com/resources/we…
Suggested Courses
Course of the Month17 days, 4 hours left to enroll

862 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