[Koha] New OPAC design

[Paul Poulain]

Kia ora, hoping you're all enjoying the new month starting,

We (BibLibre) think that the default OPAC layout is not adapted to the 
youngest audience. That's why we've decided to create a new design for 
the OPAC, that will be soon submitted for inclusion in Koha 19.05. We 
really hope you'll enjoy this new design.


We have set it on our demo instance, you can have a look here : 
https://demo.biblibre.com/


PS: our customers will have this design automatically set during the 
next update.


--
Paul Poulain, Associé-gérant / co-owner
BibLibre, Services en logiciels libres pour les bibliothèques
BibLibre, Open Source software and services for libraries

___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] [Koha-devel] New OPAC design

[Paul Poulain]

You can thank Fridolin for this great work, my skills in terms of design 
are far lower than what he's able to do !


Le 01/04/2019 à 14:08, Pedro Amorim a écrit :

Looks great, Paul!

I would've gone for a Pokémon theme myself but My Sweet Pony also 
works! xD



On Mon, 1 Apr 2019 at 11:56, Paul Poulain > wrote:


Kia ora, hoping you're all enjoying the new month starting,

We (BibLibre) think that the default OPAC layout is not adapted to
the
youngest audience. That's why we've decided to create a new design
for
the OPAC, that will be soon submitted for inclusion in Koha 19.05. We
really hope you'll enjoy this new design.

We have set it on our demo instance, you can have a look here :
https://demo.biblibre.com/

PS: our customers will have this design automatically set during the
next update.


--
Paul Poulain, Associé-gérant / co-owner
BibLibre, Services en logiciels libres pour les bibliothèques
BibLibre, Open Source software and services for libraries

___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] [Koha-devel] New OPAC design

[Philippe Blouin]

There's a gender bias there.  We need to get more BOYS to read. Please 
add a way to shoot the horses...


Philippe Blouin,
Responsable du développement informatique

Tél.  : (833) 465-4276, poste 230
philippe.blo...@inlibro.com 

inLibro | pour esprit libre | www.inLibro.com 
On 19-04-01 08 h 20, Paul Poulain wrote:


You can thank Fridolin for this great work, my skills in terms of 
design are far lower than what he's able to do !


Le 01/04/2019 à 14:08, Pedro Amorim a écrit :

Looks great, Paul!

I would've gone for a Pokémon theme myself but My Sweet Pony also 
works! xD



On Mon, 1 Apr 2019 at 11:56, Paul Poulain > wrote:


Kia ora, hoping you're all enjoying the new month starting,

We (BibLibre) think that the default OPAC layout is not adapted
to the
youngest audience. That's why we've decided to create a new
design for
the OPAC, that will be soon submitted for inclusion in Koha
19.05. We
really hope you'll enjoy this new design.

We have set it on our demo instance, you can have a look here :
https://demo.biblibre.com/

PS: our customers will have this design automatically set during the
next update.


--
Paul Poulain, Associé-gérant / co-owner
BibLibre, Services en logiciels libres pour les bibliothèques
BibLibre, Open Source software and services for libraries

___
Koha-devel mailing list
koha-de...@lists.koha-community.org
http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-devel
website : http://www.koha-community.org/
git : http://git.koha-community.org/
bugs : http://bugs.koha-community.org/

___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] New OPAC design

[Aaron Sakovich]

Awesome design. Just wondering, is that done using Bootstrap or Horseshoe?

Aaron
--
Aaron Sakovich
Internet and Technology Services manager
Huntsville-Madison County Public Library
915 Monroe St, Huntsville AL 35801
http://hmcpl.org/ -- asakov...@hmcpl.org

Sent from my iPad.

