Programmer Think

catalogue Concept of index                 Database index                 Function of index                  Side effects of indexing Principles for creating indexes Classifica ...

What is TCC? TCC is the abbreviation of Try, Confirm and Cancel. It was first proposed by a paper entitled Life beyond Distributed Transactions:an Apostate's Opinion published by Pat Helland in 2007.TCC compositionTCC is divided into three stagesTry phase: try to execute, complete all business checks (consistency), and reserve necessary busines ...

Resource download: https://download.csdn.net/download/weixin_44893902/45602690 Exercise point design: fuzzy query, delete, add 1, Language and environment Implementation language: JAVA language.Environment requirements: MyEclipse/Eclipse + Tomcat + MySql.Use technology: Jsp+Servlet+JavaBean or spring MVC + Spring + mybatis. 2, Realiz ...

basic operation connect mysql -h address -P port -u user name -p password Database operation To view the current database: SELECT DATABASE(); Display current time, user name and database version: SELECT now(), user(), version(); Create Library CREATE DATABASE [IF NOT EXISTS] Database name database options -- Database options: -- ...

Today, we introduce a hospital physical examination reservation system based on SSM framework, which has complete functions. Project requirements: Functional requirements: The system is divided into three roles: system administrator, doctor and physical examination personnel. The system administrator mainly has the following f ...

Multi table query, also known as association query, refers to two or more tables completing the query operation together. Prerequisite: these tables queried together are related (one-to-one, one to many). There must be an associated field between them. This associated field may or may not have a foreign key. For example, employee table a ...

Software version used this time: IDEA: 2019.1.3 Professional Edition mysql: mysql 8.0.16 jdk: 17.0.1 tomcat: tomcat 9.0 JDBC version: 8.0.16 Preliminary preparation: 1. Put the JDBC driver in the lib folder of tomcat 2. Build a database in mysql, mine is "mydata", and then execute the following two pieces of code. CREATE TA ...

Preface The installation of Hive needs to be built on top of Hadoop (similar to Hbase), and two other blogs by the author can be referenced for standalone and pseudo-distributed installations of Hadoop: Detailed tutorial on single installation of Hadoop under Ubuntu (with required installation package downloads)Detailed tutorial on pseu ...

Wan A10: how does mysqldump achieve consistent backupExperimental sceneMySQL 8.0.25 InnoDBExperimental steps:Start general first_ Log observe the changes in the export execution processset global general_log=ON;mysqldump key parameter description:--Single transaction parameter description:Set the isolation level to REPEATABLE READ and start a r ...

1, Configure ELK log analysis system 1. Topology Configure and install ELK log analysis system, install cluster mode, two elasticsearch nodes, and monitor tomcat server logs hostoperating systemIP addressMain softwareNode1Centos7.4192. 168.8.15Elasticsearch,KibanaNode2Centos7.4192.168.8.16ElasticsearchapacheCentos7.4192.168.8.17Logst ...