[Krydos] Website reactivation

[marcodalcanto]

Hello,
I would like the blocked website to be reactivated.
Can you explain why it was blocked?
The website is used to display IoT data from home devices.
Thank you.
Marco

[wolstech]

You're suspended for excessive mariaDB server usage. It lists 14,240 in a 24 hour period, but not sure what the units are in this case (perhaps number of queries or CPU time spent running your queries?).

The fact you mentioned it was for IOT stuff makes me think you might be updating the database too often...the fix might be a simple as reducing the polling frequency of whatever is connecting and using the database server.

Honestly, this is only the second or third time I can ever remember someone getting suspended for this. I'm going to escalate this to Krydos as he will have more information on what happened...

[Krydos]

2 hours ago, wolstech said:

It lists 14,240 in a 24 hour period, but not sure what the units are in this case

The unit is seconds. Each user can have 10 simultaneous queries running at once. So if you start 10 queries that all take 10 seconds to finish your MariaDB load number would be 100 over 10 real life seconds.

9 hours ago, marcodalcanto said:

I would like the blocked website to be reactivated.

What are you going to do to reduce your MariaDB load?

[Ookma-Kyi]

@marcodalcantoTry not to use * when selecting columns in your queries as that tends to use up more resources. This is especially true if you only need the values from 2 to 3 columns in a table with many columns.

Example

select password from users where username = ${username}

Edited 3 hours ago by Ookma-Kyi