Quoting Jeremy Zawodny <[EMAIL PROTECTED]>: > On Wed, Oct 15, 2003 at 09:37:29AM +0100, Gavin Foster IFP wrote: > > > > An example from just after restart (using myTop in 'm' mode showing > > number of queries executed each 1 second interval): > > Dan has your answer on this. I'm just amazed that anyone uses the 'm' > feature. I added it mostly as a debugging aid long ago. :-)
Wow! Jeremy Zawodny - I took my company's web server from an average server load of 6 to an average of 0.4 using your mysql optimisation lecture slides and mytop (having only experienced basic SQL server beforehand) Thank you! P.S. and yes the logging did tell me all I wanted to know - badly written database access code was to blame. --gav. > > Jeremy > -- > Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! > <[EMAIL PROTECTED]> | http://jeremy.zawodny.com/ > > MySQL 4.0.15-Yahoo-SMP: up 31 days, processed 1,183,695,572 queries (431/sec. avg) > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > > -- Gavin Foster IT Manager IFP http://www.french-property.com/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
