MySQL Forums
Forum List  »  Source, Builds, Binaries

Advanced Search
New Topic

Re: No threads in mysql
Posted by: Bill Karwin
Date: October 02, 2006 11:35AM

MySQL server should be multi-threaded in all cases.

See http://dev.mysql.com/doc/refman/5.0/en/mysql-threads.html and http://dev.mysql.com/doc/internals/en/threads.html for some details about how MySQL uses threads.

Quote

Every client connection has its own thread ...

Based on other things I've read from MySQL engineers, there is no support for utilizing multiple threads for a single connection. Thus you don't gain a lot of benefit from SMP until you have multiple clients performing queries simultaneously.

Regards,
Bill K.

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Views
Written By
Posted
No threads in mysql
3113
Alvaro Marin
September 29, 2006 07:04AM
Re: No threads in mysql
1914
Bill Karwin
October 02, 2006 11:35AM
Re: No threads in mysql
1875
David Shrewsbury
October 03, 2006 08:51AM
Re: No threads in mysql
1957
Alvaro Marin
October 04, 2006 10:53AM
Re: No threads in mysql
1846
David Shrewsbury
October 04, 2006 11:20AM
Re: No threads in mysql
1783
Alvaro Marin
October 04, 2006 01:59PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.