MySQL master and slave Combat and read and write separation

1. MYSQL Master-Slave principle 1) requires at least 2 database servers, one master from, master on bin-log function for recording the main library additions, deletions, modifications, updates SQL statement. 2) asynchronous replication process,

Configure:error:mysql Configure failed. Please check the Config.log for more information.

Add MySQL module to PHP times errorConfigure:error:mysql Configure failed. Please check the Config.log for more information.Workaround:[email protected] mysql]$/configure--with-php-config=/usr/local/bin/php-config --with-mysql-dir

MySQL Index optimization Example description

The following respectively create three tables, and insert 1W simple data for testing, the details are as follows: [1] test_a has a primary key but no index CREATE table ' test_a ' (  ' id ' int () unsigned not NULL auto_incr ement,  ' title '

MySQL Encryption and decryption case

1Define ("ENCRYPT",'2998a15c0cd853edad7');// Key Key2 3 4 field of the stored database is set to BLOB format (binary)5 //Aes_encrypt Encryption6 Insert into' Ks_user ' (user_name, user_pwd)Values('kstest', Aes_encrypt

Mysql/etc/my.cnf

[Client]port=3306socket =/tmp/mysql.sockdefault-character-set=utf8[mysqld]# 1 General configport=3306socket =/tmp/ Mysql.sockdatadir =/u02/mysqlbinlog_cache_size = 1mdefault-storage-engine = Innodbevent_scheduler = 1federatedjoin_ Buffer_size =

MySQL Database Basics 002

One, My YS SQ QL L supported data classes 1. For integer data, MySQL also supports specifying the display width within the parentheses following the type name, such as the INT (5) TableDisplays the width before the number when the value width is

MYSQL Basic Operation Statement collation

Database:CreateCreatte {DATABASE | SCHEMA} [IF not EXISTS] db_name [DEFAULT] CHARACTER SET [=] charset_name.Delete:DROP {DATABASE | SCHEMA} [IF EXISTS] db_name;Display:show{databases| SCHEMAS} [like ' Pattern ' | WHERE expr];Select:Use database_name;

CENTOS7 MySQL database installation and configuration

The system version after the Yum update upgrade isSecond, MySQL installationGenerally, the information given on the Internet is#yum Install Mysql#yum install Mysql-server#yum install Mysql-develBoth MySQL and Mysql-devel were installed successfully,

MySQL built-in functions

String functionsSelect concat (' Hello ', ' word ', ' my ')  myname; // concat ()    link character functions    output  hellowordmy  myname is the alias Select lcase (' MYSQL ');                     //lcase ()     Convert to lowercase       Output  

MySQL uses stored procedures to insert 400W data

CREATE TABLE Dept (/*Department Table*/deptno mediumint UNSIGNED notNULL DEFAULT0,/*numbering*/dname VARCHAR () notNULL DEFAULT"",/*name*/Loc VARCHAR () notNULL DEFAULT""/*location*/) ENGINE=myisamDEFAULTCharset=utf8;CREATE TABLE EMP (/*EMP Employee

MYSQL batch changes to content in the same column

Problem Recurrence:In the MYSQL database, the contents of a given column contain ". wmv" and need to change the WMV format after "." To "FLV"How to SolveUpdate video_info set file_path=substring (File_path,1,length (File_path)-3);Run the above

MySQL group fetch top N Records

http://blog.csdn.net/acmain_chm/article/details/4126306http://bbs.csdn.net/topics/390958705I only used the special form, that is, the group to take the latest record:Select * from (Select*fromorderbydesc) T Group by ClsnoUsing GROUP by only takes

Monitor MySQL with a MySQL template from Zabbix

Monitor MySQL with a MySQL template from Zabbix1. Installing the Zabbix Agent[Email protected] ~]# RPM-IVH http://repo.zabbix.com/zabbix/3.2/rhel/7/x86_64/zabbix-agent-3.2.0-1.el7.x86_64.rpm [[Email protected] ~]# rpm--import/etc/pki/rpm-gpg/rpm-gpg-

MySQL backup script

Perform a full hot backup of the Extmail database daily 01:00, and you can fully recover!First, create a backup script, as follows: 1234567891011121314151617

Some practices when MySQL characters are garbled

1, use the Select function to find all the information in the District data table, found to be garbled.2, then we execute the three set operation, the Character_set_client, Character_set_connection, Character_set_results set to gb2312.3, when we

MySQL's replication rationale and basic configuration

Log type for MySQLBinary log, transaction log, error log, general query log, relay log, slow query logThe binary log has the following contentsData catalog, usually placed in Mysql-bin. XXXXX number)Scroll: Reach a maximum limit, flush logs, server

Express and Database (MySQL) interaction (ii)

First, install Express in front of all said1.express.CNPM | | NPM Install Express--save2. MiddlewareA.CNPM | | NPM Install Body-parser--save When a post is requested, this middleware is needed to process the parametersB.CNPM | | NPM install

MySQL Basics Summary

1. Declaration cursor: DECLARE cursor2. Use the Fulltext child statement of the Creat table statement to enable full-text search when creating the base table3. Undo the existing table s in the database, using: drop table S4. Lookup table structure

Java calling MySQL stored procedure noaccesstoprocedurebodies error

Issue: Calling the MySQL stored procedure in Java encountered the following error:" noaccesstoprocedurebodies=true " to has driver generate parameters that represent INOUT strings irregardless of actual parameter typesWORKAROUND: The Execute

EXPLAIN commands in MySQL, mysqlexplain

EXPLAIN commands in MySQL, mysqlexplain The explain command in MySQL shows how mysql uses indexes to process select statements and connect tables. The information displayed in the explain statement can help you select a better index and write a more

Total Pages: 3233 1 .... 2937 2938 2939 2940 2941 .... 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.