Solved

Linux Mysql - file containing open databases

Posted on 2014-09-07
2
377 Views
Last Modified: 2014-09-08
Is there a file within Linux which lists all mounted db files?

I am familiar with the my.cnf which tells MySql where the data dirs are. But is there a file which lists the names of the MySql files in use?

E.g. /etc/mysql/data/database1/database1.MYI
0
Comment
Question by:Schuyler Dorsey
2 Comments
 
LVL 83

Accepted Solution

by:
Dave Baldwin earned 500 total points
ID: 40309009
Typically MySQL databases are 'open' only long enough to run queries.  If there are no queries currently being run, there would be no open database files.
0
 
LVL 78

Expert Comment

by:arnold
ID: 40309231
lsof is the tool that will list open resources by processes.
0

Featured Post

Free learning courses: Active Directory Deep Dive

Get a firm grasp on your IT environment when you learn Active Directory best practices with Veeam! Watch all, or choose any amount, of this three-part webinar series to improve your skills. From the basics to virtualization and backup, we got you covered.

Question has a verified solution.

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

Suggested Solutions

Linux users are sometimes dumbfounded by the severe lack of documentation on a topic. Sometimes, the documentation is copious, but other times, you end up with some obscure "it varies depending on your distribution" over and over when searching for …
The purpose of this article is to demonstrate how we can use conditional statements using Python.
Learn how to find files with the shell using the find and locate commands. Use locate to find a needle in a haystack.: With locate, check if the file still exists.: Use find to get the actual location of the file.:
How to Install VMware Tools in Red Hat Enterprise Linux 6.4 (RHEL 6.4) Step-by-Step Tutorial

726 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