MySQL Forums
Forum List  »  Performance

Connection/Thread priorities
Posted by: Christian Reusch
Date: June 13, 2005 12:15PM

Hi,

I have a general question concerning multiple connections:

Connection 1: Program that makes updates to a table
every second (Server program)

Connection 2: Program that sends a large query to
MySQL-Server (Client program)

Problem: If query from a client (large query) is sent,
Updates on Connection 1 take a very long time, so that
server does not work properly anymore.

I thought, if a database server is multi-threaded, this
should not happen.

Regards, Chris

Options: ReplyQuote


Subject
Views
Written By
Posted
Connection/Thread priorities
2247
June 13, 2005 12:15PM


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.