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

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

VARCHAR index size in InnoDB

Saturday, August 22nd, 2009 Posted in en_US, mysql, performance | No Comments »

Although my previous conclusions about VARCHAR influence on index size could be quite storage engine specific, I'd like to see if we can extend them to InnoDB, so I took ... 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..