SEO
vBulletin Search Engine Optimization
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
02-28-2008, 05:39 AM
| ||||
| ||||
 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@gmail.com      |
|
02-28-2008, 05:40 AM
| ||||
| ||||
| Re: low-priority-updates and innodb tables 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...e-locking.html ----- Original Message ----- From: "Vitaliy Okulov" <vitaliy.okulov@gmail.com> 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:vitaliy.okulov@gmail.com > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/mysql?unsub=m...rt@visolve.com > > |
Linear Mode
