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" <[EMAIL PROTECTED]> To: <mysql@lists.mysql.com> 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:[EMAIL PROTECTED] > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > >