aboutsummaryrefslogtreecommitdiffstatshomepage
path: root/OpenSim/Data/MySQL/Resources/RegionStore.migrations
diff options
context:
space:
mode:
authorJustin Clark-Casey (justincc)2011-06-10 02:33:50 +0100
committerJustin Clark-Casey (justincc)2011-06-10 02:33:50 +0100
commit9149ef6c89a5dd5de144022530e5a4facdc91919 (patch)
tree1436360f3193b7227f4257f954dd3d2840be450b /OpenSim/Data/MySQL/Resources/RegionStore.migrations
parentMerge branch 'master' of ssh://opensimulator.org/var/git/opensim (diff)
downloadopensim-SC_OLD-9149ef6c89a5dd5de144022530e5a4facdc91919.zip
opensim-SC_OLD-9149ef6c89a5dd5de144022530e5a4facdc91919.tar.gz
opensim-SC_OLD-9149ef6c89a5dd5de144022530e5a4facdc91919.tar.bz2
opensim-SC_OLD-9149ef6c89a5dd5de144022530e5a4facdc91919.tar.xz
For MySQL, migrate region tables to the MyISAM storage engine rather than InnoDB
Using MyISAM proves vastly faster for persisting scene objects. For instance, a scene object that took 9 seconds to persist before now takes 1. This also improves the experience of loading large OARs. We don't use any of the transactional features of InnoDB. The only thing that may have an impact is that InnoDB does row locking on inserts while MyISAM does table locking. However, field reports say there is no noticeable difference.
Diffstat (limited to '')
-rw-r--r--OpenSim/Data/MySQL/Resources/RegionStore.migrations16
1 files changed, 16 insertions, 0 deletions
diff --git a/OpenSim/Data/MySQL/Resources/RegionStore.migrations b/OpenSim/Data/MySQL/Resources/RegionStore.migrations
index ba8d538..987625b 100644
--- a/OpenSim/Data/MySQL/Resources/RegionStore.migrations
+++ b/OpenSim/Data/MySQL/Resources/RegionStore.migrations
@@ -826,3 +826,19 @@ ALTER TABLE `prims` MODIFY COLUMN `CreatorID` VARCHAR(255) NOT NULL DEFAULT '';
826ALTER TABLE `primitems` MODIFY COLUMN `CreatorID` VARCHAR(255) NOT NULL DEFAULT ''; 826ALTER TABLE `primitems` MODIFY COLUMN `CreatorID` VARCHAR(255) NOT NULL DEFAULT '';
827 827
828COMMIT; 828COMMIT;
829
830:VERSION 38 #---------------------
831
832BEGIN;
833
834alter table land ENGINE = MyISAM;
835alter table landaccesslist ENGINE = MyISAM;
836alter table migrations ENGINE = MyISAM;
837alter table primitems ENGINE = MyISAM;
838alter table prims ENGINE = MyISAM;
839alter table primshapes ENGINE = MyISAM;
840alter table regionban ENGINE = MyISAM;
841alter table regionsettings ENGINE = MyISAM;
842alter table terrain ENGINE = MyISAM;
843
844COMMIT; \ No newline at end of file