Re: Performance problem with more than 500 concurrent queries

Hello, Thanks for you help. You can see the results in the .err file below. I've run it twice while the algorithm was running, but my knowledge in MySQL is still too poor to identify any problem here. Beside these locks that I do not know what they are. This is the third release of the

Re: Performance problem with more than 500 concurrent queries

Hi, Thanks for your suggestion. It looks like had a minor effect. I see sometimes 4 or 5 queries running. But it is not much different in general. Regards, Guillermo From: jocelyn fournier [EMAIL PROTECTED] To: [EMAIL PROTECTED] Cc: mysql@lists.mysql.com Date: 27.06.2008 12:41 Subject:

Performance problem with more than 500 concurrent queries

Hello guys, I am new to this list and also kind of new to mysql too. I have a multi-thread application written in Ruby. The application is reading one table that has two columns (Father, Children). As you might suspect, this is a tree. The fields are foreign keys to a second table, but the

Re: Performance problem with more than 500 concurrent queries

Hello, thanks for the answer. Where is the error.log stored? I run the mysqladmin, it requires the password and it exits immediately. But I cannot find any error.log. Thanks, Guillermo --- Guillermo Acilu Senior Engineer, Koiaka GmbH Koiaka GmbH Riesserkopfstr. 17 82467 Garmisch

Re: Performance problem with more than 500 concurrent queries

run the mysqladmin, it requires the password and it exits immediately. But I cannot find any error.log. Thanks, Guillermo --- Guillermo Acilu Senior Engineer, Koiaka GmbH Koiaka GmbH Riesserkopfstr. 17 82467 Garmisch-Partenkirchen Tel: +49 (0)8821 9679555 Fax: +49 (0)8821 730 9185 Mailto