Network Tools
Technical Article
Several vps performance test unixbench results
test program:
wget --no-check-certificate https://github.com/teddysun/across/raw/master/unixbench.sh chmod +x unixbench.sh ./unixbench.sh
result:
Solve the problem of secure-file-priv option when importing and exporting mysql data
Mysql database imports or exports from a file to a file, prompting The MySQL server is running with the --secure-file-priv option so it cannot execute this statement. The reasons and solutions are as follows:
Some versions of mysql have restrictions on import and export through files, which are not allowed by default.
View the configuration and execute the mysql command
A multi-angle look at classic cases of data mining – shopping basket analysis
Correlation analysis is one of the important components in the data mining system, and its representative case is "shopping basket analysis". Let's take the shopping basket analysis data provided by the data mining software Clementine as an example to explore this aspect from multiple aspects.
Multi-row merge functions collect_set, collect_list, concat_ws in sql
Take N fields from the database, and then combine them together and use "," to separate the display. At first, I thought of using CONCAT() to process it, but it was troublesome. Unexpectedly, CONCAT_WS() was mentioned in the manual, which is very easy to use.
Solve the problem that python3 requests headers parameters cannot have Chinese characters
from urllib import parse str1 = 'hahahaha' str2 = parse.quote(str1) #quote() encodes the string print(str2) < x2>#str2=haha%E5%93%88%E5%93%88
Original link: https://blog.csdn.net/RAPIER512/article/details/79761593