Send Koha-devel mailing list submissions to
koha-devel@lists.koha-community.org
To subscribe or unsubscribe via the World Wide Web, visit
https://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-devel
or, via email, send a message with subject or body 'help' to
koha-devel-request@lists.koha-community.org
You can reach the person managing the list at
koha-devel-owner@lists.koha-community.org
When replying, please edit your Subject line so it is more specific
than "Re: Contents of Koha-devel digest..."
Today's Topics:
1. Additional DB indices for Koha? (Victor Grousset/tuxayo)
2. Re: Additional DB indices for Koha? (Fridolin SOMERS)
3. Re: Additional DB indices for Koha? (Tomas Cohen Arazi)
4. Re: Additional DB indices for Koha? (Victor/tuxayo)
----------------------------------------------------------------------
Message: 1
Date: Mon, 21 Mar 2022 18:40:12 +0100
From: Victor Grousset/tuxayo <victor@tuxayo.net>
To: koha-devel <koha-devel@lists.koha-community.org>
Subject: [Koha-devel] Additional DB indices for Koha?
Message-ID: <b01d23c3-f9c5-bc03-daa1-e21f50a2fe1d@tuxayo.net>
Content-Type: text/plain; charset=UTF-8; format=flowed
Hi :)
Has there already been the need of additional DB indices for Koha? To
speed up some queries that doesn't use a primary or foreign key.
From what I see in kohastructure.sql , there is no index besides the
implicit ones for keys.
Cheers,
--
Victor Grousset/tuxayo
------------------------------
Message: 2
Date: Mon, 21 Mar 2022 12:51:15 -1000
From: Fridolin SOMERS <fridolin.somers@biblibre.com>
To: koha-devel@lists.koha-community.org
Subject: Re: [Koha-devel] Additional DB indices for Koha?
Message-ID: <c857d810-de12-0d4b-31b8-59c2100b2294@biblibre.com>
Content-Type: text/plain; charset=UTF-8; format=flowed
Hi,
There has been this on (by me) :
Bug 3445: add more indexes on the action_logs table
Best regards
Le 21/03/2022 à 07:40, Victor Grousset/tuxayo a écrit :
> Hi :)
>
> Has there already been the need of additional DB indices for Koha? To
> speed up some queries that doesn't use a primary or foreign key.
>
> From what I see in kohastructure.sql , there is no index besides the
> implicit ones for keys.
>
> Cheers,
>
--
Fridolin SOMERS <fridolin.somers@biblibre.com>
Software and system maintainer 🦄
BibLibre, France
------------------------------
Message: 3
Date: Mon, 21 Mar 2022 20:13:56 -0300
From: Tomas Cohen Arazi <tomascohen@gmail.com>
To: "Victor Grousset/tuxayo" <victor@tuxayo.net>
Cc: koha-devel <koha-devel@lists.koha-community.org>
Subject: Re: [Koha-devel] Additional DB indices for Koha?
Message-ID:
<CABZfb=WQRzt52nnPRLVOq3-ZsbvHGLfqU2ge1tX6FobmQC0Png@mail.gmail.com>
Content-Type: text/plain; charset="utf-8"
We have lots of indexes. KEY and INDEX are basically synonyms in MySQL.
We in fact might have too many indexes defined. This is a valid hypothesis
when the index size (on disk) is too close to the DB size for a table.
El lun, 21 mar 2022 a las 14:40, Victor Grousset/tuxayo (<victor@tuxayo.net>)
escribió:
> Hi :)
>
> Has there already been the need of additional DB indices for Koha? To
> speed up some queries that doesn't use a primary or foreign key.
>
> From what I see in kohastructure.sql , there is no index besides the
> implicit ones for keys.
>
> Cheers,
>
> --
> Victor Grousset/tuxayo
> _______________________________________________
> Koha-devel mailing list
> Koha-devel@lists.koha-community.org
> https://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-devel
> website : https://www.koha-community.org/
> git : https://git.koha-community.org/
> bugs : https://bugs.koha-community.org/
>
--
Tomás Cohen Arazi
Theke Solutions (http://theke.io)
✆ +54 9351 3513384
GPG: B2F3C15F
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.koha-community.org/pipermail/koha-devel/attachments/20220321/1b7c0aa3/attachment-0001.htm>
------------------------------
Message: 4
Date: Tue, 22 Mar 2022 00:43:07 +0100
From: Victor/tuxayo <victor@tuxayo.net>
To: koha-devel <koha-devel@lists.koha-community.org>
Subject: Re: [Koha-devel] Additional DB indices for Koha?
Message-ID: <a722a0f1-e294-46cf-d9ff-5bccbd3c3969@tuxayo.net>
Content-Type: text/plain; charset=UTF-8; format=flowed
Ah we use KEY to add indices!
Thanks Fridolin and Tomas.
On 22-03-22 00:13, Tomas Cohen Arazi wrote:
> We in fact might have too many indexes defined. This is a valid
> hypothesis when the index size (on disk) is too close to the DB size for
> a table.
That might also slow down inserts and updates or is that not significant?
Cheers,
--
Victor/tuxayo
------------------------------
Subject: Digest Footer
_______________________________________________
Koha-devel mailing list
Koha-devel@lists.koha-community.org
https://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-devel
website : https://www.koha-community.org/
git : https://git.koha-community.org/
bugs : https://bugs.koha-community.org/
------------------------------
End of Koha-devel Digest, Vol 196, Issue 16
*******************************************