MySQL

We often receive this question about MySQL's ibdata1 file in the Percona Support Section. When the monitoring server sends an alarm about the storage of the MySQL server, the panic begins-that is, the disk is almost full. After a survey, you realize

1. MySQL 5.6.32 64-bit installation package download Download the MySQL 5.6.32 64-bit installation package download (or wget download) using Thunderbolt in the official website http://dev.mysql.com/downloads/mysql/5.6.html#: # CD/USR/LOCAL/SRC# wget

Meta-Information for the database:First, let's introduce the meta-information of the database (metadata):Metadata (Metadata) is data about the data.Metadata is the data that describes the structure of data in a data warehouse and how to build

What do we need to back up? In general, the data that we need to back up is divided into the following Data Binary log, InnoDB transaction log Code (stored procedures, stored functions, triggers, event schedulers) Server

26 Lesson Union Queryis to combine two or more query results into one result.The where of the two statements is more complex, it is cumbersome to write together, and it is divided into two simpleMysql> SELECT * from goods where cat_id =3Union-select

Percona xtrabackup ( PXB) is a backup tool developed by Percona Company for the physical hot standby of MySQL database, supporting MySQL (Oracle), Percona Server and MariaDB, and all open source, is the industry's conscience. Tool SetAfter the

Recently looked at the Kigg framework, found that in the EF + MySQL database, the data is garbled, using the tool (Navicat ) to view the structure of the table category found Kigg database is latin1 encoded by default (default Charset=latin1), as

Reference article:Http://ourmysql.com/archives/1359?utm_source=tuicool&utm_medium=referralOfficial: Https://github.com/box/AnemometerSingle-node anemometer monitoring1 Installing Anemometer# cd/data/www/web3# git clone

Set the user to show database permission firstGrant Select,insert,update,delete on redmine1.* to [e-mail protected]"%" identified by "Jira";Add super permissions and allow remote access:GRANT all privileges on * * to ' myuser ' @ ' 192.168.1.3 '

String functionsASCII (str)Returns the ASCII value of the first character of the string str (str is empty when the string returns 0)Mysql> Select ASCII (' 2 ');50Mysql> Select ASCII (2);50Mysql> Select ASCII (' dete ');100ORD (str)If the string str

How to use HAProxy to Set up MySQL Load balancing Dec 2, MySQL, Scaling, Server optimization Ubuntu, Debian PreludeHAProxy is an open source software which can load balance HTTP and TCP servers. In the previous article on HAPROXY we configured load

MySQL Append comment or a lot of changes comment 2016-01-25 20:28:05Category: MySQLMySQL 5.6.14The previous project was rather hasty, with no comments on the built-in statements.Now you want to complete the annotation information.But MySQL late

MySQL turn on slow query log MySQL accelerated query speed of a unique weapon: query cache on the MySQL query cache from five angles for detailed analysis: How to query cache, how to configure, how to maintain, how to determine the performance of

8. Install Apache Http Server:[email protected] ~]# Yum install httpd9. Download Extmail and Extman and initialize the Extmail database using the MySQL script provided by ExtmanVisit the Extmail official website (http://www.extmail.org/) to download

I. Introduction of MVCCMVCC (multiversion Concurrency control), a multi-version concurrency control technology that allows most of the transaction engines that support row locks, no longer simply use row locks for concurrency control of the database,

Changing password for database users is one of the more common tasks for DBAs. There are several different ways to password changes to the MySQL user account. The recommended way to use cryptographic functions is to change the password.This paper

JDBC (Java Data Base Connectivity,java database connection) is a Java API for executing SQL statements that provides unified access to a variety of relational databases, consisting of a set of classes and interfaces written in the Java language.

1. Create Categories Admin Page Mainly includes the following pages: A. index.php, prepare various variable data. For display page use. B. categories.html.php, showing categories. C. form.html.php, which is used to edit or add author pages. Page

Simple Mysql tutorial (3) and simple mysql tutorial In the previous article, I introduced a simple mysql tutorial (2) Merge two tables with the same structure in mysql: (Note that the structure of the two tables must be the same) There are two

MySQL replication introduction and setup, mysql replication setupMySQL Replication MySQL replication is a MySQL Server (slave) that replicates logs from another MySQL Server (master) and then parses the logs and applies them to itself, similar to