access time / data location
Posted 03 October 2006 - 08:37 AM
I've got a few questions about mySQL:
1. I made a java interface to store and get data to a mySQL database over matlab. The interface works very well and very fast, if I don't have a lot of data in the tables. But if I have about 500'000 rows in a table, it takes a lot of time to load the data (about 2-3 sec). Is this normal?
2. I don't really get where the data is stored. I use MySQL Server 5.0 version 5.0.24a. I just see that there is a new folder (if i create a new database) with the name of the scheme and the information of the created tables. But where is the data i store? I just got that the file "ibdata1" is much bigger than before, so the data must be there. But I want to create a new scheme anbur this onto a dvd. I need portable data. Is this possible?
3. How can I erase data? I know how to erase a table or a scheme, but the data isn't really erased, because the file "ibdata1" is still the same size. I think this is maybe the same problem like in Nr.2!
Looking forward to your answers, thanx for your help,
Posted 03 October 2006 - 08:50 AM
I have MySQL 4.1 installed in this directory.
C:\Program Files\MySQL\MySQL Server 4.1\
and in there, there is a folder called 'data' this is where the databases area. Each database has its own folder and then in there are the tables.
table_name.frm <-- table structure
table_name.MYD <-- the actually data
table_name.MYI <-- the index data if you have this setup, otherwise you want have files with the extension .MYI
If you are looking for a GUI to work with MySQL, try http://webyog.com/en/ very easy to create, edit, empty, backup, drop, query and whatever else to the databases.
Posted 03 October 2006 - 09:01 AM
Posted 03 October 2006 - 02:46 PM
0 user(s) are reading this topic
0 members, 0 guests, 0 anonymous users