Solved

Linux Mysql - file containing open databases

Posted on 2014-09-07
2
358 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 82

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 76

Expert Comment

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

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

Join & Write a Comment

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.
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 how to get help with Linux/Unix bash shell commands. Use help to read help documents for built in bash shell commands.: Use man to interface with the online reference manuals for shell commands.: Use man to search man pages for unknown command…
Connecting to an Amazon Linux EC2 Instance from Windows Using PuTTY.

746 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

10 Experts available now in Live!

Get 1:1 Help Now