- @cafeugo: i think there’s a #define somewhere for the max number of tables in a join… although casually surprised it performs well at … #
Powered by Twitter Tools.
Powered by Twitter Tools.
Powered by Twitter Tools.
Powered by Twitter Tools.
Powered by Twitter Tools.
Powered by Twitter Tools.
Powered by Twitter Tools.
Powered by Twitter Tools.
Powered by Twitter Tools.
Powered by Twitter Tools.
Powered by Twitter Tools.
How do I make an existing project (let’s say, MySQL) switch from generating a config.h that has #undef HAVE_FOO to one that generates #define HAVE_FOO 0 instead?
Why? Well, here’s why:
Testing for features should be done by including “config.h” and using #if HAVE_<feature>. Use of #if (rather than #ifdef) allows the gcc -Wundef flag to warn users about features which aren’t defined 1 or 0 in config.h.
I can’t remember the last time i used default mkfs or mount options… oh yeah, that’s right – by accident.
Anyway… I did a little experiment today.
The filesystem is my laptop /home – XFS, 100GB, 95% used (so 5-6GB free), rather aged. This is where a lot of my MySQL development is done. Mkfs options: 128MB log, version2 log. Mount options: logbufs=8, logbsize=256k. All of this geared towards increasing metadata performance.
Why metadata performance? well… source code trees are a lot of metadata :)
So, let’s try some things: cloning a repository and then removing the repository.
Two variables are being tested: mounting the file system with nobarrier (or barrier, the default). Write barriers tell the disk to ensure write order to the platter when write cache is in use. Also testing disabling (or enabling, the default) the disk write cache.
NOTE: the last option which has the write cache enabled and write barriers disabled is NOT SAFE. If your machine crashes, you loose data, and potentially your file system ends up corrupted.
So I’m now disabling my disk write cache and mounting with nobarrier.
If you use real disk arrays – e.g. battery backed write cache RAID boxes, the story is likely very different!
Powered by Twitter Tools.
LugRadio is possibly the best Linux/Free Software related podcast out there – and it has been for a very long time. LugRadio Live is a live event where lots of people gather together to love freedom.
This year, there’s a LugRadio Live USA – and it’s in San Francisco. So, are you going to be (or are able to be) around SF the weekend before the MySQL UC? If, there is no excuse not to drop in on LugRadio Live USA – it should be awesome! (oh, and it doesn’t cost much… like $10 or something)
Powered by Twitter Tools.
Watched In the Name of the King: A Dungeon Siege Tale (2007) the other day. Fucking awful. Only watch while unconcious and wanting to have the remaining life sucked out of you. We took to making up dialog for the people on the screen – and ours was better.
Powered by Twitter Tools.
Powered by Twitter Tools.
Powered by Twitter Tools.