Solved

Linux Mysql - file containing open databases

Posted on 2014-09-07
2
375 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 77

Expert Comment

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

Featured Post

Master Your Team's Linux and Cloud Stack

Come see why top tech companies like Mailchimp and Media Temple use Linux Academy to build their employee training programs.

Question has a verified solution.

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

Creating and Managing Databases with phpMyAdmin in cPanel.
Join Greg Farro and Ethan Banks from Packet Pushers (http://packetpushers.net/podcast/podcasts/pq-show-93-smart-network-monitoring-paessler-sponsored/) and Greg Ross from Paessler (https://www.paessler.com/prtg) for a discussion about smart network …
Learn several ways to interact with files and get file information from the bash shell. ls lists the contents of a directory: Using the -a flag displays hidden files: Using the -l flag formats the output in a long list: The file command gives us mor…
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.:

792 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