MySQL

The last time I encountered MySQL master server data consistency problem, think of it was a few years ago, but also vaguely remember the panic scene, fortunately, finally with the help of Maatkit solve the problem. A few years later, when I faced

Mysqlslap--help1.1.1 Remote Connection TestMysqlslap-a-H "10.10.10.92"-p33061.1.2 50 and 100 respectively, the total query 1000 times, iteration 5 times, the local account password connection test, output CPU informationMysqlslap-a--concurrency=50,10

First, install MySQLThere are so many different ways.Second, excerpt from: https://linux.cn/thread-14135-1-1.html1) First add the following in the [Mysqld] field on DB1 my.cnf:Server-id = 1//database ID number, 1 is represented as master, where

Group_concat function in MySQLThe complete syntax is as follows:Group_concat ([DISTINCT] field to connect [order by Asc/desc sort field] [Separator ' delimiter '])Basic QueryMysql> select * from AA;+------+------+| id| name |+------+------+| 10|| 20|

MySQL: Client Connection tool-U,--user=name???? Specify User name-P--password???????? Specify password-h–host=hostname Specify the server IP or domain name-p–port=???????????? Specify portOf course, you can also specify the user name and password in

first, the data table structureCREATE TABLE ' Jx_attach ' ( ' attach_id ' int (one) not null auto_increment, ' feed_id ' int (one) DEFAULT NULL, ' att Ach_name ' varchar (255) NOT NULL, ' cycore_file_id ' varchar (255) DEFAULT null, '

When the MySQL service starts, not only listens to the Ip:port, but also listens to a socket, our installation mysql is the monitorListen to the/tmp/mysql.sock. If PHP is local, then PHP and MySQL communication can be communicated through the socket,

As we all know, InnoDB uses IoT (Index organization table), the so-called Index organization table, and leaf nodes store all the data, which means that data is always stored in some order. So the question is, if it is such a statement, how should it

a simple test:Start Transaction;insert into TB1 values (3, repeat (' a ', 65000), ' X ', 1);--commit;rollback;tb1.ibd, respectively, in before you insert, roll back the size of the file before the rollback:Someone in QQ group asked why.--------------

In the data, table-building processing is a very common and useful method.the relationship between tables and tables is 1:1 1:n N.Three different ways.1-to-1 way Example: A husband and wife think: Keep Everyone's information in a table. There are

When I first learned about MySQL, I saw the term undo log, but I didn't know what undo log was, so I had to figure out what undo log was before I could continue to see some MySQL data. What is the principle of undo log? How does it match the other

"Backed-up Commands"1) backing Up the databaseMysqldump-uroot-pwsyht-b Library name >/opt/test.sql #加-B for information on adding use DB and CREATE database db2) View the databaseEgrep-v "#|\*|--|^$"/opt/test.sql #查看test. SQL Library Contents3)

JMeter can also be used for database stress testing, and compatible with various database types, only the corresponding database driver classes and URLs need to be changed. The following is the URL for the database-driven class to be organized. and

1,mysql Installation Scripts1#!/bin/Bash2Rsync='10.39.2.120::wenhui/database/install'3Cmake='cmake-2.8.6.tar.gz'4Mysql='mysql-5.5.24.tar.gz'5Mysql_dir='/usr/local/mysql55'6Mysql_datadir='/data1/mysqldata/mysql3306'7 8 function Main () {9User='

1, Connection MySQL format: mysql-h host address-u user name-P user Password1. Connect to MySQL on this machine. First open the DOS window, then enter the directory Mysql\bin, and then type the command Mysql-u root-p, enter after the prompt you to

Seems to have the same effect, adding a key to the table and set up the index of the table, can be fast data query. The difference between them is that they are on different levels.Key is a part of the relational model theory, such as a primary key (

Mysql optimization tips and mysql tips A comprehensive technology for mysql optimization, mainly including A: Table Design rationalization (in line with 3NF) B: add an appropriate index. [four types: general index, primary key index, unique index

Use shell to automatically back up mysql Databases and shellmysql databases at regular intervals #! /Bin/bashid = "root" # username pwd = "123456" # password dbs = "blog.ewsd.cn dangjian.ewsd.cn idc.ewsd.cn shangfa.ewsd.cn" # list of database names,

Mysql Log learning SummaryI. Log introduction mysql logs are mainly divided into four types. Using these log files, you can view what happened in mysql. These four types of logs are: error logs record problems that occur when mysql service is

MySQL clears slow Query filesThis chapter describes how to generate a new slow Query file online when the slow Query file is large. Test environment: mysql 5.6.21 step configuration slow query default my. the cnf file is in the/etc/directory vim/etc/