MySQL

[[email protected] ~]# yum-y install mysql-server MySQL..........................[[email protected] ~]# rpm-q mysql-server (see if installation and version number)[email protected] ~]# Yum list |grep mysql-servermysql-server.x86_64 5.1.73-5.el6_6

Remark: Install xtrabackup First: https://www.percona.com/downloads/XtraBackup/LATEST/My version here is: percona-xtrabackup-24-2.4.6-2.el7.x86_64.rpmLocal installation: Yum Localinstall percona-xtrabackup-24-2.4.6-2.el7.x86_64.rpmView 650)

InnoDB Architecture The InnoDB storage engine primarily includes memory pools and background threads. Memory pool: Multiple memory blocks make up a pool of memory, mainly maintain the internal data of the process/thread, cache the disk

Basic operations of the database:The SQL language is primarily used to store data, query data, update data, and manage relational database systems, developed by IBM and divided into 3 types of SQL language DDL Database Definition language: Database,

Storage EngineDatabase Storage Engine (How the data is stored and how the transaction is affected ) types of storage and manipulation tablesThere is only one storage engine in Oracle and SQL , andMySQL has a variety of storage engines, Users can

MySQL pre-installation preparations Environment Preparation: Linux system cmake mysql installation package Uninstall the RPM package installed MySQLyum-y Remove MySQL Mysql-serverRm-rf/etc/my.cnfInstall to resolve dependencies:yum-y install ncurses-

single-table queryprepare an employee table Company.employeeEmployee number emp_id intEmployee Name emp_name varchar (30)Employee gender Sex enumHire Date hire_date Date post post varchar (50)Job Description job_description varchar (50)Salary Salary

1. mysql Login:Mysql-u Root-p or mysql-uroot-p******Password2. Display all current DB:show databases;3. Create DB:Create Database mydb1;4, to operate the table, the first to select the DB:Use MYDB1;5, Show all the table:Show tables;6. Create a table:

Mysql Log error log: Log mysql server startup, shutdown, and run errors and other informationBinary log: A binary file that records all operations except select in the database (the most important log)Query LOG: Record query informationSlow query

Environmental requirementsGCC, gcc-c++, CMake, bison (possible) support1.Yum install gcc gcc-c++ cmake Bison2, modify the Yum configuration, to achieve the search local settingsRemove or rename/etc/yum.repos.d/centos-base.repoModify Vi/etc/yum.repos.

1. Check if the system already has a database of its ownRpm-qa | grep MySQLIf there is,RPM-E MySQL #普通删除Rpm-e--nodeps MySQL #强力删除, delete if you have dependencies2. Yum List | grep mysql #查看yum source MySQL version information3. Yum install-y

With regard to SQL optimization techniques, you may have seen n versions, especially for junior-level programmers. If you do not have a bit of analytical practice, just take it as a Bible and practice it in your work, you are most likely to be out

1, the normal situation.SELECT Joineventids from user2, use the Group_concat function to get the column change.Select Group_concat (joineventids) from user3. Use Substring_index and Cross join to split the numbers inside the column and make a row

mysql-zrm--action restore--source=/common/test/20170407091226/--backup-set test--verboseFull standby recovery of a database of course, no problem.However, however , however: There are exceptions when backing up multiple libraries:When backing up

First we want to download the MySQL installation package, you can go to the Http://mysql.com official website according to their own computer system version download can also click on the MySQL resources download Password: btuu recommended to

1. Follow the hierarchy to see Help“？ Contents "command to display all the categories available for queryingMysql>? ContentsYou asked-Help on Help category: "Contents"For more information, type ' help ', where is one of the

First step: Download MySQLUse the wget command on the Linux terminal to download network resources: http://mirrors.sohu.com/mysql/MySQL-5.7/mysql-5.7.16-linux-glibc2.5-i686.tar.gzStep two: Unzip the filefirst cd/usr/local under: then unzip the tar

First step: Download MySQLDownload network resources using the wget command on the Linux terminal:wget http://mirrors.sohu.com/mysql/MySQL-5.7/mysql-5.7.17-linux-glibc2.5-x86_64.tar.gzStep two: Unzip the fileCd/usr/local, then unzip the tar zxvf

Haven't updated the blog for a long time! Today, using day, I learned a bit about MySQL database. Introduction to the database of three ways to connect!Development tools: MyEclipseMySQL5.6MySQL Connection driver: Mysql-connector-java-5.1.27.jarLoad

Basic mysql operations I. Concept: data database: DB database management system: DBMS Database System: DBS MySQL: Database mysql: client commands (used to connect to services or send SQL commands) SQL: structured Query Language. MySQL supports this