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
The ultimate question: which cameras and lenses are better. Because I saw some misleading post about lense prices on the internet what people tend to think is the holy scipture I decided to calculate how much would it cost me to build a decent set of lenses for Canon and … Continue reading
I just sent a couple of my photos to apply for the “Élet-Csend” (“Life-Still”) photo tender. This tender was announced by a Kompánia theather in Hungary. The best pictures will be exhibited in Erkel Ferenc community centre from 16th of October. I’m really hoping at least one of my pictures … 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