List:General Discussion« Previous MessageNext Message »
From:ViSolve DB Team Date:January 25 2007 10:27am
Subject:Re: low-priority-updates and innodb tables
View as plain text  
hi,

AFAIK, if we start mysqld with --low-priority-updates, it sets table updation a lower
priority than the SELECT statements, irrespective of storage engines.

hence it will affect the priority of the update operation.
Ref: http://mysql.justdn.org/doc/refman/5.1/en/table-locking.html

----- Original Message ----- 
From: "Vitaliy Okulov" <vitaliy.okulov@stripped>
To: <mysql@stripped>
Sent: Monday, January 22, 2007 7:27 PM
Subject: low-priority-updates and innodb tables


> Здравствуйте, mysql.
> 
> Hi all.
> I want to ask about low-priority-updates and innodb tables. Does
> low-priority-updates=1 affect on priority of select or update query on
> innodb type tables?
> 
> -- 
> С уважением,
> Vitaliy                          mailto:vitaliy.okulov@stripped
> 
> 
> -- 
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:    http://lists.mysql.com/mysql?unsub=1
> 
>
Thread
low-priority-updates and innodb tablesVitaliy Okulov22 Jan
  • Re: low-priority-updates and innodb tablesViSolve DB Team25 Jan