source: trunk/language/en_UK.iso-8859-1/help/maintenance.html @ 1648

Last change on this file since 1648 was 1111, checked in by rub, 19 years ago

Improvement issue 0000319:
Add new item on page administration/maintenance.
This item allow to repair and optimize database

Functionality tested with MySQL 4.1.9.
Please to report problem with previous version of MySql

  • Property svn:eol-style set to native
  • Property svn:keywords set to Author Date Id Revision
File size: 1.8 KB
Line 
1<h2>Maintenance</h2>
2
3<p>To optimize page generation time, PhpWebGallery uses cached
4information. For example, instead of counting the number of pictures
5contained in each category at each page reload, this information is stored
6in the database. In theory, this information should always be correct, but
7sometimes an error can occur and cached information becomes wrong.</p>
8
9<p>Some informations become useless with time. Deleting this useless
10information from database make you save disk space.</p>
11
12<ul>
13
14  <li><strong>Update categories informations</strong>. For each category,
15  informations to update or control are the following : list of parent
16  categories, number of pictures, date of the last picture, position among
17  brother categories, position among all categories. This action also checks
18  the coherence of representative picture.</li>
19
20  <li><strong>Update images informations</strong>. For each picture,
21  informations to update are : full path to file, average
22  rate. <em>Warning</em>: do not get confuse with metadata informations
23  which can be synchronized from <span class="pwgScreen">Administration,
24  General, Synchronize</span> or by reaching the modification screen of a
25  single picture (through <span class="pwgScreen">Picture</span> for
26  example).</li>
27
28  <li><strong>Purge history</strong>. Delete all lines from
29  <code>history</code> table. Screen <span class="pwgScreen">Administration,
30  General, History</span> shows no informations anymore on past
31  history. <em>Warning</em>: all data will be lost and there is no way to
32  get informations back.</li>
33
34  <li><strong>Purge sessions</strong>. Delete expired user sessions.</li>
35
36  <li><strong>Purge never used notification feeds</strong></li>
37
38  <li><strong>Repair and optimize database</strong>
39  For each table, re-odrer, repair and optimize operations are done.
40  </li>
41
42</ul>
Note: See TracBrowser for help on using the repository browser.