> On Apr 1, 2019, at 06:56, Paul Poulain  wrote:
> 
> Kia ora, hoping you're all enjoying the new month starting,
> 
> We (BibLibre) think that the default OPAC layout is not adapted to the 
> youngest audience. That's why we've decided to create a new design for the 
> OPAC, that will be soon submitted for inclusion in Koha 19.05. We really hope 
> you'll enjoy this new design.
> 
> We have set it on our demo instance, you can have a look here : 
> https://demo.biblibre.com/
> 
> PS: our customers will have this design automatically set during the next 
> update.
> 
> -- 
> Paul Poulain, Associé-gérant / co-owner
> BibLibre, Services en logiciels libres pour les bibliothèques
> BibLibre, Open Source software and services for libraries
> 
> ___
> Koha mailing list  http://koha-community.org
> Koha@lists.katipo.co.nz
> https://lists.katipo.co.nz/mailman/listinfo/koha
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] [Koha-devel] New OPAC design

[Fridolin SOMERS]

Many boys including me like My Little Poney, its a real shonen-manga 
with super-powers and quests.


Le 01/04/2019 à 14:54, Philippe Blouin a écrit :
There's a gender bias there.  We need to get more BOYS to read. Please 
add a way to shoot the horses...


Philippe Blouin,
Responsable du développement informatique

Tél.  : (833) 465-4276, poste 230
philippe.blo...@inlibro.com 

inLibro | pour esprit libre | www.inLibro.com 
On 19-04-01 08 h 20, Paul Poulain wrote:


You can thank Fridolin for this great work, my skills in terms of 
design are far lower than what he's able to do !


Le 01/04/2019 à 14:08, Pedro Amorim a écrit :

Looks great, Paul!

I would've gone for a Pokémon theme myself but My Sweet Pony also 
works! xD



On Mon, 1 Apr 2019 at 11:56, Paul Poulain > wrote:


    Kia ora, hoping you're all enjoying the new month starting,

    We (BibLibre) think that the default OPAC layout is not adapted
    to the
    youngest audience. That's why we've decided to create a new
    design for
    the OPAC, that will be soon submitted for inclusion in Koha
    19.05. We
    really hope you'll enjoy this new design.

    We have set it on our demo instance, you can have a look here :
    https://demo.biblibre.com/

    PS: our customers will have this design automatically set during the
    next update.


--
Paul Poulain, Associé-gérant / co-owner
BibLibre, Services en logiciels libres pour les bibliothèques
BibLibre, Open Source software and services for libraries

___
Koha-devel mailing list
koha-de...@lists.koha-community.org
http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-devel
website : http://www.koha-community.org/
git : http://git.koha-community.org/
bugs : http://bugs.koha-community.org/

___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha


--
Fridolin SOMERS 
BibLibre, France - software and system maintainer
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

[Koha] April 2019 koha-US meeting dates

[Jason Robb]

*koha-US meetings are open to any and all.*

*Board Meeting -*
When:  Wednesday, April 3rd at 10:30 am CDT (time converter

)
Where: https://kslib.zoom.us/j/450230564
Agenda:
https://docs.google.com/document/d/1Uu7n0XoikQ25pHXT_ZLUvJdEhnbfBFIIhfmTP5CZrv4/edit?usp=sharing

*Board meetings* focus on business-related matters and topics that would
otherwise slow down general meetings.

*General Meeting* -
When: Wednesday, April 10th at 10:30 am CDT (time converter

)
Where: https://kslib.zoom.us/j/110290143

*General meetings* put an emphasis on Koha -- bugs, issues, development
ideas, workflows -- bring your problems and questions so we can discuss!
These meetings also include major organizational decisions and reports from
various committees.

Meetings are held via Zoom video conferencing. A microphone and camera are
recommended but not required. Zoom is available for Windows, Mac, and Linux
on desktops and Android and iOS on mobile devices. For help getting
started, visit: *https://support.zoom.us/hc/en-us/categories/200101697
*

If you have topics for discussion at either meeting, please send them to
secret...@koha-us.org.

Jason Robb
koha-US secretary
secret...@koha-us.org
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] [Koha-devel] New OPAC design

[Philippe Blouin]

