Demo and Lab activities for the workshop false false true Select 1 5000 central jdbc:postgresql://127.0.0.1:26257/serial?autoReconnect=true&sslmode=disable&ssl=false&ApplicationName=Demo1 org.postgresql.Driver true 6 10000 TRANSACTION_SERIALIZABLE 60000 root false false saveConfig true true true true true true true true true false true true false false false true false false false true 0 true true true true true true false saveConfig true true true true true true true true true false true true false false false true false false false true 0 true true true true true true true log false saveConfig true true true true true true true true true false true true false false false true false false false true 0 true true true true true false saveConfig true true true true true true true true true false true true false false false true false false false true 0 true true true true true true false saveConfig true true true true true true true true true false true true false false false true false false false true 0 true true true true true true 500 false false false false saveConfig true true true true true true true true true false true true false false false true false false false true 0 true true true true true true 500 false false false true false saveConfig true true true true true true true true true false true true false false false true false false false true 0 true true true true true true 500 false false false continue false -1 5 1 true ${__P(duration,120)} true central Callable Statement BEGIN; SET TRANSACTION PRIORITY HIGH; SELECT * FROM alerts WHERE customer_id=9743; COMMIT; Store as String allowedThroughputSurplus 1.0 0.0 3 0 100 10000 0 throughput 10000.0 0.0 100 central Callable Statement BEGIN; SET TRANSACTION PRIORITY LOW; SELECT * FROM alerts WHERE customer_id=9743; COMMIT; Store as String allowedThroughputSurplus 1.0 0.0 3 0 100 10000 0 throughput 10000.0 0.0 100 central Callable Statement BEGIN; SELECT * FROM alerts WHERE customer_id=9743; COMMIT; --SELECT * FROM alerts --WHERE customer_id=${__Random(1000,1009)} Store as String allowedThroughputSurplus 1.0 0.0 3 0 100 10000 0 throughput 10000.0 0.0 100 central Callable Statement SELECT * FROM alerts WHERE customer_id=9743; --SELECT * FROM alerts --WHERE customer_id=${__Random(1000,1009)} Store as String allowedThroughputSurplus 1.0 0.0 3 0 100 10000 0 throughput 10000.0 0.0 100 central Callable Statement SELECT * FROM alerts as of system time experimental_follower_read_timestamp() WHERE customer_id=9743; Store as String allowedThroughputSurplus 1.0 0.0 3 0 100 10000 0 throughput 10000.0 0.0 100 central Callable Statement SELECT * FROM alerts WHERE customer_id=9800; Store as String allowedThroughputSurplus 1.0 0.0 3 0 100 10000 0 throughput 10000.0 0.0 100 central Callable Statement BEGIN; SET TRANSACTION PRIORITY LOW; UPDATE alerts SET cstatus=cstatus, updated_at=now() WHERE customer_id=9743; --SELECT pg_sleep(0.1); --SELECT pg_sleep(5); COMMIT; Store as String allowedThroughputSurplus 1.0 0.0 3 0 100 10000 0 throughput 2000.0 0.0 100 central Callable Statement BEGIN; SET TRANSACTION PRIORITY HIGH; UPDATE alerts SET cstatus=cstatus, updated_at=now() WHERE customer_id=9743; --SELECT pg_sleep(0.1); --SELECT pg_sleep(5); COMMIT; Store as String allowedThroughputSurplus 1.0 0.0 3 0 100 10000 0 throughput 2000.0 0.0 100 continue false -1 6 1 true ${__P(duration,60)} true central Callable Statement SELECT * FROM alerts WHERE customer_id=9743; --SELECT * FROM alerts --WHERE customer_id=${__Random(1000,1009)} Store as String allowedThroughputSurplus 1.0 0.0 3 0 100 10000 0 throughput 10000.0 0.0 100 central Callable Statement BEGIN; SET TRANSACTION PRIORITY HIGH; UPDATE alerts SET cstatus=cstatus, updated_at=now() WHERE severity=${__Random(0,10)} LIMIT 100; COMMIT; Store as String allowedThroughputSurplus 1.0 0.0 3 0 100 10000 0 throughput 2000.0 0.0 100 central Callable Statement BEGIN; SET TRANSACTION PRIORITY HIGH; UPDATE alerts SET cstatus=cstatus, updated_at=now() WHERE severity=${__Random(0,10)} LIMIT 1000; COMMIT; Store as String allowedThroughputSurplus 1.0 0.0 3 0 100 10000 0 throughput 2000.0 0.0 100 central Callable Statement BEGIN; SET TRANSACTION PRIORITY HIGH; UPDATE alerts SET cstatus=cstatus, updated_at=now() WHERE severity=${__Random(0,10)} LIMIT 5000; COMMIT; Store as String allowedThroughputSurplus 1.0 0.0 3 0 100 10000 0 throughput 2000.0 0.0 100 central Callable Statement BEGIN; SET TRANSACTION PRIORITY HIGH; UPDATE alerts SET cstatus=cstatus, updated_at=now() WHERE severity=${__Random(0,10)} LIMIT 10000; COMMIT; Store as String allowedThroughputSurplus 1.0 0.0 3 0 100 10000 0 throughput 2000.0 0.0 100 continue false -1 3 1 true ${__P(duration,120)} true USE CLI to demonstrate Retries ::: Run with update_low and update_high to get two differnt retry errors central Callable Statement BEGIN; SET TRANSACTION PRIORITY HIGH; UPDATE alerts SET cstatus=cstatus, updated_at=now() WHERE customer_id=9743; --SELECT pg_sleep(0.1); --SELECT pg_sleep(5); COMMIT; Store as String allowedThroughputSurplus 1.0 0.0 3 0 100 10000 0 throughput 2000.0 0.0 100 central Callable Statement BEGIN; SET TRANSACTION PRIORITY LOW; UPDATE alerts SET cstatus=cstatus, updated_at=now() WHERE customer_id=9743; --SELECT pg_sleep(0.1); --SELECT pg_sleep(5); COMMIT; Store as String allowedThroughputSurplus 1.0 0.0 3 0 100 10000 0 throughput 2000.0 0.0 100 continue false -1 3 1 true ${__P(duration,60)} true set cluster setting sql.defaults.implicit_select_for_update.enabled=true/false and run with the two differnt updates central Callable Statement -- Must configure the following: -- set cluster setting sql.defaults.implicit_select_for_update.enabled=false; UPDATE alerts SET cstatus=cstatus, updated_at=now() WHERE customer_id=9743; Store as String allowedThroughputSurplus 1.0 0.0 3 0 100 10000 0 throughput 2000.0 0.0 100 central Callable Statement -- Must configure the following: -- set cluster setting sql.defaults.implicit_select_for_update.enabled=true; UPDATE alerts SET cstatus=cstatus, updated_at=now() WHERE customer_id=9743; Store as String allowedThroughputSurplus 1.0 0.0 3 0 100 10000 0 throughput 2000.0 0.0 100