MySQL

MVCC is the abbreviation for multiversion concurrency control, which provides no lock reading at the MySQL thing isolation level, such as a thing that does not affect the data read when it executes the update, such as SQL that does not commit when

MySQL Replication is an asynchronous copy process, copied from one MySQL instace (we call Master) to another MySQL instance (we call it Slave). The entire replication process between Master and Slave is done primarily by three threads, of which two

The world's 78,707 major cities information MySQL database, including latitude and longitude coordinate values, has been exported to the SQL file, because it is relatively large, there is 10M, so this is exported separately, for the upgrade failed

These two days in a database project, using MySQL, the need to remote access to MySQL through the external IP, found that the default MySQL is not allowed remote access, need to do a simple configuration.As follows:1. Open a terminal (CMD)

1, decompression.  2. Add "D:\Program Files\mysql-5.7.11-winx64\bin" to the system environment variable.  3, modify the My-default.ini.   4 . Initialize the data directory and a data directory will appear under the installation directory. (Run as

#!/bin/bash#记录备份的时间echo "-----" $ (date + "%y-%m-%d%h:%m:%s") "-----" >>/data/backup_mysql/record.log#定义变量Myuser=rootmypassword=29749716# @HeiniaoSocket=/data/mysql/mysql.sockmycmd= "Mysql-u $MYUSER-p$mypassword-s $SOCKET"mydump= "Mysqldump-u

I. Purpose of the backupDisaster recovery: Recovering and restoring corrupted dataChange in demand: the need to restore data to change before it changesTest: Test whether new features are availableIi. issues to be considered in backupCan tolerate

Log in to MySQL mysql-h hostname-u username-p passwordStart MySQL under MacAdded to the. bash_profile file in the terminal's own user name.Export path=/usr/local/mysql/support-files/: $PATH pathThen terminal input sudo mysql.server (start start

First, background knowledge1. A lock is a mechanism by which a computer coordinates multiple processes or threads concurrently accessing a resource.A, lock classification.| Shared lock (read lock): During a lock, multiple users can read the same

The first two days with VS2013 connection MySQL encountered a lot of problems, the Internet search a lot of the discovery is not clear, so I would like to summarize the problems I encountered, to help Yimeimei less to go a little detour.Steps:1: The

"Introduction to the Background"during the use of SQL Server database, you must have had to solve a variety of problems experienced, many times, will be in everyone's blog to see Problems and solutions. Now that the development is using the MySQL

PrefaceSome of the feedback before several articles too theoretical lack of practical details, this article on more operability of the content bar.Note: This article is based on the background of MySQL, many of which are applicable to other

Yum-y Install GCC Python-devel1. Install PipDownload and install from Https://github.com/pypa/pip/archive/8.1.1.zipUnzip Pip-8.1.1.zipCD pip-8.1.1Python setup.py Install2, Installation MySQLdbPip Install MySQLdbIf you use import mysqldb in a Python

I. Introduction of the Database1. Structured Query Language (Structured Query language)2, SQL: industry standard. (supported by each database vendor)Sql-server: The standard has been extended. TSQL dialectOracle: Scaling standards.

First, the database engine　　The Database engine is the core service for storing, processing, and securing data. Use the database engine to control access and quickly process transactions to meet the requirements of most applications that need to

Summary of functions commonly used in MySQL:First, mathematical functionsABS (x) returns the absolute value of XBin (x) returns the binary of X (Oct returns octal, HEX returns hex)Ceiling (x) returns the smallest integer value greater than XEXP (x)

Select table_name as "Tables", Round (((data_length + index_length)/1024/1024), 2) ' Size in MB ' from Information_schema . TABLES WHERE table_schema = ' Zabbix ' ORDER by (data_length + index_length) DESC limit 10; (View MySQL database table

One, close firewall and SELinux[[Email protected] raddb]# service iptables stop[Email protected] raddb]# Vim/etc/selinux/configSelinux=disabledSecond, installation Freedius[[email protected] RADDB] #yum install freeradius*-yThird, need to install

MySQL insert delayed, mysqldelayed Insert delayed syntax INSERT [LOW_PRIORITY | DELAYED | HIGH_PRIORITY] [IGNORE] [INTO] tbl_name [(col_name,...)] VALUES ({expr | DEFAULT },...), (...),... [on duplicate key update col_name = expr,...] or: INSERT

MySQL Study Notes: QueryChapter 3 1. When we do not know what database names can be used? You can use the following command to View Details: `SHOW DATABASES；` The result is as follows: 2. When we know the databases that can be used, such as mysql,