?
Solved

where does mysql store its data files in windows 8

Posted on 2014-01-16
3
Medium Priority
?
517 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 2000 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

U.S. Department of Agriculture and Acronis Access

With the new era of mobile computing, smartphones and tablets, wireless communications and cloud services, the USDA sought to take advantage of a mobilized workforce and the blurring lines between personal and corporate computing resources.

Question has a verified solution.

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

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.
In this blog post, we’ll look at how using thread_statistics can cause high memory usage.
In this video, Percona Solution Engineer Rick Golba discuss how (and why) you implement high availability in a database environment. To discuss how Percona Consulting can help with your design and architecture needs for your database and infrastr…
In this video, Percona Solutions Engineer Barrett Chambers discusses some of the basic syntax differences between MySQL and MongoDB. To learn more check out our webinar on MongoDB administration for MySQL DBA: https://www.percona.com/resources/we…
Suggested Courses

771 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