Latest search engine results plugin update

[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.

[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

[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.

[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

[blog.brockha.us]

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..