Hi Jonathan,I have tested the solution from https://wiki.koha-community.org/wiki/DBMS_auto_increment_fix. A restart of the MySQL Server with a large Koha Database (several hundred thousand biblio) or a large number of Koha Sites can take a long time. This is mainly because the ALTER TABLE command rebuilds the entire table. Usually you can save a lot of time and resources when you update AUTO_INCREMENT only if necessary. Here is an attempt to solve this using the example of biblioitems/deletedbiblioitems.
USE koha_kohadev;SET @ai = ( IFNULL( ( SELECT AUTO_INCREMENT FROM information_schema.tables WHERE TABLE_SCHEMA = 'koha_kohadev' AND TABLE_NAME = 'biblioitems' ), 0 ) );
SET @shadow_ai = ( IFNULL( ( SELECT MAX(biblioitemnumber) FROM deletedbiblioitems ), 0 ) + 1 );
SET @sql = ( SELECT IF(@shadow_ai > @ai, CONCAT( 'ALTER TABLE biblioitems AUTO_INCREMENT = ', @shadow_ai ), 'SELECT "skip"' ) );
PREPARE st FROM @sql; EXECUTE st; Cheers, Uli Ulrich Kleiber Bibliotheksservice-Zentrum Baden-Württemberg (BSZ) 78457 Konstanz / Germany Phone: +49 7531 88 4179 E-Mail: ulrich.klei...@bsz-bw.de http://www.bsz-bw.de
On Wed, 12 Jul 2017 at 15:11 Jonathan Druart
<jonathan.dru...@bugs.koha-community.org
<mailto:jonathan.dru...@bugs.koha-community.org>> wrote:
Hi devs,
Please review and test
https://wiki.koha-community.org/wiki/DBMS_auto_increment_fix
I have added a ref from the Koha on Debian wiki page
https://wiki.koha-community.org/wiki/Koha_on_Debian#Further_Configuration
It sounds like I should add it somewhere more visible, but do not
find where, any ideas?
See also bug 18931 where I would like to add a warning on the about
page if data are corrupted.
Please review quickly, that way we can share the tips on the general
mailing list.
Cheers,
Jonathan
_______________________________________________
Koha-devel mailing list
Koha-devel@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/
smime.p7s
Description: S/MIME Cryptographic Signature
_______________________________________________ Koha-devel mailing list Koha-devel@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/
