Arthas: an artifact for troubleshooting. It was brutally abused by MySQL in the first battle

I thought it might be a log problem, but there is no evidence to support it. The trace command can monitor the time consumption of each step, and can cooperate with the conditional expression to print a detailed log when the time consumption exceeds xx ms. Find a machine, enter a command, and then wait. When rt spikes appear again, the time-c ...

Posted by hr8886 on Sat, 18 Dec 2021 09:37:44 +0100

MySQL basic learning notes - Day01

1. Concept of database DB: database: a "warehouse" for storing data. It holds a series of organized data;DBMS: Database Management System. Database is a container created and operated by DBMS;SQL: Structure Query Language: a language specially used to communicate with the database;Relationship diagram of the three: 2. Common ...

Posted by Hurklefish on Sat, 18 Dec 2021 04:19:36 +0100

Joint query of Mysql

Joint query of Mysql union of joint query union can merge tables queried by more than two select statements and eliminate duplicate rows in the table. The select statement needs to have the same number of columns with the same data type. 1. Query the ID and province name of each province in China select ProID,ProName from T_Province 2. I ...

Posted by moe on Sat, 18 Dec 2021 00:51:58 +0100

Basic usage of mysql

mysql application: 1.client: client program, which connects to the server 2.SQLyog is easy to use and can be executed directly from multiple command lines. 3. Send e-mail: the default port is net25. The default port of the database is 3306. This port is unified according to the port of the server 4.server side: on linux. show databases; Displa ...

Posted by Mchl on Fri, 17 Dec 2021 23:27:40 +0100

[Step into Stack 1, Java for first-line Internet architects building essential skills

<dependency> <groupId>org.springframework.cloud</groupId> <artifactId>spring-cloud-starter-netflix-hystrix</artifactId> </dependency> <dependency> <groupId>org.springframework.cloud</groupId> <artifactId>spring-cloud-starter-alibaba-nac ...

Posted by d.shankar on Fri, 17 Dec 2021 21:55:02 +0100

[Vue basic knowledge summary 6. Build a highly available enterprise database cluster with Mycat and Mysql

NPM ======= 1, Introduction to npm The full name of NPM is Node Package Manager JS package management tool is the world's largest module ecosystem, in which all modules are open source and free; It's also a node JS package management tool, which is equivalent to Maven on the front end. 1. Installation location of NPM tools Through npm, w ...

Posted by aeboi80 on Fri, 17 Dec 2021 21:22:41 +0100

Tools | common MySQL kernel debugging skills

Author: Ke Yuchang consultant Software EngineerCurrently engaged in container R & D of RadonDB MySQL, graduated from Huazhong University of science and technology, and has many years of experience in database kernel development.Mastering the reading and debugging ability of MySQL kernel source code is not only the daily work of database R & ...

Posted by imtaqi on Fri, 17 Dec 2021 14:56:05 +0100

Xtrabackup download and installation (full incremental backup)

preface The database needs to be started during backup and closed during recovery 1, What is Xtrabackup? MySQL cold standby, mysqldump and MySQL hot copy cannot realize incremental backup of the database. In the actual production environment, incremental backup is very practical. If the data is greater than 50G or 100G and the stora ...

Posted by icaro on Fri, 17 Dec 2021 14:06:04 +0100

Basic knowledge summary of MySQL database

Objectives of this unit 1, Why learn database 2, Related concepts of database DBMS,DB,SQL 3, Characteristics of database storage data 4, Initial MySQL MySQL Product introduction MySQL Product installation ★ MySQL Start and stop of services ★ MySQL Login and logout of services ★ MySQL Common ...

Posted by kf on Fri, 17 Dec 2021 10:48:50 +0100

Performance tuning cases

Performance tuning cases time2021-09-02environmentcentos7. 6. JMeter, redis, mysql, Java applications 1, jmeter's command line uses give an example: # Run in command line mode and execute test JMX test script, and save the test results to result In JTL jmeter -n -t test.jmx -l result.jtl # Specify IP distributed operation jm ...

Posted by inrealtime on Fri, 17 Dec 2021 04:24:35 +0100