excessive growth of our Koha system
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 archivohistorico@and.ccoo.es www.estudiossindicales.andalucia.ccoo.es
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 (< archivohistorico@and.ccoo.es>) 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 archivohistorico@and.ccoo.es www.estudiossindicales.andalucia.ccoo.es _______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz 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 hagud@orex.es · 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.
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 <hagud@orex.es> 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 (< archivohistorico@and.ccoo.es>) 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 archivohistorico@and.ccoo.es www.estudiossindicales.andalucia.ccoo.es _______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz 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 hagud@orex.es · 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 Koha@lists.katipo.co.nz https://lists.katipo.co.nz/mailman/listinfo/koha
-- Sent from my Android device with K-9 Mail. Please excuse my brevity.
participants (3)
-
Archivo Historico Andalucia -
Chris Cormack -
Hugo Agud