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 | Host | db | Command | Time | State | Info | +------+-----------+-----------+-------+---------+------+-------+------------------+ | 1 | kobliuser | localhost | kobli | Sleep | 1117 | | NULL | | 2 | kobliuser | localhost | kobli | Sleep | 3323 | | NULL | | 3 | kobliuser | localhost | kobli | Sleep | 2900 | | NULL | | 4 | kobliuser | localhost | kobli | Sleep | 1643 | | NULL | | 5 | kobliuser | localhost | kobli | Sleep | 1058 | | NULL | | 6 | kobliuser | localhost | kobli | Sleep | 2277 | | NULL | | 7 | kobliuser | localhost | kobli | Sleep | 1516 | | NULL | | 8 | kobliuser | localhost | kobli | Sleep | 1336 | | NULL | | 9 | kobliuser | localhost | kobli | Sleep | 1197 | | NULL | | 10 | kobliuser | localhost | kobli | Sleep | 1400 | | NULL | | 12 | kobliuser | localhost | kobli | Sleep | 2813 | | NULL | | 114 | kobliuser | localhost | kobli | Sleep | 3553 | | NULL | | 126 | kobliuser | localhost | kobli | Sleep | 3424 | | NULL | | 140 | kobliuser | localhost | kobli | Sleep | 0 | | NULL | | 142 | kobliuser | localhost | kobli | Sleep | 3204 | | NULL | | 144 | kobliuser | localhost | kobli | Sleep | 3076 | | NULL | | 170 | kobliuser | localhost | kobli | Sleep | 2917 | | NULL | | 208 | kobliuser | localhost | kobli | Sleep | 485 | | NULL | | 276 | kobliuser | localhost | kobli | Sleep | 2747 | | NULL | | 346 | kobliuser | localhost | kobli | Sleep | 2605 | | NULL | | 422 | kobliuser | localhost | kobli | Sleep | 102 | | NULL | | 483 | kobliuser | localhost | kobli | Sleep | 0 | | NULL | | 553 | kobliuser | localhost | kobli | Sleep | 2254 | | NULL | | 621 | kobliuser | localhost | kobli | Sleep | 2137 | | NULL | | 696 | kobliuser | localhost | kobli | Sleep | 2022 | | NULL | | 777 | kobliuser | localhost | kobli | Sleep | 1892 | | NULL | | 843 | kobliuser | localhost | kobli | Sleep | 1780 | | NULL | | 913 | kobliuser | localhost | kobli | Sleep | 1655 | | NULL | | 981 | kobliuser | localhost | kobli | Sleep | 1538 | | NULL | | 1050 | kobliuser | localhost | kobli | Sleep | 0 | | NULL | | 1109 | kobliuser | localhost | kobli | Sleep | 0 | | NULL | | 1175 | kobliuser | localhost | kobli | Sleep | 1190 | | NULL | | 1248 | kobliuser | localhost | kobli | Sleep | 1076 | | NULL | | 1318 | kobliuser | localhost | kobli | Sleep | 0 | | NULL | | 1415 | kobliuser | localhost | kobli | Sleep | 844 | | NULL | | 1490 | kobliuser | localhost | kobli | Sleep | 722 | | NULL | | 1558 | kobliuser | localhost | kobli | Sleep | 602 | | NULL | | 1620 | kobliuser | localhost | kobli | Sleep | 479 | | NULL | | 1693 | kobliuser | localhost | kobli | Sleep | 0 | | NULL | | 1698 | admin | localhost | NULL | Query | 0 | NULL | show processlist | | 1769 | kobliuser | localhost | kobli | Sleep | 227 | | NULL | | 1833 | kobliuser | localhost | kobli | Sleep | 108 | | NULL | | 1870 | kobliuser | localhost | kobli | Sleep | 1 | | NULL | +------+-----------+-----------+-------+---------+------+-------+------------------+ 43 rows in set (0.00 sec) I know a lot about koha, sorry for that. _____________________________________ *Manuel Cuesta Álvaro* manucu...@gmail.com http://manucuesta.es On 29 September 2014 12:20, Arslan Farooq <arslan...@gmail.com> wrote: > 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