Forums | Mahara Community

Support /
Load is applied to a oparation


anonymous profile picture
Deleted user
Posts: 2

14 June 2013, 1:24 PM

Hi Mahara members,

I am using Mahara 1.5.2 on Cent OS 5.2, which I got from mahara.org.
I'm using MySQL 5.1.61.
I'm using PHP 5.3.10.

I click on the 'Portfolio' tab, I click 'Create page' button, I click 'Edit content' tab, I click 'General',
and I drag and drop 'Text box' to page layout area.

I see CPU utilization is about 100% (mysqld) for five seconds in spite of one PC.
Therefore, Many user do this oparation, mahara's site is too heavy.

I want to snappy site.
What should I do ?

my.cnf set up as follows.

innodb_buffer_pool_size = 2048M
innodb_additional_mem_pool_size = 10M
innodb_log_buffer_size = 128M

I see below query takes a bit of a while by this oparation.

SELECT a.*, CAST(a.owner IS NOT NULL AND a.owner = '1' 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 = 9) WHERE (
    a.owner = '1'
    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 = '1' AND aar.can_republish = 1
    )
    OR a.id IN (SELECT artefact FROM "artefact_access_usr" WHERE usr = '1' AND can_republish = 1)
    OR a.institution IN ('xxxxx','mahara')
) AND artefacttype IN('html')ORDER BY title ASC LIMIT 5


and


SELECT COUNT(*)  FROM "artefact" a
LEFT OUTER JOIN "artefact_parent_cache" apc ON (a.id = apc.artefact AND a.institution = 'mahara' AND apc.parent = 9) WHERE (
    a.owner = '1'
    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 = '1' AND aar.can_republish = 1
    )
    OR a.id IN (SELECT artefact FROM "artefact_access_usr" WHERE usr = '1' AND can_republish = 1)
    OR a.institution IN ('xxxxx','mahara')
) AND artefacttype IN('html')

Yaju Mahida's profile picture
Posts: 127

17 June 2013, 12:17 PM

Upgrading to Mahara 1.5.10 will fix this issue.

Bug report - https://bugs.launchpad.net/mahara/+bug/1039865

Mahara 1.5.10 - https://launchpad.net/mahara/1.5/1.5.10

 

 

Aaron Wells's profile picture
Posts: 896

17 June 2013, 12:42 PM

I'd also recommend switching to Postgres.

Cheers,
Aaron

anonymous profile picture
Deleted user
Posts: 2

20 June 2013, 6:49 PM

Thanks!
I can't switch to Postgres because of my circumstances.
I will try Upgrading to Mahara latest version.

4 results