[jira] [Updated] (INFRA-6097) ooo-forum.a.o has mysql problems

["Gavin (JIRA)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/INFRA-6097?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Gavin updated INFRA-6097:
-------------------------

    Component/s: VMWare
    
> ooo-forum.a.o has mysql problems
> --------------------------------
>
>                 Key: INFRA-6097
>                 URL: https://issues.apache.org/jira/browse/INFRA-6097
>             Project: Infrastructure
>          Issue Type: Task
>      Security Level: public(Regular issues) 
>          Components: VMWare
>         Environment: ubuntu, mysql.
>            Reporter: jan iversen
>            Assignee: jan iversen
>            Priority: Minor
>
> 1) The number of httpd work tasks is higher than max_connections, leading to mysql error when load is high. Looking at the average load it seems best to reduce the number of work tasks.
> 2) mysql needs tuning, the buffer pool for indexes is too small (run tuning script, and look at result)
> 3) myisam tables should be converted to innoDb for better performance

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira