[Due to server hardware (Hard disk) ?] DB Table crash due to hit counting

Hi,

My db has been crashing recently. The hosting company is telling me:

"I have checked the logs and I believe that the issues with your server are due to the fact that your website generates slow MySQL queries which overloaded the server. "

Here's some of the slow mysql queries:
UPDATE xxx_content SET hits=hits+1 WHERE id = 897
Executed 1303 min ago for 10 sec on Database --> .
UPDATE xxx_flexicontent_items_tmp SET hits=hits+1 WHERE id = 858

Finally they recommend:
"I advise you to first check the plugin/extensions which makes this query "SET hits=hits+1". Probably this is extension/plugin that counts the hits and takes too many system resources. "

I also did a google on the issue and came across this:
www.itoctopus.com/subqueries-a-major-cau...-on-a-joomla-website
and it says " query within a query " from FLEXIcontent leads to slow load times and discusses the hits issue.

Now - I'm not an expert with these issues and the site is running "FLEXIcontent version 2.3.0 dev" - so it does need an update.

But - I am thinking long-term that this a major issue and has it been fixed?

Thanks,

Robert

Hello

in file
plugins/flexicontent/system/flexisystem/flexisystem.php

put this line into comments:
if ( $app->isSite() )$this->countHit();

How many visitors and views does your website have ?

Thanks ggppdk.

It has 9000 - 12000 sessions a month. 20,000 - 23,000 page views.
I will add the comment.

Is there any truth to what itoctopus is saying?

Also - its not a cheap host - its SiteGround Cloud - www.siteground.com/cloud-hosting.htm

Hello

hhmm,
the query is updating specific row, it should be able to handle easily 100x than that

Hello

how many items do you have ?
maybe backup and convert the tables to InnoDB which has better locking than MyIsam tables

also i forgot, is unique counting enabled ? it will reduce the number of time that the table is updated