(Ronald) I am of the attitude, the day you stop learning something is the day you die. I’m not prepared to induce MySQL into both sides of that equation, however some days it never ceases to amaze me what little thing I didn’t know about MySQL.
Tag: Open Source
Preparing for MySQL 5.x Certification
(Mark Schoonover) You’ve decided to obtain MySQL certification and that’s great! Now it’s a matter of how to go about it? You can go the traditional routes and take a class, or you can prepare on your own. I did the latter, and 2 exams later during MySQL Conference 2007, I passed the Certified MySQL
Error Handling Examples
(Guy Harrison and Steven Feuerstein) In this second article in a three-part series, you will learn more about errors and exception handlers.
What would make MySQL Multiple Queries Usable?
(Peter Zaitsev) MySQL Has API to run Multiple Queries at once. This feature was designed mainly with saving network round trip in mind and got a little traction due to associated security risks and not significant gains in most cases.
Error Handling
(Guy Harrison and Steven Feuerstein) In this first article in a three-part series, you will learn how to create various types of exception handlers.
How MySQL executes ORDER BY
(Sergey Petrunia) In last couple of weeks there has been a tide of ORDER/GROUP BY-related optimization bugs, where I was the fixer or the reviewer. This wasn’t an easy job because there is no sane description of how GROUP BY/ORDER BY handling is supposed to work.
To SQL_CALC_FOUND_ROWS or not to SQL_CALC_FOUND_ROWS?
(Alexey Kovyrin) When we optimize clients’ SQL queries I pretty often see a queries with SQL_CALC_FOUND_ROWS option used. Many people think, that it is faster to use this option than run two separate queries: one – to get a result set, another – to count total number of rows. In this post I’ll try t
Out with cluster, hello replication
(Brian Moon) Well, I have written a good bit about MySQL Cluster this year. We had been using it as a sort of pregenerated cache for our forward facing web servers. However, we have decided on a different route.
Do you always need index on WHERE column?
(Vadim Tkachenko) I believe we wrote about this before, but this topic popups again and again.
MySQL Proxy: Tracking Parallel Queries
(Jan Kneschke) In the Enterprise Team we had the need to track how many connections to the MySQL server in parallel. By “used” I mean running queries and not just idling around.
