August 22, 2008

MySQL End Of Life (EOL) Policy

Posted by peter |

We’ve discussed today how we should implement MySQL Version advisory in mk-audit tool. One obvious questions was to look at the end of life – it is often bad idea to run MySQL versions past end of life as even security bugs may not be fixed in these (though do not get paranoid, if you’re running MySQL in isolated environment the risk may be low).
So how does EOL schedule looks ?
[read more...]

Posted by peter @ 7:09 pm :: community, production :: 6 comments
Print This Post Print This Post book mark MySQL End Of Life (EOL) Policy in del.icio.usdel.icio.us :: submit MySQL End Of Life (EOL) Policy to digg.comdigg

Multiple column index vs multiple indexes

Posted by peter |

After my previous post there were questions raised about Index Merge on Multiple Indexes vs Two Column Index efficiency. I mentioned in most cases when query can use both of the ways using multiple column index would be faster but I also went ahead to do some benchmarks today.
[read more...]

Posted by peter @ 6:37 pm :: benchmarks :: 12 comments
Print This Post Print This Post book mark Multiple column index vs multiple indexes in del.icio.usdel.icio.us :: submit Multiple column index vs multiple indexes to digg.comdigg