MySQL

MySQL replication can ensure the redundancy of the data and read and write separation to share the system pressure, if the primary master replication can also be good to avoid the primary node single point of failure. But there are some problems

MySQL Master-Slave introductionConfigure the Primary MySQL after installation modify the MY.CNF configuration file, modify the MY.CNF, add server-id=130 and Log_bin=dashuo1 [[email protected] ~]# vim /etc/my.cnf After

Installation stepsBefore installing, we can detect whether the system comes with MySQL installed:rpm -qa | grep mysqlIf you have a system installed, you can choose to uninstall:rpm -e mysql　　// 普通删除模式rpm -e --nodeps mysql　Installation wget https:/

concat function in MySQLHow to use:CONCAT (STR1,STR2,...)Returns the string that results from the connection parameter. If any one of the arguments is NULL, the return value is null.Attention:If all parameters are non-binary strings, the result is a

The company sent a question to me, the title is as follows:In the test database, there is a flow_user table that finds all records with the same character and greater than or equal to 2 in the email field. The final effect is as

CausesIn the local database execution test platform database structure file Data_struct.sql, the execution of the build table statement resembles the following:CREATE TABLE' demo ' (' ID ' )int(Ten) unsigned not NULLAuto_increment,' name ' Longtext

[[email protected] ~]# MySQLERROR 1045 (28000): Access denied for user ' root ' @ ' localhost ' (using Password:no)Encountered:ERROR 1045 (28000): Access denied for user ' root ' @ ' localhost ' (using Password:no)On the internet to find a lot of

11.1 Lamp Architecture Introduction· LAMP = Linux + Apache (httpd) + MySQL + PHPThree characters can be in a machine, can also be separated (httpd and PHP to be together)Apache extracts data from MySQL via PHP module (dynamic request)The process of

1. What is QPS and TPS?QPS is the number of queries processed by MySQL per secondTPS is the number of transactions that MySQL processes per second2.QPS and TPs How to ask?QPS = Questions/uptimeTPS = (com_commit + com_rollback)/UptimeFor variable

MySQL view maximum number of connections and modify maximum connections1. View the maximum number of connectionsShow variables like '%max_connections% ';2. Modify the maximum number of connectionsSet GLOBAL max_connections = 200;The following

Ubuntu16 Install mysql5.7 not prompt for password, after installation, modify the MySQL password default passwordMySQL default password is emptyBut when you use the MYSQL-UROOT-P command to connect to MySQL, an errorERROR 1045 (28000): Access denied

Database related 1. InnoDB's LogInnoDB has a lot of logs, and there are 2 concepts in the log that need to be clearly divided, logical logs and physical logs. 1.1 Logical logsThe information log about the operation becomes a logical log.For

Mysqlcheck is a tool that MySQL comes with, the function is the 保养 table, actually is examines, analyzes, fixes and optimizes. Here's an introduction to the simple use of the Mysqlcheck tool, the official documentation here Original URL:

1. First verify that the server is in a secure state, that is, no one can connect to the MySQL database arbitrarily.Because the MySQL database is completely password-protected during the reset of the root password of MySQLStatus, other users can

DBA DAY04One, multi-table querySTU_ID Name ClassPayment FormClass tableScore TableEmployment Chart1.1 Copy Table (function: Backup table, quick build table)Mysql> CREATE TABLE table name SQL query; CREATE database DB4;Use DB4;CREATE TABLE User2

Ubuntu system under preparation phase update download sourceapt-get updateApache2 Installationsudo apt-get install apache2默认www目录在"var/www"下安装目录/etc/apache2/Launch Apache Service/etc/init.d/apache2 start或sudo /etc/init.d/apache2 startRestart Apache

The last article through the requests+ to crawl the cat's-eye movie list, this time through the Requests+beautifulsoup to crawl again (in fact, this site is more suitable to use the BeautifulSoup library crawl) 1. Analyze the Web page source

MySQL benchmark test (i)-reasons, strategies, ideas, reasons for using benchmark Verify some of the issues you think are verified by benchmarking and simulation data. Resolve some anomalies in the production system Test the current

Recover the specified database and table from the mysql full-database backup, and mysql backup     Requirement: development requires importing data from a certain table on a certain day, while our data is full-database backup. For example, from

Comment box with emoji pop-up layer, semantic + emoji picker, java. SQL. SQLException: Incorrect string value: '\ xF0 \ x9F ..', When you are doing a project on your own and making comments. I selected the semantic. js prototype. This is not used in