aboutsummaryrefslogtreecommitdiffstatshomepage
path: root/OpenSim/Data/MySQL (follow)
Commit message (Collapse)AuthorAgeFilesLines
* added index to ParentID on prims, as this is sorted on for prim loading.Sean Dague2008-07-161-0/+5
| | | | | | This should speed up initial load of prims, especially on primy regions.
* add migration for SceneGroupID to char(36) plus add an index. ThisSean Dague2008-07-151-0/+9
| | | | | | | should actually speed up deletes substantially, especially for large regions, as this was a table scan before.
* Patch #9148Melanie Thielker2008-07-141-0/+9
| | | | | | | | Patch 5 in the region settings series. Adds a migration to ensure corrupted data is purged and re-read from defaults. Some changes. Still no full functionality
* change SitTarget calls from functions to propertiesSean Dague2008-07-071-14/+15
|
* * remove unused CommitAssets() hook for nowJustin Clarke Casey2008-07-071-7/+0
|
* Copyright notices and formatting cleanup.Jeff Ames2008-07-061-2/+2
|
* Mantis#1661. Thank you kindly, CMickeyb for a patch that:Charles Krinke2008-07-033-36/+107
| | | | | | | patch attached to check for timeouts on mysql connections *before* operations occur that are likely to timeout. if timeout occurs or the connections is down, it is reconnected before the operation fails.
* add 3 migrations, 1 each for prims, primshapes, and primitemsSean Dague2008-07-033-0/+65
| | | | | | | to move all their UUID stores from varchar(255) -> char(36). Based on past evidence, this should help with performance.
* migrate the myisam mysql regions to innodbSean Dague2008-07-031-0/+12
|
* Update svn properties.Jeff Ames2008-07-031-5/+5
|
* * Drop InvType from the assets table since it is no longer usedJustin Clarke Casey2008-07-022-5/+8
| | | | | | | | * Migration should be automatic on sqlite and mysql * Migration is not automatic on mssql, you will need to drop the invType column manually * Migration should be fine, but as for any db change, I would recommend making sure you have backups before moving past this revision
* Mantis#1639. Thank you, Melanie for a patch that:Charles Krinke2008-07-011-1/+8
| | | | | | Reads estate_settings.xml and populates the database from it. If there is no record, just passes the defaults to the application.
* Mantis#1637. Thank you kindly, Melanie for a patch that:Charles Krinke2008-06-301-0/+6
| | | | | | Make each region load it's settings from the database on startup. No user functionality yet.
* * Fix for http://opensimulator.org/mantis/view.php?id=1512Justin Clarke Casey2008-06-292-19/+95
| | | | | | | * Introduce experimental wait timeout checking to mysql region datastore code * This should mean that if the mysql connection has timed out, we should automatically reconnect and not fail or drop queries on region database manipulations
* patch and files from mantis #1630, Thanks MelanieMW2008-06-292-0/+223
|
* last round of warning squashing. calling it a day now.Dr Scofield2008-06-274-173/+185
|
* Mantis#1591. Thank you graciously, Sempuki for a patch that:Charles Krinke2008-06-271-1/+3
| | | | | | | | | | Currently module loading is done ad-hoc. I propose creating a simple loader class that leverages Mono.Addins (and perhaps the new .NET addins when they become available in mono). Attached is a basic patch for review that compiles into HEAD, but doesn't yet replace any existing ad-hoc loaders.
* Apply patch from bug #1601 -- more documentation for Data/MySQL. Thanks ↵Jeff Ames2008-06-264-78/+315
| | | | kerunix_Flan!
* Mantis#1595. Thank you, Melanie for a patch that:Charles Krinke2008-06-261-0/+3
| | | | | Adds pipes for the prim item flags field
* Add patch from bug #1596 - adds Doxygen documentation in OpenSim.Data.MySQL ↵Jeff Ames2008-06-267-17/+224
| | | | files. Thanks kerunix_Flan!
* add migrations to mysql and sqlite for flags on embedded inventorySean Dague2008-06-251-0/+5
|
* based on positive feedback on performance of making keys fixed lengthSean Dague2008-06-241-0/+31
| | | | | | | for assets, make all the indexed columns in the inventory fixed length via migration.
* add migration to go from varchar -> char for uuid. TestedSean Dague2008-06-231-0/+9
| | | | | | | on my machine, and works, but backing up before migrations is always a good idea.
* * Adds Region ban capability to Regions. You access this by going to ↵Teravus Ovares2008-06-212-0/+122
| | | | | | | | World->Region/Estate. Then on the Estate tab, at the lower right hand corner, clicking the 'Add' button and picking an avatar. * It only persists across reboots for the mySQL datastore currently. * Currently have stubs in the other datastores.
* * Handle parcel telehub location corruption gracefully. DBNullTeravus Ovares2008-06-201-7/+16
| | | | | * mySQL this time.
* oops, build break. needed to include another reference.Sean Dague2008-06-191-0/+1
|
* add migrations support for mysql log store. This should completeSean Dague2008-06-193-1/+41
| | | | | | all the mysql bits for migration.
* fix an edge case with migrations in the region store.Sean Dague2008-06-193-2/+54
| | | | | | Add migration support to gridstore.
* the beginning of the great id format migration. This makesSean Dague2008-06-162-6/+13
| | | | | | | | | asset uuids no longer binary. I've tested this migration a few times, and it seems working in all the scenarios I've found but it wouldn't hurt to backup your asset db before running this as it does touch a very sensitive part of our content system.
* Update svn properties, clean up formatting, refactor out duplicate ↵Jeff Ames2008-06-132-2/+2
| | | | hard-coded port numbers.
* look mom, migrations in action. This adds a couple of indexesSean Dague2008-06-121-0/+6
| | | | | | | | | to mysql regions that should help on performance of some of the selects. We should start capturing more data on performance bits to figure out where else we are missing indexes and add them via migrations as well.
* Fix mysql migrations. This is tested with an existing up to date schema,Sean Dague2008-06-127-17/+32
| | | | | | | | | and no schema. It should also work with a non up to date schema as well. Btw, meetings in which I can get code done are the right kind of meetings.
* * minor: Remove and tidy duplicate 'storing object to scene' messages in logJustin Clarke Casey2008-06-121-1/+1
|
* this, in theory, adds migration support to mysql for all Sean Dague2008-06-124-112/+194
| | | | | | | | data sources besides the grid store. It is only lightly tested so the less adventurous should wait a couple of checkins before upgrading.
* check in region store initial migration definition, Sean Dague2008-06-121-0/+150
| | | | | | | now on to integrating this approach into the mysql driver. Beware the next couple of checkins.
* check in migration files for mysqlSean Dague2008-06-123-0/+152
|
* Mantis#1501. Thank you kindly, Nebadon, for a patch thatCharles Krinke2008-06-101-1/+7
| | | | | addresses the 'terrain fill 0' error.
* Formatting cleanup, minor refactoring, svn properties.Jeff Ames2008-06-041-5/+5
|
* * experimental: Make OpenSim archiver save and reload all prim textures when ↵Justin Clarke Casey2008-06-021-0/+1
| | | | not all faces have the same texture
* * Duh, actually returning from the CreateAsset method once we know the asset ↵Justin Clarke Casey2008-05-311-0/+1
| | | | exists would be better than carrying on
* * Remove the mysql logging noise I accidentally left in a few commits agoJustin Clarke Casey2008-05-311-2/+2
|
* * Change MySQL to check whether an asset already exists before inserting it ↵Justin Clarke Casey2008-05-311-1/+40
| | | | into the database
* * Implements UserServer logoff in a few situationsTeravus Ovares2008-05-311-2/+2
| | | | | | | * User tries to log-in but is already logged in. Userserver will send message to simulator user was in to log the user out there. * From the UserServer, admin types 'logoff-user firstname lastname message'. * Some regions may not get the message because they're not updated yet.
* Update svn properties. Formatting cleanup.Jeff Ames2008-05-303-12/+16
|
* actually user the database_connect string for mysql. Sean Dague2008-05-281-20/+19
| | | | | | | This means you can run all the OpenSim grid services without needing a mysql_connection.ini
* let Grid Servers specify a connect string in their configuration.Sean Dague2008-05-282-24/+39
|
* remove terrain bloat, only keep last terrain revisionSean Dague2008-05-281-1/+5
| | | | | | | for mysql. For active terraformers this should return a lot of database space.
* remove an erroneous line to fetch the terrain table in a way that Sean Dague2008-05-281-2/+0
| | | | | | isn't actually used.
* * Potential fix for Mantis#167, 332 - MySQL Thread collision.Adam Frisby2008-05-261-61/+76
|
* Update svn properties. Formatting cleanup.Jeff Ames2008-05-251-6/+8
|