I got itchy about magic quotes the other day because it’s the cause (through a fairly long cascade of errors) of some performance problems and runaways I’ve been seeing lately (pictured above).
But I deserve most of the blame for allowing a query like this to run at all:
SELECT type, data, count(*) AS hits
FROM wpopac_WPopac_bibs_atsk
WHERE data LIKE '%'
AND type IN ('subjkey','author', 'title')
GROUP BY data
ORDER BY hits DESC
LIMIT 7
As executed, it’s trying to select all 1.2 million records from the table, group them (a hugely memory intensive activity with text), and then report only the top seven.
It’s one of a few queries that returns the alternate searches in WPopac. I’m planning to rethink how that works, but I also should have built in a fail-safe to prevent it from trying to execute if the search variable is empty (the query above is written WHERE data LIKE '$searchterms%' or something like that). I’m amused that MySQL tries so hard to fulfill the search — so hard that it’ll consume all available RAM and swap to do so.
The sysadmin and DBA are now much happier — along with any user frustrated by poor performance — with this patched.
bug, bugs, mysql, patch, performance, queries, query, query failures, wpopac
Posted August 23, 2006 by Casey Bisson
Categories: Libraries & Networked Information, Technology. Tags: bug, bugs, mysql, patch, performance, queries, query, query failures, wpopac.
No Comments
No comments yet.
Comments RSS
TrackBack Identifier URI
Leave a comment
User contributed tags for this post:
catching bugs (27) - www.sexy arabe.com (18) - how to catch bugs (14) - www.sex arabe.com (13) - about (12) - catch you (10) - www.sexy arab.com (7) - www.sexy xxl.com (7) - www.sexy-arab.com (6) - how to catch june bugs (6) - catching june bugs (5) - ways to catch bugs (5) - sex arbe (5) - sex.arabe.com (4) - www.sexy.xxl.com (4) - www.sex arbe.com (4) - catch sexy (4) - sex arabe (3) - www.com catch (3) - www.google arabe.com (3) - www.arbe sex.com (3) - www.com.catch (3) - easy ways to catch bugs (2) - sexy.xxl (2) - sex arabe.com (2) - bug sXe (2) - Www.waptrick.com (2) - catching junebugs (2) - sex-arabe.com (2) - how to catch junebugs (2) - how to catch a june bug (2) - WWW.SEXY.XXL (2) - www.sexy xxl (2) - catch june bugs (2) - www.sex arbe (2) - 2how to do sex.com (2) - preventing catching bug (2) - sex arbe photo (2) - how to prevent catching bugs (2) - cute childrens quotes about catching bugs (2) - www.sexy. xxl.com (2) - arbe aflam (2) - catch bugs (2) - sex catch fighting (2) - www.sexy 4 arabic (2) - how do I prevent catching bugs on planes (2) - sexi xxl (2) - catching quotes (2) - www. sex arabe.com (1) - sexy کس (1) - xnxx performance probleme (1) - AFLAM ARBE (1) - cool ways to catch bugs (1) - mysql query consume all the ram memory (1) - www.sexy-arabe.com (1) - www photosex 89.com (1) - www.sexy.arabe (1) - 89 arbe.com (1) - 89.com.sexi movie (1) - WWW.SEXY ARBE.COM (1) - www.89.com.sexi (1) - seky xxl.com (1) - www.com sex arbe (1) - sxe.xxl.com (1) - private arabe.com (1) - www.89.com long videos sexy (1) - sxe @ xxl.com (1) - 8 ways to catch bugs (1) - xnxx bug (1) - www .sex arabe.com (1) - bug-sex.com (1) - sexy arabe.com (1) - sxe 18 arbe (1) - seky xxxl (1) - porno ten arbe (1) - www.com bugs (1) - photo sex catch (1) - sex arabe videos (1) - How long before you catch bugs (1) - catch fighting (1) - june bugs how to catch (1) - videos catch sexy (1) - quote catch bug (1) - catch sexy 2 (1) - catch bugs video google (1) - HOW DO THEY CATCH YOU (1) - quote catching bugs (1) - video de catch (1) - catch s xy (1) - BUGS THAT ARE ON YOU (1) - funny bug catching quotes (1) - catch (1) - arbe sexy (1) - www.sex.com.tr (1) - catch bugs information technology (1) - bugs to catch (1) - preventing catching bugs (1) - www.sexy.arabe,com (1) - bug catching quote (1) - www.com ctch (1) - bug sex.com (1) - how do I catch june bugs (1) - sex catch (1) - big bear june bugs (1) - how to catch june bug (1) - www.sex.arabe (1) - preventing junebugs (1) - www.sexy.89.com (1) - www.com vidéo catch (1) - catching bugs videos (1) - www.89.com sexi (1) - www.sexy 89.com (1) - before 16 sex com (1) - arabe sex (1) -
