MySQL

Due to the frequent use of powerdesigner in daily data modeling, the use of reverse engineering to generate models more quickly improves efficiency, so the summary is used as follows:1. Installing the ODBC driver for MySQLCONNECTOR/ODBC 5.1.13:Https:

5.7 of Performance_schema already have the ability to monitor the memory usage of MySQL, for this is to be achieved through the instrument, because the memory this piece does not have a corresponding consumer so long asWell, it's okay to configure

A good memory is better than a bad penThere are three kinds of SQL connection: Inner connection, outer connection, cross connection.Inner connection includes: equivalent connection, non-equivalent connection, natural connectionOuter connection

Reference http://www.cnblogs.com/lakeslove/p/6280404.htmlWith regard to msyql5.7, the biggest change during installation is the default passwordI'm installing MYSQL-5.7.17-MACOS10.12-X86_64.DMG.and

Today formally began a long road, I intend to spend the last few years to brush mysql5.5 source code, because the books at hand are basically based on mysql5.5, so there is no 5.7 version of the code, not to mention I am more concerned about the

Today's database connection, suddenly found that the database password forgot, this can do, really scared the baby, through the experiment, finally found a method, only for reference ...The general approach to accessing the database is as follows:

Sendfile (Data directly from the kernal buffer) for small filesAio (Nginx) Full Async (The difference from event-driven IO is that the data arrives at Mem before it is notified, and no notification can be returned directly to the client) support:

Create a user? 1 CREATEUSER ‘username‘@‘host‘ IDENTIFIED BY‘password‘; Descriptionusername– the user name you will createhost– specifies on which host the user can log on, if localhost is available to the local user,

1. BackgroundMysql/innodb's locking analysis has been a difficult topic. In the course of my work, my colleagues have often consulted on this issue. At the same time, the micro-blog also often receive the MySQL lock-related private messages, let me

Chapter i Mysql Introduction and Installation and configuration · section I:Mysql Introduction MySQL is a relational database management system , by Sweden MySQL AB company Development, currently belongs to Oracle -owned products.

I. MySQL report table error when executing select: is marked as crashed and last (automatic?)Here's how to fix it:Locate the Bin/myisamchk tool for the MySQL installation directory and enter it at the command line:Myisamchk-c-R. /data/dedecmsv4/dede_

Mysql performance optimization configuration parameters and mysql performance optimization parameters To modify the values of the following parameter configuration items, refer1. connection settingsShow variables like '% max_connection % ';Show

Master-master replication (dual-master slave) for building a MySql Cluster The previous article introduced how to configure master-slave replication for MySQL. This article mainly describes master-slave replication:   First, describe the keywords

How to reset the initial values of auto-increment columns in a MySQL table How to reset the initial values of auto-increment columns in a MySQL table 1. Question proposal In MySQL database design, auto-increment numeric columns are generally

Ultra-simple qps statistical methods (recommended) and qps statistical methods Calculate the QPS value in the last N seconds (including the select and insert values per second) Mysql> select variable_name, sum (per_sec) as qps from (select

MySQL Partition Table limitations and restrictions Build prohibited Partition expressions do not support the following types of construction: Stored Procedures, stored functions, UDFS, or plug-ins Declare variables or user Variables See SQL

MySQL database transaction isolation level details, mysql details Database transaction isolation level There are four isolation levels for database transactions, from low to high Read uncommitted: Dirty Read is allowed. Read committed: it is

Graph tutorial on installing and configuring mysql 5.7.13 on Mac, mysql5.7.13 The installation tutorial for mysql 5.7.13 on Mac is detailed. The record is as follows: First, download the installation package from Baidu mysql. In this case, the

How to query the json and mysql5.6json in the database in MySQL and earlier versions Saving data in MySQL sometimes throws messy and uncommon data into a json field. The following describes the formats that mysql should pay attention to when storing

Mysql GTID Mha configuration method, mysqlgtidmha Configuration Gtid + Mha + Binlog server Configuration: 1: Test Environment OS: CentOS 6.5Mysql: 5.6.28Mha 0.56 192.168.1.21 mysql1 M1192.168.1.22 mysql2 S1192.168.1.23 mysql3 S2 Mha manage, Binlog