[Koha] Mysql high cpu usage

2014-09-29 Thread Manuel Cuesta
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

Re: [Koha] Mysql high cpu usage

2014-09-29 Thread Arslan Farooq
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,

Re: [Koha] Mysql high cpu usage

2014-09-29 Thread 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 arslan...@gmail.com wrote: Hi,

Re: [Koha] Mysql high cpu usage

2014-09-29 Thread Manuel Cuesta
Here more info - SO Debian wheezy1 (not Squeezy, sorry) - MySQL version 5.5.38-0 - Koha is installed as package I found strange too many connections of user kobli mysql show processlist; +--+---+---+---+-+--+---+--+ | Id | User |