This is some form of fallacy.  Cherry-picking, probably.  Mind you, I've 
known many people in East Texas, and going to the range is certainly a 
very "girl" activity as well.  As well as fishing with a 12-pump.


I move to put the item In Discussion.


Philippe Blouin,
Responsable du développement informatique

Tél.  : (833) 465-4276, poste 230
philippe.blo...@inlibro.com 

inLibro | pour esprit libre | www.inLibro.com 
On 19-04-01 09 h 15, Fridolin SOMERS wrote:
Many boys including me like My Little Poney, its a real shonen-manga 
with super-powers and quests.


Le 01/04/2019 à 14:54, Philippe Blouin a écrit :
There's a gender bias there.  We need to get more BOYS to read. 
Please add a way to shoot the horses...


Philippe Blouin,
Responsable du développement informatique

Tél.  : (833) 465-4276, poste 230
philippe.blo...@inlibro.com 

inLibro | pour esprit libre | www.inLibro.com 
On 19-04-01 08 h 20, Paul Poulain wrote:


You can thank Fridolin for this great work, my skills in terms of 
design are far lower than what he's able to do !


Le 01/04/2019 à 14:08, Pedro Amorim a écrit :

Looks great, Paul!

I would've gone for a Pokémon theme myself but My Sweet Pony also 
works! xD



On Mon, 1 Apr 2019 at 11:56, Paul Poulain 
mailto:paul.poul...@biblibre.com>> wrote:


    Kia ora, hoping you're all enjoying the new month starting,

    We (BibLibre) think that the default OPAC layout is not adapted
    to the
    youngest audience. That's why we've decided to create a new
    design for
    the OPAC, that will be soon submitted for inclusion in Koha
    19.05. We
    really hope you'll enjoy this new design.

    We have set it on our demo instance, you can have a look here :
    https://demo.biblibre.com/

    PS: our customers will have this design automatically set 
during the

    next update.


--
Paul Poulain, Associé-gérant / co-owner
BibLibre, Services en logiciels libres pour les bibliothèques
BibLibre, Open Source software and services for libraries

___
Koha-devel mailing list
koha-de...@lists.koha-community.org
http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-devel
website : http://www.koha-community.org/
git : http://git.koha-community.org/
bugs : http://bugs.koha-community.org/

___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha



___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] [Koha-devel] New OPAC design

[Kyle Hall]

