Changes between Version 161 and Version 162 of ippToPsps

Timestamp:

Sep 29, 2011, 1:16:43 PM (15 years ago)

Author:

rhenders

Comment:

--

ippToPsps

@@ -84 +84 @@
 
 = Using the software =
+
+== Setting up a loading machine ==
+
+Although this can be changed in the config file, {{{ippToPsps}}} uses a 'scratch' MySQL database on {{{localhost}}} while processing. So, to run  {{{ippToPsps}}} a local MySQL server should be up-and-running, with a database created as the {{{ipp}}} user for use by {{{ippToPsps}}}. The default name for this is {{{ipptopsps_scratch}}}.
+
+Because {{{ippToPsps}}} uses this local database as a scratch database, there are large number of inserts and deletions, meaning large log files. For this reason, it is important to configure MySQL to store its data on a local partition, and not {{{/var}}} as is the default. For example, on {{{ipp005}}}:
+
+{{{
+/var/lib/mysql
+}}}
+
+was moved to:
+
+{{{
+/export/ipp005.0/mysql
+}}}
+
+In addition, it is prudent to decrease the default MySQL log-retention period from 90 days to 1 day. This is done is in
+
+{{{
+/etc/mysql/my.cnf 
+}}}
+
+on the line
+
+{{{
+expire_logs_days                                = 90
+}}}
 
 == Running {{{ippToPsps}}} ==