MySQL Presentations: Optimizing MySQL http://dev.mysql.com/tech-resources/presentations/presentation-oscon2000-20000719/index.html The content from the link above has been very practical and useful to me personally. ---------------------------------- Vel Pillai Web Developer On 1/19/07, Max Schwanekamp <lists at neptunewebworks.com> wrote: > > Sarah Adams wrote: > > Probably the first thing you should look into is implementing indexes > > where appropriate > > Thanks for the links. We do use indexes; I'm looking to deepen my > understanding of best practices specifically for MySQL. > > Hassan Schroeder wrote: > > To identify problem queries, you can monitor this: > > <http://dev.mysql.com/doc/refman/4.1/en/slow-query-log.html> > > > > And it might be worth while to invest in the "High Performanec MySQL" > > book (O'Reilly) -- > > I had forgotten about the Slow Query Log. Thanks for the book > recommendation especially. There are so many MySQL resources that > (aside from the docs) it's good to know what others would recommend. > > Thank you! > > -- > Max Schwanekamp > NeptuneWebworks.com > 541-255-2171 > > -- > > * * Please support the community that supports you. * * > http://evolt.org/help_support_evolt/ > > For unsubscribe and other options, including the Tip Harvester > and archives of thelist go to: http://lists.evolt.org > Workers of the Web, evolt ! >