This is truly a work of art :)
---
http://www.kylehall.info
ByWater Solutions ( http://bywatersolutions.com )
Meadville Public Library ( http://www.meadvillelibrary.org )
Crawford County Federated Library System ( http://www.ccfls.org )


On Mon, Apr 1, 2019 at 7:56 AM Paul Poulain 
wrote:

> Kia ora, hoping you're all enjoying the new month starting,
>
> We (BibLibre) think that the default OPAC layout is not adapted to the
> youngest audience. That's why we've decided to create a new design for
> the OPAC, that will be soon submitted for inclusion in Koha 19.05. We
> really hope you'll enjoy this new design.
>
> We have set it on our demo instance, you can have a look here :
> https://demo.biblibre.com/
>
> PS: our customers will have this design automatically set during the
> next update.
>
> --
> Paul Poulain, Associé-gérant / co-owner
> BibLibre, Services en logiciels libres pour les bibliothèques
> BibLibre, Open Source software and services for libraries
>
> ___
> Koha-devel mailing list
> koha-de...@lists.koha-community.org
> http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-devel
> website : http://www.koha-community.org/
> git : http://git.koha-community.org/
> bugs : http://bugs.koha-community.org/
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] New OPAC design

[Mark Alexander]

This is wonderful work.  We're going to adopt it at our little rural
library, since most of our patrons are over 50, and we need to encourage
more young people to visit.
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] New OPAC design

[Michael Sutherland]

Those colors are hideous.  Did anyone think at all about accessibility?
You can't even read the yellow lettering on white because of the lack of
contrast.  Perhaps this is a fine design for a younger audience (theme).
However, when considering a new design you should consider how individuals
with disabilities, such as color blindness, will be affected.  (Color
blindness affects approximately 1 in 12 *men* (8%) and 1 in 200 women in
the world.)

Unless the redesign is in jest.  If that's the case, carry on.

M.
---
*Michael J. Sutherland*
University Libraries
Virginia Tech
sudrl...@vt.edu | 540.231.9669 <+15402319669> | https://catalog.lib.vt.edu



On Mon, Apr 1, 2019 at 7:57 AM Paul Poulain 
wrote:

> Kia ora, hoping you're all enjoying the new month starting,
>
> We (BibLibre) think that the default OPAC layout is not adapted to the
> youngest audience. That's why we've decided to create a new design for
> the OPAC, that will be soon submitted for inclusion in Koha 19.05. We
> really hope you'll enjoy this new design.
>
> We have set it on our demo instance, you can have a look here :
> https://demo.biblibre.com/
>
> PS: our customers will have this design automatically set during the
> next update.
>
> --
> Paul Poulain, Associé-gérant / co-owner
> BibLibre, Services en logiciels libres pour les bibliothèques
> BibLibre, Open Source software and services for libraries
>
> ___
> Koha mailing list  http://koha-community.org
> Koha@lists.katipo.co.nz
> https://lists.katipo.co.nz/mailman/listinfo/koha
>
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

[Koha] Tech issues - Library list

[jeff haskell]

Hi,

I like this list for a number of reasons but can anyone please share a
library list which focuses on tech issues?

e.g. video production - editing, etc.

Thank you!
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] Tech issues - Library list

[Christopher Davis]

Here's a short list of library centric technology listservs:

https://code4lib.org/

http://web4lib.org/

http://lists.ala.org/sympa/info/lita-l

If you're looking for a technology resource for general software 
questions, you might try https://stackexchange.com/.


Good luck,

*Christopher Davis, MLS*
Systems & E-Services Librarian
Uintah County Library
204 E 100 N
Vernal, UT 84078
(435) 789-0091 ext. 261 
cgda...@uintah.utah.gov 
website: uintahlibrary.org 
catalog: basinlibraries.org 
facebook.com/uintahcountylibrary 
instagram.com/uintahcountylibrary 


On 4/1/19 12:44 PM, jeff haskell wrote:

Hi,

I like this list for a number of reasons but can anyone please share a
library list which focuses on tech issues?

e.g. video production - editing, etc.

Thank you!
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] Upgrading from Koha 17.11 to 18.11 --- anything to watch out for?

[Hector Gonzalez]

Hello, you should have a complete backup that you trust and know how to 
restore.  Both the database and the host files.

Also, if the upgrade includes your database server, the upgrade may fail, as 
the upgrade might turn mysql off and leave it off while other packages -like 
koha-common- get upgraded, and koha-common requires mysql to be up, in order to 
upgrade your database schema.  Make sure your mysql/mariadb packages are 
upgraded before letting koha upgrade.

Other than that, it should be that simple.

Hector Gonzalez.

> On Mar 31, 2019, at 1:09 PM, Chris Brown  wrote:
> 
> Hello,
> 
> We are currently running Koha 17.11 (installed from Debian packages) on
> Debian 9.3, and we want to upgrade to Koha 18.11
> 
> Is it really as simple as:
> 
> sudo apt-get update
> sudo apt-get upgrade
> 
> or is there anything else I need to watch out for? For example, do I need
> to take action to update the database schema?
> 
> Best Regards,
> 
> Chris Brown
> ___
> Koha mailing list  http://koha-community.org
> Koha@lists.katipo.co.nz
> https://lists.katipo.co.nz/mailman/listinfo/koha


___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

[Koha] Koha 3.4

[Luisa Korodrau]

Dear Koha Community,
Need help. I have only just been appointed as Librarian to a Theological
library and we have just installed Koha 3.4 to automate the collection and
as of last week I have started cataloguing the 15,000 resources that we
currently have.

