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.

  • Managing MySQL Replication (HTML and PDF)
  • MySQL Optimization (HTML and PDF)

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

Reader Comments
# Jeff Bearer said:

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.

on April 15, 2003 07:29 AM
Disclaimer: The opinions expressed here are mine and mine alone. My current, past, or previous employers are not responsible for what I write here, the comments left by others, or the photos I may share. If you have questions, please contact me. Also, I am not a journalist or reporter. Don't "pitch" me.

 

Privacy: I do not share or publish the email addresses or IP addresses of anyone posting a comment here without consent. However, I do reserve the right to remove comments that are spammy, off-topic, or otherwise unsuitable based on my comment policy. In a few cases, I may leave spammy comments but remove any URLs they contain.