[Koha] Mysql high cpu usage

2014-09-29 Thread Manuel Cuesta 
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

Re: [Koha] Mysql high cpu usage

2014-09-29 Thread Manuel Cuesta 
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