diff options
| author | David Walter Seikel | 2013-02-23 07:20:32 +1000 |
|---|---|---|
| committer | David Walter Seikel | 2013-02-23 07:20:32 +1000 |
| commit | 18af255e90b54b7b1d39eb20f4932ba433bc7b55 (patch) | |
| tree | d5559672bfe22a6fca85a5722d9537a376f941f7 /OpenSim/Data/MySQL/Resources/XAssetStore.migrations | |
| parent | Add IG version bits. (diff) | |
| download | opensim-SC_OLD-18af255e90b54b7b1d39eb20f4932ba433bc7b55.zip opensim-SC_OLD-18af255e90b54b7b1d39eb20f4932ba433bc7b55.tar.gz opensim-SC_OLD-18af255e90b54b7b1d39eb20f4932ba433bc7b55.tar.bz2 opensim-SC_OLD-18af255e90b54b7b1d39eb20f4932ba433bc7b55.tar.xz | |
MyISAM is much better performing for OpenSim.
Diffstat (limited to '')
| -rw-r--r-- | OpenSim/Data/MySQL/Resources/XAssetStore.migrations | 4 |
1 files changed, 2 insertions, 2 deletions
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` ( | |||
| 16 | `asset_flags` int(11) NOT NULL, | 16 | `asset_flags` int(11) NOT NULL, |
| 17 | `creator_id` varchar(128) NOT NULL, | 17 | `creator_id` varchar(128) NOT NULL, |
| 18 | PRIMARY KEY (`id`) | 18 | PRIMARY KEY (`id`) |
| 19 | ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Version 1'; | 19 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Version 1'; |
| 20 | 20 | ||
| 21 | CREATE TABLE `xassetsdata` ( | 21 | CREATE TABLE `xassetsdata` ( |
| 22 | `hash` binary(32) NOT NULL, | 22 | `hash` binary(32) NOT NULL, |
| 23 | `data` longblob NOT NULL, | 23 | `data` longblob NOT NULL, |
| 24 | PRIMARY KEY (`hash`) | 24 | PRIMARY KEY (`hash`) |
| 25 | ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Version 1'; | 25 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Version 1'; |
| 26 | 26 | ||
| 27 | COMMIT; \ No newline at end of file | 27 | COMMIT; \ No newline at end of file |