Loading...
 
Skip to main content

Features / Usability


after upgrade to 6.1: slow respose opening wiki pages, slow img plugin

Dear community

I am rather new to this, so please forgive if my questions (and answers) don't make much sense.

My central problem is the performance of my site after a major upgrade to 6.1.

What I do/did:
I have been running a TikiWiki (5.0 I think) for a project at my university (Lueneburg, Germany) since May 2010, using the university server.
MySQL
Server: Localhost via UNIX socket
Server Version: 5.1.54-log
Protokoll-Version: 10
MySQL-Zeichensatz: UTF-8 Unicode (utf8)
Webserver
Apache
MySQL-Client-Version: 5.1.54
PHP Erweiterung: mysql
phpMyAdmin
Versionsinformationen: 3.2.2.1

Me and my fellow researchers created a lot of wiki pages, uploaded pictures using the tikiimg plugin, stored gallery pics and files in the database (NOT in a directory). As it turned out, the sql file got bigger and bigger with the amount of pictures saved to the database (around 900 MB), but still everything was fine, response time was no problem. Some time last year I got a message in TikiWiki saying there is a new version of TikiWiki. Decided to upgrade. Wanted to do a MySQL dump but realised the file was too big because of all the pictures. Moved the files in the file galleries to a directory (files/asdateien/). Did the MySQL dump using MySQL Dumper. Saved all the files in the tiki directory on the server to my computer. Deleted TikiWiki on the server. Installed TikiWiki 6.1 on the server and connected it to my database. Moved the files (asdateien/) from my local backup back to the server.

After that the wiki seemed to work fine, at least all the pictures were at the right places, the wiki pages were OK. But the whole Tiki responded very slow. Opening a wiki site takes at least 7 seconds for a site without pictures, more than 35 seconds for sites with pictures, and it takes even longer until the thumbnails finally show up in the wiki site. If I want to open more than 1 wiki site in extra tabs sometimes the whole wiki crashes, I cannot even log out. Downloading pictures works no prob, but viewing them by clicking on the thumbnail in the wiki site sometimes (not always) results in a crash, too. Uploading pictures (even pictures of only 500 KB) takes ages and sometimes also crashes.

What I did to solve the problem:

  • university says: server is fine, no problems with any other sites so it must be an error in TikiWiki
  • I switched off all Tiki features and plugins I don't need (calendar, forums etc.)
  • I cleared the tiki cache
  • I checked the "Performance" settings in the admin panel, but don't really know what to chance here:
    • Documentation http://doc.tiki.org/Performance+Admin+PanelQuestion does not really help)
    • only found this: "Bytecode Cache cache is not used. Using a bytecode cache (APC, XCache) is highly recommended for production environments." Where and how can I change theses settings, if I have to?


Do you have any idea what I can do to make my Tiki work properly again?

Any help is much appreciated!

Kind regards from snowy Lueneburg
Antje

I'd also ask for better documentation on this page, and some tips on finetuning for webmasters who are still learning and don't do this as our primary job.

We need to know the pros and cons of every setting, explained in moderately simple technical language.