From: Date: January 25 2007 10:27am
Subject: Re: low-priority-updates and innodb tables
List-Archive: http://lists.mysql.com/mysql/204615
Message-Id: <007401c74063$291aa320$3f0110ac@devco>
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="----=_NextPart_000_0071_01C74091.203E7C30"

------=_NextPart_000_0071_01C74091.203E7C30
Content-Type: text/plain;
	charset="windows-1251"
Content-Transfer-Encoding: quoted-printable

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 -----=20
From: "Vitaliy Okulov" <vitaliy.okulov@stripped>
To: <mysql@stripped>
Sent: Monday, January 22, 2007 7:27 PM
Subject: low-priority-updates and innodb tables


> =C7=E4=F0=E0=E2=F1=F2=E2=F3=E9=F2=E5, mysql.
>=20
> Hi all.
> I want to ask about low-priority-updates and innodb tables. Does
> low-priority-updates=3D1 affect on priority of select or update query =
on
> innodb type tables?
>=20
> --=20
> =D1 =F3=E2=E0=E6=E5=ED=E8=E5=EC,
> Vitaliy                          mailto:vitaliy.okulov@stripped
>=20
>=20
> --=20
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:    =
http://lists.mysql.com/mysql?unsub=3Dmysqlsupport@stripped
>=20
>
------=_NextPart_000_0071_01C74091.203E7C30--