MySQL Archive

PostegreSQL Deserves NoSQL Fan Respect

PostegreSQL is a plain old SQL database, very powerful and very consistent. In some case, project needs an ACID database, but schemaless.. With JSON support, PostegreSQL is a very interesting tool to provide ACID and some very

Resolving MySQL Problems Quickly

Troubleshooting MySQL problems doesn’t need to involve trial-and-error and it doesn’t need to take a long time. You need only two things: a good process and good tools. This session shows you an approach that the speaker

Herding Sphinxes in Search

Sphinx is an open-source search tool that can also do other magic. Blazing full-scans, easy multi-core and multi-box queries, and wicked fast math spring to mind. When the queries are right, 1-billion-pageview sites switch from MySQL to

Online Operations and Improved Diagnostics for MySQL 5.6

MySQL 5.6 was released in February 2013. It is the largest release of MySQL in history (measured by code size increase) and contains a number of very useful enhancements to replication, performance and security. What I want

Practical MySQL Performance Optimization

This presentation discusses how to get great MySQL performance while being practical – spending time on what gives you the best return. It covers the main areas for improving MySQL performance, pointing out the most important things