Watch out for kernel >= 3.0 power saving regressions…

Wednesday, November 30th, 2011 Posted in en_US, fedora, linux driver, performance, ubuntu | No Comments »

I was reading Phoronix comprehensive tests about recent power saving regressions - specifically important for laptops -, and would like to point out this to everyone, since, according to the ... Read more..

Multiple field index vs external primary key calculation

Saturday, August 29th, 2009 Posted in en_US, mysql, performance | No Comments »

I bumped over a client which was using a VARCHAR(200) as a MyISAM PRIMARY KEY key for detecting colisions which was externally (by the app) calculated and fed into MySQL. ... Read more..

Benchmarking de parâmetros InnoDB

Wednesday, July 15th, 2009 Posted in mysql, performance, pt_PT | No Comments »

Aqui vão uns benchmarks que fiz uma vez com InnoDB para uma tabela quase exclusivamente de escrita. Com quase exclusivamente quero dizer que 99.99% das operações eram INSERTs. O filesystem, ... Read more..

MySQL DATETIME vs TIMESTAMP vs INT performance and benchmarking with InnoDB

Monday, July 6th, 2009 Posted in en_US, linux driver, mysql, performance, sugarcrm | No Comments »

Following my tests with DATETIME vs vs TIMESTAMP vs INT performance and benchmarking with MyISAM storage engine, I've wondered about the performance impact using InnoDB, which is usually more peaky ... Read more..

MySQL DATETIME vs TIMESTAMP vs INT performance and benchmarking with MyISAM

Monday, July 6th, 2009 Posted in en_US, mysql, performance | 9 Comments »

Recently there was a discussion about DATETIME vs TIMESTAMP vs INT performance and storage requirements. If one setup was bound to disk usage, one would expect INT to perform better, ... Read more..