All pastes #923654 Raw Edit

Something

public text v1 · immutable
#923654 ·published 2008-02-29 19:09 UTC
rendered paste body
mysql> describe konline;
+--------+------------------+------+-----+---------+-------+
| Field  | Type             | Null | Key | Default | Extra |
+--------+------------------+------+-----+---------+-------+
| sid    | varchar(50)      | NO   | PRI |         |       |
| uid    | int(11)          | YES  | UNI | NULL    |       |
| cc     | varchar(3)       | NO   |     |         |       |
| vreme  | int(10) unsigned | NO   |     |         |       |
| strana | varchar(15)      | NO   |     |         |       |
| ipadr  | varchar(15)      | NO   |     |         |       |
| uagent | char(90)         | YES  |     | NULL    |       |
+--------+------------------+------+-----+---------+-------+
It's an InnoDB table, here are slow queries, no idea what to do :/

# User@Host: sql_wbrod[sql_wbrod] @ localhost []
# Query_time: 2  Lock_time: 0  Rows_sent: 0  Rows_examined: 0
SET timestamp=1204229336;
update konline set vreme = unix_timestamp() where sid = '7ibh8rpiadccqmk86m259r2la0';
# Time: 080229  4:58:56
# User@Host: sql_wbrod[sql_wbrod] @ localhost []
# Query_time: 2  Lock_time: 0  Rows_sent: 0  Rows_examined: 0
SET timestamp=1204257536;
update konline set vreme = unix_timestamp() where sid = 'gcck0e5tbhpigk7u04pvse1pg4';
# Time: 080229 12:25:43
# User@Host: sql_wbrod[sql_wbrod] @ localhost []
# Query_time: 2  Lock_time: 0  Rows_sent: 0  Rows_examined: 0
SET timestamp=1204284343;
update konline set vreme = unix_timestamp() where sid = 'sgbnu52r768ji9qq2s3udcn0v5';
# Time: 080229 13:32:52
# User@Host: sql_wbrod[sql_wbrod] @ localhost []
# Query_time: 2  Lock_time: 0  Rows_sent: 0  Rows_examined: 0
SET timestamp=1204288372;
update konline set vreme = unix_timestamp() where sid = 'jjq0nl41s6runvou4beeqsdtj7';
# Time: 080229 17:32:03
# User@Host: sql_wbrod[sql_wbrod] @ localhost []
# Query_time: 2  Lock_time: 0  Rows_sent: 0  Rows_examined: 0
SET timestamp=1204302723;
update konline set vreme = UNIX_TIMESTAMP(), strana = 'brodarnetovci' where sid = '2nt9ngrtps9fk6u5rkrdbrnrb3';
# User@Host: sql_wbrod[sql_wbrod] @ localhost []
# Query_time: 2  Lock_time: 0  Rows_sent: 0  Rows_examined: 0
SET timestamp=1204302723;
update konline set vreme = unix_timestamp() where sid = '0u6dfk7b8qpmkm6785i8uupis1';
# Time: 080229 18:43:22
# User@Host: sql_wbrod[sql_wbrod] @ localhost []
# Query_time: 2  Lock_time: 0  Rows_sent: 0  Rows_examined: 0
SET timestamp=1204307002;
update konline set vreme = unix_timestamp() where sid = 'fv569p4is40bksbph35m8ooml4';