Hello.
On Wed 2002-12-25 at 20:06:22 -0800, [EMAIL PROTECTED] wrote:
> My company is currently upgrade our company'database from PICK, an
> old database system to mysql..
>
> Our company database got 1 table where the record is more than 40
> million records, and the other table also got about i million record
> each..
>
> what i found is i only can use the simple sql query to select the
> data from database and can't use the query like left join,equi-join
> and even a global variable also can make our server(2G RAM, 40G
> hardisk, Pentium 4) take a long time to respond..maybe this is a
> limitation of mysql i think..can't store such huge data..
No, 40 million records is no particular problem for MySQL. Most
probably some indexes are missing.
You need to be far more specific.
Which version of MySQL do you use? (SELECT VERSION())
Which OS do you use? Which version?
What is (one of) the slow query(ies)?
What shows EXPLAIN for that query?
What does "a long time" mean, in seconds?
And so on. Provide anything else you think could matter.
Please post the result of SHOW TABLE STATUS and SHOW CREATE TABLE for
the relevant tables.
HTH,
Benjamin.
--
[EMAIL PROTECTED]
---------------------------------------------------------------------
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
