I have question about mysqld theading. I understand that mysqld will have one thread per connection, is that right??
If thru, Can I assign higher priority to perticular thread/connection/client ? for example , If we have two clients connected to mysqld using Thread A and Thread B. ( they are using same DB same TABLE). I want to give higher priority to Thread A then Thread B. By higher priority I mean if Thread B is doing something( select/update/insert or anything), and if there is some request on Thread A then it should preempt the Thread B and it should get executed first, after Thread A releses resourse Thread B should continue from where it was left. I am NOT looking for SELECT over UPDATE priority Second Question. When I use "--low-priority-updates", Will it have priority between threads? for example, if Thread B is doing UPDATE and Thread A want to do SELECT, will Thread A get priority over Thread B? Will it preempt Thread B? Thanks Naushit. Note: I am not subcribed to Mysql list , plase cc your reply to me . --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
