MySQL

#!/bin/shlog=/var/log/mysql-backup.log# MySQL db infouser_root=xxxxxxuser_pwd=xxxxxxx# mysql data stored dirTODAY= ' Date +%f ' storedir=/mnt/tf-card/mysql-back/$TODAYmkdir $STOREDIRecho "* * * PATH: $STOREDIR mysql-backup * * *" >> $ log# Delete

1. mysql User management' User ' @ ' host '; HOST:IP, hostname, NETWORK,% (any long character), _ (any single character) skip_name_resolve={on| OFF} Skip host name resolution [[email protected] ~]# vim/etc/my.cnf Skip_name_resolve=on2. View the

Last month before interviewing a company, the idea of MySQL sub-table, then briefly said the next hash algorithm sub-table, as well as the idea of discuz sub-table,But for the new data self-ID storage of the design idea is not very good answer (the

1)mysql downloadAddress: https://dev.mysql.com/downloads/mysql/2) all the way next installation, after installing the file directory as follows (excluding Data folder, My.ini file)3) new file My.ini, note that the format is ANSI, the contents of the

This article refers to the MySQL website.The native system environment is: CentOS 7.0, minimized version;MySQL version that will be installed: V5.7 Community versionI. Summary1, the current MySQL only Community Edition (community) is free, the other

Run the script at timed intervals:1. Operationcrontab-eXX * * * * /bin/bash yourpath/mysqlbak.sh2. Open your own initiative to run the fileVi/etc/crontabAdditions such as the following are included in the etc. Let them run the task on their own

[[Email protected] ~] #rm-F/etc/init.d/mysqld[Email protected] ~]# mkdir-p/data/{3306,3307}/data[Email protected] packages]# RPM-IVH tree-1.5.3-2.el6.x86_64.rpmWarning:tree-1.5.3-2.el6.x86_64.rpm:header V3 rsa/sha256 Signature, key ID

To create a MySQL group:Groupadd MySQLCreate a MySQL user and give this mysq group, do not create a home directory, do not allow users to log in. (Because the MySQL you just created is a virtual user, you are not allowed to log in)Useradd mysql-g

0. PreparationA. Install the database : the master-slave MySQL database (MySQL server) is installed:Version, MySQL allows low version master with high version slaveHttps://dev.mysql.com/doc/refman/5.7/en/replication-compatibility.htmlOf course, the

1. Excessive anti-normalization to create too many columns for a tableWhen we design the structure of the database, it is easy to make the first mistake is that the table is excessively anti-normalization design, which makes the table too many

Database: As the name implies is a storage data warehouse, according to the structure of the data to organize the storage and management of data.Create a databaseCreate Databese [if not exists]db_name DEFAULT CHARACTER SET charset_name;Create

1, installation Mysql-proxyThe implementation of read-write separation is implemented with LUA scripting, now mysql-proxy inside is integrated, no need to installDownload:

1. The MyISAM Storage Engine index key length sum cannot exceed 1000 bytes. 2. The BLOB and text type columns can only create prefix indexes. 3. MySQL does not currently support function indexing. 4. MySQL cannot use an index when it is not equal to

SQL statement type: DDL: Database Definition language CREATE,DROP,ALTERDML: Data manipulation Language Insert,delete, UPDATE,SELECTDCL: Data Control Language Grant,revoke common SQL statements:    create  database# Creating a database create table   

The MySQL statement is divided into 11 steps, as noted, the first execution is always the from operation, and finally the limit operation is performed. Each of these operations produces a virtual table that acts as a processing input, except that

This article describes the I/O-related parameter configurations for the two storage engines of the InnoDB and MyISAM.1.InnoDB I/O related configurationInnoDB is a transactional storage engine that, in order to reduce the IO overhead incurred when

The data was moved to MySQL by Oracle, and since Oracle was case-sensitive, MySQL's configuration used the default configuration, resulting in some data import failures, and some unique key errors, conflicts.Record the test process below.Database

Astgo Often crashes and slows down? Try mysql Data fragmentation, Use tools such as SSH or navicat to connect to the database (Note: It is done after the database is connected, instead of directly using SSH, and a command error is prompted) Run the

MySQL enables remote connection and mysql enables The basic syntax for enabling MySQL is grant authorization, which is usually not a problem. It is mainly because it may not be connected after it is enabled. Grant all privileges on Database Name.

Mysql learning notes 008 and mysql learning notesObtain database and table information     Generally, normal programmers or DBAs will suddenly think of a series of questions when coding: Who am I? Where am I? What am I doing? What about my database?