*HELP - Infinite loop detected in JError - Joomla! Forum - community, help and support
i got error on website:
http://www.florenceredwolves.com
and dont know do.
here information hosting company.
the administrators of go daddy’s database servers have discovered database caused overload of shared resources server resides on. overload threatened health of server and, in turn, threatened connectivity of other customers utilizing it. is, of course, unacceptable. go daddy had no choice take immediate action protect our network , prevent possibility of service interruption other customers. database disabled result.
after detecting problem go daddy's database administrators requested go daddy's advanced hosting support team notify of action taken , request resolve underlying issue. unfortunately, unable troubleshoot custom scripting, , therefore, unable provide specific solution you. following information provided our administrators:
you need correct following query:
problematic query:
select count(*) c1yjd_k2_comments itemid=375 , published=1
explain:
id select_type table type possible_keys key key_len ref rows extra
1 simple c1yjd_k2_comments index_merge itemid,published,latestcomments itemid,published 4,4 746600 using intersect(itemid,published); using where; using index
this query examines 746,600 rows , database has queries running several times second, unacceptable in shared hosting.
can me out on this? beyond knowledge!!!
http://www.florenceredwolves.com
and dont know do.
here information hosting company.
the administrators of go daddy’s database servers have discovered database caused overload of shared resources server resides on. overload threatened health of server and, in turn, threatened connectivity of other customers utilizing it. is, of course, unacceptable. go daddy had no choice take immediate action protect our network , prevent possibility of service interruption other customers. database disabled result.
after detecting problem go daddy's database administrators requested go daddy's advanced hosting support team notify of action taken , request resolve underlying issue. unfortunately, unable troubleshoot custom scripting, , therefore, unable provide specific solution you. following information provided our administrators:
you need correct following query:
problematic query:
select count(*) c1yjd_k2_comments itemid=375 , published=1
explain:
id select_type table type possible_keys key key_len ref rows extra
1 simple c1yjd_k2_comments index_merge itemid,published,latestcomments itemid,published 4,4 746600 using intersect(itemid,published); using where; using index
this query examines 746,600 rows , database has queries running several times second, unacceptable in shared hosting.
can me out on this? beyond knowledge!!!
if have large database, lot of concurrent users, , etc. you've grown 
. it's time move on , abandon shared hosting...it's not meant intensive applications joomla , can be. bare bones installations best ran on vps start off.
virtual private servers dedicated servers sliced shares of varying hardware alotments. can shrink , grow easily, , isn't pricy dedicated. shared hosting free when crammed onto 1 machine , try best load balance (hopefully).
sharing resources variable, have descent performing shared hosting or awful because it's oversold...traffic spikes in other sites slow yours down, etc. lot of reasons why sucks...i mean expect when paying $1, 5$, etc...?
joomla takes cpu , ram because of compiling php , executing it, more extensions add more server load, more concurrent users accessing site more server load, more queries , etc. more server load. dynamic site, normal static sites have no processing requirements server because it's fixed , make little no database queries. slim sites bit of php aren't bad joomla big, heavy, , bloated because it's powerful , great.
[mod note: removed self promotion]
hacking core joomla files , mysql queries isn't ideal, , may not save in case.
[mod note: removed self promotion]
fine tuned apc (alternative php cache)
opcode cache php scripts aren't recompiled every time, , read memory gives performance benefits.
dedicate ram, cpu, , hard drive site runs faster , uses it's own hardware , doesn't share it. helps mysql , php performance.
mod_deflate incase want compress content sending client, debatable because places load on cpu.
mysql query caching , fine tuned mysql settings.
we route our network through cloudflare gain speed, performance, , security benefits , saves bandwidth!
[mod note: removed self promotion]
. it's time move on , abandon shared hosting...it's not meant intensive applications joomla , can be. bare bones installations best ran on vps start off. virtual private servers dedicated servers sliced shares of varying hardware alotments. can shrink , grow easily, , isn't pricy dedicated. shared hosting free when crammed onto 1 machine , try best load balance (hopefully).
sharing resources variable, have descent performing shared hosting or awful because it's oversold...traffic spikes in other sites slow yours down, etc. lot of reasons why sucks...i mean expect when paying $1, 5$, etc...?
joomla takes cpu , ram because of compiling php , executing it, more extensions add more server load, more concurrent users accessing site more server load, more queries , etc. more server load. dynamic site, normal static sites have no processing requirements server because it's fixed , make little no database queries. slim sites bit of php aren't bad joomla big, heavy, , bloated because it's powerful , great
. [mod note: removed self promotion]
hacking core joomla files , mysql queries isn't ideal, , may not save in case.
[mod note: removed self promotion]
fine tuned apc (alternative php cache)
opcode cache php scripts aren't recompiled every time, , read memory gives performance benefits.
dedicate ram, cpu, , hard drive site runs faster , uses it's own hardware , doesn't share it. helps mysql , php performance.
mod_deflate incase want compress content sending client, debatable because places load on cpu.
mysql query caching , fine tuned mysql settings.
we route our network through cloudflare gain speed, performance, , security benefits , saves bandwidth!
[mod note: removed self promotion]
Comments
Post a Comment