Page 1 of 1
Latest search engine results plugin update
Posted: Mon Aug 31, 2009 11:36 pm
by justgetthere
My host provider, GoDaddy, shutdown my shared unlimited hosting account due to the latest update to the search engine visitor tracking plugin. I just deleted it and I'm waiting for them to restore my account, this is what they sent me.
We have disabled your database to return the server to normal usage. To re-enable your database, you will need to correct the following query:
select day,time,ref from serendipity_visitors where ((ref like
'
http://www.google.%' and ref like '%search?%') OR (ref like
'%.search.yahoo.com/search%') OR (ref like
'
http://www.bing.com/search%') OR (ref like
'%scroogle.org/cgi-bin/nbbw.cgi%') OR (ref like
'%ixquick.com/do/metasearch.pl%') OR (ref like
'
http://searchservice.myspace.com%' and ref like '%qry=%'))order by day
desc,time desc limit 10
The query examine 1,532,998 rows which is not allowed on Shared Hosting Accounts.
Re: Latest search engine results plugin update
Posted: Wed Sep 02, 2009 5:07 pm
by garvinhicking
Hi!
Yes, from time to time you should clear up the serendipity_visitors database table. If that is not an option, you might want to upgrade the statistics plugin to a new version which should add some new indexes to make the query perform better.
Best regards,
GArvin
Re: Latest search engine results plugin update
Posted: Fri Sep 04, 2009 10:20 pm
by justgetthere
All the plugins I use are regularly updated. The statistics plugin is updated. I updated the Google search results plugin and 2 days later Godaddy sent me the email and shutdown my hosting. What is different between the plugin use on my site versus others. I don't customize any code or anything so I don't understand what is happening and the query problem they are talking about.
Re: Latest search engine results plugin update
Posted: Mon Sep 07, 2009 2:50 pm
by garvinhicking
Hi!
The statistics plugin is a plugin that ships with serendipity core itself; which serendipity version are you using? I believe the update for the keys happened in 1.4.1 or 1.5 (beta).
The SQL that you could execute on your databas eto add those indixes manually (like through phpMyAdmin):
Code: Select all
CREATE INDEX visitorses ON serendipity_visitors (sessID);
CREATE INDEX visitorday ON serendipity_visitors (day);
CREATE INDEX visitortime ON serendipity_visitors (time);
CREATE INDEX visitortimeb ON serendipity_visitors_count (year, month, day);
CREATE INDEX refsrefs ON serendipity_refs (refs);
CREATE INDEX refscount ON serendipity_refs (count);
HTH,
Garvin
Re: Latest search engine results plugin update
Posted: Sun Sep 20, 2009 7:55 pm
by blog.brockha.us
justgetthere wrote:
desc,time desc limit 10
The query examine 1,532,998 rows which is not allowed on Shared Hosting Accounts.
The sql query limits to
10 rows (internally examining more, of course). If the indexes are created, garvin gave to you, this should be very fast and not a real problem for the MySQL database..