mahara-contributors team mailing list archive

[Rahim Virani <rahim.virani@xxxxxxxxxxx>]

Hi Aaron and the Mahara Community,

First of all thanks for fixing the following bug:
https://bugs.launchpad.net/mahara/+bug/1039865.

As Donna indicates we were able to successfully upgrade to 1.5 but it is
not usable.  It seems there is quite a culture of ridicule surrounding
MySQL among  Mahara developers (referring to:
https://mahara.org/interaction/forum/topic.php?id=302) even though MySQL
is listed as  being officially supported
(https://wiki.mahara.org/index.php/System_Administrator's_Guide/Requirements).

We first implemented Mahara a long long time ago (we pre-date the 1.0
release), at the time I do not believe that Postgres was listed as the
"recommended" option.

In the event that the CAST function will continue to cause problems with
our Mahara installation (I realize this is a MySQL performance issue and
Mahara is simply working around the performance issue -- again thank
you).  Do you know of any large installations that have migrated from
MySQL to Postgres, we are stuck on 1.4 for now as it seems it is the
last version that functioned properly with MySQL out of the box, we are
mindful of the strong recommendation to move off of 1.4.

Is there a data migration script to move from MySQL to Postgres?  
How would you recommend approach a migration? 

I have pasted recent site statistics for your reference, any helpful
guidance would be appreciated, personally we not committed to either
DBMS (we do have more experience with MySQL) but if we need to move to
Postgres under the communities recommendation then we will have no
choice, I just cant see an easy migration path.

Site installed: 29 August 2008

Users: 1046
 Active users: 2 today, 147 since 02 August, 926 all time

Groups: 381
 On average, each user is in 2.1 groups

Pages: 28680
 Users who make pages have about 25.3 pages each

Database size: 1GB

Disk usage: 19.3GB

Mahara version: 1.5.11 (latest version is 1.7.2)

Thanks again for everyone's attention to these issues.

-- 
You received this bug notification because you are a member of Mahara
Contributors, which is subscribed to Mahara.
Matching subscriptions: Subscription for all Mahara Contrib members
https://bugs.launchpad.net/bugs/1081947

Title:
  Adding Journal or Text box to a page takes approx 2 minutes to load

Status in Mahara ePortfolio:
  Confirmed

Bug description:
  Mahara version  1.5.2
  Linux CentOS release 5.8
  PHP Version 5.3.15
  MySQL 5.0.77 

  When editing a page and trying to add a normal text box by dragging it
  into the page, this loads for approx 2 minutes or more and then
  eventually appears.

  It happens with a journal too but all others are fine and are instant
  as they should be.

  I'm not getting any apache log errors for this nor general server
  errors. The only thing I am able to see is the query that it hangs on
  for this length of time.... it is the below...

  I hope someone can help as obviously this is causing quite a lot of
  issues for the users!! Anyone able to diagnose what is the issue here?

  The thing is, there is another exact version of the Mahara site
  alongside this one but just a blank version which runs perfectly fine
  so this must be an issue within the database somewhere or the
  maharadata.

  Query below: this hangs for about 1 minute 45..

  SELECT a.*, CAST(a.owner IS NOT NULL AND a.owner = '1739' AS UNSIGNED) AS editable FROM "artefact" a
              LEFT OUTER JOIN "artefact_parent_cache" apc ON (a.id = apc.artefact AND a.institution = 'mahara' AND apc.parent = 371) WHERE (
                  a.owner = '1739'
                  OR a.id IN (
                      SELECT aar.artefact
                      FROM "group_member" m
                          JOIN "artefact" aa ON m.group = aa.group
                          JOIN "artefact_access_role" aar ON aar.role = m.role AND aar.artefact = aa.id
                      WHERE m.member = '1739' AND aar.can_republish = 1
                  )
                  OR a.id IN (SELECT artefact FROM "artefact_access_usr" WHERE usr = '1739' AND can_republish = 1)
                  OR a.institution IN ('test','mahara')
              ) AND artefacttype IN('blog')ORDER BY title ASC LIMIT 10 |

  Then this one for the rest of the time until eventually the text box
  or journal appears on the page:

  SELECT COUNT(*)  FROM "artefact" a
              LEFT OUTER JOIN "artefact_parent_cache" apc ON (a.id = apc.artefact AND a.institution = 'mahara' AND apc.parent = 371) WHERE (
                  a.owner = '1739'
                  OR a.id IN (
                      SELECT aar.artefact
                      FROM "group_member" m
                          JOIN "artefact" aa ON m.group = aa.group
                          JOIN "artefact_access_role" aar ON aar.role = m.role AND aar.artefact = aa.id
                      WHERE m.member = '1739' AND aar.can_republish = 1
                  )
                  OR a.id IN (SELECT artefact FROM "artefact_access_usr" WHERE usr = '1739' AND can_republish = 1)
                  OR a.institution IN ('test','mahara')
              ) AND artefacttype IN('blogpost') |

  Thank you for your help

To manage notifications about this bug go to:
https://bugs.launchpad.net/mahara/+bug/1081947/+subscriptions