MULTIPLE API REST REQUEST - CRASH MYSQL

[Jordan91]

---

BUG REPORT INFORMATION

Centreon Web version:
2.8.17
Centreon Engine version:
1.8.1
Centreon Broker version:
3.0.12
OS:
Centos 6.9
Additional environment details (AWS, VirtualBox, physical, etc.):

Steps to reproduce the issue:

1. Multiple API REST REQUEST (*1000)
   2.Waiting for global read lock | DELETE FROM ws_token WHERE generate_date < DATE_SUB(NOW(),
   INTERVAL 1 HOUR) |

Describe the results you received:
Crash Mysql

Describe the results you expected:
Better performence and no crash for MYSQL => /usr/share/centreon/www/api/index.php
Additional information you think important (e.g. issue happens only occasionally):

[lpinsivy]

@Jordan91 each connection start with an authentication or you use token existing?

[Jordan91]

Hi,

@lpinsivy Every call API requires a new Token

BR,