javierla

MySQL server is sometimes very slow

example

------------------------------------------

27/02/13 09:03:35: WARNING:

slow query: 79.3017 seg

file: /php/cron/updatePlayers.php?

query : UPDATE `player` SET `value` = ? WHERE `player`.`id` = ?

trace:

#0 /home1/javierla/public_ht-------------------------: my_db->q('UPDATE `player`...', 'ii', 190000, 1521)

#1 /home1/javierla/public--------------------: Player->updateValueOfDay(190000)

#2 /home1/javierla/publi--------------------(174): Player->update(Object(Player))

#3 {main}

-------------------------------------

HelioHost username: javierla

Server: Stevie

HelioHost main domain: comunda.es

My account has been suspended.

I don't know the causes.

Could you activate it? please.

Thanks you

how I can know the process that caused high load on the server?

HelioHost username: javierla

Server: Stevie

HelioHost main domain: comunda.es

My account has been suspended.

I don't know the causes.

Could you activate it? please.

Thanks you