Webserve and MySQL disk space quota

Important:
On Webserve, the default version of PHP is 7.1; however, PHP 5.6 will still be available until it is retired on December 17, 2018. Webtest servers are already using PHP 7.1. For help specifying which version of PHP to use, see PHP server-side scripting language.

On this page:


Current Webserve and MySQL quota

Current available quota, FY 17-18

Service Quota
Webserve 2 GB
MySQL for Webserve account 5 GB

Disk storage space on Webserve

Quotas will not be enforced for existing accounts on the current Webserve environment. UITS encourages all account owners to keep their storage usage under 2 GB where practical, but there is no hard limit at this time. If your storage is significantly over 2 GB, Web Services Support will contact you to help determine if you can reduce your storage usage.

Effective July 1, 2018 new accounts will have an initial quota of 2 GB. If you have a demonstrated need for more storage, UITS will increase your quota upon request. To request an additional quota, email the Web Services Support team, along with the reason you need an additional quota allotment and the amount you believe you will need. Webserve administrators will review requests and grant additional quotas on a case-by-case basis.

As a Webserve account owner, you are required to follow best practices on your site to stay below the 2 GB quota:

  • Remove unused files, including .PDFs.
  • When possible, avoid using Webserve as a file-sharing platform, using appropriate alternatives instead (for example, Box).
  • Remove streaming media files, using alternatives such as Kaltura when practical.
  • Remove backup copies, storing them on Box or another storage service capable of handling restricted content.

Determine current disk space use

To see how much space your Webserve account is currently using, log into the account. At the prompt, enter:

du -h

The command may take several minutes to run if your account has a large number of files. As it scans your account, the command will list your folders along with the size of each. When complete, the command will display your account’s total used space at the end (bordered in red below):

Account space used

Disk storage space on MySQL for Webserve

You are granted an automatic 5 GB of quota when your MySQL for Webserve account is created.

As a MySQL for Webserve account owner, you are required to follow best practices on your site to stay below the 5 GB quota:

  • Remove unused schemas and tables.
  • Optimize schema use to minimize the amount of data replication.

Determine current disk space use

Note:
For help working with MySQL Workbench and using API stored procedures, see Use MySQL Workbench to connect to the Webserve MySQL servers.

To see how much space your MySQL for Webserve account is currently using, use MySQL workbench to run this API stored procedure:

call api.checkDbSize('name', 'asc');

The procedure above returns a list of schemas in ascending alphabetical order by schema name, along with current size in megabytes (MB). Using different arguments, you can sort by schema size ('size' instead of 'name') and descending order ('desc' instead of 'asc').

This procedure ignores empty schemas (those with no tables).

This is document adbt in the Knowledge Base.
Last modified on 2018-12-06 13:50:23.

Contact us

For help or to comment, email the UITS Support Center.