April 28, 2010

MySQL performance on ZFS filesystem

A 52mn presentation by Allan Packer and Neelakanth Nadgir from Sun Microsystems. ** keep in mind ZFS can only be used in userspace on linux (through fuse) due to license comptability issue (GPL/BSD license) enjoy! httpv://www.youtube.com/watch?v=a31NhwzlAxs

October 6, 2008

MySQL Select Optimization line

Weather used in php or any other scripting language… sometimes we have the need to query a database in order to fetch or manipulate certain data. One of the most common request, widely written and used is SELECT * FROM MyTable WHERE ID='ValueX' and NAME='ValueY'; now, ID and NAME are just columns… so nothing special However.. how could someone optimize that line of code? Fact is, lots of coders out there, do not realize how unoptimize this line could be and the different problems it could generate. ... Read more