Hi,
So, you are using:
UPDATE {$this->configs[‘table_name’]} SET field_text = ‘{$this->generateRandomString(150)}’ WHERE field_int > 10 LIMIT 400",
DELETE FROM {$this->configs[‘table_name’]} WHERE field_float = 0.51",
but there is no index on field_int nor on field_float. Also, inserted field_int, field_float value pair is always the same, so each time the very same row is updated and deleted. It looks like a locking nightmare, the script is writing the same row over and over, you can’t expect good scalability here, right?
Not sure what you are trying to test here, but maybe better try some OLTP ready benchmarks, like sysbench?
Galera may add here additional overhead, but I’d like to see if those deadlocks are regular InnoDB ones or Galera conflicts rather. Can you attach SHOW ENGINE INNODB STATUS\G output after the test as well as error log (enable wsrep_log_conflicts before).