mysql linux filesystem
Question of Linux file system?
Not exactly a beginner, but need help, though. I am a webmaster, both in design and hosting Website of my client (and please do not comment on the accommodation I am Net + certified). I wrote my own set of PHP libraries for the pages dynamic, but before the space becomes an issue (despite the raid storage 2TBs that use very little-by-client thank my lib / php), I need know what takes up more space: many, sometimes up to 100 very small files, a flat file containing regular expressions filters (such as ":" to separate entries would be in smaller files), or simply a MySQL database? I know that the smallest files take a little more space through inodes, but must not make a difference. Of course this is all in a 1TB drive RAID 5 using ext3 filesystem.
Most systems most used files in less space for a large file from a large number of small files in the same combined size due to the overhead required for each file and blocks that are not 100%. I made the quick experiment to confirm this ext3 – 1000 files a few bytes each took about 4 MB file system outside (3mb general), where a 1MB file took off 1028 kb (4kb general). So far in MySQL, there is a rapid response – is highly dependent on how data is organized and indices – but even an indexed data table probably will take more space than the equivalent text file. There is a balance between access speed and space use. Data take less space is not necessarily easier access. That's the difference between OLTP systems and data warehouse.