Programmer Think

Note: this content is compiled from the MySQL video of Shangshan Silicon Valley Station B >>MySQL video of Shangsi valley station B The previous chapter talked about SQL single line functions. In fact, there is another kind of SQL function, which is called aggregation (or aggregation, grouping) function. It is a function that summari ...

Redis breakdown Redis cache breakdown refers to the sudden failure of a very hot key (i.e. more keywords searched on the client). At this time, a large number of requests sent from the client cannot find the key in redis, they will find it in the data, and eventually lead to excessive pressure and collapse of the database. Solution: 1. Set th ...

Transfer from Explain MySQL data types in detail , the content is slightly modified. integer data type Number of bytes Signed minimum Signed maximum Unsigned minimum Unsigned maximum TINYINT 1 -128 127 0 255 SMALLINT 2 -32768 32767 0 65535 MEDIUMINT 3 -8388608 8388607 0 16777215 INT 4 -2147483648 2147483647 0 4294967295 BIGINT 8 ...

01. Nacos 1. Introduction It is said that Nacos has more than 100000 instances running inside Alibaba, which has passed the test of various large traffic such as double 11 C: Consistency: all nodes see the same data at the same time A: Availability: all requests receive a response P: Partition tolerance: CPA theory ...

introduction In actual business development, data interaction between multiple tables is often involved. At this time, single table query can no longer meet complex business requirements, so multi table connection query is needed; Connection query is mainly divided into the following three types: Inner connection Equivalent connectionNon ...

Top level distribution analysis of LAMP architecture in Linux system theory 1, LAMP (Linux Apache MySQL PHP) LAMP It has the advantages of universal, cross platform, high performance and low price LAMP Whether it is performance, quality or price, it is the preferred platform for enterprises to build websites (1) Distribution interpretation ...

Tomcat Statement: This is the note I took when I taught you to learn Java at station b with up master Nange. I'll share it with you Video address: https://www.bilibili.com/video/BV1NE411Q7Nx If there is any offense, please contact me to delete web application server: Tomcat, Jboos, Weblogic, Jetty Install Tomcat Download the co ...

1, SpringBoot project environment IntelliJ IDEA 2018.3.2Mysql 5.1 2, Tencent cloud CentOS 7.6 image server Students can apply for Tencent cloud student exclusive, 27 yuan for three months 3, Attention (1) XShell Modify host namehostnamectl set-hostname master #Set to master name View current hostnamehostname After modifying the hos ...

query Simple query Query all mysql: SELECT e.* From emp e oracle: SELECT e.* From emp e; Query specific columns mysql: SELECT e.empno,e.ename,e.job from emp e oracle: SELECT e.empno,e.ename,e.job from emp e Alias use mysql: select e.empno 'Employee number',e.ename 'Employee name',e.job 'Employee position',e.mgr 'Superior ...

1, Presto overview 1. Introduction to Presto Presto is an open source distributed SQL query engine, which is suitable for interactive analysis and query. The data volume supports GB to PB bytes. Although Presto has the ability to parse SQL, it does not belong to the standard database category. Presto supports online data query, including Hiv ...