To: "Scott Gerhardt" <[EMAIL PROTECTED]>
>From what I have heard from a local guru. you shoud double that
again. I had mysql working fine on 150 meg for development purposes,
but I was warned that as soon it had to support any kind of traffic,
anything less than 500 meg would be quickly maxed out.
Anybody else got feedback on this?
On 27 Jan 2001, at 12:46, Scott Gerhardt wrote:
> Adding another 192megs of ram or so would really boost performance.
> When I increased the RAM on my PIII 450Mhz from 128 to 256Mb,
> performance almost doubled for most queries on a 72k record table.
>
>
>
>
>
> > > From a mysqldump:
> > >
> > > #
> > > # Table structure for table 'names'
> > > #
> > > CREATE TABLE names (
> > > id int(10) unsigned DEFAULT '0' NOT NULL,
> > > name varchar(80) DEFAULT '' NOT NULL,
> > > KEY id (id)
> > > );
> > >
> > > The machine is an Intel Celeron 533Mhz, with 64 mb of RAM, with
> > > dual
> > 10
> > > GB EIDE hard drives (doing RAID), running FreeBSD 3.4-Release.
> > >
> > >
> > >
> > > Artem Koutchine wrote:
> > >
> > > > Well then, be so kind and tell us your index configuration
> > > > and your hardware configuration.
> > > >
> > > > ----- Original Message -----
> > > > From: "Manuel Capinha" <[EMAIL PROTECTED]>
> > > > To: <[EMAIL PROTECTED]>
> > > > Sent: Saturday, January 27, 2001 9:10 PM
> > > > Subject: 3 million+ records problems.
> > > >
> > > > > Hi!
> > > > >
> > > > > I've got a table with 3 million+ records. This table has only
> > > > > to columns: an int and a varchar(80).
> > > > >
> > > > > I need to periodically execute a statement like: "SELECT
> > id,count(*)
> > > > > FROM names GROUP bY id", which takes very long time to end.
> > > > >
> > > > > I'm using perl (DBI) to access this table. When I do a select
> > > > > by
> > id
> > > > > (SELECT name FROM names WHERE id=1) it hangs forever for very
> > large
> > > > > results (>1million).
> > > > >
> > > > > I'm running mysql 3.22.29 on FreeBSD 3.4. Would an upgrade to
> > the
> > > > latest
> > > > > 3.23 help ? Would an upgrade to FreeBSD 4 or maybe Linux help
> > > > > ? The id column is indexed, but i believe this is A Good
> > Thing(tm).
> > > > >
> > > > > I've checked past messages of this mailing list and i couldn't
> > find
> > > > > anything that seemed relevant to my case. Can anyone give me
> > some
> > > > > suggestions to speed things up ?
> > > > >
> > > > > Thanks in advance.
> > > > >
> > > > > Manuel Capinha,
> > > > > who as just seen his weekend ruined.
> > > > >
> > > > >
> > > >
> > > ------------------------------------------------------------------
> > > --
> > > > -
> > > > > 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
> >
> >
>
>
> ---------------------------------------------------------------------
> 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
>
John Jensen
520 Goshawk Court
Bakersfield, CA 93309
---------------------------------------------------------------------
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
