MySQL slow log strange entries
Hi allI've been looking through a MySQL slow log this morning (parsed though 'mysqldumpslow') and have found a large number of strange queries which have taken a lot of time.
They all involve random letters for some reason. See the examples below:
SELECT * FROM users WHERE UName='S' AND UPass=PASSWORD('S') AND External='S' AND Enabled='S'
SELECT Ranges FROM fbsupergroups WHERE CompanyName='S' AND Name='S'
SELECT * FROM headline WHERE id = N
SELECT County FROM projects WHERE LEFT(RefNo, N)!='S' GROUP BY County
They are all different sites using different databases.
Does anyone know what might be causing this? Has anyone seen anything like it before?
Cheers
Matt