MySQL

MySQL logs can be set up via MySQL's my.cnf file. However, if the log file is not cleaned or recycled for a long time, it will cause the log file to become bigger and larger, thus affecting the performance of MySQL. And the use of the RPM package

Introduction of Environment Configuration 1. Introduction of experimental environment Rsyslog Server Os:centos Release 6.5 (Final) x86_64Rsyslog SERAVR ip:211.149.204.229Rsyslog Client Os:centos Release 6.5 (Final) x86_64Rsyslog Client ip:63.223.64

Three kinds of return to MySQL tutorial insert a record to return the record ID method Method One ID Int (one) not null PRI key auto_increment,name varchar (a), backup varchar (50)Now, when you want to insert a record, return his ID value (insert

Zabbix as a monitoring software is very flexible, supporting the data types are very rich, such as digital (no plus or minus), digital (floating-point), log, text and so on. All we need to do is use the script to collect the data, then Zabbix

MySQL InstallationInstall MySQL on Linux/unixThe Linux platform recommends the use of the RPM package to install Mysql,mysql AB provides the following RPM package download address: Mysql-mysql server. You need this option unless you only want

Infobright is a column-type database based on a unique proprietary knowledge grid technology. Infobright is open source MySQL Data Warehouse solution, introduced a column storage solution, high-strength data compression, optimized statistical

Table partitioning is only recently known Oh, I used to do is the table to achieve the billion level of data, I would like to give you a description of the MySQL table partition to create and use it, I hope to be helpful to you classmates. Table

One: MySQL myisam table damage Reason summary: 1, the server suddenly power off causing data file corruption, forced shutdown, did not first shut down the MySQL service; the mysqld process was killed while writing the table.2, disk damage.3, the

At present, there is no database products specifically for the cross-IDC optimization, in theory by the industry that the best solution is based on the Paxos protocol (temporarily only Google made the implementation, Google F1), today only discusses

This article will explain in detail the use of a very broad mem_root structure in MySQL, while eliminating the debug section of the information, only to analyze the normal situation, the use of mem_root in MySQL to do the memory allocation

Introduction:MySQL sometimes forget the root password do not panic, you can reset the password without the original passwordLinux:1. Edit MySQL configuration file my.cnfVI/ETC/MY.CNF #编辑文件, find [mysqld], add a line below

Data access component for MySQL (MYDAC) is a component library of the Access components that provide direct access to the MySQL database server. MYDAC can be connected directly to the MySQL server or MySQL client library. MYDAC is used to help

These points of injection point generation are mostly located at the HTTP header locationCommon HTTP injection points are generated in "Referer", "X-forwarded-for", "Cookie", "X-real-ip", "Accept-language", "Authorization"; Less-18 Header

There are many reasons for not being remote, and the problem I am experiencing today is that I cannot remotely connect to an instance I created on EC2 by Navicat.1. Through the command "Netstat-an|grep 3306" check 3306 ports open to those addresses,

1. The year of Popular Science:①, not the whole hundred years can be divisible by 4 for a leap year. (such as 2004 years is a leap year, 2100 is not a leap year) ②, the whole century can be divisible by 400 is a leap year. (as 2000 is a leap year, 19

Install MARIADB, the default is no password, but generally refers to the password to be set. There are a variety of problems when you set a password, and you may not understand its rationale. I tried both methods, but failed. The following two are

Binlog is a binary log file of MySQL record operation, there are three formats to choose from, but the old SBR is not suitable for most business needs now, so most of them are recommended to use MBR and RBR, that is, mixed or row, and the reason for

MySQL Database (1)Although it is a good idea to save data to disk in file form. But people have invented things that are more formatted and faster and easier to write and read-databases (if you read RTHK's information, they call it "the database").

Five best MySQL GUI tools recommendedin this article, we'll cover some of the most common MySQL GUI tools and attach download links. I hope we can make better use of these tools. AD: Network + Offline Salon | Mobile app Mode innovation: give you a

1. Change Root Userbashsu -## OR ##sudo -i2. Install MySQL YUM Repositoryfedorabash## Fedora 25 ##dnf install https://dev.mysql.com/get/mysql57-community-release-fc25-9.noarch.rpm## Fedora 24 ##dnf install https://dev.mysql.com/get/mysql57-community-