Loading...
 
Features / Usability

Features / Usability

Forum List Topic List

 
Thread actions
PDF Print this page
  • Print all pages

    • problems with indexing

    Posted by Mike Finko posts: 228 Ukraine

    Hi,

    I work with a tracker that I believe is pretty big, about 300 fields now. Up to about 260 fields, indexing still worked. But since I added another 30 - 40 fields and went over 300, the site does not want to complete indexing.
    (Tiki 15.4, 2GB memory limit for rebuilding the index, 2400 seconds, VPS hosting, CentOS 6x)

    I already have 'Exclude all plugins' (no exceptions) under Admin > Search > General Settings (but will Trackers index?).

    There are probably several things misconfigured on the site, as I always get a '500 Internal Server Error', but before going over 300 fields at least I could check the last time the site was indexed and see a new date & time. Now it's stuck on the last date & time of the indexing before adding the new 30 - 40 fields to the tracker.

    Additionally, per the instructions on the Unified Indexing page https://doc.tiki.org/Unified-Index
    it says:

    "The index is stored at temp/unified-index/ While the rebuild is occuring, a directory temp/unified-index-new/ will appear (This is to permit the existing index to be used until the new one is ready). If temp/unified-index-new/ doesn’t disappear after the indexing, something must have gone wrong."

    Well, I don't see this folder ('unified-index), but in the 'temp' folder I do see 12 other files that seem to be some type of 'index' files:
    Index Files
    should all of these be here? Could they be causing a conflict? Should I delete any?

    Also, in phpMyAdmin, I see an ever increasing number of Index files (24 now!):
    PhpMyAdmin Index Files
    should all of these be here? Could they be causing a conflict? Should I delete any?

    Or is all this normal and I just need to increase the memory at my provider to 4GB or 8GB?

    Thanks,
    Mike

    Reads: 2970
    Link
    Posted by Mike Finko posts: 228 Ukraine

    Ok, I discovered that part of the problem is that the site is getting to be huge, so I upgraded the package at the webhost (from 4GB Memory & 100GB disk space to 8GB/200GB) - I believe disk space was also causing the problem. phpMyAdmin finally started working again.

    But I still cannot figure out what these 'Index...' files are (i.e. 'index_59a95ed158cf8' when viewed in phpMyAdmin) - it would not matter if not for them multiplying like mushrooms (at ~50MB each), which are taking up valuable disk space. Also, on one back-up site I deleted all the tracker files and imported them again fresh (so all item ID's, field names, etc., would match exactly, if using the Tiki Trackers import/export) - before the import, there were like 20 or so, now there are 33! So 1.6GB of the 2.1GB Tiki is just index files - that just doesn't sound correct. This back up is on my personal website and very realistic that I'll hit my 10GB limit and have to move up to a VPS - I just don't need the headaches of managing my own server right now.

    Desperate for some advice - Is something incorrect with my Tiki admin or server configs that are causing the index files to constantly duplicate? can I safely delete some of these index files via phpMyAdmin?

    Huge thanks,
    Mike

    Link
    Posted by Mike Finko posts: 228 Ukraine

    Hi again,

    does anyone have any ideas about why so many Index files? Can I just delete most of them?

    thanks,
    Mike

    Link