Solved

where does mysql store its data files in windows 8

Posted on 2014-01-16
3
510 Views
Last Modified: 2014-01-22
Hello

I am looking at a mysql server 5,6 running innodb on windows 8 and my database appears to be 5 gig in size based on this query

SELECT table_schema "databasename", sum( data_length + index_length ) / 1024 / 1024 "Data Base Size in MB"
FROM information_schema.TABLES GROUP BY table_schema ;

There are a few other databases on the server making the whole lot about 8 gig. However when I look at the C:\ProgramData\MySQL\MySQL Server 5.6\data\ibdata1 file it is only 1 gig in size. Please could you advise where the other data is? How do I find out the entire size requirements of a mysql installation including all of its databases?

thanks
0
Comment
Question by:andieje
[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
3 Comments
 
LVL 60

Expert Comment

by:Kevin Cross
ID: 39785678
The system tables go to C:\ProgramData\MySQL if you do not specify a different path, but I for example have mine under C:\RDMS\MySQL.  If you open the INSTANCE > Options File from the MySQL Workbench, you should see option datadir that you can set to the path your desire (e.g., mine looks like "C:/RDMS/MySQL/data\").
0
 

Author Comment

by:andieje
ID: 39786088
Thanks Kevin, but why is my indata1 file only 1 gig when my combined database total in 8 gig?
0
 
LVL 60

Accepted Solution

by:
Kevin Cross earned 500 total points
ID: 39786144
Are all your tables INNODB?
In other words, if C:\ProgramData\MySQL is indeed your data directory, the ibdata1 usually is the data file; however, you can have individual files (file-per-table configuration).  Therefore, check under other folders in the data directory for .ibd files.  In addition, if you see any .my* files, you have some MyISAM tables also.
0

Featured Post

Transaction Monitoring Vs. Real User Monitoring

Synthetic Transaction Monitoring Vs. Real User Monitoring: When To Use Each Approach? In this article, we will discuss two major monitoring approaches: Synthetic Transaction and Real User Monitoring.

Question has a verified solution.

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

I use MySQL for many of my development projects in a Windows environment. To manage my databases (and perform queries) for years I used a tool called MySQL administrator.  This tool has since been replaced by MySQL Workbench. So I decided to m…
Popularity Can Be Measured Sometimes we deal with questions of popularity, and we need a way to collect opinions from our clients.  This article shows a simple teaching example of how we might elect a favorite color by letting our clients vote for …
There's a multitude of different network monitoring solutions out there, and you're probably wondering what makes NetCrunch so special. It's completely agentless, but does let you create an agent, if you desire. It offers powerful scalability …
In this brief tutorial Pawel from AdRem Software explains how you can quickly find out which services are running on your network, or what are the IP addresses of servers responsible for each service. Software used is freeware NetCrunch Tools (https…

728 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