Tag Archives: mysql

MySQL 5.6 @ Facebook development tree Steaphan is a hero (well, everyone else on database engineering team are too) and he is driving efforts to publish MySQL 5.6 changes we’re making to the open. Now they’re on the github (yet … Continue reading

Link | Posted on by | Tagged , | Leave a comment

On replication, some more

Dear MySQL, I feel ashamed that I ever wanted you to support 4.0->5.1 replication, and apologize for that. I really understand that it was really egoistic of me even to consider you should be involved in this. I even understand … Continue reading

Posted in mysql | Tagged , , , | 6 Comments

Profile guided optimization with gcc

Yesterday I wrote how certain build optimizations can have performance differences – and I decided to step a bit deeper into a quite interesting field – profile guided binary optimization. There’re quite a few interesting projects out there, like LLVM … Continue reading

Posted in mysql | Tagged , , , | 6 Comments

Notes from land of I/O

A discussion on IRC sparkled some interest on how various I/O things work in Linux. I wrote small microbenchmarking program (where all configuration is in source file, and I/O modes can be changed by editing various places in code ;-), … Continue reading

Posted in mysql | Tagged , , , , , | 8 Comments

On blocking

If a process has two blocking operations, each blocking other (like, I/O and networking), theoretical performance decrease will be 50%. Solution is very easy – convert one operation (quite often the one that blocks less, but I guess it doesn’t … Continue reading

Posted in mysql | Tagged , , , ,