Working on machines without understanding them ? Then you should be here..
Geographical location should not become a barrier to Share our knowledge.
Puzzles and Interview question are intended to be discussed here.
"Query end" state in MySql appears to consume a lot of time which becomes a bottleneck for insert operations.
I had written a stored Procedure in Mysql which implements a cursor to iterate over the rows of a table. This cursor worked well on my machine but it took a lot of time in the live environment (POC setup).
Initial culprit seemed to be the hardware but after analysing the procedure with "show processlist", I found that every insert would...
Friday, August 23, 2013
Subscribe to:
Posts (Atom)