Using non-standard memory allocator for MySQL in Linux
By default we all use glibc memory allocator which is a standard for every Linux system. malloc() implementation of glibc is pretty decent for most workloads and usually we don’t need to change it. What about MySQL? In this case it worth to look into another implementations, especially if your multyprocessor hardware is expecting to [...]
How to migrate MySQL users from one server to another
Sometimes you need to create a copy of your production server, but using newer MySQL version. Lets say you want to see if there are any compatibility issues with you application related to new MySQL release. If you have hundreds of MySQL users and difference between versions is high, then copying users using mysqldump can [...]
Query cache in MySQL 5.5 and 5.6
MySQL 5.6.10 was released a couple of weeks ago and it’s time to start playing with it. Change log is impressive, though some recent benchmark tests are not looking so good as expected. But this post is not about benchmarks. It will be pretty short. One thing I noticed is that now in 5.6.10 query_cache_type [...]
How to log MySQL connections – yet another way
Sometimes you need to catch some information which can’t be provided by MySQL “out of the box”. Once upon a time I had to enable temporary logging on one of MySQL servers. The goal is to collect a pairs of remote users and their hostnames/IPs authenticated on the server. That’s it, no more info required.
My first post
I’ve always wanted to start my own blog about MySQL and other IT things, which I’m interested in.