MySQL

IntroductionNow because the project needs to build MySQL cluster, from the simplest start, first install a MySQL under Linux system.steps:First step: Install:Tar mysql-5.5.48-linux2.-x86_64.tar.gzCopy to the specified path:CP mysql-5.5.48-linux2.6-

First, the relevant concept of MySQL introduction Second, the configuration of MySQL under Windows Configuration steps Start, stop, and uninstall of MySQL service Third, the basic composition of MySQL script Iv. data

Backup Database errorCause: The monitoring server has a relatively high CPU load recently. (Cpu4 core, load 2.7 or so) is very strange, because the other server MySQL occupies not a lot of resources, so I first optimized the database configuration

A B database installation Just don't say it.Start A B Databaseexecute on A B databaseGrant Replication Slave on * * to ' repl ' @ ' 127.0.0.1 ' identified by ' 123456 ';Link DatabaseChange a Host my.cnf ConfigurationLog-bin=mysql-bin# Binary Logging

Currently, MySQL backup files, after a week or so clean up, manual cleanup will be more trouble, so wrote a simple script to achieve.Prerequisite Introduction:The MySQL backup file is placed inside the/usr/bak/sql, and the backup name format for the

1, group BY, with order by NULL to avoid sorting, will be much faster;2, as far as possible without sub-query, with join substitution;3, as far as possible to filter more records of the conditions on the left;4. Do not use! =, or, expressions (such

0. User management:1. New User:>create USER name identified by ' Ssapdrow ';2. Change Password:>set PASSWORD for Name=password (' FDDDFD ');3. Rights Management>show GRANTS for name; View name User Rights>grant SELECT on db_name.* to name; All

Original link: http://www.orlion.ga/1147/Mysqli has an object-oriented style and a process-oriented style, a personal feeling or an object-oriented style is better (after all, object-oriented)1, Mysqli::_construct ()mysqli::__construct  ([ string 

After MySQL installation, after landing found only two database:mysql> show databases;+--------------------+| Database |+--------------------+| Information_schema || Test |+--------------------+,mysql> use MySQLERROR 1044 (42000): Access denied for

One: Concept understanding:1.tid:transaction ID, which is the transaction ID number of the MySQL server. 2.gtid:global Transaction ID, global transaction ID, no two thing IDs are the same in the entire master-slave replication schema.3. The global

Method 1: Use the Set password commandFirst log in to MySQL.Format:mysql> set password for user name @localhost = password (' new password ');Example:mysql> set password for [email protected] = password (' 123 ');Method 2: Use MysqladminFormat:

Environment: MySQL Sever 5.1 + MySQL command line toolProblem: MySQL command line loginSolve:command-line logon syntax:Mysql–u user name [–h host name or IP address]–p passwordNote: The user name is the user you logged in, the hostname or IP address

The reason for poor query performance is that too much data has been accessed All columns are returned when a multi-table connection is made select * from sakila.actor inner join sakila.file_actor using(actior_id)inner join sakila.film

Installation machine: 10.11.1.193, 10.11.1.194Primary and Standby Synchronization mode: Asynchronous synchronizationMySQL version: MySQL community5.6.28Download the source code and unzip:TAR-ZXF mysql-5.6.28.tar.gzCMake Installation:Install the

MySQL InnoDB b-tree index using TipsHere is the main discussion about the use of InnoDB B-tree index, do not mention the design, just use. The B-tree index primarily acts on the Where and order by clauses. It's all discussed here in the mysql-server-

Binlog file record format statement, row, rixed three kinds, before 5.7 by default is statement mode, to 5.7 starts by default to row mode.Statement is the statement mode, Binlog record all the statements to make changes to the data, to see Binlog

[[email protected] ~]# mysqladmin-uroot password ' 123456 ' set a password for MySQL[[email protected] ~]# mysqladmin-uroot password ' 123456 ' local login MySQLIf we now have the MySQL password forgotten, reset it now.[[email protected] ~]# vim/etc/

Run: Python If the error indicates that the system is not mounted python or you can bypass the installation python stepInstall PythonDownload wget http://python.org/ftp/python/2.7/Python-2.7.tar.bz2TAR-JXVF python-2.7.tar.bz2CD

Secure Mysql binlog deletion and mysqlbinlog Deletion Introduction: If you have set up master-slave synchronization for Mysql or enabled log-bin for the database, a large number of log files will be generated in the data directory of your database

Upgrade MySql to support emoji and utf8mb4 Some children's shoes do not have a deep understanding of Emoji expressions. They are reluctant to use Emoji and do not want to go to Baidu.Emoji is a character, not an image. If it is not supported by the