I don’t know how many of you are out there but I know at least some who’s lazy enough to rather write scripts than doing the same task over and over again. I’m definitely one of them. I hate repetitive tasks. Just like Abraham Lincoln said: “If I had eight hours … Continue reading
I have a HP MicroServer which I’m very satisfied with. I bought this right away when HP announced it when it still didn’t have a retail price determined. The only downside of it that it has only soft-RAID (or fake-RAID) controller built-in. A proper HP Smart Array controller must have … Continue reading
I just forked and committed some patches to the BitTornado library on GitHub.
Right now I only committed basic fixes to be able to use it in our environment (Python 2.7). Namely:
- Backlog was not always int which should be enforced so I did a force … Continue reading
We’re always testing the latest versions of MySQL with most of the environments to make sure that we can find the critical issues before it goes to production. This wasn’t different with the 5.6 MySQL neither. We already started to play with this version in the summer. The first news … Continue reading
(Note: when I’m talking about MySQL I usually assume InnoDB storage engine. Any other case I explicitly tell this is MyISAM or Memory etc.)
I’ve heared an interesting aproach of using Master-slave replication in MySQL.
So the theory was that since updates by primary keys are fast and by … Continue reading
Autosuggest is always a deal breaker in web applications. Normally users interact with the site once in every 20-30 seconds or even less frequent. That means if we have 30 concurrent visitors on our site we will have 1 request/sec on the webserver. This amount of traffic can be handled … Continue reading
In the last past month I got a lot of question about how to learn to fundaments of being a DBA/DBO. So I decided to write a (hopefully) comprehensive post about this.
First of all as always it depends. Lately I see an upcoming trend to make sharp … Continue reading
Why is it so important to close connections to databases if there’s no explicit need to keep them open (which usually the case)?
- Icinga reports high usage of allowed connections (>90%) on master MySQL server.
- No running queries or any specific in processlist. All the connections are sleeping … Continue reading
I just faced a problem with Joomla 2.5 install when the web install get stuck after the 1st step (language selection). After I searched the internet I found a lot of forums describing the same problem. I read a lot of strange ideas about fixing this with different apache and … Continue reading
I always hear newer and newer exotic way to store different types of data in MySQL. People are trying to solve the problem of storing complex and not necessary strictly structured data in databases which is fine. But I never understood why to try to be tricky with the simplest … Continue reading