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
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 woul
On Tue, Nov 05, 2002 at 08:18:57PM -0500, Murad Nayal wrote:
>
>
> Hello,
>
> I am struggling trying to optimize the performance of mysql over rather
> large databases. for now there is one issue I don't understand and I am
> wondering if anybody can help with any hints.
>
> I am trying to cre
Hello,
I am struggling trying to optimize the performance of mysql over rather
large databases. for now there is one issue I don't understand and I am
wondering if anybody can help with any hints.
I am trying to create an index for a large table (100,000,000 rows). the
index is for a column of
