Tuesday, December 26
Bum!
MySQL supports large files if your operating system does. So there's no need to worry about your application dropping dead if a particular MyISAM table exceeds 4GB.
Comments are disabled.
Post is locked.
MySQL supports large files if your operating system does. So there's no need to worry about your application dropping dead if a particular MyISAM table exceeds 4GB.
Except that the default table pointer size is 32 bits.
And it seems that changing it from 32 to 40 bits slows database writes by about 10%.
Not that I will necessarily be using MyISAM. What I was doing when my table hit 4GB was finding out whether to use MyISAM or InnoDB.
Well, off we go again. About 4500 inserts per second right now (at one record per query, which is far from the fastest method, but is after all what the application will be doing).
Posted by: Pixy Misa at
09:57 PM
| No Comments
| Add Comment
| Trackbacks (Suck)
Post contains 116 words, total size 1 kb.
44kb generated in CPU 0.0142, elapsed 0.1822 seconds.
54 queries taking 0.1736 seconds, 325 records returned.
Powered by Minx 1.1.6c-pink.
54 queries taking 0.1736 seconds, 325 records returned.
Powered by Minx 1.1.6c-pink.
