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';