[Sysadmin] evolt

David Kaufman david at gigawatt.com
Wed May 4 15:02:52 CDT 2011


Site's back up now, and mighty snappy, now the 5,108,226 row session 
table's been truncated.

Seems we'd been being bitten by this bug:
https://techcommons.stanford.edu/topics/drupal/sessions-table-cleanup

And so drupal was never expiring sessions form the db.

I added:

   ini_set('session.gc_probability', 1);

to setings.php and its all much goodlier now.

-dave


On 5/4/2011 11:01 AM, Dean Mah wrote:
> I think that that table can be truncated.
>
> Dean
>
>
> On Wed, May 4, 2011 at 6:45 AM, David Kaufman<david.kaufman at gmail.com>  wrote:
>> Correction: 1. server is reachable by http, it just has big ugly db error on
>> the homepage, and
>>
>> Correction 2: ssh was not down (I was trying to ssh to tempest -- heheh).
>>
>> But many mysql tables were in need of repair, all are repaired now except
>> the big ass sessions table which is still being repaired.
>>
>> Will update when this is done.
>>
>> -dave
>>
>> On 5/4/2011 12:10 AM, David Kaufman wrote:
>>>
>>> On 4/28/2011 11:28 PM, Dean Mah wrote:
>>>>
>>>> The server appears to be unreachable by ssh or http. I've tried to
>>>> create a ticket but I don't know the root password. Can you request
>>>> an investigation or a reboot?
>>>>
>>>> Thanks,
>>>> Dean
>>>>
>>>
>>> Hi Dean,
>>>
>>> Sorry I was mia for this!
>>>
>>> Looks like the site is down again -- db error on the homepage and no
>>> ssh. I'll open another ticket.
>>
>
>
> ----------------------------------------
> so, are we gonna get this vote on for
> the EvoltSysadmin mascot or what?
>



More information about the Sysadmin mailing list