For our production machines, we change sessions and zebraqueue tables
engine to MyISAM (because they do not have any foreign key). With
cleanup_database.pl set in crontab every night, those tables file size
is stable.
Regards,
Le 28/02/2014 23:54, Paul A a écrit :
At 12:59 PM 2/28/2014 -0800
Hi,
On Fri, Feb 28, 2014 at 2:54 PM, Paul A wrote:
> At 12:59 PM 2/28/2014 -0800, Galen Charlton wrote:
>
> We've found that it's the 'sessions' that accumulate. We cron it every
> morning at 3am, but I just ran it manually now (13.5 hours later) and get:
>
> whoever@nelson:/usr/share/koha$ ./bin
At 12:59 PM 2/28/2014 -0800, Galen Charlton wrote:
Hi,
On Fri, Feb 28, 2014 at 12:37 PM, Michael Hafen
wrote:
[snip]
> -rw-rw 1 mysql mysql 1551892480 Feb 28 12:53 import_records.ibd
[snip]
> -rw-rw 1 mysql mysql 490733568 Feb 28 13:30 zebraqueue.ibd
One thing to note is that if you u
Hi,
On Fri, Feb 28, 2014 at 12:37 PM, Michael Hafen
wrote:
[snip]
> -rw-rw 1 mysql mysql 1551892480 Feb 28 12:53 import_records.ibd
[snip]
> -rw-rw 1 mysql mysql 490733568 Feb 28 13:30 zebraqueue.ibd
One thing to note is that if you use cleanup_database.pl to do things
like trim the zeb
At 11:29 AM 2/28/2014 -0800, Galen Charlton wrote:
Hi,
On Fri, Feb 28, 2014 at 10:52 AM, Paul A
wrote:
[snip]
> -rw-rw 1 mysql mysql 1117782016 Feb 28 18:43 ibdata1
> [log files identical]
>
> Two questions if I may. First, are my numbers typical?
Hard to say without knowing how many bi
For reference, here is the file sizes and some table sizes from my database:
ls -l *.ibd|sort -k 5 -n -r|head -n 28-rw-rw 1 mysql mysql 2654994432
Feb 28 13:30 action_logs.ibd
-rw-rw 1 mysql mysql 1551892480 Feb 28 12:53 import_records.ibd
-rw-rw 1 mysql mysql 1283457024 Feb 28 13:30 b
Hi,
On Fri, Feb 28, 2014 at 10:52 AM, Paul A wrote:
[snip]
> -rw-rw 1 mysql mysql 1117782016 Feb 28 18:43 ibdata1
> [log files identical]
>
> Two questions if I may. First, are my numbers typical?
Hard to say without knowing how many bibs you have.
Regardless, if you're not using the innod
Recent exchanges on "how big a hard disk do you need" (associated possibly
with bug 11830) prompted me to have a look for "big" files on our
production box. The worst offender appears to be /var/lib/mysql with the
"oracle bug" for ibdata:
-rw-rw 1 mysql mysql 1335885824 Feb 28 18:41 ibdata
