Re: [Koha-devel] Cleaning up...

Paul A schreef op do 17-09-2015 om 12:06 [-0400]: > We did try the innodb_file_per_table in 5.5 (but you have to ALTER all > the > tables to get the benefits) and the sum total of all the individual > files > was a little bigger than the original ibdata1 -- so whatever the > other > benefits mig

Re: [Koha-devel] Cleaning up...

I also looked at MySql 5.6 when I upgraded to 14.04. I actually used it for many months. However I found that the Ubuntu packages were lagging far behind the source release when there were security updates. So I decided, for the sake of my own sanity, to downgrade back to 5.5. YMMV. The point

Re: [Koha-devel] Cleaning up...

At 04:05 PM 9/17/2015 +0200, Stefano Bargioni wrote: +1 for "default in some newer versions". sb Robin Sheat writes: Paul A schreef op vr 11-09-2015 om 18:37 [-0400]: -rw-rw 1 mysql mysql 1302331392 Sep 11 17:45 ibdata1 This is solved by using this option: https://dev.mysql.com/doc/refman/

Re: [Koha-devel] Cleaning up...

+1 for "default in some newer versions". sb Robin Sheat writes: Paul A schreef op vr 11-09-2015 om 18:37 [-0400]: -rw-rw 1 mysql mysql 1302331392 Sep 11 17:45 ibdata1 This is solved by using this option: https://dev.mysql.com/doc/refman/5.6/en/innodb-parameters.html#sysvar_innodb_fil

Re: [Koha-devel] Cleaning up...

Paul A schreef op vr 11-09-2015 om 18:37 [-0400]: > -rw-rw 1 mysql mysql 1302331392 Sep 11 17:45 ibdata1 This is solved by using this option: https://dev.mysql.com/doc/refman/5.6/en/innodb-parameters.html#sysvar_innodb_file_per_table which I'd recommend setting. It seems like it might be a d

Re: [Koha-devel] Cleaning up...

Hie, nice SQL query, I keep it :D Le 11/09/2015 16:22, Mark Tompsett a écrit : Greetings, mysql> SELECT table_name, table_rows, round(((data_length + index_length) / 1024 / 1024),2) "Size in MB" FROM information_schema.TABLES where table_schema = "koha_library" and ((data_length+index_length)

Re: [Koha-devel] Cleaning up...

At 01:10 PM 9/11/2015 -0400, Mark Tompsett wrote: Greetings, > I would suggest the cleanup_database.pl script in the cronjobs directory, except I've just looked at it and it doesn't touch the import_items or import_biblios tables. As Galen mentioned it does via cas

Re: [Koha-devel] Cleaning up...

Yeah, I didn't think to check the foreign key rules. Thanks for correcting me on that :) On Fri, Sep 11, 2015 at 11:10 AM, Mark Tompsett wrote: > Greetings, > > > > I would suggest the cleanup_database.pl script in the cronjobs directory, > except I've just looked at it and it doesn't touch the

Re: [Koha-devel] Cleaning up...

Greetings, > I would suggest the cleanup_database.pl script in the cronjobs directory, > except I've just looked at it and it doesn't touch the import_items or > import_biblios tables. As Galen mentioned it does via cascades. Thanks for pointing me at the better way. GPML, Mark Tompsett __

Re: [Koha-devel] Cleaning up...

Hi, On Fri, Sep 11, 2015 at 1:02 PM, Michael Hafen wrote: > I would suggest the cleanup_database.pl script in the cronjobs directory, > except I've just looked at it and it doesn't touch the import_items or > import_biblios tables. > Actually, it does, via the --import DAYS switch and cascading

Re: [Koha-devel] Cleaning up...

I would suggest the cleanup_database.pl script in the cronjobs directory, except I've just looked at it and it doesn't touch the import_items or import_biblios tables. On Fri, Sep 11, 2015 at 8:22 AM, Mark Tompsett wrote: > Greetings, > > mysql> SELECT table_name, table_rows, round(((data_length

[Koha-devel] Cleaning up...

Greetings, mysql> SELECT table_name, table_rows, round(((data_length + index_length) / 1024 / 1024),2) "Size in MB" FROM information_schema.TABLES where table_schema = "koha_library" and ((data_length+index_length)/1024/1024)>10 order by (data_length+index_length); +-+--

[Koha-devel] Cleaning up some files

Paul, If the tests in t/db_dependent/lib and its subdir KohaTest are not working and should not be used anymore, could you please remove them from master? The files in t/data/db_schemas could be moved to docs/db_schemas, or deleted too. They just show the koha structure on some moments in time.

Re: [Koha-devel] Cleaning up import tables and action log

Le 17/10/2011 12:17, Marcel de Rooy a écrit : > Hi, > > Is anyone of you using code to periodically purge records from > import_records, import_biblios, import_batches and/or action_logs ? > > If so, would it be an idea to include such code into cleanup_database.pl > in misc/cronjobs ? +1 Sounds

Re: [Koha-devel] Cleaning up import tables and action log

Marcel de Rooy > Is anyone of you using code to periodically purge records from > import_records, import_biblios, import_batches and/or action_logs ? > If so, would it be an idea to include such code into cleanup_database.pl in > misc/cronjobs ? I'm pretty sure we do at one of our more resource

[Koha-devel] Cleaning up import tables and action log

Hi, Is anyone of you using code to periodically purge records from import_records, import_biblios, import_batches and/or action_logs ? If so, would it be an idea to include such code into cleanup_database.pl in misc/cronjobs ? Thanks for sharing, Marcel