Re: [Koha] SQL report to search for series statements and volume numbers

Hi Michael, an inefficient and quite long running SQL statement for your request might be the following: SELECT s.ser AS series, s.vol AS volume, s.biblionumber FROM ( SELECT ExtractValue(a.metadata,'//datafield[@tag="490"][1]/subfield[@code="a"]') AS ser,

Re: [Koha] Error while using Acquisition Module vendors search (Koha 18.11.05 on Ubuntu 18.04 LTS)

Dear Ata ur Rehmann, I have seen this error message in Koha 18.05 as well. In our case the problem was solved increasing the "sort_buffer_size" configuration parameter of mysql. Adding/changing the parameter sort_buffer_size = 2M to/in the [mysqld]-section of the mysql-server configuration (t

Re: [Koha] MySQL database server, dedicated vs virtual

Hi Tobias, a few month ago we did comparisons measuring the Koha-OPAC-Search performance with plack and memcached enabled using version 3.22. Our tests were not scientifically organised. We wanted to gather experience running Koha in different environments. We used the same MySQL database and