Archive for July, 2009

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..

Este fim de semana…

Monday, July 13th, 2009 Posted in lazer, mysql, programming, pt_PT, scaling | 1 Comment »

Desta vez, num capítulo mais pessoal, os planos do fim-de-semana saíram furados. A minha opinião, que nem sequer me dei ao trabalho de me informar muito, é que espero bem ... Read more..

Sobre o ZFS

Saturday, July 11th, 2009 Posted in filesystems, pt_PT, solaris | No Comments »

Tão cedo comecei a experimentar e a afinar o parzinho sensação (ZFS and MySQL), fui logo procurar se já alguém tinha começado alguma implementação de ZFS em/para Linux [tal e ... Read more..

Syntax Highlighting nos blogs da DRI

Thursday, July 9th, 2009 Posted in dri, pt_PT | No Comments »

Não é à toa que toda a gente gosta do arco-íris - se uma imagem vale mil palavras, ler código a cores deve valer umas boas 900. Depois de montar ... 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..

Analysing MySQL slow queries

Saturday, July 4th, 2009 Posted in en_US, mysql, performance | No Comments »

While I'm engaged in my MySQL DBA mode, I usually come across the hard task of surfing around the slow query log. Everybody trying to trace MySQL performance problems will hit ... Read more..