MySQL

MySQL Binlog Detailed1. PrefaceThe log is to record every change in the database into a dedicated file, which is called a log file. MySQL only opens the error log by default, because too many logs will affect the processing performance of the system.

InMySQLClient andMySQLThere is a character set converter between the service side. Character_set_client =>GBK: The converter knows that the client is sending a GBK format encoding character_set_connection=> GBK: Convert the data sent from the

MySQL database optimization related knowledge:The choice of two common engines1, MyISAMDefault engine when MySQL version is less than 5.5Advantages: Good at data processing, high-speed reading and writing; The data is stored in the order of

Read Lock: All sessions can only be queried by the SELECT statementTABLE [table_name] READSELECT * FROM table_name;INSERT into table_name () VALUES (); #一直等待, until unlocked or timed outWrite Lock: only the current session can be added and checked,

As a programmer, the importance of mastering a database is self-evident, MySQL as a widely used database, it is necessary to master it, now and everyone a learning MySQL database!The first step to learning MySQL is, of course, installing and

Increasetmp_table_sizevalues. MySQL's configuration file,tmp_table_sizeThe default size is32M. If a temporary table exceeds that size,MySQLproduce aThe table Tbl_name is fullform of error if you do a lot of advancedGROUP byquery,

In recent projects, a shell script is required to perform SQL operations on a database and convert the results to txt, and the filter results are tab-delimited and saved to a remote server for other people to use in Excel to read content in

Wrote a more complete MySQL multi-instance start stop script.[[email protected] 3307]#Cat MySQL#!/bin/sh[ $#! = 1]&&{Echo"usage:/data/3307/mysql {start|stop}"Exit 0}if[" $"=="Start"];thenif[!-f/data/3307/mysqld.pid];then/application/mysql/bin/mysqld_

In general, when the data of our database exceeds the 100w record, we should consider the table or partition, this time I would like to elaborate on some of the methods of the table. First of all, we need to figure out how many tables, the premise

1. Change the host data of the first record of the user table in the local database to%, or use the update user set host= '% ' where user= ' root ';2, the command line client with MySQL operation the following steps: First to enter a password,

Reference:http://tieba.baidu.com/p/3042628829Step1:Apple--System preferences, bottom point MySQL close MySQL service in popup page (click Stop MySQL server)Step2:Enter Terminal input: cd/usr/local/mysql/bin/Log in Administrator right after enter

1) Database classification2) System functions3) Create a database4) Select Database5) Build a table statement6) Inserting data7) Delete the data from the user delete the database list8) Modify table data9) Query data10) User AuthorizationOne) Show

/an ASCII 0 (NUL)    characters. \ nA new line character.\ tA locator character.\ rA carriage return character.\bA backspace.\‘a single quotation mark ("'")    characters. \  "a double quotation mark ("" ")    characters. \\a backslash ("\")   

In the process of cloning a server into a test environment during a production, it is found that the relevant network configuration after cloning has been modified to the test environment, but it is reported that the following error occurred after

SELECTplc.id, Plc.policy_no, Plc.out_date, Og.organ_name, Ir.insurer_name, Pd.product_name, Plc.policy_amount, Plc.channel, Plc.settle_status, Bill.agent_amount, Bill.fee_percentage, Bill.settle_status, Mem.real_name fromTb_policy_info plc

MySQL Tutorial master-slave synchronization failed Last_io_error:got fatal Error 1236 from master workaroundThis error is encountered such as: "Last_io_error:got fatal error 1236 from master when reading data from binary log: ' Could not ' find

MySQL Optimization related summary2016-05-31 Database concentration camp Optimization Order: Select the appropriate engine and table structure and data type Build an index and optimize SQL. Increased cache, Redis, memcache.

MHA is widely used in MySQL database, it is small and easy to use, powerful, realize the MySQL replication architecture-based self-manual master-slave failover, from the library redirection to the main library and automatic synchronization. However,

First, TIMESTAMPDisplay format: Yyyy-mm-dd HH:MM:SSTime range: [' 1970-01-01 00:00:00 ' to ' 2037-12-31 23:59:59 ']TIMESTAMP DEFAULT current_timestamp on UPDATE current_timestamp refreshes this data column when creating new records and modifying

Complete mysql query statement sorting and mysql statement sorting -- Basic Query Select * from pet -- List specified Columns Select name, owner form pet -- Performs arithmetic operations directly to alias A Field Select sin (1 + 2) as sin -- Where