SQLPlex | Database technology community - 5 Recently Added Articles http://www.sqlplex.com This RSS Feed contains 5 recently added articles to the knowledge base. You can click on the title to view its content. Knowledge Base (http://www.sqlplex.com) http://www.sqlplex.com/article-386.html Get MySQL on Sun Systems http://www.sqlplex.com/article-386.html MySQL is a natural fit for Sun's award-winning Sun Fire x64 servers or SPARC Enterprise servers with CoolThreads technology. Sun's modular storage systems provide effective, efficient data storage]]> http://www.sqlplex.com/article-385.html New Release of MySQL 6.0.6 http://www.sqlplex.com/article-385.html MySQL 6.0.6-alpha, a new version of the MySQL database system has been released. MySQL 6.0 includes two new storage engines: the transactional Falcon engine, and the crash-safe Maria engine.

The Maria storage engi]]> http://www.sqlplex.com/article-384.html Multiple column index vs multiple indexes http://www.sqlplex.com/article-384.html After my previous post there were questions raised about Index Merge on Multiple Inde]]> http://www.sqlplex.com/article-383.html 101 Reasons Why PostgreSQL is a better fit for Rails than MySQL http://www.sqlplex.com/article-383.html
MySQL cannot utilize more than one index per query. I believe this is worth repeating: MySQL CANNOT UTILIZE MORE THAN ONE INDEX PER QUERY. Wait till your tables get large enough and this will surely ]]> http://www.sqlplex.com/article-382.html New partitioning features http://www.sqlplex.com/article-382.html feature that partitioning makes possible. So I thought
it might be a good idea to mention a little bit what
we're doing in the area of partitioning.