Programming VIP

catalogue 1, Fundamentals of database system 1.1 concept 1.1.2 SQL language classification 1.1.3 data independence (physical independence, logical independence) 1.2 conceptual model 1.2.1 entity, attribute, code (key), entity type, entity set, relation 1.2.2 ER diagram and relationship model 1.2.3.ER to logical structure model 1.3 st ...

mysql IO replication exception - heartbeat is not compatible with local info 1. Problem description An IO replication exception case was recorded. One set of MySQL Cluster slave database on a system line had the problem of IO replication thread interruption at about 22:57 every day in the recent week. Check the error information "h ...

preface: In the process of learning mysql, you may have understood the concept of triggers. It is not clear whether you have studied triggers in detail. Recently, I read several documents about triggers and shared MySQL trigger related knowledge. 1. Introduction to trigger triggers are database objects related to tables. They trigger when th ...

Recently, many insertBatch codes have been written in new projects. It has been said that batch insertion is much more efficient than circular insertion. This paper will experiment. Is it true?Test environment:SpringBoot 2.5Mysql 8JDK 8DockerFirst, insert multiple pieces of data. Options:foreach loop insertSplicing sql, one executionInsert usin ...

1, Optimization direction 1. Five resources + kernel at host level 2. At the service level, find the core function of the service in the architecture → core optimization 3. Code, business level → assistance / assistance direction 4. Docking (tomcat connector nginx → php → fpm module fastCGI 9000) 2, Hardware optimizati ...

Article catalog Current situation of domestic databaseIntroduction to domestic databaseUse and adaptation of localization databaseSpecial grammar and precautions GBase8S precautionsOSCAR precautionsGaussDB100 precautionsProgram adaptationLocalization database performanceAdapt Activiti process engineMigration from Oracle and My ...

oninit commandexplainoninit -iInitialize the disk space of the root dbspaceoninitStart in online database modeoninit -jStart the database to single user modeoninit -sStart the database to static mode Start database to online mode Start GBase 8s. After starting with this command, GBase 8s enters the online service status and can provide ex ...

The SQL language provides two different ways to use it interactive Embedded Why introduce embedded SQL SQL language is a non procedural language Transaction processing applications require high-level languages There are differences in details between the two methods. In the programming environment, SQL statements need to be expanded Process of ...

1. JDBC template (concept and preparation) What is a JDBC Template? Spring framework encapsulates JDBC and uses JDBC Template to facilitate database operation preparation: Configure the database connection pool in the Spring configuration file: <!-- DruidDataSource dataSource = new DruidDataSource();--> <bean id="dataSource" clas ...

Basic operations of mysql (1) Create database CREATE DATABASE `school` Create table CREATE TABLE `student` ( #Table name `id` int(4) NOT NULL AUTO_INCREMENT COMMENT 'Student number', #Details of the elements of the column, column self increment `name` varchar(4) NOT NULL DEFAULT 'anonymous' COMMENT 'full name', `pwd` varchar(20) NOT ...