On Wed, Nov 06, 2002 at 12:28:00AM -0500, Murad Nayal wrote: > > thanks jeremy for the reply > > Jeremy Zawodny wrote: > > > > > > > > > > any idea why is it that the mysqld daemon is not using the CPUs and/or > > > why is this taking so long?? > > > > You might benefit from a larger key buffer. > > > > Can you show us the output of "vmstat 1" for 10 or 20 seconds? > > > > What would be an appropriate key_buffer_size.
Well, "as big as you can afford" while you're doing the massive index builds. How about 1GB? > other 'typical' operations I would need to perform are joins of say > 15-20 tables each about 1,000,000 rows or so. of course the plan is > to index all the join columns. the end result of the joins should be > the same size as an individual table. i.e. for each row of first > table there should be only one matching row of the second and so > on. should the key_buffer_size be roughly the size of all the index > files of these tables combined? If you can afford it, that'd be great. But it may not be practical either. > It seems that poor performance related to my earlier question was due to > disk io delays after all. IRIX has a 'sar' command that probably does > the same thing as vmstat. here is the output (half way through the index > building: the 50% idle is due to the second processer. > > 00:22:13 %usr %sys %intr %wio %idle %sbrk %wfs %wswp %wphy %wgsw > %wfif > 00:22:18 15 3 0 33 48 0 99 0 0 1 > 0 > 00:22:23 9 2 0 41 49 0 100 0 0 0 > 0 Yeah, I'm guessing that %wio means "percent of time waiting on I/O" or something close to that. -- Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! <[EMAIL PROTECTED]> | http://jeremy.zawodny.com/ MySQL 3.23.51: up 92 days, processed 1,932,691,988 queries (241/sec. avg) --------------------------------------------------------------------- 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
