MySQL

Master-master Mutual Primary Preparation1: According to the master and slave configuration steps to configure Masterb to Mastera from the library;2: Make sure that Masterb is not written, get its sync point on Masterb by the show Master Status

MySQL data tables support six types, namely: BDB, HEAP, ISAM, MERGE, MYISAM, Innobdb.These six types are divided into two categories: "Transaction-Safe" (Transaction-safe), including BDB and InnoDB, while the rest fall into the second category,

The customer provides the MySQL environment, but does not support Chinese, Use the following command to view the MySQL character set Connect to the MySQL service and enter the following command Mysql>show variables like ' character_set% '; Shown

Create a function in the master database of the MySQL master-slave replication machine, reporting the following error:Error code:1418. This function has none of the deterministic, NO SQL, or READS SQL DATA in its declaration and binary logging is

Isolation Level Concepts:First, read UNCOMMITTED (read-uncommitted)When the transaction isolation level is set to read-uncommitted (Read UNCOMMITTED), in this state, the data updated by one session is immediately visible to the other session, even

First, login MySQL view with show VARIABLES like ' character% '; The following character set, shown below:+--------------------------+----------------------------+| variable_name | Value

First, the problem descriptionIn MySQL master-slave replication mode, slave reported the wrong "relay log read failure", causing the master-slave synchronization to stop.Mysql> Show Slave Status\g1. Row

　　MySQL provides standard SQL pattern matching and an extended regular expression based on Unix-like utilities such as VI, grep, and SEDpattern-matching format.The pattern matching of SQL allows you to match any single character with "_", while "%"

Because MATLAB is based on Java, but the native Matlab is not JDBC, this is a Java MySQL connection.Only Matlab has this package, in order to properly connect MySQL.1. Download the corresponding package in

Environment: Windows 2003 SP2 + MySQL5.5.28 -Sometimes you need to save the results that you query in one table with a SELECT statement to another table with the same structure, and you can do that with a pair of SQL statements at the command

--preparatory workdrop table if exists Emp;CREATE table if not exists EMP(UID INT primary KEY,Sid int);INSERT into EMP values (+);INSERT into EMP values (2,2);drop table if exists Sal;CREATE table if not exists Sal(Sid Int Primary KEY,Salary

mysql> set global slow_query_log=0; Query OK, 0 rows Affected (0.00 sec)  mysql> set global slow_query_log_file= '/data/mysql_33096/mysqllog/slow_ Query_2014-06-09.log '; Query OK, 0 rows Affected (0.00 sec)  mysql> Show variables like ' slow% '; +--

MySQL binary package installation and customization BasedirPreface: MySQL Binary package, fixed dead. Basedir to be /usr/local/mysql/, But many people like to customize the directory, like I like to put /opt/app/mysql Data Catalog likes to be

Recently in doing Binlog log capture synchronization to the data platform. The initial need for Sqoop to initialize data from the Library data table into HBase, the entire process needs to be automated to minimize human intervention. However, for

The default data file storage directory for MySQL is/var/lib/mysql. The following steps are required if you want to move the directory to/home/data:1. Set up the data directory in the home directoryCd/homemkdir data2. Stop the MySQL service

1. Check if the system has MySQL       use command:       #rpm-qa | grep mysql &NBSP 2, uninstall the installed MySQL       uninstall MySQL command as follows:         #rpm-e-- Nodeps  mysql-libs-5.1.61-4.el6.x86_64       To remove all

show slave status \g; Last_sql_error:worker 3 failed executing transaction ' 6c9da32f-0513-11e4-a949-00e04c8a7573:1 ' at Master log mysqldb01-bin.000001, End_log_pos 4541041; Could not execute Delete_rows event on table wind.t1; Query execution was

same Show The timestamp column is displayed in the same format as the datetime column. In other words, the display width is fixed at 19 characters, and the format is Yyyy-mm-dd HH:MM:SS. different Range datetime Retrieves and displays datetime

Problems caused by MySQL 5.6 upgrade: mysql 5.6 upgrade The MySQL database of the Project was upgraded from 5.5 to 5.6 yesterday. As a result, some tables cannot be updated. The following error is reported: When @ GLOBAL. ENFORCE_GTID_CONSISTENCY =

[MySQL] tree traversal (query of multi-level menu bar and multi-level upper and lower departments)Preface: 关于多级别菜单栏或者权限系统中部门上下级的树形遍历，oracle中有connect by来实现，mysql没有这样的便捷途径，所以MySQL遍历数据表是我们经常会遇到的头痛问题，下面通过存储过程来实现。1. Create a test table and data:DROP