Hello.
Check that MySQL doesn't hang, and that your system doesn't swap. You can connect to MySQL server and check with 'SHOW PROCESSLIST' states of MySQL threads. See: http://dev.mysql.com/doc/mysql/en/show-processlist.html Juan Pablo Espino <[EMAIL PROTECTED]> wrote: > Hello all! > > I have two tables in my database: results(20 000 rows) and > data_lab1(3 000 rows) Both are related by a sample number (sample_id.) > I need to find the samples of data_lab1 table that they are not in > results table. > > I think the following query is the solution: > > SELECT data_lab1.sample_id, results.sample_id > FROM data_lab1 > LEFT JOIN results ON results.sample_id =3D data_lab1.sample_id > WHERE results.sample_id IS NULL=20 > > But 15 minutes later, it does not return any results and then I stop > it. I don't have a lot of experience with MySQL. My system is: > > PC: Pentium 3, 900 MHz, 512 MB-RAM > White Box Linux 3 > MySQL v4.0 > > Something wrong with the query?, another idea?, thanks in advance for > any suggestion, regards > > Juan P. Espino > -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
