I suppose you're doing this on your workstation (Windows?)? Ideally,
Mysql should be on it's own machine - it (or any database) is designed
to suck up resources. Also, you definitely need to tweak the
configuration file. MySQL's default config is very anemic (annoying I
know) as opposed to Oracl
methinks you have other troubles. i've been running MySQL on K6II-266 for
a long time and its been running fine serving up several databases with
multiple users. 512MB of RAM currently but it had only 128 until
recently. Its running Linux (RedHat 7.2). I recently switched to 4.03,
but it had b
up the works. If you post your my.cnf file, someone here might be able
to rule out the former.
Edward Dudlik
Becoming Digital
www.becomingdigital.com
- Original Message -
From: "blackrat" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, 13 June, 2003 13:37
www.becomingdigital.com
- Original Message -
From: "blackrat" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, 13 June, 2003 13:37
Subject: Machine requirements
I've just started using mySql. I'm an experience programmer with SQL based
database, b
I think something is definitely wrong with your setup or your query. A
query for a count of the number of rows should be almost instantaneous.
How are your querying? You should be using:
select count(*) from tablename
Any other query that you filter on should have a index on the search
field. A
I've just started using mySql. I'm an experience programmer with SQL based
database, but know nothing about mySql. I'm setting up a single user
database to be accessed with some Perl programs, with one main table, which
will contain about 3 million lines. I'm running on an Athlon 1250 with
384m
