MySQL

Note: The following are rewritten in the My.ini file in the MySQL directory (technical text).First, InnoDB memory optimizationInnoDB uses a chunk of memory to do the I/O cache pool, which is used not only to cache InnoDB index blocks, but also to

The database operation is divided into three parts, namely, DDL (database, table operation) DML (data Delete and change) DQL (check)"DDL" CREATE | ALTER | DROPDatabase"CREATE DATABASE"CREATE datebase database name DEFAULT charracter SET UTF8 COLLATE

Recently contacted MySQL more, take this to record some knowledge points.Tips:1. When the data is exported to a. sql file, the single quote ' is escaped, and the final INSERT statement is \ '2. When inserting non-repeating data (insert if not exist),

MySQL first time the next morning connected to the wrong, solution com.mysql.jdbc.exceptions.jdbc4.CommunicationsException:Communications link failureCom.mysql.jdbc.exceptions.jdbc4.CommunicationsException:Communications link failure Last packet

Select statement execution Process:START ———— >from------>where (SELECT, appropriate line)--------->group by (grouping)---------->having (filtering the grouping) ———— >order by ( Sort) ———— >select (projection, suitable field) ———— >limit ———— >end

Environment Kernel Information:[Email protected] ~]# uname-alinux lodboyedu-2.6. -696. el6.x86_64 #1: £ º x86_64 x86_64 x86_64 Gnu/linuxZabbix reason for startup failureThis error occurs at startup:[Email protected] zabbix-3.2. 7]

Recently logged on to a server MySQL total error:Access[[email protected] ~]# mysql-u root-pEnter Password:ERROR 1045 (28000): Access denied for user ' root ' @ ' localhost ' (using Password:no) denied for user ' root ' @ ' localhost ' (usi ng

A brief introduction: We are going to test todayTwo-Shard rule Sharding-by-murmur1 Table-related configurationidmurmur  2 function-related configuration    0  2  160   The weight of the weightmapfile node, the node without the specified weight,

SELECT into OUTFILE>HelpSelect; Name:'SELECT'Description:syntax:SELECT [All | DISTINCT | Distinctrow] [high_priority] [max_statement_time = N] [Straight_join] [Sql_small_result] [Sql_big_result] [Sql_buffer_result]

Under Window1. Export the entire databaseMysqldump-u user name-p database name > exported file nameMysqldump-u dbuser-p dbname > Dbname.sql2. Export a tableMysqldump-u user name-P database name Table name > exported file nameMysqldump-u dbuser-p

2017-10-30Next article (use Java IO package for file read and write operations here, I'll summarize how to use JDBC to connect to the MySQL database and perform data query operations . SceneUse the JDBC connection database to query the data, return

1. Application EnvironmentRDS (database) Migration between cloud vendors, mysql-proxy implementation of RDS instances can be accessed through the intranet, to achieve late database data export, import, master-slave operation2, Mysql-proxy build

Environment : three machinesPrimary server: 192.168.1.130Main Standby machine: 192.168.1.131Monitoring machine: 192.168.1.132130 and 131, is MySQL dual master architecture1. Install the Mha4mysql-node on three machinesYum-y Install Perl-dbd-mysqlTAR-

View MySQL Execution planUse Navicat to view the MySQL execution plan:Open Profile Analysis tool:Check to see if it takes effect: Show variable like '%profil% ';View process: Show Processlist;Select database: Use Db_jiakao;Type of all analysis: Show

2.1 Download MySQL1 Website: https://www.mysql.com/2mkdir -p/root/soft/mysql3 [email protected] ~]# cd/root/soft/mysql/4wget https://dev.mysql.com/get/ Downloads/mysql-5.7/mysql-boost-5.7.20.tar.gz2.2 Downloads OpenSSL1 Website:

One, multi-table connection query# Focus : outer link Syntax select field List from table 1 Inner | left | Right join table 2 on table 1. field = Table 2. Fields;1, Cross link: No matching criteria are applicable. Generate Cartesian Product

This article is mainly from the principles, manuals and source code analysis in PHP query MySQL return a large number of results when the memory footprint of the problem, while the use of MySQL C API is also involved.Yesterday, a colleague in the

Reference: Https://pypi.python.org/pypi/py-mysql2pgsqlThe company has a project, originally used MySQL database, now to change to Postgres. So I searched and found a py-mysql2pgsql tool. Here are the notes:Suppose we want to import the 2 libraries

Mysql zip archive (5.7.19) Installation tutorial details, mysql5.7.19 1. Download the zip archive version http://dev.mysql.com/downloads/mysql/ from the official website MySQL v5.7.19 official version (32/64-bit installation version and zip

Detailed description of mysql redundancy and duplicate indexes, detailed description of mysql redundant Indexes Mysql allows you to create multiple indexes on the same column, whether intentionally or unintentionally. mysql needs to maintain