Changeset 5895
- Timestamp:
- Nov 30, 2011, 2:46:07 PM (11 years ago)
- Location:
- trunk
- Files:
-
- 3 edited
Legend:
- Unmodified
- Added
- Removed
-
trunk/config/dist/base.config
r5822 r5895 271 271 # ssl.truststore.provider = 272 272 273 # =================== 274 # Migration section 275 # =================== 276 # Configuration settings that are related to migrating a BASE 277 # installation on a MySQL database to a PostgreSQL database. 278 # See documentation for more information. 279 280 # Enable this flag to compress the exported data. This may increase 281 # performance if disks are slow. 282 # migrate.export.compress = 0 283 284 # The number of rows that should be fetched at the same time from 285 # the database. Increasing this value may give better performance 286 # but requires more memory. 287 # migrate.export.fetch-size = 20000 288 289 # Enable this flag to issue an SQL statment for statistical 290 # analysis of the imported data before continuing with the next table. 291 # Disabling this may result in very poor performance. 292 # migrate.import.analyze = 1 293 294 # Enable this flag to drop the primary key of a table before importing 295 # data to it. This may increase the performance. The primary key is 296 # re-created after the data has been imported. 297 # migrate.import.drop-primary-key = 1 298 299 # Enable this flag to drop unique constraints and indexes before importing 300 # data. This may increase the performance. The constraints and indexes 301 # are re-created after the data has been imported. NOTE! Foreign key 302 # constraints are not affected by this flag, since they must always be dropped. 303 # migrate.import.drop-constraints = 1 304 305 -
trunk/doc/src/docbook/admin/installation.xml
r5890 r5895 1556 1556 </listitem> 1557 1557 1558 <listitem> 1559 <para> 1560 Make sure that you have configured migration-specific settings 1561 in the <filename>base.config</filename> file. In most cases the 1562 default settings should be good, but if you are experiencing 1563 performance problems it may be necessary to change some settings. 1564 See <xref linkend="appendix.base.config.migrate" /> for more 1565 information. 1566 </para> 1567 </listitem> 1568 1558 1569 <listitem> 1559 1570 <para> … … 1568 1579 where <replaceable>/path/to/migration/dir</replaceable> 1569 1580 is replaced with the path to the working directory created above. 1570 Make sure that the directory is empty since existing files will1571 cause the corresponding table to be skipped (useful when debugging).1572 1581 Depending on the size of the BASE installation the export may 1573 1582 take a long time. … … 1576 1585 </orderedlist> 1577 1586 1587 <note> 1588 <para> 1589 Make sure that the migration working directory is empty to perform 1590 a full export. Existing files in the directory causes the corresponding 1591 tables to be skipped. This can be useful when debugging and after a 1592 server crash, since the export will resume where it stopped. Just make 1593 sure that the database hasn't been modified in the meantime. 1594 </para> 1595 </note> 1578 1596 <warning> 1579 1597 <para> … … 1584 1602 </para> 1585 1603 </warning> 1586 1587 1604 </listitem> 1588 1605 </varlistentry> … … 1667 1684 Make the corresponding changes in <filename>base.config</filename> 1668 1685 so that the BASE installation points to the new database. 1686 Also, make sure that you have configured migration-specific settings 1687 in the <filename>base.config</filename> file. In most cases the 1688 default settings should be good, but if you are experiencing 1689 performance problems it may be necessary to change some settings. 1690 See <xref linkend="appendix.base.config.migrate" /> for more 1691 information. 1669 1692 </para> 1670 1693 </listitem> -
trunk/doc/src/docbook/appendix/base.config.xml
r5822 r5895 1064 1064 1065 1065 </simplesect> 1066 1067 <simplesect id="appendix.base.config.migrate"> 1068 <title>Migration section</title> 1069 1070 <para> 1071 The settings in this section only affect the migration program that can 1072 be used to move a BASE installation from a MySQL database to PostgreSQL. 1073 For more information about this see <xref linkend="installation.migrate" />. 1074 </para> 1075 1076 <variablelist> 1077 <varlistentry> 1078 <term><property>migrate.export.compress</property></term> 1079 <listitem> 1080 <para> 1081 Enable this option 1082 to compress the data files generated by the export. This may 1083 improve performance in case disk speed is a limiting factor. 1084 Default is to not compress. 1085 </para> 1086 </listitem> 1087 </varlistentry> 1088 <varlistentry> 1089 <term><property>migrate.export.fetch-size</property></term> 1090 <listitem> 1091 <para> 1092 The number 1093 of rows that should be fetch at the same time from the database. 1094 A higher value may increase the performance but uses more 1095 memory. The default value is 20000. 1096 </para> 1097 </listitem> 1098 </varlistentry> 1099 <varlistentry> 1100 <term><property>migrate.import.analyze</property></term> 1101 <listitem> 1102 <para> 1103 Enable this flag to issue an SQL statment for statistical 1104 analysis of the imported data before continuing with the next 1105 table. Disabling this may result in very poor performance. This 1106 option is enabled by default. 1107 </para> 1108 </listitem> 1109 </varlistentry> 1110 1111 <varlistentry> 1112 <term><property>migrate.import.drop-primary-key</property></term> 1113 <listitem> 1114 <para> 1115 Enable this flag to drop the primary key of a table before 1116 importing data to it. This may increase the performance. The 1117 primary key is re-created after the data has been imported. 1118 This option is enabled by default. 1119 </para> 1120 </listitem> 1121 </varlistentry> 1122 1123 <varlistentry> 1124 <term><property>migrate.import.drop-constraints</property></term> 1125 <listitem> 1126 <para> 1127 Enable this flag to drop unique constraints and indexes before 1128 importing data to a table. This may increase the performance. 1129 The constraints and indexes are re-created after the data has been 1130 imported. NOTE! Foreign key constraints are not affected by this flag, 1131 since they must always be dropped. This option is enabled by 1132 default. 1133 </para> 1134 </listitem> 1135 </varlistentry> 1136 </variablelist> 1137 1138 </simplesect> 1066 1139 1067 1140 </appendix>
Note: See TracChangeset
for help on using the changeset viewer.