SQL Select with nolock keyword

MySQL & MariaDB Other MySQL® Questions
1

Hi All

I have created a Percona Slave (version 5.1.61-rel13.2) for a MySQL Community Server (5.1.61-log)…

The problem is with the nolock keyword in the select statement and the SLAVE fails at the query. Manuall running the query also fails on the PErcona Slave…

I wanted to upgrade the master to PErcona, but because of this, I might be forced to install MySQL community edition on the slave…

Query output on both servers ==>

On Master (MySQL Community Edition) - mysql> select catid,status from table1 nolock where status=1;
±--------±-----+
| catid | status |
±--------±-----+
| 101 | 1 |
| 102 | 1 |
| 103 | 1 |
| 104 | 1 |
| 105 | 1 |
| 106 | 1 |
±--------±-----+
6 rows in set (0.00 sec)

On Slave (PErcona) ==> mysql> select catid,status from table1 nolock where status=1;

ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'nolock where status=1

=============

Please help…

2

Not sure about the MySQL support for the keywork or declaration WITH NOLOCK. BTW you can try to work with isolation Modes, interchanging between REPEATABLE_READ and READ_UNCOMMITED or even add the IN SHARE MODE to your queries.

=> [url]https://dev.mysql.com/doc/refman/5.6/en/innodb-consistent-read.html[/url]
=> [url]https://dev.mysql.com/doc/refman/5.6/en/innodb-locking-reads.html[/url]
=> [url]http://www.percona.com/blog/2006/08/06/select-lock-in-share-mode-and-for-update/[/url]

3

== [URL]http://www.solitaire-champ.com/[/URL] ==