Data Structure
Networking
RDBMS
Operating System
Java
MS Excel
iOS
HTML
CSS
Android
Python
C Programming
C++
C#
MongoDB
MySQL
Javascript
PHP
In JavaScript, we can use window.location object to force a page to load another page. We can use the location object to set the URL of a new page. There are different ways – window.location.href property, window.location.assign() and window.location.replace() methods, to set the URL of a new page using the location object. We will discuss each of the property and methods in detail in this tutorial. Window.location.replace The first way is to use the window.location.href property. This property contains information about the current URL of the page, and it can be used to redirect the user to a new page. ... Read More
Shooting stars appear to be the gleaming indications of the warmth produced as these small shivers make a blip in the frigid night sky. The Shooting Star effect is one of the most unique background effects for dark-themed websites. Shooting Stars Animation is a fantastic example of a loading screen that keeps your attention for a long time while the rest of the material on the website loads. This effect can be utilised in page loaders and user interfaces. In this article, we will discuss about the method to create Shooting Star Animation effect using CSS. For this, we will ... Read More
As the ‘heap out of memory’ error message suggests, it occurs when any JavaScript code takes more memory than allocated memory, when we run any JavaScript program, the computer allocation particular memory to the JavaScript program. When we run code of JavaScript or any programming language, our computer creates a process and allocates fixed memory. When a program needs more memory size, it raises an error like heap out of memory. For example, if we create an array of size 1020 and try to initialize every array index with some value, the heap goes out of memory and raises ... Read More
In the Go, a binary tree is a tree data structure where each node has at most two children, as the left child and the right child. Go's built-in data structures and operations, like structs and pointers, can be used to create a binary tree. The tree's nodes can be visualized as structs with fields for the value kept at each node and pointers to any left or right children. There are three types of tree traversals- preorder, inorder and postorder. We will use two methods to implement the binary tree data structure. In the first method we executed pre-order ... Read More
We can optimize our web application in various ways, and cause our web page to load faster, and in a more efficient way, which not only will reduce the load on the web servers, but also increase the SEO rankings of the website. Let’s discuss the different ways through which we can optimize the web page, and understand them with the help of examples. Approach 1: Minimize the File Size as Much as Possible File size should be minimized as much as possible. This can be achieved by trimming unnecessary whitespaces from within the file, removing unnecessary comments, and/or replacing ... Read More
The important statistics collected for a performed query, including time, temporary tables, indexes, joins, and more, are gathered in the Query Stats SQL editor results tab (see the following two figures). Requirements Enabled query, and collect performance schema statistics. The performance_schema has statement instrumentation enabled. SQL Editor: Query Stats Visual Explain Plan By utilizing the additional data included in the enhanced JSON format, the visual explain feature creates and presents a visual depiction of the MySQL EXPLAIN statement. All EXPLAIN formats, including the standard format, the raw extended JSON, and the visual query plan, are available in ... Read More
The controls listed below can be used to examine and export performance report data (see the following figure) − Export − Export all entries from the current performance report, including all queries and values, together with any associated data (including column headings). opens an export file dialogue. Copy Selected − Copies a single entry from the current performance report together with any related data (and column titles). the system's clipboard is saved. a case in point Query Copy − This function copies the SQL statement that produced the performance report. the system clipboard is saved. Refresh − The performance ... Read More
The MySQL system variable values are displayed using SHOW VARIABLES. There is no privilege required for this statement. Only the ability to connect to the server is necessary. Syntax SHOW [GLOBAL | SESSION] VARIABLES [LIKE 'pattern' | WHERE expr] A LIKE clause, if present, tells SHOW VARIABLES which variable names to match. To choose rows based on broader criteria, use a WHERE clause. An optional global or session variable scope modification is accepted by SHOW VARIABLES − The statement displays values for global system variables when GLOBAL is used as a modifier. For new connections ... Read More
The handling of missing or incorrect values in queries that change the data is governed by MySQL Strict Mode. This contains the CREATE TABLE, UPDATE, and INSERT statements. When attempting to process the query with MySQL Strict Mode enabled, which is the default setting, invalid or missing data may result in warnings or failures. When Strict Mode is turned off, the identical query would have its missing or incorrect data modified and would result in a straightforward warning. This could appear to be the desired outcome, but with Strict Mode turned off, certain activities might have unanticipated effects. For instance, ... Read More
In this article, we are going to learn about collecting Mysql statistics and Metrics. Performance Dashboard View statistics about server performance in a dashboard. Open a query tab, choose the Management tab, and then click Dashboard in the Performance section of the Navigator sidebar to display the dashboard. The informational structure of the Administration - Dashboard tab is depicted in the following image. Performance: Dashboard Network Status This displays data on network traffic that the MySQL server has transmitted and received via client connections. The incoming network traffic, outgoing network traffic, and client connections are examples of data ... Read More