Well, I'm still digging myself out of a pile of stuff to do. I haven't updated my MySQL page *yet*, but my presentations are available in HTML and PDF format.
Warning: they're still a bit rough, but I've had enough requests that I figured I should get something on-line for now. Lots of other stuff has taken priority for a bit. More on that later.
As always, they're better in person. You should have been at the conference. :-)
Posted by jzawodn at April 14, 2003 10:27 PM
In the optimization talk you state "use query cache if you must" do you mean that you should make every attempt to fix the query instead of just turning on the cache? Or are there some situations where using the query cache where the need is questionable will inversely impact performance.
Also you state that one thing to boost performance is to run the db on the same hardware as the application to reduce latency. This is what we are curently doing with replication and I'm debating moving the db's onto stand alone cluster. I'm curious if you have any opinions of the 2 setups and what you think of the tradeoffs when seperating the db from the application.
Excellent slideshows, I'll be digesting these for a while.
