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
HTML5 was a real big improvement in the webdevelopment. We don’t need ugly JS hacks anymore for the simplest stuff. We can use the built-in functions of the webbrowsers instead. Anybody who didn’t check the new tags and attributes what the new standard provides I highly recommend to do it. … Continue reading
I’ve created the php-apc status collector for Diamond. It’s available on github under Diamond-PhpCollectors: https://github.com/charlesnagy/Diamond-PhpCollectors
This collector is for collecting APC (Alternative PHP Cache) statistics for Graphite.
To be able to use the plugin first of all you will need to put the included stats_apc.php to the www directory … Continue reading
I’ve created the php-fpm status collector for Diamond. It’s available on github under Diamond-PhpCollectors: https://github.com/charlesnagy/Diamond-PhpCollectors
$ curl http://localhost/fpm_status
start since: 2926
accepted conn: 113
listen queue: 0
max listen queue: 0
listen queue len: 128
idle processes: 2
active processes: 1
total processes: 3
max active processes: 1
max children reached: 0
First of all you will need to enable status page in php-fpm.conf.
The following line should be in the config file.
pm.status_path = /fpm_status
Reload php-fpm service.
In the … Continue reading