A hot backup of MySQL on the primary server is required in the near future, i.e. data is synchronized in real time.Refer to the article as follows: http://369369.blog.51cto.com/319630/790921/My environment is as follows: Host a ip:42.62.25.47 from
There are two major strides in opening MySQL's remote login account: 1. Determine that the firewall on the server does not block port 3306. MySQL default port is 3306, need to determine the firewall does not block 3306 port, otherwise remote is
1. Download the Ubuntu version of MySQL2. Unzip MySQL3. Installationsudo dpkg-i mysql-common_5.6.21-1ubuntu14.04_amd64.deb mysql-community-server_5.6.21-1ubuntu14.04_amd64.deb Mysql-community-client_5.6.21-1ubuntu14.04_amd64.debError notification
MySQL Delete alias problem-log of meteor flame-NetEase Blog http://wzl3585493.blog.163.com/blog/static/7615611020126188377970/Delete from student s where s.id in (All-in);(Execution failed)Select s.* from student s where s.id in ();( executed
MySQL wildcard charactersThe pattern match for SQL agrees that you use "_" to match any single character, while "%" matches the random number of characters (containing 0 characters). In MySQL, the default mode of SQL is to ignore uppercase and
MySQL connection operationEstablish a connection$con = mysql_connect (' localhost ', ' root ', ' 123456 ');Determine if the connection is successfulif ($con) {Die (' Connection failed! '). Mysql_error ());Exit}Select a character SetMysql_set_charset
There is no detailed description of key_length in the MySQL manual, and the calculation method of Key_length is verified by experiments.
When the index field is a fixed-length data type, such as Char,int,datetime, if there is a null tag, this
Prerequisites: You need permission to have the database server1: Modify the My.ini configuration file Mysqld: What does D mean?Deamon Service program running in the background, adding a row to skip permission validation2: Stop the MySQL service
Mysql error-Modify mysql. sock location, mysqlmysql. sock
Sometimes Mysql. sock location errors may occur in mysql, resulting in the inability to connect to the database.
When an error is reported in mac:
First modify my. cnf
The location is
Mysql optimization points section, mysql optimization Section1. Rationality of Database Table Design
1) three paradigms
1. paradigm: atomicity, attributes cannot be divided;
2. paradigm: No part of dependency,
Example: (student ID, course name) →
Slow mysql subqueryWhen you use the explain tool to view the execution plan of the SQL statement, if the select_type field contains "DEPENDENT SUBQUERY", you should note that, you have fallen into the slow mysql subquery "pit "... Let's look at a
Considerations for MySQLDROPTABLE and DROP large tables
Syntax:
Delete table
DROP TABLE SyntaxDROP [TEMPORARY] TABLE [IF EXISTS] tbl_name [, tbl_name] ... [RESTRICT | CASCADE]
You can delete one or more tables at a time. You must have the DROP
Familiar with MySQL stored proceduresStored Procedure is a set of SQL statements for specific functions. It is compiled and Stored in the database, you can call and execute a stored procedure by specifying its name and giving a parameter (if the
Mysql master-slave switchover steps
1> normal switchover
1) Check the output of the show processlist statement from the server until you see Has read all relaylogwaiting for the slave I/O thread to update it
2) Make sure that the slave server has
MySQL trigger foreachrowFor each, each row is affected and all triggers are executed, which is called a row-Level Trigger. In oracle triggers, row-level triggers and statement-level triggers can be executed only once regardless of the number of rows
Back up the MySQL database in linux and delete the Backup Data seven days ago
#! /Bin/bash # backup database hz jshuabo sdhuaboname =$ (date + % Y % m % d) /alidata/server/mysql-5.1.73/bin/mysqldump-u root-p123456 hz>/root/sqlBackup/hz. $ name. SQL/
Use the GROUP_CONCAT function of MySQL to implement aggregate multiplication.The MySQL aggregate function provides addition, average, minimum, and maximum, but not multiplication. Here we use the existing MYSQL GROUP_CONCAT function to implement
Shell to export each mysql stored procedure as a single file
# Shell implementation: export the Stored Procedure Code in mysql as the file dbcn = "mysql-h172.16.1.194-uroot-p123456"; db = BCReport_Sync_Executor; ii = 0; ct = '$ dbcn-N-e "select
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