MySQL Forums :: Performance :: High load - queries take long time

This is possibly excessive:
innodb_log_file_size = 1500M
and may cause hiccups when it is flushing it.

To assist in analyzing slow SELECTs, please provide
* SHOW CREATE TABLE tbl\G -- engine, indexes -- works better than DESC
* SHOW TABLE STATUS LIKE 'tbl'\G -- sizes
* EXPLAIN SELECT ...\G -- clues of inefficiencies
* SHOW VARIABLES LIKE '%buffer%'; -- cache size
* SHOW VARIABLES LIKE 'innodb%'; -- various settings
and surround them with [ code ] and [ / code ] -- preserves formatting

Please SHOW CREATE TABLE Puntuacio_a_Tormar\G so I see if this needs a better index:

SELECT * FROM Puntuacio_a_Tormar WHERE ReceiverID = 100000241230329

How much RAM do you have?

Do any deadlocks show up in SHOW INNODB STATUS;
SHOW GLOBAL STATUS;
will show the rest of the data.