database file size - MySQL Database

Mike

I running MySQL locally and have the following dir setup

C:\wamp\mysql\d ata\mike - This is where the tables for the database
mike are stored

C:\wamp\mysql\d ata - This is where I think the database data is stored.

Basically the file in the data dir. (ibdata1) is 10,240kb in size.
When I update a table in the mike database the file size of ibdata1
doesn't increase and I don't know why?

Anyone got any ideas??

Thanks

Mike

Feb 20 '06 #1

Subscribe Reply

3110

Gordon Burditt

>I running MySQL locally and have the following dir setup

C:\wamp\mysql\ data\mike - This is where the tables for the database
mike are stored

C:\wamp\mysql\ data - This is where I think the database data is stored.

Basically the file in the data dir. (ibdata1) is 10,240kb in size.
When I update a table in the mike database the file size of ibdata1
doesn't increase and I don't know why?

ibdata1 is preallocated and probably (unless you've really used
it to capacity) has free space within it (from the point of view
of MySQL, but not as far as the OS is concerned).

Gordon L. Burditt

Feb 20 '06 #2

Bill Karwin

"Mike" <mi**@mjfcadsol utions.co.uk> wrote in message
news:11******** **************@ o13g2000cwo.goo glegroups.com.. .

I running MySQL locally and have the following dir setup

C:\wamp\mysql\d ata\mike - This is where the tables for the database
mike are stored

C:\wamp\mysql\d ata - This is where I think the database data is stored.

Basically the file in the data dir. (ibdata1) is 10,240kb in size.
When I update a table in the mike database the file size of ibdata1
doesn't increase and I don't know why?

MySQL come with at least two storage implementations , MyISAM and InnoDB.
InnoDB tables reside in the <datadir>/ibdata1 file. MyISAM tables reside as
individual files under <datadir>/<databasename >.

If you add volume to a table in the mike database, it may be added to either
<datadir>/mike/<tablename>.MYD , or else <datadir>/ibdata1. Which one
depends on the table storage type, which was determined when you created the
table. For example, if the table uses the MyISAM storage type, then the
ibdata1 file won't be touched at all.

And as Gordon says, sometimes a change to the table won't necessarily result
in an immediate change in the file size. For efficiency, the RDBMS may
sometimes increase file size with some room to spare.

Regards,
Bill K.

Feb 21 '06 #3

Similar topics

2266

Image storing in database

by: pescott | last post by:

Hello people, I could really use your help on this one... I have script to upload image data to a database, but all that is uploaded is the decription, not the data BLOB itself. There must be something wrong with the code that fread() and fopen() the file, but what? The inclusion file below, which diplays the form: <?php print ("<table>"); print ("<tr>");

PHP

21224

Database size question

by: dchow | last post by:

Our database size is currently 4G and is incrementing at a rate of 45M/day. What is the max size of a SQL database? And what is the size beyond which the server performance will start to go down?

Microsoft SQL Server

7343

SQL1224N A database agent could not be started to service a request

by: Marvin Libson | last post by:

Hi All: I am running DB2 UDB V7.2 with FP11. Platform is Windows 2000. I have created a java UDF and trigger. When I update my database I get the following error: SQL1224N A database agent could not be started to service a request, or was terminated as a result of a database system shutdown or a force command.

DB2 Database

6461

bsddb3 database file, what are the __db.001, __db.002, __db.003files for?

by: Claudio Grondi | last post by:

I have just started to play around with the bsddb3 module interfacing the Berkeley Database. Beside the intended database file databaseFile.bdb I see in same directory also the __db.001 __db.002 __db.003 files where

Python

7199

MS Access Database File Size smaller then previous version

by: Knick via AccessMonster.com | last post by:

I am novice to MS Access Development, I regularly back my access database every 2, 3 days ...today when I was going to back my database I saw the access file on the network drive was only 9 MB in size, while the backup files that I had saved few days back were 258 MB in size. And the network drive is where the database is saved on. Can anyone suggest something why or how I can track what happend or a way to

Microsoft Access / VBA

8197

How to collect DB2 Database size Version Lesser than 8.2

by: vijay.db | last post by:

Hi Group, It's really confusing to calculate the size of the DB2 UDB database in versions lesser than 8.2. In Version 8.2 if we run the query db2 "call get_dbsize_info(?,?,?,0)" it gives us an approximate size of the database. But it we try calculating the file system sizes of the database home directory, containers file system it gives some other size...

DB2 Database

221

367641

Uploading files into a MySQL database using PHP

by: Atli | last post by:

You may be wondering why you would want to put your files “into” the database, rather than just onto the file-system. Well, most of the time, you wouldn’t. In situations where your PHP application needs to store entire files, the preferred method is to save the file onto the server’s file-system, and store the physical location of the file in your database. This is generally considered to be the easiest and fastest way to store files. ...

PHP

2361

Controlling the sort order for records retrieved from an Access database

by: Brit | last post by:

I have an ASP file that retrieves names from an Access database for 4 different categories of membership, which the visitor to the page selects (corporate, institutional, regular, or student). The DNS name is "cati", the names are specified in the "Last_names" field, and the categories are in the "categories" field. l want the results sorted in alphabetic order by last name. However, the results appear to be in a totally random,...

ASP / Active Server Pages

3490

does this backup sequence commit all data to the database

by: Roger | last post by:

backup log testdb with truncate_only DBCC SHRINKFILE (testdb_log, 100) WITH NO_INFOMSGS backup database testdb to disk = '\\DC01\Backups\DB01\testdb.bak' with init and does the shrinkfile command reduce the size of the ldf ?

Microsoft SQL Server

2952

problem with inserting file name in database

by: liberty1 | last post by:

Hi everyone. I appreciate your effort at helping newbies like me. I have the following problems and will appreciate urgent help. PROBLEM NUMBER 1: Using PHP and MySQL, I am able to upload picture successfully unto the server but not so with the file name of the picture even though other parameters in my form got inserted successfuly in the database. I have read several posts on this topic including here on this site but I can't get around...

PHP

8896

Changing the language in Windows 10

by: Hystou | last post by:

Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...

Windows Server

9653

Problem With Comparison Operator <=> in G++

by: Oralloy | last post by:

Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...

C / C++

9333

Discussion: How does Zigbee compare with other wireless protocols in smart home applications?

by: tracyyun | last post by:

Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...

General

8328

AI Job Threat for Devs

by: agi2029 | last post by:

Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...

Career Advice

6869

Access Europe - Using VBA to create a class based on a table - Wed 1 May

by: isladogs | last post by:

The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...

Microsoft Access / VBA

6151

Couldn’t get equations in html when convert word .docx file to html file in C#.

by: conductexam | last post by:

I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...

C# / C Sharp

4771

Trying to create a lan-to-lan vpn between two differents networks

by: TSSRALBI | last post by:

Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...

Networking - Hardware / Configuration

3395

transfer the data from one system to another through ip address

by: 6302768590 | last post by:

Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system

C# / C Sharp

2872

How to add payments to a PHP MySQL app.

by: muto222 | last post by:

How can i add a mobile payment intergratation into php mysql website.

PHP