Tag Archives: directio

on io scheduling again

Most of database engines have to deal with underlying layers – operating systems, device drivers, firmware and physical devices, albeit different camps choose different methods. In MySQL world people believe that InnoDB should be handling all the memory management and … Continue reading

Posted in mysql | Tagged , , , , | Leave a comment

Logs memory pressure

Warning, this may be kernel version specific, albeit this kernel is used by many database systems Lately I’ve been working on getting more memory used by InnoDB buffer pool – besides obvious things like InnoDB memory tax there were seemingly … Continue reading

Posted in facebook, mysql | Tagged , , , | 4 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