excessive growth of our Koha system

classic Classic list List threaded Threaded
3 messages Options
Reply | Threaded
Open this post in threaded view
|

excessive growth of our Koha system

Archivo Historico Andalucia
 Hi everyone!

For some time we have been having an error in our koha system due to
excessive growth of the database. The file that is constantly growing is:
var/lib/mysql/ibdata1. It seems a zebra problem (We have a Koha old
versión: 3.08...)

We don't know why it grows so much or how to fix it. Currently we have to
increase the server space because every few days there is a failure due to
lack of space. It is a temporary solution but we would definitely like to
fix the problem.

Any suggestions?

Thank you very much in advance!

Manuel
--
*Manuel Bueno Lluch*
Archivo Histórico de CCOO de Andalucía
c/ Japón, 41 - 41008, Sevilla
Tlf: 954401619 / 62726
[hidden email]
www.estudiossindicales.andalucia.ccoo.es
_______________________________________________
Koha mailing list  http://koha-community.org
[hidden email]
https://lists.katipo.co.nz/mailman/listinfo/koha
Reply | Threaded
Open this post in threaded view
|

Re: excessive growth of our Koha system

Hugo Agud Andreu
Good morning

The best solution is to figureout why it is growing the database

1. check logs of koha and apache
2. check tables sizes and figure out what's the table
3. check that  cleanup cron is working fine



El lun., 10 feb. 2020 a las 9:29, Archivo Historico Andalucia (<
[hidden email]>) escribió:

>  Hi everyone!
>
> For some time we have been having an error in our koha system due to
> excessive growth of the database. The file that is constantly growing is:
> var/lib/mysql/ibdata1. It seems a zebra problem (We have a Koha old
> versión: 3.08...)
>
> We don't know why it grows so much or how to fix it. Currently we have to
> increase the server space because every few days there is a failure due to
> lack of space. It is a temporary solution but we would definitely like to
> fix the problem.
>
> Any suggestions?
>
> Thank you very much in advance!
>
> Manuel
> --
> *Manuel Bueno Lluch*
> Archivo Histórico de CCOO de Andalucía
> c/ Japón, 41 - 41008, Sevilla
> Tlf: 954401619 / 62726
> [hidden email]
> www.estudiossindicales.andalucia.ccoo.es
> _______________________________________________
> Koha mailing list  http://koha-community.org
> [hidden email]
> https://lists.katipo.co.nz/mailman/listinfo/koha
>


--

*Hugo Agud - Orex Digital *

*www.orex.es <http://www.orex.es>*


<http://www.orex.es/>    [image: www.orex.es/koha] <http://www.orex.es/koha>
   [image: www.orex.es/vufind] <http://www.orex.es/vufind>


Director

Passeig Comte Vilardaga, 118 3-3  08980 -Sant Feliu de Llobregat - Tel: 933
856 138   [hidden email] · http://www.orex.es/



No imprima este mensaje a no ser que sea necesario. Una tonelada de papel
implica la tala de 15 árboles y el consumo de 250.000 litros de agua.



Aviso de confidencialidad
Este mensaje contiene información que puede ser CONFIDENCIAL y/o de USO
RESTRINGIDO. Si usted no es el receptor deseado del mensaje (ni
está autorizado a recibirlo por el remitente), no está autorizado a copiar,
reenviar o divulgar el mensaje o su contenido. Si ha recibido este mensaje
por error, por favor, notifíquenoslo inmediatamente y bórrelo de su sistema.
_______________________________________________
Koha mailing list  http://koha-community.org
[hidden email]
https://lists.katipo.co.nz/mailman/listinfo/koha
Reply | Threaded
Open this post in threaded view
|

Re: excessive growth of our Koha system

Chris Cormack-7
Actually this is not a Koha issue at all but one to do with mysql and innodb.
If you search for file_per_table and innodb you should find the answer

Chris

On 10 February 2020 7:35:58 PM AEDT, Hugo Agud <[hidden email]> wrote:

>Good morning
>
>The best solution is to figureout why it is growing the database
>
>1. check logs of koha and apache
>2. check tables sizes and figure out what's the table
>3. check that  cleanup cron is working fine
>
>
>
>El lun., 10 feb. 2020 a las 9:29, Archivo Historico Andalucia (<
>[hidden email]>) escribió:
>
>>  Hi everyone!
>>
>> For some time we have been having an error in our koha system due to
>> excessive growth of the database. The file that is constantly growing
>is:
>> var/lib/mysql/ibdata1. It seems a zebra problem (We have a Koha old
>> versión: 3.08...)
>>
>> We don't know why it grows so much or how to fix it. Currently we
>have to
>> increase the server space because every few days there is a failure
>due to
>> lack of space. It is a temporary solution but we would definitely
>like to
>> fix the problem.
>>
>> Any suggestions?
>>
>> Thank you very much in advance!
>>
>> Manuel
>> --
>> *Manuel Bueno Lluch*
>> Archivo Histórico de CCOO de Andalucía
>> c/ Japón, 41 - 41008, Sevilla
>> Tlf: 954401619 / 62726
>> [hidden email]
>> www.estudiossindicales.andalucia.ccoo.es
>> _______________________________________________
>> Koha mailing list  http://koha-community.org
>> [hidden email]
>> https://lists.katipo.co.nz/mailman/listinfo/koha
>>
>
>
>--
>
>*Hugo Agud - Orex Digital *
>
>*www.orex.es <http://www.orex.es>*
>
>
><http://www.orex.es/>    [image: www.orex.es/koha]
><http://www.orex.es/koha>
>   [image: www.orex.es/vufind] <http://www.orex.es/vufind>
>
>
>Director
>
>Passeig Comte Vilardaga, 118 3-3  08980 -Sant Feliu de Llobregat - Tel:
>933
>856 138   [hidden email] · http://www.orex.es/
>
>
>
>No imprima este mensaje a no ser que sea necesario. Una tonelada de
>papel
>implica la tala de 15 árboles y el consumo de 250.000 litros de agua.
>
>
>
>Aviso de confidencialidad
>Este mensaje contiene información que puede ser CONFIDENCIAL y/o de USO
>RESTRINGIDO. Si usted no es el receptor deseado del mensaje (ni
>está autorizado a recibirlo por el remitente), no está autorizado a
>copiar,
>reenviar o divulgar el mensaje o su contenido. Si ha recibido este
>mensaje
>por error, por favor, notifíquenoslo inmediatamente y bórrelo de su
>sistema.
>_______________________________________________
>Koha mailing list  http://koha-community.org
>[hidden email]
>https://lists.katipo.co.nz/mailman/listinfo/koha

--
Sent from my Android device with K-9 Mail. Please excuse my brevity.
_______________________________________________
Koha mailing list  http://koha-community.org
[hidden email]
https://lists.katipo.co.nz/mailman/listinfo/koha