At 02:38 PM 1/30/2002 , you wrote: >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?
I would first rely on Heikki's suggestions and the MySQL Doc's as a starting point to create the initial PHP script. Then pass it around to a few knowledgeable MySQL people and they can run it on their machines to see how accurate it is. The PHP code will be open source so it will keep getting "refined" over the next few weeks. Eventually it will be posted on a website (MySQL? or InnoDb?) for everyone to try out. It will of course display a disclaimer saying this is what you should start with and further refinements may be necessary. But I think this will be a start in the right direction. It will get more an more accurate as time goes on and will give novice users something to start with. Brent >--- 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 --------------------------------------------------------------------- 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
