MySQL Learn more about MySQL | Shulou Tech Info

Mysql ibtmp1 reclaim space

About ibtmp1 recycling space can only restart the database, a bit of a hole ah ah! [root@raca1 data] # ls-lhtotal 7.6GMurray rwmurr-1 mysql mysql 56 Jul 1

2022-06-01 Database 我要分享

What is the process of backing up Mysql 8.0.18 by xtrabackup 8

This article introduces what the process of xtrabackup 8 backup Mysql 8.0.18 is like, the content is very detailed, interested friends can refer to, hope to be helpful to you. 1. First of all, a slightly larger one is built in mysql8.

2022-05-31 Database 我要分享

Redhat 6.5 mysql upgrade 5.5.48 implementation outline from mysql 5.6.32 to mysql 5.7.16

1mysql os versionredhat 6.52, old version mysql 5.5.48 create test database and test table mysql > create database zxy;Query OK, 1 row affecte

2022-06-01 Database 我要分享

How to use the Netdata Mysql health monitoring plug-in

This article is to share with you about how to use the Netdata Mysql health monitoring plug-in. The editor thinks it is very practical, so share it with you as a reference and follow the editor to have a look. One: mysql file configuration / usr/local/netd

2022-06-01 Internet Technology 我要分享

Mysql multi-instance configuration

Common configuration method of Mysql multi-instance: install mysql dependent package yum install ncurses-devel libaio-devel-ymysql configuration file: pull to server [root@MySql ~] # t

2022-06-01 Database 我要分享

MYSQL_Linux installation simple tutorial

The following mainly brings you MYSQL_Linux installation simple tutorial, I hope these text can bring you practical use, this is also my main purpose of editing MYSQL_Linux installation simple tutorial this article. All right, don't talk too much nonsense, let's just read the following. * experiment

2022-06-01 Database 我要分享

Upgrade from MySQL 5.6 to MySQL 5.7-version upgrade best practice

1. Background MySQL 5.7 is the latest version of MySQL. Compared with MySQL 5.6, it has the following characteristics * performance and scalability: improving the scalability of InnoDB and the performance of temporary tables to achieve faster network and big data loading and other operations.

2022-06-01 Database 我要分享

MySQL- multi-version and multi-instance hybrid deployment

1. Background * centralized operation and maintenance of MySQL database can be deployed to run multiple MySQL service processes on a server, and different socket listens to different service ports to provide their own services. Each instance is independent of each other, and the dat of each instance

2022-06-01 Database 我要分享

Database backup and restore series-- detailed and complete implementation of single table backup and recovery

Reference implementation: https://www.percona.com/doc/percona-xtrabackup/LATEST/innobackupex/innobackupex_script.htmlRest

2022-06-01 Database 我要分享

What are the methods to uninstall MySQL

This article mainly explains "what are the methods of uninstalling MySQL". The content of the article is simple and clear, and it is easy to learn and understand. Please follow the editor's train of thought to study and learn "what are the methods of unloading MySQL"? 1) M of RPM package installation

2022-05-31 Database 我要分享

Steps for Mysql-5.5.32 cmake installation

This article mainly introduces "the steps of Mysql-5.5.32 cmake installation". In the daily operation, I believe many people have doubts about the steps of Mysql-5.5.32 cmake installation. The editor consulted all kinds of materials and sorted out simple and easy-to-use operation methods.

2022-05-31 Database 我要分享

How to solve the problem of large space occupied by quot;mysql-bin.000001"

This article introduces the relevant knowledge of "how to solve the problem that mysql-bin.000001 takes up too much space". In the operation of actual cases, many people will encounter such a dilemma, so let the editor lead you to learn how to deal with these situations. I hope you all

2022-05-31 Database 我要分享

CentOS 6.3 install MySQL-5.7.10

MySQL installation is divided into three types: 1, RPM package installation; 2, binary package installation; 3, source code installation. The first way is relatively simple, directly RPM package installation is OK, or through the yum source to install, but can not customize the installation directory. The third way is more complicated. In general projects

2022-06-01 Database 我要分享

Summary of uninstalling MySQL for Linux platform

1: check if the MySQL component is installed. [root@DB-Server init.d] # rpm-qa | grep-I mysql MySQL-devel-5.6.23-1.linux_glibc2

2022-06-01 Database 我要分享

Introduction to the process of installing mysql Database in centos

This article mainly explains "the process of installing mysql database in centos". Interested friends may wish to have a look at it. The method introduced in this paper is simple, fast and practical. Next let the editor to take you to learn "centos installation of mysql database process introduction" bar!

2022-06-01 Servers 我要分享

The method of using cmake to install mysql on linux

Editor to share with you how to use cmake to install mysql on linux. I hope you will gain a lot after reading this article. Let's discuss it together. Methods: 1. Install ncurses-devel dependency package; 2. Download and decompress mysql compression

2022-06-01 Database 我要分享

How to install Multi-instance and Master-Slave configuration in Mysql under Linux

Editor to share with you how to install multiple instances and master-slave configuration of Mysql under Linux. I hope you will gain something after reading this article. Let's discuss it together. When mysql creates multiple instances, it actually points the DATA file and SOCK,PORT to no.

2022-05-31 Database 我要分享

MySQL mistakenly deleted the database to restore the actual combat

Create test library, table create database test;use test;create table leo (id int,name varchar (10)); insert data insert into leo

2022-06-01 Database 我要分享

Highly available deployment for mysql MMM

What this article shares with you is the highly available deployment of mysql MMM. I believe most people have not yet learned this skill. In order to let you learn, I have summarized the following contents. Without saying much, let's read on. 1 Environment: 1.1 OS and MYSQL vers

2022-06-01 Database 我要分享

MMM high availability experiment

1 Environment: 1.1 OS and MYSQL verson: [root@mysql01 ~] # uname-aLinux mysql01 3.10.0-327.18.2.el7.x86_64 # 1 S

2022-06-01 Database 我要分享