[Mahara-contributors] [Bug 1081947] Re: Adding Journal or Text box to a page takes approx 2 minutes to load

2013-10-21 Thread Aaron Wells
** Changed in: mahara Milestone: 1.8.0 = 1.8.1 ** Summary changed: - Adding Journal or Text box to a page takes approx 2 minutes to load + Use of CAST() causes extreme slowdown in large MySQL sites ** Tags added: mysql optimization ** Changed in: mahara Importance: Medium = High --

[Mahara-contributors] [Bug 1081947] Re: Adding Journal or Text box to a page takes approx 2 minutes to load

2013-09-30 Thread Aaron Wells
** Changed in: mahara Milestone: 1.8rc1 = 1.8.0 -- You received this bug notification because you are a member of Mahara Contributors, which is subscribed to Mahara. Matching subscriptions: Subscription for all Mahara Contributors -- please ask on #mahara-dev or mahara.org forum before

[Mahara-contributors] [Bug 1081947] Re: Adding Journal or Text box to a page takes approx 2 minutes to load

2013-08-11 Thread Aaron Wells
Sorry about the frustration. We try to fix issues as soon as we can, but we've got limited resources. :( Really the main limitation on MySQL support is that the Mahara lead developers, my employer Catalyst IT (http://www.catalyst.net.nz), is an organization that primarily uses Postgres. So,

[Mahara-contributors] [Bug 1081947] Re: Adding Journal or Text box to a page takes approx 2 minutes to load

2013-08-10 Thread Rahim Virani
After doing some additional research it seems that most Mahara Users are on MySQL: https://mahara.org/user/nigel -- 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

[Mahara-contributors] [Bug 1081947] Re: Adding Journal or Text box to a page takes approx 2 minutes to load

2013-08-10 Thread Rahim Virani
Updated Link above: http://nigel.mcnie.name/blog/whats-up-in-mahara- land-recently -- 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

[Mahara-contributors] [Bug 1081947] Re: Adding Journal or Text box to a page takes approx 2 minutes to load

2013-08-09 Thread Donna Hrynkiw
So let me get this straight. We reported a problem with the use of CAST in the upgrade script -- and that was fixed, but it's still present in the Mahara codebase in other locations. So we can successfully upgrade (v1.4.0 to v1.5.11), but we can't *use* Mahara. Erg! -- You received this bug

[Mahara-contributors] [Bug 1081947] Re: Adding Journal or Text box to a page takes approx 2 minutes to load

2013-08-09 Thread Rahim Virani
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

[Mahara-contributors] [Bug 1081947] Re: Adding Journal or Text box to a page takes approx 2 minutes to load

2013-04-18 Thread Aaron Wells
** Changed in: mahara Milestone: 1.7.0 = 1.8.0 -- 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

[Mahara-contributors] [Bug 1081947] Re: Adding Journal or Text box to a page takes approx 2 minutes to load

2013-01-17 Thread Yaju Mahida
In December 2012 we upgraded to Mahara 1.5.4 and since the upgrade the apache error log was full with MySQL server has gone away. After investigation we found two very slow queries related to TextBox. To solve this we put the index create index arteaccerole_roleart_ix on artefact_access_role

[Mahara-contributors] [Bug 1081947] Re: Adding Journal or Text box to a page takes approx 2 minutes to load

2012-11-25 Thread Hugh Davenport
** Changed in: mahara Status: New = Confirmed ** Changed in: mahara Importance: Undecided = Medium ** Changed in: mahara Milestone: None = 1.7.0 -- You received this bug notification because you are a member of Mahara Contributors, which is subscribed to Mahara.

[Mahara-contributors] [Bug 1081947] Re: Adding Journal or Text box to a page takes approx 2 minutes to load

2012-11-22 Thread Andrea Gordon
ok we have managed to fix this in case anyone was wondering.. it was happening just due to the huge size of the database.. we added two new indexes to the below tables: artefact_access_role artefact_access_usr index type = index, column = artefact and saved... all of the