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..
Wednesday, August 26th, 2009 Posted in mysql, pt_PT | No Comments »
Lembrei-me de partilhar um teste que fiz há tempos. O que se pretendia era demonstrar que podemos percorrer uma tabela MyISAM (e só neste caso específico) de forma controlada (ie, ... Read more..
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..
Thursday, August 20th, 2009 Posted in en_US, mysql, performance | 4 Comments »
I was trying to determine if the storage size of a VARCHAR field in MySQL had any fixed influence in the key size. I've created a few tables, but an ... Read more..