Any Mysql gurus in the house?

Comments

1. rayg (1 comments.) says:

   1/24/2005 at 7:52 pm

   check your thread cache setting. see jeremy’s post: http://jeremy.zawodny.com/blog.....00173.html
2. Mark says:

   1/24/2005 at 8:50 pm

   Turned up the thread cache size. Time will tell. Thanks Ray, I will post an update soon.
3. Matt (64 comments.) says:

   1/24/2005 at 10:47 pm

   High Performance MySQL, also by Zawodny, is a fantastic book that helped me with some issues we ran into with scaling Ping-O-Matic.
4. Mark says:

   1/25/2005 at 9:34 am

   The difference with the cache is small. I will have to keep looking. I might just buy the book since I know it will come in handy sometime.
5. Matt (64 comments.) says:

   1/25/2005 at 5:29 pm

   You’ll probably get the most benefit from optimizing the indicies and queries, at least that’s what I’ve found. If you can make the row length fixed that helps too.