/usr/sbin/mysqld, Version: 5.0.51a-24+lenny5-log ((Debian)). started with:
Tcp port: 3306 Unix socket: /var/run/mysqld/mysqld.sock
Time Id Command Argument
# Time: 130518 9:04:49
# User@Host: xwiki[xwiki] @ localhost [127.0.0.1]
# Query_time: 3 Lock_time: 0 Rows_sent: 45 Rows_examined: 45
use xwiki232;
select this_.XWR_DOCID as XWR1_1_0_, this_.XWR_VERSION1 as XWR2_1_0_, this_.XWR_VERSION2 as XWR3_1_0_, this_.XWR_DATE as XWR4_1_0_, this_.XWR_COMMENT as XWR5_1_0_, this_.XWR_AUTHOR as XWR6_1_0_, this_.XWR_ISDIFF as XWR7_1_0_ from xwikircs this_ where this_.XWR_DOCID=-348239597 and this_.XWR_ISDIFF is not null;
# Time: 130518 13:19:46
# User@Host: xwiki[xwiki] @ localhost [127.0.0.1]
# Query_time: 3 Lock_time: 0 Rows_sent: 0 Rows_examined: 3
select year(activityev0_.ase_date) as col_0_0_, month(activityev0_.ase_date) as col_1_0_, day(activityev0_.ase_date) as col_2_0_, activityev0_.ase_page as col_3_0_, max(activityev0_.ase_date) as col_4_0_ from activitystream_events activityev0_ where 1=1 and (activityev0_.ase_user in ('XWiki.erewr')) and (activityev0_.ase_space not in ('Import' , 'Panels' , 'Scheduler' , 'Stats' , 'XAppClasses' , 'XAppSheets' , 'XAppTemplates' , 'XWiki' , 'WatchCode' , 'WatchSheets' , 'XApp' , 'WatchAdmin' , 'Watch' , 'ColorThemes' , 'AnnotationCode')) and (activityev0_.ase_wiki in ('xwiki')) and (activityev0_.ase_version like '%.1' or activityev0_.ase_type<>'update') group by year(activityev0_.ase_date) , month(activityev0_.ase_date) , day(activityev0_.ase_date) , activityev0_.ase_page order by 5 desc limit 20;
# Time: 130518 17:08:19
# User@Host: sandbox[sandbox] @ localhost [127.0.0.1]
# Query_time: 3 Lock_time: 0 Rows_sent: 1 Rows_examined: 1
use sandbox;
select baseproper0_.XWP_NAME as col_0_0_, baseproper0_.XWP_CLASSTYPE as col_1_0_ from xwikiproperties baseproper0_ where baseproper0_.XWP_ID=1329512480;
# Time: 130519 0:00:03
# User@Host: xwikifarm_sites[xwikifarm_sites] @ localhost [127.0.0.1]
# Query_time: 3 Lock_time: 0 Rows_sent: 5466 Rows_examined: 6888
use xwikifarm_sites;
select activityev0_.ase_eventid as ase1_32_, activityev0_.ase_requestid as ase2_32_, activityev0_.ase_stream as ase3_32_, activityev0_.ase_date as ase4_32_, activityev0_.ase_priority as ase5_32_, activityev0_.ase_type as ase6_32_, activityev0_.ase_application as ase7_32_, activityev0_.ase_user as ase8_32_, activityev0_.ase_wiki as ase9_32_, activityev0_.ase_space as ase10_32_, activityev0_.ase_page as ase11_32_, activityev0_.ase_hidden as ase12_32_, activityev0_.ase_url as ase13_32_, activityev0_.ase_title as ase14_32_, activityev0_.ase_body as ase15_32_, activityev0_.ase_version as ase16_32_, activityev0_.ase_param1 as ase17_32_, activityev0_.ase_param2 as ase18_32_, activityev0_.ase_param3 as ase19_32_, activityev0_.ase_param4 as ase20_32_, activityev0_.ase_param5 as ase21_32_ from activitystream_events activityev0_ where (activityev0_.ase_hidden<>1 or activityev0_.ase_hidden is null) and activityev0_.ase_date>'2013-03-11 00:00:00' and (activityev0_.ase_type in ('create' , 'update' , 'delete')) order by activityev0_.ase_date desc;
# Time: 130519 1:20:10
# User@Host: ocean[ocean] @ localhost [127.0.0.1]
# Query_time: 3 Lock_time: 0 Rows_sent: 56 Rows_examined: 10208
use ocean_public;
select activityev0_.ase_wiki as col_0_0_, year(activityev0_.ase_date) as col_1_0_, month(activityev0_.ase_date) as col_2_0_, count(*) as col_3_0_ from activitystream_events activityev0_ where activityev0_.ase_space<>'Scheduler' group by activityev0_.ase_wiki , year(activityev0_.ase_date) , month(activityev0_.ase_date) order by 1, 2, 3, 4;