Logstash JDBC plugin: MySQL SET TRANSACTION ISOLATION LEVEL


(Gianfranco) #1

Hello,

I need to perform a query on a MySQL database.
The table is very heavy and so the best way to query it is to write something like:

SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED;
SELECT * FROM MYTABLE where ID > :sql_last_value LIMIT 5000;
COMMIT;

Since this is not a single statement, I cannot use it on the statement field.

How can I manage that?

Many thanks