DELETE STATMENT

[Haris Zukanovic]

Hi everyone,

I tried searching to understand how much slower executing a DELETE
statement can be on a Galera system 3 nodes. Is that a constant increase
with respect to how a single mysqld would perform?


kind regards

--
--
Haris Zukanovic

[Ilias Bertsimas]

Hi Zuka,

It is not really that slower than on a normal mysql (network lag for certification is the only extra). Just make sure the tables you are deleting rows from have a Primary Key. 

One piece of advice for not slowing down your cluster when you delete a lot of rows constantly is to do it in a loop and DELETING a few rows on every cycle. You can achieve that using LIMIT.

Kind Regards,

Ilias.

[Haris Zukanovic]

Thank you for advice

kind regards
Haris Zukanovic

-- 
--
Haris Zukanovic