[Koha] Mysql high cpu usage

[Arslan Farooq]

Hi,

...and reading here
http://forums.cpanel.net/f402/mysql-high-cpu-usage-374152.html I think
have a look at MySQL logs as well, or better paste ~200 lines here
http://paste.koha-community.org/ as well.

Arslan

On Mon, Sep 29, 2014 at 3:14 PM, Arslan Farooq <arslanone at gmail.com> wrote:
> Hi,
>
> What are your basic hardware specs: RAM, Processor for example. And
> what is your MySQL version?
>
> How was Koha installed: package or source tarball?
>
> Someone more knowledgeable in performance related stuff may require
> the above information to help you.
>
> Arslan
>
> On Mon, Sep 29, 2014 at 3:05 PM, Manuel Cuesta <manucuest at gmail.com> wrote:
>> Hello everyone,
>>
>> in a Debian Squeeze installation Koha works slow and I can see cpu usage is
>> mysql is 100%. Recently the site was down for too many connections and I
>> change max_connections=500 and OK.
>> Now there are 20 connections (sleep) from same kobli user to DB.
>>
>> How could I reduce this cpu usage?
>>
>> Thanks in avance
>>
>> _____________________________________
>> *Manuel Cuesta Álvaro*
>>
>> manucuest at gmail.com
>> http://manucuesta.es
>> _______________________________________________
>> Koha mailing list  http://koha-community.org
>> Koha at lists.katipo.co.nz
>> http://lists.katipo.co.nz/mailman/listinfo/koha
>
>
>
> --
> Electronic Resource Librarian
> SZABIST Islamabad
> www.szabist-isb.edu.pk
> arslan.farooq at szabist-isb.edu.pk
> +92 514 863 363-65



-- 
Electronic Resource Librarian
SZABIST Islamabad
www.szabist-isb.edu.pk
arslan.farooq at szabist-isb.edu.pk
+92 514 863 363-65