Tag：plan
-
Time：2020-11-22
Author: Cui Yiding Up to now, “become a contributor series” has launched a series of activities such as “support ast restore to SQL”, “add build in function for tikv”, “vectorization expression”, etc.Taking advantage of the opportunity of tidb to optimize the database, we can take advantage of this opportunity to optimize the database. As we […]
-
Time：2020-11-22
preface It was mentioned in a MySQL sharing that some relevant knowledge points will be organized into corresponding articles. As a result of a period of time busy, there has been no time to sort out these related content. But what must be said must be implemented. The content of this chapter mainly focuses on […]
-
Time：2020-11-10
1. Open SQL Server 2016 configuration manager 2. Enable SQL server agent (msqlserver) service If it fails to enable the SQL server agent (msqlserver) service directly, do as follows: Select “SQL server agent (msqlserver)” — right click – properties; login identity – current account: change the account name and password to […]
-
Time：2020-10-28
numerical calculation 1. Overflow and underflow The first problem of numerical calculation is the overflow and underflow. Overflow means that the value is very large, overflow is Nan value, while underflow means that the value is very small, and underflow is 0. Numerical overflow is likely to lead to numerical calculation problems, so corresponding solutions […]
-
Time：2020-10-20
Author: Hu Chengqing background From 9:00-10:00 on January 11, 2019, a MySQL database ran out of CPU.Hardware configuration: 256g memory, 48 core Analysis process When we took over the problem, the scene was no longer there, and the information was limited, so let’s check the status at that time from the monitoring system. From the […]
-
Time：2020-10-18
Author: Wang ShunI am a member of the DBA team of aikesheng, who is responsible for the project of the company, dealing with database problems. I like to learn technology and delve into technical problems.Source: original contribution*The original content is not allowed to be used without authorization. Please contact the editor and indicate the source. […]
-
Time：2020-10-12
This article is part of the handout of the first issue of my 91 algorithm. The 91 algorithm is approaching the end of the first phase. The specific time of the two period will be concerned about my official account. Once open, the first time will be announced to the official account of “Li Kaga”. […]
-
Time：2020-10-6
stayPart 2: Spark core programming guideIn this paper, the core module of spark is explained. This article will discuss spark SQL, another important module of spark. Spark SQL is built on the basis of shark and released in May 2014. From the name, we can see that the module is a relational operation API provided […]
-
Time：2020-10-6
Author: Mokhtar Ali Ebrahim Crazy technology house Original text: https://likegeeks.com/budget-… No reprint without permission We all want to save money by sharing hosting, but for some sites, VPS and even dedicated programs are inevitable. If you have to make a more advanced plan, it may mean that your site is growing and getting more traffic […]
-
Time：2020-9-13
Because SQL server needs to back up the database regularly, we usually choose to create a maintenance plan in the management maintenance plan. When the maintenance plan created for various reasons is inappropriate or does not need to be deleted, sometimes it will prompt that it cannot be deleted and various prompts will report errors. […]
-
Time：2020-9-5
Flink has added Python support (pyflink) since version 1.9.0. The latest release of Flink 1.10 makes it clear that the functional features of pyflink ecology are gradually improved with the efforts of the community. In order to let everyone better use pyflink, pyflink community support program has been officially launched from now on! 01 why […]
-
Time：2020-8-25
“SQL at scale” (from pingcap official website) is a concise summary of tidb, and our tidb SQL Engine team is responsible for the “SQL” part of these three words, and its importance can be seen. The general processing flow of SQL in database can be briefly summarized as query optimization and execution. During this period, […]
