The logs in MySQL are mainly divided into the following categories:Query logSlow query logError logBinary logRelay LogTransaction log
DescriptionThe Linux system supported in this experiment is the CENTOS7 version, the database used is base
Catalogue (technical article)More about the index, divided into the following points to explain:I. Overview of indexes (what are indexes, advantages and disadvantages of indexes)Second, the basic use of the index (CREATE INDEX)Third, the basic
MySQL InnoDB supports three kinds of line locking methods:Row lock (Record Lock): The lock is added directly above the index record.Gap Lock: Locks are added to a nonexistent free space, which can be between two index records or the space after the
one, CONCAT () functionThe CONCAT () function is used to concatenate multiple strings into a single string. Using data table info as an example, where select Id,name from Info LIMIT 1, the return result is +----+--------+| ID | Name |+----+--------+
Problem reason: remote login mysql error after migrating database to MySQL host:1130 ' 10.0.0.8 ' is This MySQL ServerWORKAROUND: Switch to MySQL host and refresh MySQL database after entering MYSQmysql> FLUSH privileges;Successful remote login
Environment:Master, Binlog_format from library = statementIsolation level: RC
Main Library Session 1
Main Library Session 2
Main Library Session 3
From a library session
In general, when MySQL migrates from Windows to Linux, there are standard tutorials on the Web:1) Enter the/mysql/bin directory on the Windows platform (assuming your database name is MyData)Execute the mysqldump command to export your database,
Recently used cicada known CMS station than more, feel pretty handy, but in the installation of customers will appear installation error, the reason is very simpleLooking at their Install.sql file, the default value for some time fields is 0000-00-00
1. MySQL Data Recovery Common approachThere are generally three ways to recover from MySQL:1. Officially recommended based on fully prepared +binlog, it is common practice to restore the most recent full-time, then through
Key monitoring-mysql-nginx-php One, Zabbix monitoring MySQL is configured on the client: [[email protected] ~]# vim /usr/local/zabbix/ etc/chk_mysql.sh#!/bin/bash# ----------------------------------------------------------------------------
An error occurred while inserting a set of data into the MySQL database! The database is relentless. Error: Error 1365 (22012): division by 0; meaning: You cannot insert the result of an operation with a divisor of 0 in the previous database. So go
Experimental Summary:This experiment hosts the system as CentOS 6.9 by default.HOST1 host as Remote log client Installation: Rsyslog (default installation), Rsyslog-mysqlHost2 host as Log server installation: MySQL (default installation, can also
Original link: Http://isky000.com/database/mysql-perfornamce-tuning-schemaMany people have the database design paradigm as the database table structure of the "bible", that as long as the requirements of this paradigm design, you can make the design
Standalone index:A stand-alone index refers to an indexed column that cannot be part of an expression, or a function's argument Example 1:SELECTactor_id fromActorWHEREactor_id+1=5--This writing, even if the index on the actor_id, it does not
One, the group copy is a what ghost?Start with MySQL replication technology, first of all, MySQL asynchronous replicationIn asynchronous replication mode, the execution transaction on master generates Binlog,slave on the local relaylog by connecting
In the last few days in the project to the win on the database to Ubuntu, so the first thing is to export the SQL script from the win Navicat directly, and then into the Ubuntu import will report errors, skip the error continues to cause the
Reset the msyql Database root Password and msyql Database root Password
Password resetting method:
The specific method is:
1. Find the my. ini configuration file in the installation directory and open the configuration file,
Find the [mysqld]
Implementation Analysis of MySQL statement locking, mysql statement implementation
Abstract: Analysis of Two SQL statement locks in MySQL
Check the lock applied to the SQL statement under explain.
SLQ1:select * from t1 where id = 10;SQL2:delete from
MySql Data backup script (not original), mysql Data Backup
Create a file xxx. bat with the following content:
@ Echo offSet hour = % time :~ 0, 2%If "% time :~ 0% % "=" "set hour = time :~ 1, 1%Set now = % Date :~ 0, 4% % Date :~ 5, 2% % Date :~ 8,
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.
A Free Trial That Lets You Build Big!
Start building with 50+ products and up to 12 months usage for Elastic Compute Service