[Koha] Mysql high cpu usage

Manuel Cuesta manucuest at gmail.com
Mon Sep 29 23:55:53 NZDT 2014


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*

manucuest at gmail.com
http://manucuesta.es

On 29 September 2014 12:20, Arslan Farooq <arslanone at 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 <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
>


More information about the Koha mailing list