In order to see the global locks in MySQL (Innodb), use the SHOW command. The below query shows the global locks as well owner of locks and waiters. The following query will also show transaction id and more related to Innodb.The query is as follows:mysql> SHOW ENGINE INNODB STATUS\GThe following ... Read More

In some situations, we need to recall activity again from onCreate(). This example demonstrates how to reload activity in Android.Step 1 − Create a new project in Android Studio, go to File ⇒ New Project and fill all required details to create a new project.Step 2 − Add the following ... Read More

In this section we will see some advanced features of Zilog Z-80 Microprocessor. These features are basically compared to the Intel 8085 Microprocessor.The features are listed below −Sr.No.Features & Description1Opcode CountIn this Microprocessor there are 698 Opcodes of different lengths.2Instruction LengthThe instructions can be divided into four categories according to ... Read More

This example demonstrates How to Dynamically Add Views into View.Step 1 − Create a new project in Android Studio, go to File ⇒ New Project and fill all required details to create a new project.Step 2 − Add the following code to res/layout/activity_main.xml. In the above code, we have ... Read More

The Zilog Z-80 is 40 pin DIP Microprocessor. Here we will see the actual pin level diagram of Z-80 and also the functional pin diagram of it.This is the actual pin diagram of Z-80 Microprocessor. Now we will see the functional pin diagram of it.Now let us see the Pin ... Read More

There is a single way by which you can set a global event_scheduler=ON even if MySQL is restarted. You need to set global system variable ON and need to use this system variable even if MySQL restart.For this, I am using system variable @@event_scheduler using select statement. The query is ... Read More

Now, in this section we will see how we can use the Zilog Z-80 Microprocessor to add Multi-byte numbers.In this example, we are using 4-byte numbers (56 2F 7A 89)16 and (21 FB A9 AF)16In the memory, at first, we are storing the byte counts, and then the numbers (from ... Read More

Given two lists, print all the common element of two lists. Examples − Input : L1 = [5, 6, 7, 8, 9] L2 = [5, 13, 34, 22, 90] Output : {5} Explanation The common elements of both ... Read More

C# has many operators that work on the left-right and righ-left associativity. Chanining depends on the left-to-right associativity on operators with same precedence. Operator precedence determines the grouping of terms in an expression. This affects evaluation of an expression. Certain operators have higher precedence than others do; for example, the ... Read More

The readline is UNIX specific module. It defines a number of functions to read and write history files in easier way from python interpreter. We can use this module directly or using the rlcompleter module. This module settings may affect the built-in input() method prompt and also the interactive ... Read More