rendered paste bodymysql> 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';