What are size limits for mysql on Ubuntu 18.04 and how can I increase them?

Solution 1:

Therefore I suspect that some size limit of the database was reached and that I will have to increase it.

I doubt it. If you reach a limit those get reported (probably /var/log/mysql/error.log, and/or /var/log/mysql.log).

What are some size limits for mysql databases and how can I increase them

These limitation are NOT editable:

• InnoDB permits up to 4 billion tables.

• MySQL has hard limit of 4096 columns per table

• The maximum tablespace size is four billion pages (64TB), which is also the maximum size for a table.

• MyISAM permits data and index files to grow up to 256TB by default, but this limit can be changed up to the maximum permissible size of 65,536TB (2567 − 1 bytes).

But you are no where near those.

Other limitation can be enforced by editing /etc/my.cnf but if there are you added them.

A MySQL query did not run successfully!

This notice says nothing uselful.

Your problem is with the function create_db and MySQL is throwing an error. In theory it could indeed be a limitation of MySQL but the odds on the query being wrong are a lot higher. Maybe there is a (double)quote or some other character in the data that is not processed correctly. Or there is a JOIN not correct and due to the amount of data MySQL now believes it needs to use another INDEX (a SELECT with an ORDER BY that has a lot of the same values or has NULL values in a field tends to switch INDEX a lot in my experience).

You probably need to find out what the SQL command actually is and examine it or the results of the execution.

Without the actual content of the function and an example of your database there is not a lot to go on.