[Building Sakai] Slow Querys against SST_RESOURCES

[Ciellie Jansen van Vuuren]

Hallo We hit a 2700 simultaneous users today and the MySQL db was hammered quite
extensively. We see slow queries against SST_RESOURCES is there some fix. Here's
examples 
# Time: 110221 12:09:10
# User at Host: sakai[sakai] @ sakai-ap-lnx1.nwu.ac.za [143.160.38.172]
# Query_time: 3  Lock_time: 0  Rows_sent: 0  Rows_examined: 11804303
select this_.ID as ID189_0_, this_.USER_ID as USER2_189_0_, this_.SITE_ID as
SITE3_189_0_, this_.RESOURCE_REF as RESOURCE4_189_0_, this_.RESOURCE_ACTION as
RESOURCE5_189_0_, this_.RESOURCE_DATE as RESOURCE6_189_0_, this_.RESOURCE_COUNT
as RESOURCE7_189_0_ from SST_RESOURCES this_ where
this_.SITE_ID='c811eb99-e68e-4c41-b667-87337fdf18a1' and
this_.RESOURCE_REF='/content/group/c811eb99-e68e-4c41-b667-87337fdf18a1/Front
page/New HTML Page-1' and this_.RESOURCE_ACTION='read' and
this_.USER_ID='22261710' and this_.RESOURCE_DATE='2011-02-19';
# Time: 110221 12:09:11
# User at Host: sakai[sakai] @ sakai-ap-lnx2.nwu.ac.za [143.160.38.174]
# Query_time: 4  Lock_time: 0  Rows_sent: 0  Rows_examined: 11804303
select this_.ID as ID189_0_, this_.USER_ID as USER2_189_0_, this_.SITE_ID as
SITE3_189_0_, this_.RESOURCE_REF as RESOURCE4_189_0_, this_.RESOURCE_ACTION as
RESOURCE5_189_0_, this_.RESOURCE_DATE as RESOURCE6_189_0_, this_.RESOURCE_COUNT
as RESOURCE7_189_0_ from SST_RESOURCES this_ where
this_.SITE_ID='3c97145e-0d90-4433-a950-722f7d73f736' and
this_.RESOURCE_REF='/content/group/3c97145e-0d90-4433-a950-722f7d73f736/zFront
page/New HTML Page' and this_.RESOURCE_ACTION='read' and
this_.USER_ID='23178299' and this_.RESOURCE_DATE='2011-02-19';