Logstash JDBC plugin: MySQL SET TRANSACTION ISOLATION LEVEL

Elastic Stack Logstash
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

2

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.