MySQL data files and log files
Posted on 2008-11-10
In Data folder I can see a folder named with my database name. Inside it I can see few .FRM files. The largest size of a .FRM file is 11 KB. In the Data folder itself, I can see some files whose name are like this:
ibLogFile0 - 10 MB
ibLogFile1 - 10 MB
ibData1 - 18 MB
impserver.pid - 1 KB
I want to know, what is the maximum size of the .FRM file in Windows XP SP2 (FAT32 and NTFS). I also want to know why log files have reached to 10 MB when the database size (total of .FRM files) is 132 KB.
For what these 'ib...' files are used?