Excessive MySQL activity

Hi all,

My host has put a block on my dolphin 7.0 site due to excessive MySQL activity. It has been overloading the server.

Does anyone know how to fix this problem? I've tried to optimize the tables but that doesn't do anything.

Could this be due to a hacked site?

who is your host? and what exactly do they say is causing the load? what hosting package are you using and how many members do you have online before it starts showing load? let me take a look at your site.

To avoid persistent connections to DB, try to replace

in inc/classes/BxDolDb.php

$this->link = @mysql_pconnect($full_host, $this->user, $this->password);

with

$this->link = @mysql_connect($full_host, $this->user, $this->password);

When optimizing your DB, maybe try some requests to delete datas regarding deleted members activities, like:

DELETE FROM `bx_spy_friends_data` WHERE `bx_spy_friends_data`.`sender_id` = 0;

DELETE FROM `bx_wall_events` WHERE `bx_wall_events`.`owner_id` = 0;

etc...