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