Procedure to find top IO SQLs


Comments

Post a Comment

Popular posts from this blog

Devops

Maven Maven is an Open Source, Java-based build tool and developed by Apache. Maven is a powerful project management tool that is based on POM (project object model).  It is used for project build, dependency, and documentation. Different build tools: Java           -> ANT/Maveen/Gradle .Net            -> Nant/MS Build Python      -> PyBuilder Ruby          -> Rake Using Jave can be developed 3 different types of applications: a) Standalone Applications: Types of packages: jar (Java Archive) Examples: .java  .class .jar b) Web Applications Types of packages: war (Web Archive) Examples: Java Code + Web content (Html, CSS, JS, Images) - static contents c) Enterprise Applications Types of packages: ear (Enterprise Archive) Examples: How to run the java class "welcome.java"? Step-1: compile the .java file using javac javac welcome.java .jav files are human-readable forma...
Read more

rs.stepDown() in MongoDB replication

It instructs the primary of the replica set to become a secondary. After the primary steps down,the eligible secondaries will hold an election for primary. Generally, the rs.stepDown() does not immediately step down the primary. If no electable secondaries are up to date with the primary, the primary waits up to secondaryCatchUpPeriodSecs (by default 10 seconds)  for a secondary to catch up. Once an electable secondary is available, the method steps down the priamry.  Once stepped down, the original primary becomes a secondary and is ineligible from becoming primary again for the remainder of time specified by stepDownSecs. The rs.stepDown() method attempts to terminate long-running user's operations that block the primary from stepping down, such as an index build, a write operation, or a map-reduce job. Syntax: rs.stepDown(stepDownSecs, secondaryCatchUpPeriodSecs)
Read more