MySQL

I. Introduction to the Environment（1）系统环境介绍：[[email protected] ~]# uname -aLinux linux-node2 3.10.0-693.5.2.el7.x86_64 #1 SMP Fri Oct 20 20:32:50 UTC 2017 x86_64 x86_64 x86_64 GNU/Linux[[email protected] ~]# cat /etc/redhat-release CentOS Linux

Record operation: Insert/update/delete/select1. Insert record (total three kinds)The first type: an expression1.INSERT [into] tbl_name [(Col_name,...)] {values| VALUE} ({expr| DEFAULT},...), (...),... mysql> CREATE TABLE users (id SMALLINT UNSIGNED

Views ViewA view is a virtual table whose contents are defined by a query. As with a real table, a view contains a series of column and row data with names. However, the view does not exist in the database as a stored set of data values. Row and

MySQL sub-table 3 ways to tag: MySQLposted on 2017-12-26 10:49:20First, let's talk about why the tables are divided.When a piece of data reaches millions of, you spend more time searching for it, and if you have a joint query, I think it's possible

Order:There are many similar articles on the Internet, but also a variety of Baidu came out, but for most of the first contact with MySQL master-slave small white, the online article code inside many technical points are not understood, there is a

MySQL official MySQL EF provider is in preview stageYou can choose to download the official MySQL or use a third-party NuGet package for installationMySQL official MySQL EF provider:Install-package MySql.Data.EntityFrameworkCoreOr use a third

mysql-data table Mysql-create table creationTo create a new table in the database, you can use the MySQL CREATE TABLE statement.CREATE table [IF not EXISTS] table_name ( column_list #在 column_list section specifies a list of tables. )

This is the branch page for http://www.cnblogs.com/EasonJim/p/7139275.html.Before installing MySQL, you need to know the following:1, MySQL various versions of the difference, reference: http://www.cnblogs.com/EasonJim/p/6274344.html2, the official

deploy MySQL high-cluster mysql-mmm + MySQL master-slave synchronizationEnvironment readiness (four database servers 12 11 10 9)Systemctl Stop FirewalldSetenforce 0Configuring the Yum SourceYum-y Install gcc gcc-c++ perl-*Systemctl Start mysqld++++++

1.3 Build the MySQL database server and set the database administrator's native loginPassword is 123456A Buy server (storage CPU memory) DELL HP Lenovob Installing the operating system RHEL7.2C Install the package that provides the database service (

First, data backup　　1. Backup with mysqldump commandThe mysqldump command backs up the data in the database into a text file. The structure of the table and the data in the table are stored in the generated text file.The mysqldump command works very

Core Knowledge points1.InnoDB: Data and indexes are stored in separate files, clustered indexes, row-level locks, transactions, MVCC2.MyISAM:(1) Cons: Transaction and table-level locks are not supported because table locks are not supported and lock

Reference: http://blog.csdn.net/zbw18297786698/article/details/52999940Description: 192.168.3.81 CentOS release 6.5 apache-activemq-5.10.11. Copy the MySQL drive to the ACTIVEMQ environmentMysql-connector-java-5.1.44-bin.jar[Email protected]

MySQL parameter optimization this thing is not well researched or more difficult to understand, in fact, not only MySQL, most of the program parameters optimization, is very complex. MySQL parameter optimization is no exception, for different

1. Decompression logstash2.2.2 Backstage, enter the ETC directory, create logstash-simple.conf, add the following configuration, according to their own environment to modifyInput {JDBC {Jdbc_driver_library =

Can MySQL use the index in a like query? Where do you use the index?When using like, if you use ' percent ', will you use the index?EXPLAIN SELECT * from ' user ' WHERE username like '%ptd_% ';  The result above is a full table scan (type = = All)

To run a command with an administrator user:Mysql> Show [full] processlist; # full is optional, and if not added, only the first 100 results are displayed by default.You can rely on this result to analyze some information such as user connection

User management:1. Create a new User:>create user name identified by ' RedPen ';2. Change your password:>set Password for Name=password (' ddd ');3. Rights Management:>show grants for username; View name User Rights>grant Select on Db_name.*to name;

Using the source code installation, can add some parameters according to the actual production environment, improve MySQL performanceMySQL official website https://www.mysql.com/This article uses the 5.1 version of the dedicated installation

How to enable slow log query in MySQL In Windows, find the my. ini file in the MySQL installation directory. The mysql version I use is earlier than 5.1.40. Add the following lines in my. ini: MySQL Method for enabling slow log query [Mysqld]