Guys,

Found an interesting article related to query Sniffing in MYSQL.

https://wikitech.leuksman.com/view/Querybane

The idea here is to look for problematic queries running for a long time and identifying them based on a certain set of rules and killing them...Seems to be very good idea, b'cos we faced problems of problematic queries running in the server affecting lot of users. Automated query killers like these may come handy in these sort of situations

Your thoughts?

Thanks
Shiva...

Hi Shiva,

The given link is not working for me. I am using IE7 browser.

thanks

__________________
Karpagarajan. R
Necessity is the mother of invention

Hi Karpagarajan,

Just checked with the link in IE 6.0 and it seems to be working.

Maybe in IE7 they would've made some added security for accessing Secured pages.

Thanks
Shiva...

Yes Shiva,

It is giving error - "website's security certificate" only in IE7. But it is working in IE6.

It is useful one. The query Sniffing in MYSQL is very useful to kill the problematic queries. Do you know, this kind of query sniffing available in ORACLE?

I think, if we want to kill particular query, we should kill that process(PROCESS ID). But i think it is not possible to identify the problamatic query in oracle . We need to test those queries in SQL prompt and if the query is working fine, then only it should be taken for production server.

This one is good shiva

thanks

__________________
Karpagarajan. R
Necessity is the mother of invention

Mr.Shiva,


Its really very interesting article, need to spend time for this to read the complete article.

Hope it will help us a lot ..

__________________
-Murali..