MySQL master-slave status detection

Installing UuencodeYum Install SharutilsCreate a shell script#!/bin/bashdate_str= ' Date +%y%m%d ' slave=$ (/disk/mysql/bin/mysql-ucheckslave-p123-h 127.0.0.1-e "show slave Status\G " | grep Running | grep Yes | WC-L) if (($slave = = 2) then echo

MySQL 5.6 Sets the reason for invalid value for Long_query_time

Problem:Use the Internet to find the way to open the slow query log:Add in/ETC/MY.CNFLong_query_time=1slow_query_loglog_queries_not_using_indexes=1Then restart MySQL.The slow query log is really open, with select Sleep (0.5), select Sleep (1) to

MySQL installation on Linux II (MySQL source installation)

1. Download the appropriate MySQL installation source packageAddress: http://dev.mysql.com/downloads/mysql/5.1.html2. Uninstall unused old installed MySQL if previously installedSince many Linux distributions are preloaded with MySQL, they are

Source code compilation Install MySQL

1. First install the CMake # wget http://www.cmake.org/files/v2.8/cmake-2.8.4.tar.gz # tar zxvf cmake-2.8. 4.tar.gz # CD cmake-2.8. 4 #./configure # make # make Install 2. Pre-installation system settingsBuild

MySQL Master-slave backup

MySQLdual-Machine hot standbyEnvironment description650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M00/4C/C1/wKioL1RE0zbAm9B1AAJWSS3H_Mc796.jpg "title=" 1.jpg " alt= "Wkiol1re0zbam9b1aajwss3h_mc796.jpg"/>Msql Primary and standby structure1,

Remote linux server MySQL database regularly backed up and deleted

There are some on-line Linux under the regular backup of MySQL method, but many of the steps are not detailed enough, not suitable for beginners, they have been pondering for a long time, finally fix.1.Linux server is generally the SSH protocol, if

Javaweb Learning Summary (37)--Get the MySQL database auto-generated primary key

The test script is as follows:1 Create Table test1 2 (3 int Primary Key Auto_increment, 4 varchar () 5 );Test code:1 PackageMe.gacl.demo;2 3 Importjava.sql.Connection;4 Importjava.sql.PreparedStatement;5 ImportJava.sql.ResultSet;6

MySQL forgot password

Sometimes suddenly forget the MySQL password will be really uncomfortable, here is a MySQL password forgot to reset the password method, operating system Win8,mysql version:5.6.101 shut down the Mysql.exe,mysqld.exe process inside the task manager;2

FIX: MySQL is blocked because of many connection errors;

Environment: CentOS 6.5,mysql 5.6.19Problem:Error when using Telnet to l0.0.1.120 3306 databaseKHost ' l0.0.1.120 ' is blocked because of many connection errors; Unblock with ' mysqladmin flush-hosts ' Connection closed by foreign host.Cause: The

MySQL Paging stored procedure

DROP PROCEDURE IF EXISTS Pr_pager;CREATE PROCEDURE Pr_pager (In P_table_name VARCHAR (1024),In P_fields VARCHAR (1024),In P_page_size INT,In P_page_now INT,In P_order_string VARCHAR (128),In p_where_string VARCHAR (1024),Out P_out_rows INT)Not

Execute MySQL statement in Shell script

For automated operations, such as backup recovery, DBAs often need to encapsulate SQL statements into shell scripts. This paper describes several methods of SQL statements for shell scripts in MySQL database under Linux environment, for your

Several modes of MySQL replication

In MySQL 5.1, the improvement in replication is the introduction of new replication technologies: row-based replication.Several modes of MySQL replicationIn MySQL 5.1, the improvement in replication is the introduction of new replication

"MySQL" common operations

2.mysqlService MySQL StatusMySQL--versionMysql-h Server host address-u user name-P user PasswordExit exitsMYSQL-H host name-u user name-P connection remote MySQL1, database Backup commandMysqldump-h localhost-u root-p--default-character-set=utf8

MySQL bulk delete tables based on regular expressions

Recently in the maintenance of a WordPress mall project, the mall is multi-station, will be independent of the station to create a few tables. Project on the test server, it seems to be a malicious crawler registration, resulting in thousands of

MySQL master-slave monitoring script:

In large-scale web site is often the master from the design of the database, if read and write according to the design pattern is only the main library above, then from the server is often the role of intelligent backup, sometimes the backup port

MySQL allows access to other computers to open

First go to MySQL:Mysql-u RootIf you have a password, you are prompted to enter itThen enter the following authorization code,The following is the authorized user root to use the password admin123 from any host to connect to the MySQL serverGRANT

MySQL boot prompt: The server quit without updating PID file (...) Failed

I found a lot on the Internet.1. may be/usr/local/mysql/data/rekfan.pid file does not have permission to writeWORKAROUND: Give permission to execute "chown -R mysql:mysql /var/Data" "Chmod-r 755/usr/local/mysql/data" Then restart mysqld! 2. The

MySQL ibdata1 file migration

Purpose: Host system/var directory is almost full, the query is the largest file is MySQL ibdata1 file, 17G size, it is necessary to migrate this file to other directories to release the/var directory space.1. It's a good habit to back up the

Mysql method for obtaining the total number of rows of group by records, mysqlgroup

Mysql method for obtaining the total number of rows of group by records, mysqlgroup Mysql can obtain the total number of record groups in a field within the group by statement, but cannot count the number of records in the group. Mysql SQL

Detach mysql Residue

Detach mysql Residue 1. Check whether mysql exists in the control panel. If yes, uninstall it. Or run the mysql installation file of the same version and select "remove" to uninstall it. 2. the mysql service is still running after it is

Total Pages: 3233 1 .... 1844 1845 1846 1847 1848 .... 3233 Go to: GO

Contact Us

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

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.