MySQL

Key monitoring-mysql-nginx-php One, Zabbix monitoring MySQL is configured on the client: [[email protected] ~]# vim /usr/local/zabbix/ etc/chk_mysql.sh#!/bin/bash# ----------------------------------------------------------------------------

Source: Various storage engines in MySQL databaseMySQL has a variety of storage engines, each storage engine has its own advantages and disadvantages, you can choose the preferred use : MyISAM, InnoDB, MERGE, MEMORY (HEAP), BDB (BerkeleyDB),

To share with you about MySQL in the data security topic, how to use some configuration to ensure data security and ensure that the storage of data is safe to the ground.I joined Momo in 2014 and joined the network in 2015 to do the MySQL operation,

Query data for 7 days ahead:[HTML]View PlainCopyprint? SELECT * from data table where Date_sub (Curdate (), INTERVAL 7 day) [HTML]View PlainCopy print? Query data for 30 days ahead:[HTML]View PlainCopyprint?

Procedure 1: With return value:1 Drop procedure if existsProc_addnum;2 Create procedureProc_addnum (inchXint,inchYint, outsum int)3 BEGIN4 SET sum=X+y;5 EndThen, the execution process, the out output return value:1 Call Proc_addnum (2,3,@sum); 2

Change buffer is a special data structure that is used to modify the secondary index page when the secondary index page to be modified is not in the buffer pool. The operations on the secondary index page may be insert, UPDATE, and delete operations.

In the previous chapter, the simple application of PHP to the value of HTML is explained in this chapter, which explains the two types of HTML to PHP, that is, the two cases mentioned in the previous chapter.　　1. Submission of the form　　　Open

I. MySQL master-slave synchronizationMySQL supports one-way, asynchronous replication, one server acting as the primary server during replication, and one or more other servers chargingWhen from the server. The primary server writes the update to

Http://www.yinghualuowu.com/php/echart.htmlCREATE TABLE sex with Name numPHPIni_set(' Display_errors ', 1);//error Message Ini_set(' Display_startup_errors ', 1);//PHP startup error message error_reporting(-1); Ini_set(' Error_log

Problem Description: Error 1067 occurred while MySQL was importing data.1 first find the line to be faulted: CREATE TABLE ' Fct_sales ' (' UpdateTime ' datetime not NULL DEFAULT current_timestamp COMMENT ' update Time ') Engine=innodb DEFAULT

There is a project deployed to the server, the log is always prompted to find the table.Originally Linux under MySQL default to table name is case-sensitive.Workaround:One, the specification code, the table name all uppercaseSecond, modify the MySQL

First, the basic statement of the Operation databasecmd into MySQL: mysql-uroot-pCreating database: Create library name;Create data Table : with SQLite;View database : Show DATABASES;View Data Sheet : show TABLES;Enter database : use library

Emoji, these small cartoon images that express emotion have become an integral part of modern communication, so that Emoji's word has been officially earned in 2015 by Webster's and Oxford's dictionaries. When it comes to the birth of emoji, here's

1.INTMySQL supports integer types in 5 , and each integer type can be divided into signed and unsigned integers. Type Number of bytes TINYINT 1 SMALLINT 2 Mediumint 3

One, table-level lock1. Read lock,lock table t_student Read, add read lock, so that other Sessiona and sessionb can not modify the data, just read the data.Show processlist; View process, modify the state is waiting for the table level lock, has

The MySQL default mode of operation is autocommit auto-commit mode. This means that unless a transaction is explicitly started, each query is executed automatically as a separate transaction. We can change whether the autocommit mode is

MySql Data backup script (not original), mysql Data Backup Create a file xxx. bat with the following content: @ Echo offSet hour = % time :~ 0, 2%If "% time :~ 0% % "=" "set hour = time :~ 1, 1%Set now = % Date :~ 0, 4% % Date :~ 5, 2% % Date :~ 8,

How can Mysql use commands to achieve hierarchical search help? Preface This article mainly introduced to you the Mysql use command classification to find help related content, this article sample branch version MariaDB-10.1.19 Based on msql, share

MySQL Learning (4) -- foreign key, mysql learning foreign key 1. For example, there are two tables: "Classification Table" and "commodity table". To indicate the category of a commodity, we usually add a column to the commodity table, used to store

MySQL slow query log and MySQL Log MySQL has a log called slow query log, which is mainly used to record time-consuming query operations.   . Through this log, we can analyze which operations affect performance, and we need   Some optimization