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,