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

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

Thanks for the advice - ggppdk.

Sorry - where do I find unique counting?

We have done the following:
1. Our isotope universal module was generating many queries when it was set to extract images from Field. So - we have made it to extract from content by manually running the query to extract those images from the field - as we already know the file ID from where we got the image. I applied it to our sister site but not our other store site. The attached diagram shows the difference in memory and queries usage.


Image Link

2. We manually updated to innoDB as well.

I will repost in a few days to let you know how it goes.

Thanks,

Robert

Hello

innoDB might be a little slower in some cases, but is best choice, because it is almost crash proof and it's better locking does it more appropriate for update operations

do not forget to post an update