MySQL

/*Navicat MySQL Data TransferSource server:206 Docker MySQL 13306Source Server version:50720Source host:192.168.7.206:13306Source Database:kafkamonitorTarget Server Type:mysqlTarget Server version:50720File encoding:65001Date:2018-05-05

Install MYSQL1, download the MySQL installation file to install MySQL requires the following two files:mysql-server-4.0.23-0.i386.rpm mysql-client-4.0.23-0.i386.rpm is: http://www.mysql.com/downloads/ mysql-4.0.html, open this page, drop-down page

INDEXBecauseperformance, Smart resultsFor many reasons, when searching for text, Full-Text search one is better than the wildcard wildcards regular expression, which indexes the specified column to quickly locate the corresponding row, andSmart

This environment is based on CentOS 71) Install NginxYum Install Nginx # systemctl enable nginx.service# systemctl start Nginx.service2) Install MARIADBYum Install mariadb-server# systemctl enable mariadb# systemctl start mariadbWhen the

Chapter III: Analysis of server performance? This chapter will answer the following three questions:? How to confirm that the server is in the best performing state? Find out why a statement isn't performing fast enough? Diagnostics are described by

1.Heartbeat IntroductionHeartbeat is a Linux open source, widely used high-availability cluster system, since 1999 to now, released a number of versions, is currently open source Linux-ha project The most successful example, in the industry has been

1, add Percona warehouse.# yum install -y http://www.percona.com/downloads/percona-release/redhat/0.1-4/percona-release-0.1-4.noarch.rpm2, install the plug-in.# yum -y install percona-zabbix-templates# rpm -ql percona-zabbix-templates/var/lib/zabbix/

MySQL view maximum number of connections and modify maximum connections1. View the maximum number of connectionsShow variables like '%max_connections% ';2. Modify the maximum number of connectionsSet GLOBAL max_connections = 200;The following

Mysqlcheck is a tool that MySQL comes with, the function is the 保养 table, actually is examines, analyzes, fixes and optimizes. Here's an introduction to the simple use of the Mysqlcheck tool, the official documentation here Original URL:

This article for me to learn old boy teacher MySQL DBA senior operation of the study notes, rookie a If there is a wrong place to write, please the great God more guidance, I will thank you very much. hehe ~7.6.1 MySQL Multi-instance common

Character Set issues:Basic concepts? A character (Character) is the smallest of the ideographic symbols in a human language. such as ' A ', ' B ' and so on;? Given a series of characters, each character is given a numeric value that represents the

Inside the navicat, find the function, right-click, new function, select the process, if there are parameters to fill in the function, if there is no direct click to completeAt the begin ... End writes the SQL statement to execute, such as the

---------------------------Stored Procedure--------------------Grammar:To create a stored procedure:CREATE [definer = {User|current_user}] PROCEDURE sp_name ([Proc_parameter [, Proc_parameter ...]) [Characteristics ...]

In the application of hive, the following error occurred when you had an "error" in your SQL syntax; Check the manual-corresponds to your MySQL server version for the right syntax-use-near ' OPTION Sql_select_limit=d Efault ' is caused by a mismatch

1. Password PolicyThe strength of the password was enhanced in MySQL 5.6, and the Validate_password plugin was introduced. Support for password strength requirements.(1) Install plug-in[[email protected] ~]#

A Brief Introduction to MySQL's B-tree index and INDEX OPTIMIZATION, and a brief introduction to mysql MySQL MyISAM and InnoDB engines use B + tree indexes by default ("BTREE" is displayed during queries). This article discusses two issues: Why

Use shell to write a mysql data backup script and shellmysql Data Backup Ideas It's actually very simple. Write a shell script and use mysqldump of mysql to export data to the corresponding SQL file. Use crontab of linux to regularly run the

Basic MySQL commands and basic mysql commands   SQL Statement Mysql version: For mysql-5.6.36 version1.1 Common commands # View database mysql> show databases; show databases like '% pres %'; # fuzzy query # View table mysql> use xzymysql> show

Database quiz question 2 and database quiz question 2 Questions on Century jiayuan Network 1. count the number of persons in each category (type: Select type, count (type) from tab_user group by type; 2. Count the total score of five people:

Description of the meaning of N and M in MySQL Data Type DECIMAL (N, M), mysqldecimal My colleague asked me what the meaning of N and M in the MySQL Data Type DECIMAL (N, M). Needless to say, M is obviously the DECIMAL place, but is N the maximum