I need technical advise whether I should install the latest Koha 18 version
or continue with version 3.4 and upgrade later.

Luisa Korodrau
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] Koha 3.4

[Chris Cormack]

Hi Luisa

I would stop now, the last 3.4 release was 7 years ago, it is very very
out of date. And upgrading from a version that old will be very hard.

If you haven't catalogued much already I would start with a new install
of 18.11.04 and start with that.

Chris

On 2/04/19 11:17 am, Luisa Korodrau wrote:
> Dear Koha Community,
> Need help. I have only just been appointed as Librarian to a Theological
> library and we have just installed Koha 3.4 to automate the collection and
> as of last week I have started cataloguing the 15,000 resources that we
> currently have.
> 
> I need technical advise whether I should install the latest Koha 18 version
> or continue with version 3.4 and upgrade later.
> 
> Luisa Korodrau
> ___
> Koha mailing list  http://koha-community.org
> Koha@lists.katipo.co.nz
> https://lists.katipo.co.nz/mailman/listinfo/koha
> 
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

[Koha] Purging patrons while keeping those with items on loan

[Elaine Bradtke]

The reason I'm doing this is our membership numbering system has changed,
and our card numbers are the membership numbers (the membership card is the
library card).
I've come up with a workaround:

   1. Put all patrons with outstanding loans in a list (I have a report
   that lists them)
   2. Create a new patron category for these patrons (and change the
   individual  card numbers to the new card numbers)
   3. Go through and purge the patrons by category, leaving the staff,
   patrons with outstanding loans, institutions, (any non-member patrons)
   4. Upload new patrons, matching by card number, overwriting the old ones
   (this, at least in the past meant that addresses, and expiry dates were
   updated, but loans remained as they were).

But wouldn't it be nice if there was an option in the Patron Batch Delete
function that said something like "Do not delete patrons with items checked
out".
Any librarian will tell you that just because a patron's card has expired
doesn't mean they've returned everything they've borrowed. This only works
because we have a very small number of borrowers!

Elaine Bradtke
VWML
English Folk Dance and Song Society | http://www.efdss.org
Cecil Sharp House, 2 Regent's Park Road, London NW1 7AY
Tel+44 (0) 20 7485 2206 (This number is for the English Folk Dance and
Song Society in London, England. If you wish to phone me personally, send
an e-mail first. I work off site)
--
Registered Company No. 297142
Charity Registered in England and Wales No. 305999


On Mon, Apr 1, 2019 at 10:36 AM Elaine Bradtke  wrote:

> Is there an easy way to delete all patrons *EXCEPT* the people who have
> items checked out?
> If I download just the records of the patrons who have items out, will it
> contain their borrowing information?
>
> The number of patrons with items checked out is very small. In a pinch I
> could reconstruct the information by hand, but trying to avoid that.
>
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] [Koha-devel] New OPAC design

[dcook]

It's 11am April 2nd in Australia and... yep. Yep. Yep. Fridolin is a wizard. 

David Cook
Systems Librarian
Prosentient Systems
72/330 Wattle St
Ultimo, NSW 2007
Australia

Office: 02 9212 0899
Direct: 02 8005 0595

-Original Message-
From: koha-devel-boun...@lists.koha-community.org 
 On Behalf Of Paul Poulain
Sent: Monday, 1 April 2019 10:57 PM
To: koha-de...@lists.koha-community.org; koha@lists.katipo.co.nz
Subject: [Koha-devel] New OPAC design

Kia ora, hoping you're all enjoying the new month starting,

We (BibLibre) think that the default OPAC layout is not adapted to the youngest 
audience. That's why we've decided to create a new design for the OPAC, that 
will be soon submitted for inclusion in Koha 19.05. We really hope you'll enjoy 
this new design.

We have set it on our demo instance, you can have a look here : 
https://demo.biblibre.com/

