Slow Queries

[Diego Tucci]

Hi All,

My name is Diego and I am facing issues with my current server, which I describe below:

Server: Localhost via UNIX socket
Server version: 5.1.60-community-log
Protocol version: 10
User: venicep@localhost
MySQL charset: UTF-8 Unicode (utf8)
Apache/1.3.41 (Unix) mod_fastcgi/2.4.6 mod_auth_pop/Ferozo-2.0 mod_auth_pam/1.1.1 PHP/4.4.4
MySQL client version: 5.0.94
PHP extension: mysql

The problem is that the users_sessions shown below is a 17 column table with indexes on the ID colum, but for some reason which I cannot determine sometimes it takes 5 to 10 seconds to update.

I copy here the slow_queries.log file:

# Time: 120712 22:00:21
# User@Host: v_s1[v_s1] @ localhost []
# Query_time: 5.771018 Lock_time: 0.000023 Rows_sent: 0 Rows_examined: 1
use v_008;
SET timestamp=1342141221;
UPDATE users_sessions SET `upd_date` = '2012-07-12 22:00:16' WHERE id=4581;
# Time: 120712 22:00:29
# User@Host: v_s1[v_s1] @ localhost []
# Query_time: 5.578081 Lock_time: 0.000061 Rows_sent: 0 Rows_examined: 1
use venicep_018;
SET timestamp=1342141229;
UPDATE users_sessions SET `upd_date` = '2012-07-12 22:00:23' WHERE id=1044;


Could you please help me how to identify and fix this issue?

If further information is needed please let me knoe!

Thanks in advance to everyone.