However, there are times when this feature actually slows down the performance.
An excellent example & explanation about this is discussed on the article I linked here.
I experienced a similar situation – a query is reading multiple indexes + intersect + sort it = CPU intensive, AND turned out it's executed several hundred times per #second.
It ended up overloading the database server pretty spectacularly 🙂
The (temporary) quick fix is to execute the following command in MySQL console :
SET GLOBAL optimizer_switch="index_merge_intersection=off"
Then once you implemented the correct solution to the problem (change the query / create a new compound index / etc), don't forget to turn it on again.
Otherwise other "innocent" queries might suffer because of it 🙂
Embedded Link
The Optimization That (Often) Isn’t: Index Merge Intersection – MySQL Performance Blog
Prior to version 5.0, MySQL could only use one index per table in a given query without any exceptions; folks that didn’t understand this limitation would often have tables with lots of single-column indexes on columns which commonly appeared in their WHERE clauses, and they’d wonder why the EXPLAIN plan for a given SELECT would […]
Post imported by Google+Blog for WordPress.
oh gituh ya.. oke pa terimakasih
thanks untuk info dan sharenya
wow nice,..thx
REVADSNETWORK 90% Revenue Sharing
Wow..Mantap Sharenya..
share yang wokeh deh..
MySQL : careful with index_merge sangat bermanfaat
• Gan, Makasih banget Informasi dari agan memang lagi saya cari, dan Alhamdulillah nyanthol disini. Mantap….Nyus Banget Gan. Langsung mau Ane Praktekin. Buat Pembaca Yang Baru berkunjung….Sering-sering aja Mampir kesini…Infonya selalu Mak Nyus…TOP BGT.
• Luar Biasa…. Postingan info Ini Very Well and Recommended Untuk temen –Temen yang lagi Nyari. Joss…
Ini dia yang saya cari mas, lumayan untuk belajar untuk tugas akhir nanti 😀
mantab nano spray
keren bang
maksih banyak infonya gan ,,
terima kasih sob buat informasinya!
artikel MySQL : careful with index_merge sangat bermanfaat..
thank you for sharing this info, very usefull…
semuanya ingin dapat backlink.. he
Makasih untuk informasinya, sangat menarik untuk di pahami
artikelnya menarik sekali, d tunggu artikel berikutnya.
Nice infonya mas 🙂
keren banget gan infonya ,, makasih udah share ya ,,
artikelnya bagus sekali, terima kasih yah.
MySQL : careful with index_merge wow, keren
thanks MySQL : careful with index_merge wow, keren
thanks MySQL : careful with index_merge : sangat bagus gan
MySQL : careful with index_merge : menarik sekali gan
MySQL : careful with index_merge mantap gan
makasih atas MySQL : careful with index_merge
mantep gan MySQL : careful with index_merge
MySQL : careful with index_merge
keren ya gan MySQL : careful with index_merge
nice info maksih ya gan
oke pa. kita saling percaya aja ya. 😀
makasih beritanya. bagus isi artikelnya.
MySQL : careful with index_merge mantep
bagus artikel MySQL : careful with index_merge
Informasinya sangat bagus sekali
semoga tetap jaya..
saya tunggu infonya yang baru y..
MySQL : careful with index_merge mantep gan..
nice info .. thank’s n reggard’s
obat sipilis ampuh
pegobatan sipilis
cara mengobati sipilis
cara mengobati wasir
obat wasir alami
obat wasir manjur
MySQL : careful with index_merge oke gan mantep
info yang anda berikan memang bermanfaat. thanks ga
artikelnya bagus sekali mas
makasih artikel “MySQL : careful with index_merge”
MySQL : careful with index_merge keren banget gan
thanks for “MySQL : careful with index_merge” amazing..keep post
MySQL : careful with index_merge bagus gan thanks
makasih MySQL : careful with index_merge nya
wow amazing “MySQL : careful with index_merge”
“MySQL : careful with index_mergeâ€
setelah d baca mantep mas
“MySQL : careful with index_merge†keren juga artikelnya.
“MySQL : careful with index_merge” mantep gan
oh gituh ya..
oke pa terimakasih semua beritanya. salam sukses aja
“MySQL : careful with index_merge†mantap sekali mas
“MySQL : careful with index_merge†artikelnya bermanfaat..
“MySQL : careful with index_merge†artikelnya mantap
wow , artikel yang bagus gan
amazing, keep update
artikelnya bermanfaat.. numpang promo ya gan 🙂 http://www.cara-main-sbobet.com/
“MySQL : careful with index_merge†menarik gan
oke banget artikelnya
“MySQL : careful with index_merge” mantap mas
MySQL : careful with index_merge mantap
mantap mas
“MySQL : careful with index_merge” mantap om
wah keren ni artikelnya
MySQL : careful with index_merge bagus artikelnya
wow mantaaaaaap
thanks brooo!
makasih banyak informasinya mas
thanks for “MySQL : careful with index_merge†amazing..keep post
update gan, keren2 nih
wow keren nih webnya
keren2 nih postnya..
ga ngerti 🙁
okay,,,, thank you very helpful article,,,,
bagus materinya!
update gan, bagus2 ini artikelnya
MySQL : careful with index_merge like this!
wow, thanks for share..
mantep postingannya gan..
gak begitu paham, hehehehe
salam super buat admin,
Can you be more specific about the content of your article? After reading it, I still have some doubts. Hope you can help me.