What is the best source of information about performance tuning MySQL? I saw that Jeremy's proposed book was to include a lot of coverage on this topic -- are there other sources? Is the online doc the best place so far?
--- Mike Wexler <[EMAIL PROTECTED]> wrote: > I don't think this will work. The setting depend on > a lot more variables then > you list. For example the mix of queries to updates. > Although what you are > suggesting might make a first approximation. > Maybe a field where you could copy and paste the > output of show status would > help to alleviate the problems and get us to at > least a second approximation. > > I agree that some kind of automation here would be > desirable. > > > BD wrote: > > > I sent a reply back to JW about his problem on > performance tuning and > > came up with I thought a really good idea. But > there weren't any bites > > so I thought I start it on a new thread. > > > > There are a lot of threads about setting up MySQL > for the best > > performance. This might help to solve the > problem. > > > > What I'd like to see is a web page that has a > MySQL/InnoDb configuration > > calculator where you simply enter the specifics of > your hardware (like > > amount of RAM, # processors), # of connections, > operating system, and > > database size, and it would tell you how best to > configure the cnf > > file. In fact, it could also generate the lines > for the .cnf file so > > you can just copy and paste it into your own file > (this avoids typing > > mistakes too). The web page could be hosted on > MySQL or InnoDb web site. > > That way it would also be accessible from the > client's office too. > > > > This would at least provide the novice user with a > setup configuration > > that is more accurate than he could achieve by pen > and paper the first > > time out. The web page could be written in PHP and > is easy enough to > > implement and the benefits would be enormous when > you consider the # of > > MySQL sites out there that could use it. > > > > Ok, what do you think. Will this idea fly? > > > > Brent > > > > Heikki, are you listening? :-) > > > > > > > > > --------------------------------------------------------------------- > > Before posting, please check: > > http://www.mysql.com/manual.php (the manual) > > http://lists.mysql.com/ (the list > archive) > > > > To request this thread, e-mail > <[EMAIL PROTECTED]> > > To unsubscribe, e-mail > <[EMAIL PROTECTED]> > > Trouble unsubscribing? Try: > http://lists.mysql.com/php/unsubscribe.php > > > > --------------------------------------------------------------------- > Before posting, please check: > http://www.mysql.com/manual.php (the manual) > http://lists.mysql.com/ (the list > archive) > > To request this thread, e-mail > <[EMAIL PROTECTED]> > To unsubscribe, e-mail > <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: > http://lists.mysql.com/php/unsubscribe.php > __________________________________________________ Do You Yahoo!? Great stuff seeking new owners in Yahoo! Auctions! http://auctions.yahoo.com --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php