Are you sure that your select is in fact using the index on that column? Could
you please explain select for us.
John Jensen wrote:
> 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
---------------------------------------------------------------------
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
