From 18af255e90b54b7b1d39eb20f4932ba433bc7b55 Mon Sep 17 00:00:00 2001 From: David Walter Seikel Date: Sat, 23 Feb 2013 07:20:32 +1000 Subject: MyISAM is much better performing for OpenSim. --- OpenSim/Data/MySQL/Resources/XAssetStore.migrations | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) (limited to 'OpenSim/Data/MySQL/Resources/XAssetStore.migrations') diff --git a/OpenSim/Data/MySQL/Resources/XAssetStore.migrations b/OpenSim/Data/MySQL/Resources/XAssetStore.migrations index d3cca5e..bb58c39 100644 --- a/OpenSim/Data/MySQL/Resources/XAssetStore.migrations +++ b/OpenSim/Data/MySQL/Resources/XAssetStore.migrations @@ -16,12 +16,12 @@ CREATE TABLE `xassetsmeta` ( `asset_flags` int(11) NOT NULL, `creator_id` varchar(128) NOT NULL, PRIMARY KEY (`id`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Version 1'; +) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Version 1'; CREATE TABLE `xassetsdata` ( `hash` binary(32) NOT NULL, `data` longblob NOT NULL, PRIMARY KEY (`hash`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Version 1'; +) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Version 1'; COMMIT; \ No newline at end of file -- cgit v1.1