Re: Really good idea on Performance Tuning???
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
Re: Really good idea on Performance Tuning???
At 03:02 PM 1/30/2002 , you wrote: At 12:22 PM 1/30/2002 -0600, you 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. I'd like to point out that I'm pretty sure you sent the reply to me directly - I don't think it ever reached this list. That probably explains the lack of bytes ;-) Yeah, I think that would account for it.bg It would also help avoid confusion of the inconsistent documentation. I don't mean to make any doc authors feel bad but there's something that don't match up on the InnoDB setup page. Exactly. There are too many places to find the tweaking documentation. In addition to the Performance Calculator page, there could be pages on manual tuning. I'd like to see the tuning docs in one location. Not just the ones from MySQL doc's or InnoDb, but from other sources as well. I do not know PHP but if there's some way I can help with this I'd be willing to try and pitch in. If there's at least one or 2 gurus out there would could answer questions one at a time, I could maybe start by making a list of what the page needs and what it should do for at least some of the values. If you'd like, I could write a static page with forms for the server-info to save some PHP coder at least that much time. What do you think? There are several steps to designing the MySQL Performance Calculator: 1) We should determine what input we need to collect and what output we need to produce (form design). We need to keep it simple for now then expand on it later. I definitely want to include InnoDb tuning too. 2) Once we have the form fields, someone can knock together the PHP form (me?), get it ratified among the participants. 3) Then do the underlying calculations for it and generate the output. 4) Once the calculations are done, we can distribute the PHP code within the group for people to test it. 5) When it is working satisfactorily we can post it up on a temporary site to see how it stands up. We will need someone to host it for a few weeks while we get the bugs out of it. 6) Once it passes scrutiny, then perhaps it can get posted on MySql.com. It all depends of course how good it is. If you would like to participate in choosing the form design, or calculations, testing, or temporary hosting, then please e-mail me directly. I don't think we'll get anywhere if we do it publicly because we'd get everything including the kitchen sink thrown into it.g We need to keep it simple to start with then build on it from there. Brent - 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
Really good idea on Performance Tuning???
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
Re: Really good idea on Performance Tuning???
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
RE: Really good idea on Performance Tuning???
I'd buy it! -steve -Original Message- From: BD [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 30, 2002 7:23 PM To: [EMAIL PROTECTED] Subject: Really good idea on Performance Tuning??? 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
Re: Really good idea on Performance Tuning???
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
Re: Really good idea on Performance Tuning???
At 12:22 PM 1/30/2002 -0600, you 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. I'd like to point out that I'm pretty sure you sent the reply to me directly - I don't think it ever reached this list. That probably explains the lack of bytes ;-) 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). Even the first part would help! 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. It would also help avoid confusion of the inconsistent documentation. I don't mean to make any doc authors feel bad but there's something that don't match up on the InnoDB setup page. 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. No kidding! Doubtless it would be worth it just to lower the noise level on the list. Ok, what do you think. Will this idea fly? I hope so :-) I do not know PHP but if there's some way I can help with this I'd be willing to try and pitch in. If there's at least one or 2 gurus out there would could answer questions one at a time, I could maybe start by making a list of what the page needs and what it should do for at least some of the values. If you'd like, I could write a static page with forms for the server-info to save some PHP coder at least that much time. What do you think? Brent Heikki, are you listening? :-) Presuming that Heikki is some authoritative soul, I'd like to repeat that question :-) Jonathan Wilson System Administrator Cedar Creek Software http://www.cedarcreeksoftware.com Central Texas IT http://www.centraltexasit.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
RE: Really good idea on Performance Tuning???
Hi Steve, On Thu, 2002-01-31 at 06:35, Steve Rapaport wrote: I'd buy it! That is possible too: - MySQL Training (http://www.mysql.com/training/) - MySQL Support (http://www.mysql.com/support/) - MySQL Consulting (http://www.mysql.com/consulting/) See, the manual and sample cnf files already contain some good general guidelines for tuning an installation. Of course, a little web calculator could make that basic stuff easier. Nice idea! However, it will never be a substitute for manual tuning. Good database performance more than simply the result of a calculation. It involves topics like: understanding how the MySQL Server processes a query, how the optimiser works, how/when indexes are used, how queries and tables should be designed for optimal performance. You can only get those things through: - A lot of practical experience with (My)SQL (long term). - Training (fast, gain the knowledge through investing in education). - Consulting (fast, personalised, gain (some) knowledge through investing). - Support (Have issues resolved quickly by paying someone else to do it, not necessarily gaining the knowledge for the future). Generally, when talking about optimising MySQL servers and applications, I'd go for training as a first choice: best return on investment for that particular case. Of course, support is very useful as insurance, since a setup is more than just tuning. It ensures expertise is at hand, so as to minimise down-time in case something happens. Regards, Arjen. -- Get MySQL Training Worldwide, http://www.mysql.com/training/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Arjen G. Lentz [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Technical Writer, Trainer /_/ /_/\_, /___/\___\_\___/ Brisbane, QLD Australia ___/ www.mysql.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
RE: Really good idea on Performance Tuning???
That is possible too: - MySQL Training (http://www.mysql.com/training/) - MySQL Support (http://www.mysql.com/support/) - MySQL Consulting (http://www.mysql.com/consulting/) However, it will never be a substitute for manual tuning. Good database performance more than simply the result of a calculation. It involves topics like: understanding how the MySQL Server processes a query, how the optimiser works, how/when indexes are used, how queries and tables should be designed for optimal performance. You can only get those things through: - A lot of practical experience with (My)SQL (long term). - Training (fast, gain the knowledge through investing in education). I will have to agree on this point right here. I recently completed a MySQL training course and not only have I got my server optimised to get the most out of the hardware, but have also optimised all my large tables with correct index usage, and large queries so they are running up to 200% faster than previously. - Consulting (fast, personalised, gain (some) knowledge through investing). - Support (Have issues resolved quickly by paying someone else to do it, not necessarily gaining the knowledge for the future). Generally, when talking about optimising MySQL servers and applications, I'd go for training as a first choice: best return on investment for that particular case. Absolutely. See above. Neil Silvester Webmaster Heat and Control Pty Ltd - 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