Changes for page Database Administration
Last modified by Thomas Mortagne on 2025/02/18
From version 6.1
edited by Thomas Mortagne
on 2008/01/16
on 2008/01/16
Change comment:
There is no comment for this version
To version 7.1
edited by Jean-Vincent Drean
on 2008/03/17
on 2008/03/17
Change comment:
There is no comment for this version
Summary
-
Page properties (2 modified, 0 added, 0 removed)
Details
- Page properties
-
- Author
-
... ... @@ -1,1 +1,1 @@ 1 -XWiki. ThomasMortagne1 +XWiki.jvdrean - Content
-
... ... @@ -2,6 +2,8 @@ 2 2 3 3 XWiki uses by default a database to store its data. You will find on this page tips and tricks to administer and tune your database setup. For Installation please check the [Installation>Installation#HInstallandconfigureaRelationalDatabase] page which contains information on how to setup XWiki for multiple databases. 4 4 5 +#toc("" "" "") 6 + 5 5 1.1 Indexes 6 6 7 7 To improve your XWiki instance when running with many documents you should run the following script to create indexes for your database. This has been tested for MySQL 4.x and 5.0. ... ... @@ -38,3 +38,19 @@ 38 38 * If you use *postgresql* as your database : 39 39 ** Here is a {attach:modified version of the sanity check script|sanitycheck_postgresql.sql}, to be run in the "query" tool of pgAdmin. It is the same as the script for MySQL, except that the syntax for SQL comments is different. 40 40 ** pgAdmin is the GUI tool provided with postgresql to access the database. Run pgAdmin, select the <code>xwiki</code> database, and choose the "Query" option in the "Tools" menu. Then just open the script and click on the play icon ("Execute query"). 43 + 44 +1.1 Database browsing 45 + 46 +1.1.1 DbVisualizer 47 + 48 +http://www.dbvis.com/products/dbvis/download/install.jsp 49 + 50 +Supported DBs : 51 + 52 +* HSQLDB 53 +* DB2 for Windows/Linux 54 +* JavaDB/Derby 55 +* MySQL 56 +* PostgreSQL 57 +* [more>http://www.dbvis.com/products/dbvis/features/features.jsp?page=matrix] 58 +
