The account has reached the limit of simultaneous mysql connections

The site no longer goes online and I can no longer access the admin part.
They manually stopped those errors from hosting.
I understand that query in ad table has timeout. (mysql processes blocked) They told me to optimize mysql tables and queries. “The account has reached the limit of simultaneous mysql connections.”

Message hrom host.

| 19852775 | anunturi_dacla39     | localhost       | anunturi_cladan40        | Query   | 983993 | statistics              | SELECT oc_t_item.*, oc_t_item.s_contact_name as s_user_name
FROM (oc_t_item)
LEFT  JOIN oc_t_item_lo | 0         | 0             |
| 19854374 | anunturi_dacla39     | localhost       | anunturi_cladan40        | Query   | 983631 | statistics              | SELECT oc_t_item.*, oc_t_item.s_contact_name as s_user_name
FROM (oc_t_item)
LEFT  JOIN oc_t_item_lo | 0         | 0             |
| 19855827 | anunturi_dacla39     | localhost       | anunturi_cladan40        | Query   | 983268 | statistics              | SELECT oc_t_item.*, oc_t_item.s_contact_name as s_user_name
FROM (oc_t_item)
LEFT  JOIN oc_t_item_lo | 0         | 0             |
| 24810495 | root                 | localhost:39756 |                          | Query   | 71620  | Waiting for table flush | flush tables                                                                                         | 0         | 0             |
| 24810591 | anunturi_dacla39     | localhost       | anunturi_cladan40        | Query   | 71605  | Waiting for table flush | SELECT oc_t_item.*, oc_t_item.s_contact_name as s_user_name
FROM (oc_t_item)
LEFT OUTER  JOIN oc_t_i | 0         | 0             |
| 24811868 | anunturi_dacla39     | localhost       | anunturi_cladan40        | Query   | 71400  | Waiting for table flush | SELECT count(*) as total
FROM (oc_t_item i)
WHERE i.b_active = 1
AND i.b_enabled = 1
AND ( i.b_premi | 0         | 0             |
| 24811902 | anunturi_dacla39     | localhost       | anunturi_cladan40        | Query   | 71395  | Waiting for table flush | SELECT l.*, i.*, SUM(s.i_num_views) AS i_num_views
FROM (oc_t_item i)
LEFT  JOIN oc_t_item_location  | 0         | 0             |
| 24811935 | anunturi_dacla39     | localhost       | anunturi_cladan40        | Query   | 71390  | Waiting for table flush | SELECT oc_t_item.*, oc_t_item.s_contact_name as s_user_name
FROM (oc_t_item, oc_t_item_stats)
WHERE  | 0         | 0             |
| 24812030 | anunturi_dacla39     | localhost       | anunturi_cladan40        | Query   | 71370  | Waiting for table flush | SELECT count(*) as total
FROM (oc_t_item i)
WHERE i.b_active = 1
AND i.b_enabled = 1
AND ( i.b_premi | 0         | 0             |
| 24812202 | anunturi_dacla39     | localhost       | anunturi_cladan40        | Query   | 71339  | Waiting for table flush | SELECT count(*) as total
FROM (oc_t_item i)
WHERE i.b_active = 1
AND i.b_enabled = 1
AND ( i.b_premi | 0         | 0             |
| 24812919 | anunturi_dacla39     | localhost       | anunturi_cladan40        | Query   | 71215  | Waiting for table flush | SELECT oc_t_item.*, oc_t_item.s_contact_name as s_user_name
FROM (oc_t_item)
LEFT  JOIN oc_t_item_lo | 0         | 0             |
| 24813013 | anunturi_dacla39     | localhost       | anunturi_cladan40        | Query   | 71201  | Waiting for table flush | SELECT l.*, i.*, SUM(s.i_num_views) AS i_num_views
FROM (oc_t_item i)
LEFT  JOIN oc_t_item_location  | 0         | 0             |
| 24813918 | anunturi_dacla39     | localhost       | anunturi_cladan40        | Query   | 71051  | Waiting for table flush | SELECT l.*, i.*, SUM(s.i_num_views) AS i_num_views
FROM (oc_t_item i)
LEFT  JOIN oc_t_item_location  | 0         | 0             |
| 24814023 | anunturi_dacla39     | localhost       | anunturi_cladan40        | Query   | 71035  | Waiting for table flush | SELECT oc_t_item.*, oc_t_item.s_contact_name as s_user_name
FROM (oc_t_item)
LEFT OUTER  JOIN oc_t_i | 0         | 0             |
| 24814134 | anunturi_dacla39     | localhost       | anunturi_cladan40        | Query   | 71017  | Waiting for table flush | SELECT oc_t_item.*, oc_t_item.s_contact_name as s_user_name
FROM (oc_t_item)
LEFT  JOIN oc_t_item_lo | 0         | 0             |
| 24814276 | anunturi_dacla39     | localhost       | anunturi_cladan40        | Query   | 70995  | Waiting for table flush | SELECT count(*) as total
FROM (oc_t_item i)
WHERE i.b_active = 1
AND i.b_enabled = 1
AND ( i.b_premi | 0         | 0             |
| 24814407 | anunturi_dacla39     | localhost       | anunturi_cladan40        | Query   | 70977  | Waiting for table flush | SELECT count(*) as total
FROM (oc_t_item i)
WHERE i.b_active = 1
AND i.b_enabled = 1
AND ( i.b_premi | 0         | 0             |
| 24814796 | anunturi_dacla39     | localhost       | anunturi_cladan40        | Query   | 70923  | Waiting for table flush | SELECT count(*) as total
FROM (oc_t_item i)
WHERE i.b_active = 1
AND i.b_enabled = 1
AND ( i.b_premi | 0         | 0             |
| 24815180 | anunturi_dacla39     | localhost       | anunturi_cladan40        | Query   | 70867  | Waiting for table flush | SELECT count(*) as total
FROM (oc_t_item i)
WHERE i.b_active = 1
AND i.b_enabled = 1
AND ( i.b_premi | 0         | 0             |
| 24815230 | anunturi_dacla39     | localhost       | anunturi_cladan40        | Query   | 70860  | Waiting for table flush | SELECT count(*) as total
FROM (oc_t_item i)
WHERE i.b_active = 1
AND i.b_enabled = 1
AND ( i.b_premi | 0         | 0             |
| 24815279 | anunturi_dacla39     | localhost       | anunturi_cladan40        | Query   | 70855  | Waiting for table flush | SELECT l.*, i.*, SUM(s.i_num_views) AS i_num_views
FROM (oc_t_item i)
LEFT  JOIN oc_t_item_location  | 0         | 0             |
| 24815421 | anunturi_dacla39     | localhost       | anunturi_cladan40        | Query   | 70832  | Waiting for table flush | SELECT count(*) as total
FROM (oc_t_item i)
WHERE i.b_active = 1
AND i.b_enabled = 1
AND ( i.b_premi | 0         | 0             |
| 24815439 | anunturi_dacla39     | localhost       | anunturi_cladan40        | Query   | 70829  | Waiting for table flush | SELECT count(*) as total
FROM (oc_t_item i)
WHERE i.b_active = 1
AND i.b_enabled = 1
AND ( i.b_premi | 0         | 0             |
| 24815616 | anunturi_dacla39     | localhost       | anunturi_cladan40        | Query   | 70798  | Waiting for table flush | SELECT count(*) as total
FROM (oc_t_item i)
WHERE i.b_active = 1
AND i.b_enabled = 1
AND ( i.b_premi | 0         | 0             |
| 24815896 | anunturi_dacla39     | localhost       | anunturi_cladan40        | Query   | 70757  | Waiting for table flush | SELECT count(*) as total
FROM (oc_t_item i)
WHERE i.b_active = 1
AND i.b_enabled = 1
AND ( i.b_premi | 0         | 0             |
| 24816132 | anunturi_dacla39     | localhost       | anunturi_cladan40        | Query   | 70719  | Waiting for table flush | SELECT count(*) as total
FROM (oc_t_item i)
WHERE i.b_active = 1
AND i.b_enabled = 1
AND ( i.b_premi | 0         | 0             |

I investigate it just wait a little, I have your info.

I checked your site and it doesn’t seem to be an issue with osclass. I also checked your Cpanel resource stats and I didn’t find any usage-limit hit there in last week.


So I don’t know why are they limiting your MySQL connection.
In my experience, I have seen many providers who deliberately limits users so they can move to a higher plan.
I suggest, move to a better hosting provider.

I checked for your hosting provider reviews and it seems they are not popular either.

Thanks for the answer and help

Indeed but I have not had any problem for 10 years since I am with this hosting only since from I changed the website and took the theme and plugins only from osclasspoint.com to be more modern.

I’ll go back to them because they first said they had no problems with tables and other things.

Thank you for the help

Daniel