MySQL Forums
Forum List  »  Quality Assurance

Slow Queries
Posted by: Diego Tucci
Date: July 12, 2012 07:30PM

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.

Options: ReplyQuote

Written By
Slow Queries
July 12, 2012 07:30PM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.