REGEXP: performance can be very very poor

SELECT count(*) FROM `jbm_clients`.`michelin`;

+----------+

| count(*) |

+----------+

|    13042 |

+----------+

1 row in set (0.01 sec)

MariaDB [jbm]> SELECT distinct `ip` FROM `jbm_clients`.`michelin` WHERE `return_path` like '%amazonses%' and `return_path` REGEXP '(?:\.|@|-)*.amazonses.com(\.[a-z]+)?$' ;

+-------------+

| ip          |

+-------------+

| 54.240.4.10 |

| 54.240.4.11 |

| 54.240.4.12 |

| 54.240.4.7  |

| 54.240.4.8  |

| 54.240.4.9  |

+-------------+

6 rows in set (0.03 sec)

MariaDB [jbm]> SELECT distinct `ip` FROM `jbm_clients`.`michelin` WHERE `return_path` REGEXP '(?:\.|@|-)*.amazonses.com(\.[a-z]+)?$' ;

+-------------+

| ip          |

+-------------+

| 54.240.4.10 |

| 54.240.4.11 |

| 54.240.4.12 |

| 54.240.4.7  |

| 54.240.4.8  |

| 54.240.4.9  |

+-------------+

6 rows in set (3 min 11.02 sec)