Programmer Think

Next: Interviewer: you said that you are proficient in Docker. Let's talk about Dockerfile in detail 1, Communication between containers 1. One way communication 1.1 what do you mean mysql and tomcat are two independent containers, but tomcat needs to communicate with mysql, and mysql does not need to communicate with tomcat at all, which is c ...

The following adjustments are made in the test environment, then the documentation is written. System tuning: 1. Kernel Parameter Adjustment additional net.ipv4.ip_local_port_range = 1024 65535 net.core.somaxconn = 2048 net.core.rmem_default = 262144 net.core.wmem_default = 262144 net.core.rmem_max = 16777216 ...

1. Official website address Demo address on official website https://fly.layui.com/ Template download address: https://www.layui.com/template/fly/ Detailed development documents: https://www.sunnyblog.top/index.html?typeId=1260457825721647104 2. Technology stack Development tool Idea Database design JDK version Java8 Database MySQL v5. ...

1, Background High availability is another major feature of TiDB. All three components of TiDB/TiKV/PD can tolerate partial instance failure without affecting the availability of the whole cluster. The following describes the availability of these three components, the consequences of a single instance failure, and how to recover. TiDB T ...

1. Query every s in fruits table_ All f corresponding to ID_ Name value #Compact in groups mysql> select s_id,group_concat(f_name) as name from fruits group by s_id having count(f_name) > 1; 2. Same statistics s_ What are the rows of ID values? mysql> select s_id,count(*) as total from fruits group by s_id with rollup; Note: the role ...

Author: Yang Taotao Senior database expert, specializing in MySQL for more than ten years. Good at mysql, PostgreSQL, MongoDB and other open-source database related backup and recovery, SQL tuning, monitoring operation and maintenance, high availability architecture design, etc. At present, he is working in aikesheng, providing MySQL related ...

<dependency> <groupId>com.github.pagehelper</groupId> <artifactId>pagehelper</artifactId> <version>5.1.8</version> </dependency> <dependency> <groupId>com.github.pagehelper</groupId> <artifactId ...

Preface It's been a month since I joined the new company, I've finished the work at hand, and the last few days I finally have time to research the code for my old project.During the process of researching the code, I found that Spring Aop was used in the project to separate the database from reading and writing, and to learn in my own way (I d ...

Install apache yum install -y httpd Start apache systemctl start httpd Set apache to power on automatically systemctl enable httpd Access public network address to check whether apache is normal Install MySQL database wget -i http://dev.mysql.com/get/mysql57-community-release-el7-10.noarch.rpm yum -y install mysql57-community-release-el7-10 ...

view Meaning: Understand as a virtual table and use it like a regular table A new feature of MySQL version 5.1 is data generated dynamically from tables For example: a comparison between a dance class and an ordinary class Differences between views and tables: Name Create Grammar Keyword Use Occupy physical space view ...