MySQL

Playing with Oracle is a bit more focused on the shared pool, especially the library cache, which can really get a lot of performance gains after using bound variables (precompiled SQL). Now after the turn to MySQL, especially innodb a lot of things

Similar to Oracle's parameter files, MySQL's options files (such as MY.CNF) are used to configure the MySQL server, but unlike Oracle, in MySQL, the official called variable (varialbes), but actually called the parameter is also possible, Just

MySQL Character set tuning summary--http://xjsunjie.blog.51cto.com/999372/1355013The character set is a set of symbols and encoding rules, whether in the Oracle database or in the MySQL database, there is a character set selection problem. For the

1. The error message is as follows:Last_sql_error:error ' Can ' t drop database ' Oldboy '; Database doesn ' t exist ' on query. Default database: ' Oldboy '. Query: ' Drop database Oldboy 'Replicate_ignore_server_ids:Master_server_id:11 row in Set (

Reprint https://www.zhihu.com/question/19866767/answer/14942009http://whuai.blog.51cto.com/3539000/862197 Oracle: Data files include: Control files, data files, redo log files, parameter files, archive files, password files. This is divided

One, CPU maximum performance mode CPU utilization characteristics 5.1 Maximum usable 4 cores 5.5 Maximum usable 24 cores 5.6 Maximum Usable 64 cores Once query corresponds to a logical CPU If you look closely, there is an

　　MySQL cluster is based on the NDB storage engine.The whole is divided into three parts, management node, storage node, SQL node.The management node manages the entire cluster, the storage node and the NDB node, which is used to store the data, and

My.ini Configuration for MySQL5.6Note: The following configured server hardware is: 8 core 16G

Just to test a thing, I wrote a stored procedure:delimiter $$Drop procedure if existssp_test$$Create proceduresp_test ()begin DeclareV_cntint; SetV_cnt= 0; whileV_cnt 100000 DoInsert intoT1SelectV_CNT, v_cnt+1, v_cnt+2, v_cnt+3; SetV_cnt=V_cnt+ 1;

In MySQL, an index is a data structure that the storage engine uses to quickly find a target record. Common index types include B-tree indexes, hash indexes, spatial indexes (R-tree), full-text indexes, and so on.Indexes are implemented at the

MySQL database design specification 1, the database naming specification uses 26 English letters (case-sensitive) and 0-9 natural numbers (often do not need) with the underscore ' _ ' composition; the name is concise and clear (the length cannot

Primary Key Index of MySQL index, In MySQL, what are the meanings and differences between primary key indexes and secondary indexes?In the previous sharing, we introduced the differences between clustered indexes and non-clustered indexes. This time

Summary of basic operation commands for Binary Log files in MySQL, MySQL Binary Log, also known as bin-log, is a Binary Log file generated by mysql execution changes. It has two main functions:* Data reply* Master/Slave databases. It is used to add,

Mysql allows remote connection, I. Overview This article describes how to create a remote connection table through the federated storage engine. Test environment: mysql 5.6.21 Step 2 Enable federated storage engine Check whether the federated

Mysql inserts data in batches, mysql inserts data What should I do if MySQL inserts multiple records using INSERT? The following describes how to INSERT multiple records using INSERT in MySQL for your reference. If you see this title, you may ask,

MySQL partition summary, mysql Partition MySQL supports four partitions: RANGE, LIST, HASH, and KEY. Each partition has a special type. For RANGE partitions, there are range columns partitions. LIST partitions have list columns partitions. For HASH

Summary of using the describe command in MySQL, 1. The describe command is used to view detailed design information of a specific table. For example, to view the design information of the guestbook table: describe guestbookdescribe ol_user userid 2.

Create, modify, and delete mysql triggers. // Make a simple exercise. When creating a simple trigger to add an article, the time is automatically added. By default, the author is 'memories of the records'   Show columns from test; // view the table

Create user authorization in Mysql and create user authorization in mysql 1. Create a user: Command: create user 'username' @ 'host' identified by 'Password '; Description: username-the username you will create, host-specifies the host on which the

Mysql optimization -- skip-name-resolveIn the same IDC, the IDC has DNS servers and reverse resolution is performed on the IP addresses of each server, but no reverse resolution is performed on the Intranet IP addresses, therefore, after