Archive for September, 2009

Finding for each time interval, how many records are “ocurring” during that interval

Monday, September 28th, 2009 Posted in en_US, mysql, performance | No Comments »

This is a complex problem: You are mapping events (of some kind) with a start and end timestamp, but how do you know, for a specific interval [ti,tf] (timeslot), how ... Read more..

Importing wikimedia dumps

Monday, September 28th, 2009 Posted in en_US, mysql, wikipedia | 3 Comments »

We are trying to gather some particular statistics about portuguese wikipedia usage. I proposed myself for import the ptwiki-20090926-stub-meta-history dump, which is a XML file, and we'll be running ... Read more..

Listing miscellaneous Apache parameters in SNMP

Monday, September 28th, 2009 Posted in en_US, monitorização | No Comments »

We recently had to look at a server which occasionaly died with DoS. I was manually monitoring a lot of stuff while I was watching a persistent BIG apache worker ... Read more..

Side-effect of mysqlhotcopy and LVM snapshots on active READ server

Saturday, September 26th, 2009 Posted in en_US, monitorização, mysql, performance | No Comments »

I just came across a particular feature of MySQL while using inspecting a Query Cache being wiped out at backup times. Whenever you run FLUSH TABLES, the whole Query Cache ... Read more..

Tamanho e character set de campos VARCHAR e consequências

Thursday, September 24th, 2009 Posted in mysql, performance, pt_PT | 3 Comments »

Apesar do tamanho dos campos VARCHAR não influenciar o tamanho dos índices, este tipo de dados (e outros semelhantes) comportam uma série de características que podem afectar seriamente a performance. ... Read more..

Novidades na integração SugarCRM - IPBrick

Tuesday, September 15th, 2009 Posted in pt_PT, sugarcrm | No Comments »

Para a versão GA do SugarCRM 5.5, estamos a preparar algumas surpresas para a versão 5.1 da IPBrick: Disponibilização do suporte integrado para qualquer das versões SugarCRM 5.2 e 5.5 (Community ... Read more..

Automatically cleaning up SPAM Wordpress comments

Sunday, September 6th, 2009 Posted in dri, en_US, mysql | 2 Comments »

Doing the maintenance of our blogs (Wordpress), I bumped over one that had fallen on an active botnet. It was receiving like 5 or 6 spam comments per minute. It ... Read more..

About cloud computing

Wednesday, September 2nd, 2009 Posted in en_US, linux driver, scaling | No Comments »

Last Sunday I commented about Pedro's opinion about cloud computing and thought I could give my blog a reversed trackback :) Here it goes: I think Pedro's message is important. Cloud ... Read more..