Hi and I have a database with over 32 million entries and whenever I try the below mysql query or simular it crashes the sql server unless I use phpmyadmin. I have 4 columns all indexed and all are the char() type with a fixed length. Below is an example query
SELECT `id` FROM `hashes` WHERE `sha1`="<º5AD@$;\"#"
Also my column structure is as follows
id = char(7) crc32 = char(5) crc32b= char(5) sha1 = char(12)
All of those columns are indexed. I have a 2GB index. Does anybody know why this query crashes my sql server?