How to deal with the serious waiting of shared pool in oracle database under linux environment
Recently, many LINUX environment databases of multiple customers have serious wait related to shared pool during peak business hours, including the library cache lock /latch: shared pool wait event, which leads to slow feedback from business users and failure to establish new business connections. &n ...
Posted by Loryman on Sun, 16 Feb 2020 20:52:03 -0800
MyCat for MySQL Middleware
I. MyCat Basic Concepts
1. What is MyCat
A thoroughly open source, large database cluster for enterprise application developmentTransaction enabled, ACID enabled, enhanced database that can replace MySQLAn enterprise database that can be considered a MySQL cluster to replace the expensive Oracle clusterA new type of SQL Server which combines ...
Posted by mike1313 on Sun, 16 Feb 2020 15:40:39 -0800
The best location of book information table based on chain storage structure
The best location of book information table based on chain storage structure
describe
Define a linked list containing book information (book number, book name, price), read in the corresponding book data to complete the creation of the book information table, and then search for the books in the ...
Posted by aquayle on Sun, 16 Feb 2020 04:07:07 -0800
MySQL highly available KeepAlived + Dual hosts
MySQL highly available KeepAlived dual hosts
In the production environment, one MySQL host has a single point of failure, so we need to ensure the high availability of MySQL, that is, two MySQL servers. If one of the MySQL servers hangs up, the other can take over immediately.MySQL's high availability schemes are generally as follows: keepali ...
Posted by Joe Haley on Sat, 15 Feb 2020 21:49:04 -0800
Spring boot 2.0.3 integrated druid data source and monitoring
I. Druid
Druid is the best database connection pool in the Java language, and also the open source project of Alibaba. Druid is a database connection pool developed by Alibaba called monitoring. In terms of function, performance and scalability, Druid is superior to other database connection pools, including DBCP, C3P0, BoneCP, ...
Posted by Alffallen on Sat, 15 Feb 2020 11:20:50 -0800
Analysis of bootstrap switch control
Basic example:
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8" />
<meta name=viewport content="width=device-width, initial-scale=1">
<title>bootstrap Example of switch</title>
<link href="bt/css/bootstrap.min.css" rel="stylesheet" />
<link href ...
Posted by JChilds on Sat, 15 Feb 2020 07:17:12 -0800
DL based on Python Day2 multi-layer perceptron
1. Text preprocessing
Text is a kind of sequence data. An article can be regarded as a sequence of characters or words. Text preprocessing usually includes four steps:
1. Read in text
2. participle
3. Establish a dictionary to map each word to a unique index
4. Transform the text from the sequence of ...
Posted by X74SY on Fri, 14 Feb 2020 06:30:27 -0800
Java realizes online examination system (administrator function)
In this examination system, the three roles of administrator, teacher and student are equivalent to three systems.Online examination system administrator login pageSubject management page (subject can be added, deleted, modified and checked)
/**
* Query accounts in pages and show them to the page
* ...
Posted by Sfoot on Fri, 14 Feb 2020 05:10:24 -0800
Overview of mysql database and its basic operation 1
1, Introduction of database and related concepts
Database: warehouse for storing data;
1.DB(DateBase)
data base
A collection of data organized according to a data model and placed in storage
2.DBMS(DateBase Management System)
Database management system
Service software for manipulating and managing da ...
Posted by kkeim on Fri, 14 Feb 2020 04:54:00 -0800
Neat javascript code
variable
1. Use intuitive and meaningful variable names
Bad:
const yyyymmdstr = moment().format("YYYY/MM/DD");
Good:
const currentDate = moment().format("YYYY/MM/DD");
2. Use the same words for variables of the same type
Bad:
getUserInfo();
getClientData();
getCustomerRecord();
Good:
getUser(); ...
Posted by faifas on Thu, 13 Feb 2020 14:24:58 -0800