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@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@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@gmail.com http://manucuesta.es _______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
-- Electronic Resource Librarian SZABIST Islamabad www.szabist-isb.edu.pk arslan.farooq@szabist-isb.edu.pk +92 514 863 363-65
-- Electronic Resource Librarian SZABIST Islamabad www.szabist-isb.edu.pk arslan.farooq@szabist-isb.edu.pk +92 514 863 363-65