Re: mysql query - luv-main

30 Nov 2011

delete from horde_sessionhandler where session_lastmodified < now() - 10800;

It turned out that the biggest problem I had was old session data not being 
cleaned up.  It seems that the PHP GC doesn't seem to work as it should.  
Running the above command freed 3.6G of space.

On Mon, 22 Aug 2011, Arjen Lentz &lt;arjen(a)lentz.com.au&gt; wrote:
...
  You can do cross-database joins (dbs in mysql are just
a namespace thing),
 and also multi-table deletes which is an SQL extension (although you can
 then only delete from one table specified in the join). 
delete from horde.horde_prefs,isp.users where horde.horde_prefs.pref_uid = 
isp.users.uid and bluebottle.users.inactive=1 and isp.users.inactive_time < 
now() -365*24*3600 limit 10;

Would the above delete the matching rows from horde.horde_prefs without 
deleting from isp.users?

A select with the same where clauses gets the data I want.

...
  The horde schema is monstrous though, often the
references from other
 tables comprise of 3-part varchar fields - so be sure you grab the right
 (and all) the relevant fields for your joins. Check with a select before
 you do delete. 
The Horde database has 5 tables.  horde_categories, horde_vfs_seq, and 
horde_vfs have 0, 1, and 6 rows respectively.  The other two are the 
horde_sessionhandler table (which is only needed while I have active-active 
servers for the web space, I plan to go to active-passive and remove this) and 
the horde_prefs table.

What are the inter-table references that you refer to?

Thanks for your suggestions.

-- 
My Main Blog         http://etbe.coker.com.au/
My Documents Blog    http://doc.coker.com.au/