Programmer Think

Original Link: http://www.yiidian.com/jdbc/jdbc-callablestatement.html 1 CallableStatement interface The CallableStatement interface is used to call stored procedures and functions. By using stored procedures and functions, we can write business logic on the database, which will improve performance because they are precompiled. 2 What is the di ...

order This paper mainly studies MySQL plugin of skywalking skywalking-plugin.def skywalking-6.6.0/apm-sniffer/apm-sdk-plugin/mysql-8.x-plugin/src/main/resources/skywalking-plugin.def mysql-8.x=org.apache.skywalking.apm.plugin.jdbc.mysql.v8.define.ConnectionImplCreateInstrumentation mysql-8.x=org.apache.skywalking.apm.plugin.jdbc.mysql.v8.define ...

Article directory 1. Cache table data in memory 2. Parameter optimization 1. Cache table data in memory Performance tuning is mainly about putting data into memory. Caching data in memory can improve performance by directly reading the value of memory. In RDD, use rdd.cache or rdd.persist to cac ...

Redis - using Gearmand as mysql cache server Article directory Redis - using Gearmand as mysql cache server 1. What is gearland? 2. Deployment process 3. test 1. What is gearland? Gearmand is a machine used to delegate work to other machines, distributed calls are more suitable for doing a c ...

Author: Wei Xinping, the 5th MySQL practical class student of zhishutang, the 10th MySQL optimization class student, now works as a teaching assistant. Maximum length of varchar(n) and char(n) I believe that as a dba, it is often asked this question. What is the maximum length. How many bytes or how many characters. In fact, this is not very ...

Article directory 1. Basic concepts of full synchronous replication (Group replication) 1.1 group replication model: 1.2 group replication principle: 2. Realize group replication server1: (initiating node) Configure on server2 and server3: Test: 1. Basic concepts of full synchronous replicat ...

NDB cluster installation introduce https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-basics.html NDBCLUSTER (also known as NDB )Is a memory storage engine that provides high availability and data persistence. Of NDBCLUSTER The storage engine can be configured with a range of failover and load balancing options, but the simplest is to start ...

1 problem description Using the Scrapy framework, complete the collection of bidding information on the Internet. The collection fields are as follows: 2 Tips for problem solving Some pages of the Internet must be logged in to get response. You need to log in manually and get the Cookie value in t ...

Article directory The role of @ profile 2 two ways to activate the environment Source address of demo of this bloghttps://github.com/suchahaerkang/spring-annotation.git The role of @ profile @Function of Profile: switch between different environments, and register different components to the con ...

1, Connect to database Do not use database management software (such as Navicat, etc.), connect mysql server through dos, and then operate database General format for connecting to database: mysql -P port number - h mysql host name or ip address - u user name - p Explanation: (- P upper case P represe ...