Procedure to find top IO SQLs


Comments

Post a Comment

Popular posts from this blog

Configure Delayed, hidden member and Arbiter in MongoDB

Steps to Configure Delayed, hidden member and Arbiter in MongoDB To configure replication please follow the below link. https://ferozmdba.blogspot.com/2020/07/mongodb-replication-and-sharding.html Points to remember Hidden member will always be a priority "0" Delayed member will be a hidden member and priority "0" member When you consider a hidden one, make sure that priority is also "0" When configuring a delayed on, make sure that it has priority "0" as well as it is hidden. Steps to make replica as hidden var config=rs.conf() config.members[3].priority=0; config.members[3].hidden=true; rs.reconfig(config); Steps to configure slave Delayed var config=rs.conf() config.members[4].slaveDelay=3600 rs.reconfig(config);
Read more

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

Tuples in Python

 Tuples Basically Tuples in Python are very similar to Lists, but, Tuples are immutable which means that they can not be modified/changed. We generally use Tuples to make sure the values are not changed like, dates, Year, and days of the week or dates on a Calendar.  Creating a Tuple: >>> my_t1=(1,2,3) >>> my_t2=('one','two','three') >>> my_t1 (1, 2, 3) >>> my_t2 ('one', 'two', 'three') -- check the length of tupple: >>> len(my_t1) 3 >>> len(my_t2) 3 -- Tuples can have mixed objects as like Lists. >>> my_t3=(1,'two',3,'four') >>> my_t3 (1, 'two', 3, 'four') -- indexing with tuples  >>> my_t3=(1,'two',3,'four') >>> my_t3[2] 3 Immutable Tuples We can not modify the value. Here is the example: >>> my_t3=(1,'two',3,'four') >>> my_t3[2]=4 Traceback (most recent call last):  ...
Read more