Galera MySQL wsrep 5.7 very slow nested selects

[ogrekevin]

Non galera the nested select takes 0.4 seconds. On the galera cluster it takes over 2.5 minutes to complete.

I'm not sure where to start, I've looked at the release notes up to the latest 5.7.30-25.22 and see no known issues that could cause this. I'm not sure simple performance tuning would fix this.

Using Innodb engine.

Config :

[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
user=mysql
binlog_format=ROW
bind-address=0.0.0.0
default_storage_engine=innodb
innodb_autoinc_lock_mode=2
innodb_flush_log_at_trx_commit=0
innodb_buffer_pool_size=15G
innodb_buffer_pool_instances=10
innodb_read_io_threads=64
innodb_write_io_threads=16
wsrep_provider=/usr/lib64/galera-3/libgalera_smm.so
wsrep_provider_options="gcache.size=300M; gcache.page_size=300M"
wsrep_cluster_address="gcomm://172.16.1.1:4567,172.16.1.2:4567"
wsrep_sst_method=rsync
server_id=1
wsrep_node_address="172.16.1.1"
wsrep_node_name="mysql01"
max_connections = 250
max_allowed_packet=64M
# debug logging
#wsrep_log_conflicts=ON

[mysql_safe]
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid