Frequently asked questions

Back
Are there any MySQL resource usage limits?

Limits listed below are automatically enforced by the MySQL server. The limits are there to prevent single users/customers from over-loading MySQL for other customers, and we do not reset these manually.

MariaDB is a MySQL variant, and can be used by almost all software that can use MySQL.


  1. Storage space
  2. MySQL limits
  3. Explanations of each maximum limit
  4. Connection limits

1. Storage space

Storage space is limited by the size of your web hotel, and is counted as the sum of files and databases, including metadata/indexes. Example: if you have a 10 GB webhotel, and use 6 GB for files, you may only use 4 GB for databases.


2. MySQL limits

If these limits are exceeded, the MySQL server will reject further logins/queries.

LimitMySQL 5.6MySQL 5.7
MariaDB 10.3
AllFrom WebhotelExternal
max_user_connections50020010
max_connections_per_hour36 00036 000
max_updates_per_hour36 00036 000
max_queries_per_hour360 00036 000

See below for brief explanations of each limit. Connections from webhotel means from webhotels hosted on our webservers. External connections are all connections that are not made via IPv6 from our webservers.

Limits per hour are based on the number of relevant commands sent within the past hour. Example: if you reach the limit within five minutes, you must wait for around 55 minutes before it's possible to perform the same type of command again. See also the MySQL documentation for more information.


3. Explanations of each maximum limit

max_user_connections
the number of simultaneous connections
max_connections_per_hour
the number of connections per hour
max_updates_per_hour
the number of changes in data, tables or database per hour
max_queries_per_hour
the number of queries or commands per hour

4. Connection limits

If these limits are exceeded, the MySQL server will reject further connections.

LimitMySQL 5.6MySQL 5.7
MariaDB 10.3
AllFrom WebhotelExternal
TLSUnavailableSupportedRequired
Connections per timeSee MySQL limitsSee MySQL limits5/5 sec
15/50 sec
50/300 sec

If you e.g. from an external IP address attempt to connect 6 times within 5 seconds, the 6th connection will be refused. The error message may look like "connection refused" or "unable to connect to remote host", depending on what software you use to connect.

"External" connections are all connections that are not made from our IPv6 addresses. IPv6 is the default for communication from webhotels hosted by us, unless IPv6 is unavailable for the target service.


See also:

Keyword:  

Index

© 2018 Domeneshop AS · About us · Terms · Privacy policy