When the MySQL server receives a SELECT query, the query goes through several consecutive phases:
This is “A new dimension to MySQL query optimizations – part 2”. If you didn’t read part 1 already I suggest you skim through it before reading on.
To summarize, the problem at hand is this: Given a query with a join between two or more tables, the MySQL optimizer’s mission is to find the best combination of join order and access method so that the response time becomes as low as possible.…
I think most people will agree that downloading RPMs from a website is kind of old fashioned when there are yum repos. After a number of user requests, we have now launched the official yum repos for MySQL.
Can’t wait?…
On Tuesday Sept.10 I went to PHP TechTalks with Rasmus Lerdorf, Sebastian Bergmann, and Stig Bakken. Great initiative by Stig Bakken @ Zedge. The TechTalks focused on new features and best practices and for PHP 5.4 and 5.5.
Great feeling of going to the roots of LAMP and MySQL.…