Objective
A few days to take a time to "high-performance MySQL" looked at the index is very important, and then summed up to consolidate knowledge. This article uses the InnoDB storage engine as an index. Because this article does not say that the
1. Preparation prior to installation
Uninstall the mariadb Centos7 comes withrpm -qa|grep mariadb #查看一下是否有mariadb相关的包rpm -e --nodeps mariadb-libs-5.5.52-1.el7.x86_64 #把查询到的包卸载
Download the MySQL installation packagewget https://
MySQL Restart errorError:There are several possible reasons for this:1.mysql没有正常关闭2.第二次在机器上安装mysql,有残余数据影响服务启动3.权限问题,可能是/opt/mysql/data/数据目录没有权限Solution:1.没有正常关闭的话,日志里会有写 [Note]?InnoDB: Database was not shutdown normally! [Note]
Create userCREATE user ' username ' @ ' localhost ' identified by ' password ';Delete UserDROP user ' username ' @ ' localhost ';Permissions List AllOrAll PrivilegesRepresents all permissions for the specified permission level.ALTERALTER TABLE is
First, create a databaseThe SQL syntax format for creating databases in MySQL is:CREATE database name;Where the database name cannot have the same name as the database that already exists. To create a database test_db:You can view the definition of
Creating a database create databases MMP;Creating a database table is not a blank field and requires at least one fieldCREATE TABLE Info (ID TINYINT primarry Key auto_increment,//id is a field-primary key and self-incrementName VARCHAR
When using JMeter for performance or interface testing, often need to connect to the database, then how to use JMeter to connect to the database, following the MySQL database as an example to make a brief explanation:The first step: click the
#----The command line to connect to MySQL---------#启动mysql服务器net start MySQL#关闭net stop MySQL#进入Mysql-h host Address-u user name-P user Password#退出Exit#---------------------------#----MySQL User management--------- #修改密码: First, under DOS, enter
1. Uninstall system comes with MYSQ (this step is not ignored)[[email protected] ~]$ rpm-qa|grep MySQLMysql-community-common-5.7.19-1.el6.x86_64RPM-E--nodeps mysql-community-common-5.7.19-1.el6.x86_642. Download the Unzip installation package[Email
Django Link MySQL database:First step: Create an AppPython manage.py Startapp IndexStep Two: Add the app to the configuration settingsInstalled_apps = [ 'Django.contrib.admin', 'Django.contrib.auth', 'Django.contrib.contenttypes',
"Abstract" for MySQL InnoDB data engine binary log backup slow problem, proposed a MySQL InnoDB storage engine based incremental backup method, can achieve the shortest time of backup, each time record relative to the last full backup point
To modify the use of command Terminator delimiter in MySQL:The MySQL delimiter will tell the MySQL interpreter what the Terminator of the command is, and by default the MySQL command is terminated with a semicolon (;). mysql can execute commands
In fact, the path has been changed before the path confirmation no problemThen think about MySQL last step configuration fileWe all know that the configuration file chooses the configuration according to the actual situationMy choice is medium.So
1.使用navicat修改2.进入命令行界面(F6)3.输入:SELECT @@GLOBAL.sql_mode;4.结果:ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION5.6.然后我们来修改sql_mode7.输入:set GLOBAL sql_mode
Suppose there are two kinds of tables: test_on_position and Address tables, Address Table storage addresses, test_on_position store members and their usual addresses, the data are as follows:Address Table:Test_on_position table:1. The left join
Tag: Date user starts the address of the message instead of the statement does not perform the basic implementationfirst, Data Control Language (DCL)1, the data control, in fact, is "Assigning permissions"-related to users.2, the main problem is
Parameters
The value of the in parameter must be specified when the stored procedure is called, and the value of the parameter modified in the stored procedure cannot be returned as the default value.
out : This value can be changed
Source Address: https://www.jb51.net/article/140939.htmUsing Scrapy to crawl some of the data on the web, stored in the MySQL database, want to use Django to show the data, see on the web is using the Django models and Makemigration,migrate commands
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.
A Free Trial That Lets You Build Big!
Start building with 50+ products and up to 12 months usage for Elastic Compute Service