Re: [VuFind-General] MySQL database clearing

[Tim F. <T.F...@bb...>]

Hi Oliver,

Many thanks for this - it is just what we needed. 

Tim

-----Original Message-----
From: Oliver Goldschmidt [mailto:o.g...@tu...] 
Sent: 14 January 2014 13:38
To: vuf...@li...
Subject: Re: [VuFind-General] MySQL database clearing

Thanks for clarifiing that, Demian. Right, my script is for 1.x.



Am 14.01.2014 14:35, schrieb Demian Katz:
> Oliver's custom script is for VuFind 1.x; if you're using 2.x and want
to make similar enhancements, please let me know (or open a JIRA
ticket). I believe that Oliver's search cleanup speed enhancements have
already been made in 2.x -- the only thing that hasn't been done is
automation of session cleanup, which would probably be a good addition
(perhaps in a new, separate util script to allow more flexibility).
>
> - Demian
>
>> -----Original Message-----
>> From: Oliver Goldschmidt [mailto:o.g...@tu...]
>> Sent: Tuesday, January 14, 2014 8:13 AM
>> To: vuf...@li...
>> Subject: Re: [VuFind-General] MySQL database clearing
>>
>> Tim,
>>
>> I have enhanced the script to clean the searches table, since the 
>> script shipping with VuFind was very slow. My script also regards the

>> session table (in our environment this is also not cleaned up
automatically).
>>
>> I hope the script is useful for you (or anyone else).
>>
>> Best
>> - Oliver
>>
>> Am 13.01.2014 18:24, schrieb Tim Fletcher:
>>> Hi Demian,
>>>
>>> Many thanks - I'll start there. It looks like PHP has neglected to 
>>> clean the session table, much as I have neglected to check!
>>>
>>> Tim
>>>
>>> -----Original Message-----
>>> From: Demian Katz [mailto:dem...@vi...]
>>> Sent: 13 January 2014 16:37
>>> To: Tim Fletcher; vuf...@li...
>>> Subject: RE: MySQL database clearing
>>>
>>> There is a tool in the util folder called expire_searches.php which 
>>> you can run as a cron job (or manually, of course) to clean out 
>>> unneeded data from the search table. This is probably a good place 
>>> to start. The session table is supposed to get cleaned up 
>>> automatically by PHP, but this does not always work -- you should 
>>> also be safe to delete old data from there if it's hanging around
for more than a few days.
>>>
>>> - Demian
>>>
>>>> -----Original Message-----
>>>> From: Tim Fletcher [mailto:T.F...@bb...]
>>>> Sent: Monday, January 13, 2014 11:15 AM
>>>> To: vuf...@li...
>>>> Subject: [VuFind-General] MySQL database clearing
>>>>
>>>> Hi,
>>>>
>>>> Our MySQL database is beginning to get quite large so I wondered if

>>>> it was OK to go in and remove data from the session table - this 
>>>> appears to be redundant information as far as I can see. Is the 
>>>> search table also one that can be cleared out, or at least where 
>>>> the searches haven't been saved?
>>>>
>>>> Thanks,
>>>>
>>>> Tim
>>>>
>>>> ---------------
>>>> Tim Fletcher
>>>>
>>>> Library Technology Innovation Manager Birkbeck, University of 
>>>> London Malet Street London WC1E 7HX
>>>>
>>>> t.f...@bb...
>>>>
>>>> Tel: 020 7380 3269
>>>> Fax: 020 7631 6066
>>>> http://www.bbk.ac.uk/lib/
>>>>
>>>>
>>>>
>>>> -------------------------------------------------------------------
>>>> --
>>>> -
>>>> -------- CenturyLink Cloud: The Leader in Enterprise Cloud
Services.
>>>> Learn Why More Businesses Are Choosing CenturyLink Cloud For 
>>>> Critical Workloads, Development Environments & Everything In
Between.
>>>> Get a Quote or Start a Free Trial Today.
>>>>
http://pubads.g.doubleclick.net/gampad/clk?id=119420431&iu=/4140/ostg.
>>>> clktrk _______________________________________________
>>>> VuFind-General mailing list
>>>> VuF...@li...
>>>> https://lists.sourceforge.net/lists/listinfo/vufind-general
>>> --------------------------------------------------------------------
>>> --
>>> -------- CenturyLink Cloud: The Leader in Enterprise Cloud Services.
>>> Learn Why More Businesses Are Choosing CenturyLink Cloud For 
>>> Critical Workloads, Development Environments & Everything In
Between.
>>> Get a Quote or Start a Free Trial Today.
>>>
http://pubads.g.doubleclick.net/gampad/clk?id=119420431&iu=/4140/ostg.
>>> clktrk _______________________________________________
>>> VuFind-General mailing list
>>> VuF...@li...
>>> https://lists.sourceforge.net/lists/listinfo/vufind-general


------------------------------------------------------------------------
------
CenturyLink Cloud: The Leader in Enterprise Cloud Services.
Learn Why More Businesses Are Choosing CenturyLink Cloud For Critical
Workloads, Development Environments & Everything In Between.
Get a Quote or Start a Free Trial Today. 
http://pubads.g.doubleclick.net/gampad/clk?id=119420431&iu=/4140/ostg.cl
ktrk
_______________________________________________
VuFind-General mailing list
VuF...@li...
https://lists.sourceforge.net/lists/listinfo/vufind-general