[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

Hi Ggppdk,

Thanks for the tips and suggestions. It has around 1100 items.

Problem site ( updated from J1.5):
brassmonkeytaipei.com/

Its sister site is:
brassmonkeytaipei.com/bmx/ - less traffic and we have implemented some site speed improvements

Hello

please tell siteground this:

you do relative little traffic, yet you have this issue

-- siteground is creating virtual servers by using a solution that is sharing the MySQL server and other server software among clients

this will lead to MyIsam DB Tables crashes, e.g. when MySQL server is forced restarted
and this will happen on tables that are often updated

- in any case sharing the MySQL server for virtual hosting is a cheaper, inferior solution

please provide siteground with this info

Hello

please try this

backup and convert the tables to InnoDB, this should resolve the problems

Hell

in order to use innoDB you will need MySQL 5.6.4 or later

please backup