MySQL

Trigger (Trigger): Monitors a situation and triggers an action. Trigger creation Syntax four elements: 1. Monitoring location (table) 2. Monitoring Event (Insert/update/delete) 3. Trigger Time (After/before) 4. Trigger Event (Insert/update/delete)

The first is: solve the MySQL version problem (I use MySQL 5.5 version), MySQL 5.0 version after the database dialect is: Org.hibernate.dialect.MySQ5LInnoDBDialect. The second is that if you have a database dialect with a mysqlinnodbdialect, the

4.1. mysql Data type introductionMySQL supports a variety of data types, primarily numeric types, date/time types, and string types. Numeric data type:Includes integer types TINYINT, SMALLINT, Mediumint, INT, Bifint,Floating point

Recently used thinkphp to do a mailbox retrieve password function, after encountering n bug finally made, the following share the mailbox retrieve password function realization:The mailbox recovery password is actually the process of resetting the

For the MySQL database garbled problem, there are two cases:1. MySQL database encoding problem (set when building the library).2. Link the URL encoding setting of the MySQL database.For the first question, the current personal discovery can only be

One: Query the status of slow log, as shown in the sample code, slow log is already open.Mysql>Show variables like '%slow%';+---------------------+------------------------------------------+|Variable_name|Value|+---------------------+----------------

Recently the program is running for a few days, suddenly can't access, check the application process is still there. Only the database process is down. Then find the log file to see the following error .- -- - on: -: - 19934[Note]

Another application is in Server management, the parent process that does not involve the database server program to stop running, you can also use these tools to terminate. Why can't the parent process of the database server kill with these tools?

A log file was found today in the data directory of the MySQL databaseDdl_log.log so the official website to see a bit, English good can read for themselves, bad on the trouble: (The DDL LogThe DDL log, or metadata log, records metadata operations

Zabbix monitoring MySQL master-slave replication. Monitor the replication of MySQLPrinciple: Get values for slave_io_running and slave_sql_running using Run show slave status on Slave1. Create a new monitoring user on MySQLGrant replication Client

LAMP, Lnmp combat four build MySQLDescription: Server 192.168.2.32Database version mysql5.5.32CMake version 2.8.8Yum install-y gcc gcc-c++ gcc-g77 autoconf automake zlib* fiex* libxml* ncurses-devel libmcrypt* libtool-ltdl-devel*//Installation

This function is implemented using the trigger program.The triggering program syntax is as follows:Create Trigger {Before|after}{Insert|update|delete}On For each rowCore code:1 Use t14test2 Show Tables3drop tableifexists uuidtest4 CREATE TABLE

The prerequisite is that you need to install 4 MySQL databases on Linux, all of which need to be configured to complete the corresponding information.                 Need to build: MySQL 01: master database Master MySQL 02: from database slave01

The ultimate goal of replication is to keep the data of one server in sync with the data of another server, which has reached data redundancy or service load balancing. A primary server can connect to multiple slave servers, and from the server it

Install MySQL First:A. Word part:①networking network ②option Select ③port Port ④firewall firewall ⑤engine engine⑥standard Standard ⑦character character ⑧collation Proofing ⑨stirage StorageCreate drop Delete Comment Comment variables variableTwo.

1. Issue backgroundBy default, MySQL replication on the line is asynchronous, so in the extreme case, there is a certain probability of cubby the main library data when switching, so after the switch, we will rollback back to the tool to ensure that

First, master-slave replication problems and solutionsSecond, Galera ClusterThird, MySQL 5.6 Multi-threaded replication, GTIDMySQL Replication:Master ha or multi-master node modelMmm:multi Master MySQLMha:master HAMonitoring of the master node

1. Add primary key (primary key index)Mysql>alter TABLE ' table_name ' ADD PRIMARY KEY (' column ')2. Add unique (unique index)Mysql>alter TABLE ' table_name ' ADD UNIQUE (' Column ')3. Add index (normal index)Mysql>alter TABLE ' table_name ' ADD

Float numeric types are used to represent single-precision floating-point numbers, whereas double numeric types are used to represent double-precision floating-point values.float and double are floating point types, while decimal is fixed-point type;

MySQL -- When mysqldump, mysql -- mysqldump Some production environments use mysqldump -- single-transaction to back up the database at night, while colleagues just execute the alter table operation during the backup. The operation partially