Articles

Group Replication Setup in MySQL

Group Replication in MySQL: MySQL Group Replication and how to install, configure and monitor groups. MySQL Group Replication enables you to create elastic, highly-available, fault-tolerant replication topologies. MySQL Group Replication is a MySQL Server plugin that provides distributed state machine replication with strong coordination between… Read More

Master Slave Configuration in Jenkins

Dear Readers, In this article, we will see the following Master Slave Configuration in Jenkins. Steps to Follow : Master Server:👉Launch Master Server👉Install Jenkins Slave Server:👉Launch Slave Server👉Create SSH Password Authentication 👉Install java👉Generate SSH Key👉Move the Public SSH Key to Authorized keys👉Give Permission to the Authorized keys… Read More

MySQL Identifying unused indexes

Dear Readers, In this article, we will see MySQL Identifying unused indexes. Identifying unused indexes: MySQL doesn’t provide completely reliable options to get the accurate index usage details. Below listed are the some of the options available and some of the options are version specific… Read More

Top Oracle CPU & ELAPSED Queries

Dear Readers, In this article, we will see the following Top CPU & ELAPSED Queries. Top CPU Queries : select * from (SELECT dhst.sql_id,SQL_TEXT,X.CPU_TIME/1000000 CPU_Time_inSec,X.Num_Execs,round(((X.CPU_TIME/1000000)/X.Num_Execs),3) CPUPEREXEC, X.num_rows FROM DBA_HIST_SQLTEXT DHST, (SELECT DHSS.SQL_ID SQL_ID,SUM(DHSS.CPU_TIME_DELTA) CPU_TIME ,sum(executions_delta) as Num_Execs,sum(ROWS_PROCESSED_delta) as num_rows FROM DBA_HIST_SQLSTAT DHSS WHERE DHSS.SNAP_ID IN(SELECT… Read More

More Latest News »