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
