[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