On Mon, Jun 21, 2004 at 07:37:50PM +0200, Leonardo Francalanci wrote:
> > Oh. You didn't say thta. :-)
>
> Well, I wrote
> " Doing a simple "SELECT SUM(MYFIELD) FROM MYTABLE" I noticed "
> but don't worry ;)
Oh. Damned Mondays. I never liked 'em. :-(
> > How much RAM does your machine have? If it's nearly all cached,
> > you'll be CPU bound rather than disk bound.
>
> 1Gb.
>
> I'm using Solaris 8.
>
> The SUM() works as expected now (disks works a lot), but accessing by key
> is very cpu-intense and still 0% work on disk.
>
> To sum up: table scans are very disk-intense (which make sense),
> accessing by key leaves disk on idle (I see that it should not work
> as with a table scan, but at least a little!)
Hmm.
--
Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo!
<Jeremy@stripped> | http://jeremy.zawodny.com/
[book] High Performance MySQL -- http://highperformancemysql.com/
