Re: a mysql question - Niclas Hedhman - com.mysql.lists.mysql

4 messages in com.mysql.lists.mysqlRe: a mysql question

From	Sent On	Attachments
笛短	16 Oct 2002 22:36
Niclas Hedhman	16 Oct 2002 23:03
Alan McDonald	16 Oct 2002 23:34
Dicky Wahyu Purnomo	16 Oct 2002 23:48

Subject:	Re: a mysql question
From:	Niclas Hedhman (nic...@ewarna.com)
Date:	10/16/2002 11:03:39 PM
List:	com.mysql.lists.mysql

Sorry, but it is hard to understand what you are actually asking, but I'll try.

If you are returning too large resultset, it is possibly a JDBC driver problem, since it will retrieve all into Java objects, which could take "forever".

If you know your SELECT statement, just issue it in the mysql client, and you will know the number of records returned as well as how long it takes.

But I think you are trying to say something about multi-threading on connections. If I am not mistaken, you are not allowed to re-use the same connection with more than one query at a time. You either need an exclusion mechanism or a connection pool to distribute available connections among "users", i.e. different threads.

Niclas

On Thursday 17 October 2002 13:36, 笛短 wrote:

I'm a chinese software engineer, and I has use mysql for three years ago.Now,I get a matter from it. recently,I'm deal big data use mysql first.every table's data is one million,so user search the data will use long time.now ,if some user search one table togeter,the table is dead , and I find the connection to the mysql cann't close,my God,I only restart it.

my develop language is JAVA.But I can't think the error is in JAVA code.my question is wheather mysql can't support a lot of connection search one table together?

I want get a help or an advance for you ,thanks.

To request this thread, e-mail <mysq...@lists.mysql.com> To unsubscribe, e-mail <mysql-unsubscribe-niclas=ewar...@lists.mysql.com> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php