Op 02-11-17 om 16:57 schreef Dennis Baaten:
> Yes same here. Tried this already.
>
> In /etc/mysql/mariadb.conf.d/50-server.cnf:
>
> [mysqld]
> innodb_file_format = Barracuda
> innodb_large_prefix = on
>
> Check variables with phpMyAdmin, and they are set correctly.
I just realized that my documentation is not complete, thanks for
pointing that out before it my production environment :)
I changed schema.mysql, patch attached.
The trick is appending "ROW_FORMAT=DYNAMIC" to the table definitions.
In hindsight I think the first lines of this patch, (SET GLOBAL...)
are redundant with the configuration above, but I'm not sure.
--
Casper Gielen <[email protected]> | LIS UNIX
PGP fingerprint = 16BD 2C9F 8156 C242 F981 63B8 2214 083C F80E 4AF7
Universiteit van Tilburg | Postbus 90153, 5000 LE
Warandelaan 2 | Telefoon 013 466 4100 | G 236 | http://www.uvt.nl
--- /tmp/schema.mysql 2017-11-02 14:10:48.648147712 +0100
+++ schema-2.0.mysql 2017-09-18 16:27:56.892431719 +0200
@@ -24,6 +29,10 @@
-- OTHERWISE) ARISING IN ANY WAY OUT OF THE USE OF THIS SOFTWARE, EVEN
-- IF ADVISED OF THE POSSIBILITY OF SUCH DAMAGE.
+SET GLOBAL innodb_file_format=Barracuda;
+SET GLOBAL innodb_file_per_table=ON;
+SET GLOBAL innodb_large_prefix=1;
+
CREATE TABLE zone (
id BIGINT UNSIGNED PRIMARY KEY AUTO_INCREMENT NOT NULL,
rev INT UNSIGNED NOT NULL DEFAULT 1,
@@ -45,7 +54,7 @@
nextKskRoll INT UNSIGNED NOT NULL,
nextZskRoll INT UNSIGNED NOT NULL,
nextCskRoll INT UNSIGNED NOT NULL
-);
+) ROW_FORMAT=DYNAMIC;
CREATE INDEX zonePolicyId ON zone ( policyId );
CREATE UNIQUE INDEX zoneName ON zone ( name(255) );
@@ -108,7 +117,7 @@
keyType INT NOT NULL,
repository TEXT NOT NULL,
backup INT NOT NULL
-);
+) ROW_FORMAT=DYNAMIC;
CREATE INDEX hsmKeyPolicyId ON hsmKey ( policyId );
CREATE UNIQUE INDEX hsmKeyLocator ON hsmKey ( locator(255) );
@@ -149,7 +158,7 @@
parentSoaTtl INT UNSIGNED NOT NULL,
parentSoaMinimum INT UNSIGNED NOT NULL,
passthrough INT UNSIGNED NOT NULL
-);
+) ROW_FORMAT=DYNAMIC;
CREATE UNIQUE INDEX policyName ON policy ( name(255) );
CREATE TABLE policyKey (
_______________________________________________
Opendnssec-user mailing list
[email protected]
https://lists.opendnssec.org/mailman/listinfo/opendnssec-user