PS: our customers will have this design automatically set during the next 
update.

--
Paul Poulain, Associé-gérant / co-owner
BibLibre, Services en logiciels libres pour les bibliothèques BibLibre, Open 
Source software and services for libraries

___
Koha-devel mailing list
koha-de...@lists.koha-community.org
http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-devel
website : http://www.koha-community.org/ git : http://git.koha-community.org/ 
bugs : http://bugs.koha-community.org/



signature.asc
Description: PGP signature
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

Re: [Koha] Upgrading from Koha 17.11 to 18.11 --- anything to watch out for?

[Chris Brown]

Hi Hector,

Thank you for your advice -- I will keep it in mind. We plan to upgrade
over Easter when the libraries that we support will all be closed. I will
take a full snapshot of the server (virtual machine) first so we can roll
back if disaster strikes, and we already keep off-machine daily backups.

Do I still need to apply the "auto increment fix" in 18.11?

Chris Brown


On Mon, Apr 1, 2019 at 11:00 PM Hector Gonzalez  wrote:

> Hello, you should have a complete backup that you trust and know how to
> restore.  Both the database and the host files.
>
> Also, if the upgrade includes your database server, the upgrade may fail,
> as the upgrade might turn mysql off and leave it off while other packages
> -like koha-common- get upgraded, and koha-common requires mysql to be up,
> in order to upgrade your database schema.  Make sure your mysql/mariadb
> packages are upgraded before letting koha upgrade.
>
> Other than that, it should be that simple.
>
> Hector Gonzalez.
>
> > On Mar 31, 2019, at 1:09 PM, Chris Brown  wrote:
> >
> > Hello,
> >
> > We are currently running Koha 17.11 (installed from Debian packages) on
> > Debian 9.3, and we want to upgrade to Koha 18.11
> >
> > Is it really as simple as:
> >
> > sudo apt-get update
> > sudo apt-get upgrade
> >
> > or is there anything else I need to watch out for? For example, do I need
> > to take action to update the database schema?
> >
> > Best Regards,
> >
> > Chris Brown
> > ___
> > Koha mailing list  http://koha-community.org
> > Koha@lists.katipo.co.nz
> > https://lists.katipo.co.nz/mailman/listinfo/koha
>
>
> ___
> Koha mailing list  http://koha-community.org
> Koha@lists.katipo.co.nz
> https://lists.katipo.co.nz/mailman/listinfo/koha
>
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

[Koha] Koha work slowly

[Arayik Manukyan]

Dear list,

 

So as we have a huge  koha database with 7 million records  on Koha 17.11.05


we always have such problem : during the day we noticed  that  koha began
work slowly especially searching,

we couldn't export data at that time and executed reports. We use MariaDB
latest version and when execute this command "show status like Conn" we
noticed that connections are very huge nearly 150 000.(See attached
file)After restarted MariaDB  the connections  became 100.

We,of course use  documentation  and added

#
key_buffer = 2000M
max_allowed_packet = 16M
thread_stack = 128K
thread_cache_size = 8
# This replaces the startup script and checks MyISAM tables if needed
# the first time they are touched
myisam-recover = BACKUP
max_connections = 500
max_user_connections = 500
#table_cache = 64
thread_concurrency = 300
table_cache = 3
open_files_limit = 65000#
# * Query Cache Configuration
#
query_cache_limit = 50M
query_cache_size = 300M
# * InnoDB
#
# InnoDB is enabled by default with a 10MB datafile in /var/lib/mysql/.
# Read the manual for more InnoDB related options. There are many!
# You might want to disable InnoDB to shrink the mysqld process by circa
100MB.
#skip-innodb
innodb_buffer_pool_size=16777216
innodb_file_per_table

 

 

We understand that it is opac search results which didn't  reconnect after
any search.

Any suggestions?

Thanks,

 

Araik

 

 



---
Это сообщение было проверено AVG на наличие вирусов.
http://www.avg.com
___
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha