?
Solved

Linux Mysql - file containing open databases

Posted on 2014-09-07
2
Medium Priority
?
390 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 84

Accepted Solution

by:
Dave Baldwin earned 2000 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 79

Expert Comment

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

Featured Post

WordPress Tutorial 1: Installation & Setup

WordPress is a very popular option for running your web site and can be used to get your content online quickly for the world to see. This guide will walk you through installing the WordPress server software and the initial setup process.

Question has a verified solution.

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

Fine Tune your automatic Updates for Ubuntu / Debian
In this article, we’ll look at how to deploy ProxySQL.
Get a first impression of how PRTG looks and learn how it works.   This video is a short introduction to PRTG, as an initial overview or as a quick start for new PRTG users.
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…
Suggested Courses

765 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