vals = ABS(vals) + 1
name = 'somename'
where name is varchar(30) latin1_bin, vals — int(10).
The Table Is InnoDB.
Hosting 1Gb VDS-1024 CentOS
In the table to 30 entries.
The query is from 0.003 to 10 seconds.
With the admin already broke all the legs, tried all sorts of tests, recommending a config with the best settings, etc.
The question is — where to look?
On the local machines such as brakes never happens.