"weheh" <weheh@yahoo.com> writes:

> I have a mysql-based dynamic web app that's slowing down at an unacceptable
> rate as my numbers of users climbs. Can anyone help me figure out how to
> tune the database so that it runs faster? I've looked at the my.ini file
> (I'm on windows server) and beefed up most of the numbers, but don't see any
> change after rebooting my server. I'm relatively experienced at creating
> mysql DBs, but a relative newbie when it comes to administering mysql -- so
> I don't really know where to start. I have already tuned the application to
> minimize the number of calls to the database, so that base is covered.
> Thanks for helping out.

If you have not already done so, turn on query caching in the
my.ini (documentation has details). Also, make sure you have indexes,
and to the greatest extent possible make sure all your rows are fixed
length (that will help a lot with searches and indexing) -- that means
no 'varchar' fields. We have found it is sometimes better to just
declare the field extra big, instead of saving some space with varchar.

If you have long 'essay' type fields, put them in another table.

Make sure you periodically run the optimize commands -- that should
all help!

--
John
__________________________________________________ _________________
John Murtari Software Workshop Inc.
jmurtari@following domain 315.635-1968(x-211) "TheBook.Com" (TM)
http://thebook.com/