explain analyze in MySQL 8.0
Original address: https://mysqlserverteam.com/mysql-explain-analyze/
MySQL 8.0.18 was just released. October 17, 2019 ), which includes a new feature to analyze and understand how queries are executed: explain analyze.
What is explain analyze
EXPLAIN ANALYZE is a query analysis tool that tells you how much time MySQL spends on queries and why ...
Added by dw89 on Fri, 29 May 2020 19:45:52 +0300
Golang uses selenium to operate Chrome
Golang uses selenium to operate Chrome
1. Demand
Solve the problem of automatic login, and solve the problem of crawler by the way.
2. Basic concepts
Selenium: selenium is a tool for Web application testing. Selenium testing runs directly and automatically in the browser, just like real users operate manually.
Webdriver: Chrome driver is an au ...
Added by Kold on Fri, 29 May 2020 04:15:44 +0300
Alibaba SMS callback. net sdk bug causes 100% troubleshooting of production service CPU
1: Background
1. Story telling
Last year, all the isv short message channels on the Jushi tower of Ali connected to Ali communication. We made a connection transformation and used the. net sdk provided by Ali.
website: https://help.aliyun.com/document_detail/114480.html
Colleagues used ons -. Net In v1.1.3, there will be a program crash a few ...
Added by youwh on Tue, 26 May 2020 14:08:29 +0300
ASP.NET Core file upload
Original text:
ASP.NET Core file upload
preface
First blog post Introduced how to asp.net Core uses Redis and Protobuf for Session caching. This article is a small function used in the development process, how to do single file and multi file upload. If you think it will help you, you may as well click "recommend".
cat ...
Added by bradleybebad on Mon, 25 May 2020 05:56:29 +0300
Details of Zookeeper data structure
Zookeeper
https://zookeeper.apache.org/doc/current/zookeeperOver.html
ZooKeeper is a distributed, open-source coordination service for distributed applications.
It exposes a simple set of primitives that distributed applications can build upon to implement higher level services for synchronization, configuration maintenance, and groups and nami ...
Added by sfmnetsys on Sun, 24 May 2020 12:33:08 +0300
python crawls the data of the network and visualizes it
Crawling the data information about python position in the pull net, and storing the crawling data into various csv files, then cleaning the data of the relevant fields in the csv file, and making further analysis on the data visualization, including histogram display, histogram display, word cloud display, etc. according to the visualization d ...
Added by Vizor on Sun, 24 May 2020 07:37:16 +0300
RedisTemplate implements message queuing and inserts data in batches.
In the early stage, due to the small business volume of the production environment. So logs are commit ted one by one. There was no problem with the operation.
Later, with the expansion of business concurrency, the log writing frequently deals with the database, resulting in the database connection pool often occupied, until the program crashes ...
Added by blyz on Fri, 22 May 2020 09:40:09 +0300
eggjs Learning Notes Day 35: Simple Logic for Background Login Authentication
1. After getting the user name, password and authentication code in the background:
(1) Get the data submitted by the form
(2) Determine whether the verification code is correct or not
If the verification code is correct:
1. Encrypt the password in the form by MD5 MD5 moduleHttps://www.npmjs.com/package/md5
1,install cnpm install md5 --sav ...
Added by jjoves on Wed, 20 May 2020 20:28:13 +0300
Eggjs learning notes day 34: eggjs post management login and background permission judgment
1, Login verification. You can't access other pages without login.
Judge whether the user has logged in, and use the middleware in the egg.
New middleware folder under app, new adminauth.js File, type:
var url = require("url");
module.exports = options => {
return async function adminauth(ctx, next) {
// 1. The user does not log ...
Added by Far Cry on Wed, 20 May 2020 18:13:33 +0300
Python co programming practice
On Synergetic process
a collaboration is simply a more lightweight thread that is not managed by the operating system kernel and is completely controlled by the program (executed in user mode). A co program is interruptible within a subroutine, and then switches to other subroutines, returning when appropriate to continue execution.
Ad ...
Added by Justin L H on Fri, 08 May 2020 20:28:18 +0300