Mahara Community

Forums | Mahara Community

Support /
Load is applied to a oparation

Account deleted

Posts: 2

14 June 2013, 13:24

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')