Category:MySql

  • Performance pressure test of mysqlslap

    Time:2020-12-1

    Series articles: MySQL advanced optimization (1) Advanced optimization of MySQL (2) Performance pressure test of mysqlslap Enter the MySQL container docker-compose exec mysql bash mysqlslap -a -u root -p -uroot -proot Start pressure testing – C number of users, – I execute several times, – create schema database need to be pressure tested – Q […]

  • Installation and configuration of mysql8.0

    Time:2020-12-1

    1、 Download MySQL There are two ways to install mysql. One is to download the installation package for installation, and the other is to download the compressed package decompression configuration. Here, the installation package method is used. Download address of official website: https://dev.mysql.com/downloads/installer/ After entering, click download below Click no thoughts to download 2、 Install […]

  • MySQL 8.0.17 decompressed version installation tutorial

    Time:2020-12-1

    I think the decompression version is easier to install than the installation version. Needless to say, let’s take a look at the installation of the decompression version~ First, go to the official website of Mysql to download the latest MySQL 8.0.17 website: Download the extracted Directory: By default, there is no data directory and my.ini […]

  • Calculate the distance between two longitudes and latitudes by SQL

    Time:2020-11-30

    Reference for design of longitude and latitude fields: my.oschina.net/hengbao666/blog/300…SQL statement reference:blog.csdn.net/sunsineq/article/det… Note: St_ The distance function support is mysql5.6.1The st of MySQL_ Distance function does not know how accurate? I feel that there is a big gap with some distance calculation on the Internet; St of mysql5.7_ Distance_ Sphere is more accurate. I don’t know […]

  • MySQL performance optimization

    Time:2020-11-30

    In the Internet company MySQL is widely used, and we often have the demand of MySQL performance optimization. Some practical skills in MySQL optimization are sorted out. Schema and data type optimization Integers are usually the best choice for identifying columns because they are fast and usableAUTO_INCREMENT A completely “random” string (for example:MD5()、SHA1()perhapsUUID()Will be arbitrarily […]

  • Installation, configuration and uninstall of MySQL 8.0 in Windows Environment

    Time:2020-11-30

    Software version Windows:Windows10 MySQL:mysql-8.0.17-winx64.zip Installation procedure 1. Configure environment variables name:Path value:C:\Program Files\MySQL\mysql-8.0.17-winx64\bin 2. New my.ini file File location: C: program files / MySQL / mysql-8.0.17-winx64\ my.ini(this is my installation directory. You can modify it according to your actual installation path.) [mysqld] #Port number (default: 3306) port=3306 #Set MySQL installation directory basedir=C:\Program Files\MySQL\mysql-8.0.17-winx64 #Set the […]

  • This SQL problem can definitely make you understand MySQL better!

    Time:2020-11-29

    Property table_ Props) has the following structure Data volume above 800W Field name type explain id int id pn_id int Property type pv_id int Property value product_id int Product ID Among them, product_ ID and PN_ id,pv_ ID is a one to many relationship.The data is similar to this: product_id pn_id pv_id 10970 5 (model) […]

  • MySQL review 7: DDL add / delete / modify

    Time:2020-11-29

    Continuous rain washed the scattered dust, by the way, also washed the leaves green. The rain will only be less and less, knowledge will be less and less. (within a certain range) Long query past, today will lead readers into the hall of DDL language, feel the unique SQL statement! #DML language Data manipulation language […]

  • Installation and simple configuration of MySQL 8.0.17 under MacOS

    Time:2020-11-29

    If I write this article you can’t understand, there may be no online tutorial you can understand Although this article is for version 8.0. X, there are still general methods for MySQL configuration Environmental information and scope of application# environmental information Environment / software edition macOS macOS Mojave MySQL MySQL 8.0.17 Scope of application Environment […]

  • Detailed analysis of explain command in MySQL

    Time:2020-11-28

    In many cases, we need to know the performance of a SQL statement, and we will check how the query optimizer executes through the explain command. How to use it useEXPLAINVery simple, just add theEXPLAINthat will do explain select s.sid sid, s.name studentName, s.age age, c.name className from student_class sc, student s, class c; The […]

  • Syntax error or access violation: 1166

    Time:2020-11-28

    Report database 1166 error is because you have extra space on both sides of the field Give yourself a mark, step on this hole^__ ^. This work adoptsCC agreementThe author and the link to this article must be indicated in the reprint

  • Detailed explanation of MySQL 5.7 Mgr single master determining master node method

    Time:2020-11-28

    Mgr of our bank will be online at the end of the year. We have to read official documents every day to learn, do tests, and write a little knowledge every day. Do you want to learn together~ MySQL 5.7 Mgr single master determines which primary node is. We can judge by member ID, and […]