General Installation Guide
The following sections contain the information you need to select, download, and validate your distribution, and the instructions later in this chapter describe how to install the selected distribution.
MySQL version and distribution version to install
MySQL can be used on many operating systems and platforms. For inf ...
Posted on Sat, 06 Jul 2019 11:42:35 -0700 by dbakker
There are many ways to serialize C++. I recommend boost here. A simple tutorial.
The boost method is to add a friend class object to the class definition and implement the serialize() method to make the class serialized. To use boost serialization, you first need to download the boost file from the boost official website, an ...
Posted on Fri, 05 Jul 2019 16:56:39 -0700 by pjoshi
Recently, the sql script of the project has been revised and several tables have been added. Three tables need attribute self-increment. AUTO_INCREMENT can be used directly in mySql. oracle has no self-increment function. It needs to write trigger manually to realize self-increment function. Solutions have been found online. Posted ...
Posted on Fri, 05 Jul 2019 13:26:53 -0700 by brynjar
C3P0 of Database Connection Pool
In the last section, we touched on the database connection pool, learned about the role of the database connection pool, and used DBCP to operate the database through a small case. In this section, we then learned about another implementation of the database connection pool, C3P0.
A Brief Introduction to ...
Posted on Thu, 04 Jul 2019 12:33:45 -0700 by pkedpker
When MySql deadlocks occur, InnoDB automatically detects transaction deadlocks, rolls back immediately, and returns errors. Rollback usually chooses the transaction with the smallest undo amount.
Prior to MySql 5.6, the last deadlock that occurred could be returned by using the SHOW ENGINE INNODB STATUS command. After MySql 5.6, all InnoDB de ...
Posted on Thu, 04 Jul 2019 11:27:07 -0700 by Rowno
Common http verbs
Implementation of WebApi in Asp.NetCore
3.1. Create a WebApi project.
3.2. Integrated Entity Framework Core operation Mysql
3.2.1. Install related packages (for the Xxxx.Infrastructure project)
3.2.2. Create Entity and Context
3.2.3. Injecting EF services into ConfigureService
3.2.4. Migrate Datab ...
Posted on Mon, 01 Jul 2019 10:46:29 -0700 by audiomove
Classification of SQL statements
Classification of SQL statements
DDL (Data Definition Languages) statement: Data Definition Language.These statements define different data segments,
Definition of database objects such as databases, tables, columns, indexes, etc.Common statement ke ...
Posted on Mon, 01 Jul 2019 09:52:57 -0700 by iceblox
First, what is MySQL multi-instance?MySQL multi-instance simply means installing a set of MySQL programs on a server to provide access through different ports. Multi-instance not only saves the cost of physical host, but also effectively improves the efficiency of CPU and disk I/O of single physical host, and can deploy database HA between mult ...
Posted on Sun, 30 Jun 2019 14:51:19 -0700 by elthomo
Gateway: Routes user requests to a specified service and forwards the Session information contained in the front-end Cookie;
User Services: Authentication, Authority, Redis Session Management
Other services: Depend on user information in Redis for interface request validation
Structure Design of User-Role-Permissio ...
Posted on Wed, 26 Jun 2019 09:18:01 -0700 by filn
Simply learn xml and look at it on w3school.
Looking at the contrast and difference between xml and Json, this blog is still very detailed:
Knowing this problem is also good, learn to rise posture:
Now let' ...
Posted on Tue, 25 Jun 2019 17:30:29 -0700 by mingwww