session table suddenly 1.2G - Joomla! Forum - community, help and support
hi all,
i maintain joomla v2.5 site small non-profit. doesn't traffic; month of october had on average 234 visitors, 7,300 hits, 115 mb traffic day.
out of blue, have received warning hosting company site using many database resources. quota 200mb, more enough, using 2gb. 1 table, _session, has bloated more million records , 1.2g in size. database traffic has gone way up.
looking @ stats past month, appears database resources began spike massively around 8 november, around time v2.5.8 released (i apply updates when appear), sheer coincidence. resource use seems have been unusually high 2 weeks dipped bit.
looking @ visitor stats, see nothing @ unusual entire month; stats in fact little lower compared october. whatever happening on our site, internal joomla seem.
anyone have idea going on here? need our database use normal asap, otherwise our hosting costs going skyrocket.
as indicated above, site @ joomla! 2.5.8.
thanks.
i maintain joomla v2.5 site small non-profit. doesn't traffic; month of october had on average 234 visitors, 7,300 hits, 115 mb traffic day.
out of blue, have received warning hosting company site using many database resources. quota 200mb, more enough, using 2gb. 1 table, _session, has bloated more million records , 1.2g in size. database traffic has gone way up.
looking @ stats past month, appears database resources began spike massively around 8 november, around time v2.5.8 released (i apply updates when appear), sheer coincidence. resource use seems have been unusually high 2 weeks dipped bit.
looking @ visitor stats, see nothing @ unusual entire month; stats in fact little lower compared october. whatever happening on our site, internal joomla seem.
anyone have idea going on here? need our database use normal asap, otherwise our hosting costs going skyrocket.
as indicated above, site @ joomla! 2.5.8.
thanks.
sounds weird.
the session table temporary table store sessions , expired records should removed automatically.
what's session time set in site > global configuration > [system] tab > on right "session settings", session lifetime? 15 minutes default.
could check privileges set in mysql database?
is mysql user (used joomla) allowed remove records?
test: create article "test", delete article, go trash [select: status = trashed],
select "test" record & choose empty trash.
if article cannot removed there's wrong database privileges, explain error sessions table.
the session table temporary table store sessions , expired records should removed automatically.
what's session time set in site > global configuration > [system] tab > on right "session settings", session lifetime? 15 minutes default.
could check privileges set in mysql database?
is mysql user (used joomla) allowed remove records?
test: create article "test", delete article, go trash [select: status = trashed],
select "test" record & choose empty trash.
if article cannot removed there's wrong database privileges, explain error sessions table.
Comments
Post a Comment