Oracle buys Sun Microsystems. It seems this company simply cann’t stop shopping… Peoplesoft, Siebel, InnoDB and now Java and MySQL.
If we call IBM a blue giant should we name Oracle a red one? Or may be a Red Devil?…
Not carrying about Java at all, I’m worried about the MySQL future a bit. I don’t want to see this great project dying. The market sees it different, however.
The first part of this post was devoted to the tools for SQL optimization in MySQL. Here I would like to stop at several database parameters which are relevant for MySQL performance.
There are at least three areas to take a look at: Thread Cache, Table Cache and Query Cache.
From the first month of my employment at SAP I was really impressed how the guys in support become crazy on SQL optimization. Deeply impressed on variety of tools for doing this on Oracle and DB2 I decided to carry out the same analysis on my own projects. The first question I’ve asked myself: “Do we have any native MySQL tools for sql optimization?”.
Yes, we do.