MySQL

An Action folder (library)1. IncreaseCreate Database db1 charset UTF8;2. By deletingDrop database db1;3. ChangeALTER DATABASE DB1 CharSet GBK;4. Check# View the database you are currently creating show CREATE Database db1;# view all databases show

Application of Concat with Information_schema1 The general usage of concat is mainly used for splicingExample:The EXECUTE statement SELECT CONCAT (' M ', ' y ', ' S ', ' Q ', ' L ') can achieve the following effect2 When writing SQL backup

1.mysql services are provided through the MYSQLD processWe can simply double-click Mysqld.exe or enter mysqld in cmd mode. Both operations create mysqld processes in the backgroundAfter we have created the mysqld.exe process, we can log in to MySQL.2

Tag:dbn   inno   att    matching    lob    col   err   temp   ble    Based on my use of MySQL, the commonly used MySQL show statements are listed as follows: 1.show databases; Displays the name of all databases in MySQL 2.show tables [from

PartitionPartitioning is the distribution of files and indexes of a data table in different physical files.The types of partitions supported by MySQL include range, List, Hash, Key, where range is more commonly used:Range partition : Assigns

MySQL Replace statement introduction　MySQL's replace statement is a MySQL extension to the SQL standard statement.Official definition: REPLACE works exactly like INSERT, except this if an old row in the table have the same value as a new row for a

MySQL is stored on disk, and all kinds of natural disasters can result in data loss. Large companies when we often need to do a good job of data hot and cold, for small companies to do all the data backup needs to spend a lot of costs, many

First, Tomcat tuning(i), Tomcat memory optimizationParameter one:vim/tomcat/bin/catalina.shcatalina_opts="-server-xms128m-xmx512m" Modifying memory parametersParameter two:Vim/tomcat/bin/catalina. SH //

three paradigmsThree-paradigm definition (paradigm and inverse paradigm)1NF: Each data item is the smallest unit, indivisible, and only one data can be determined after the column is identified.2NF: Each non-primary attribute is completely dependent

MARIADB Query CacheThe data in the cache is in open source form, in the form of key-value pairs (k/v)Key: The hash value of the query statement;Value: Query result of query statement;The data in the cache is mainly through the comparison of the hash

The previous article describes the order in which Oracle's select syntax is executed, which describes the order in which MySQL's select syntax is executed. MySQL's select syntax is executed in the same order as Oracle, only adding MySQL's unique

Xtrabackup IntroductionXtrabackup is a free database hot-backup software Percona open source, which can back up non-blocking databases of InnoDB databases and XTRADB storage engines (as well as a table lock for MyISAM backups); The Mysqldump backup

EmployeeThe table contains all employee information, each employee has its corresponding ID, salary, and department ID.+----+-------+--------+--------------+| Id | Name | Salary | DepartmentID |+----+-------+--------+--------------+| 1 | Joe | 70

Before studying in school, just know the database is very important, but did not take the initiative to learn to understand. Now learn the process of learning MySQL once again, simply do a summary of it.First of all, remember the three concepts:1. A

VI mysql_mon.sh#!/bin/bashif [netstat -tlunp|grep mysql|wc -l-GT 0] #过滤进程名为mysql, turn into numbersThenecho "MySQL is Running."Elseecho "MySQL is Stopped."/etc/init.d/mysql startFiVI nginx_mon.sh#!/bin/bashIf [ netstat -tlunp|grep nginx|wc -l -gt 0]

1. Download MySQL Yum Repositorywget http://dev.mysql.com/get/mysql-community-release-el7-5.noarch.rpm2. Add MySQL Yum RepositoryRPM-IVH mysql-community-release-el7-5.noarch.rpm3, verify whether to add the successYum Repolist enabled | grep "Mysql.*-

Use two tables (a_table, b_table), associated fields a_table.a_id and b_table.b_id to demonstrate MySQL's internal connection, outer join (left (outer) connection, right (outer) connection, full (outer) connection).MySQL version: Server version:5.6.3

1. Problem findingSysbench test MySQL with the following configurationsysbench /usr/share/sysbench/tests/include/oltp_legacy/oltp.lua --mysql-host=192.168.1.221 --mysql-port=3306 --mysql-user=root --mysql-password=MySQL5.7 --oltp-test-mode=complex --

Mysqldump is a good command for MySQL database backup, and it comes with MySQL.- D: Only the table structure is backed up, backup files are SQL statements, only statements that create tables are backed up, and the inserted data is not backed up.- t:

Share a simpler and faster version of installation than the MySQL5.7 version: MariaDB.Shut down the firewall before the experiment starts:Service Firewalld StopSetenforce 0After configuring Ali sources:Wget-o/etc/yum.repos.d/centos-base.repo