Original address: http://chenzhou123520.iteye.com/blog/1860954Pessimistic lock Introduction (encyclopedia):Pessimistic locking, as its name implies, is a conservative attitude to the data being modified by the outside world (including other
UsepythonWrite a monitoringMySQLthe script, inZabbix WebAdd the Template:## First Use MySQLdb interface associated with the database. [[Email protected] python]# cat check_mysql_custom.py#!/usr/local/bin/python '] Author = chenmingle "" Description:
TriggerMySQL includes support for triggers. A trigger is a database object associated with a table operation that invokes the execution of a trigger on a table when a specified event occurs on the table on which the trigger is located.Triggered by
In MySQL, the round function is used for rounding data, which has two forms:1, round (x,d), x refers to the number to be processed, d refers to the retention of several decimalsOne of the notable points here is that D can be a negative number, when
/* "Data management-additions and deletions" */Use test;DROP TABLE Demo;--pay particular attention to inserting primary table data when primary foreign key relationships are involved--Main Table: Table with reference Data columns (foundation)--child
Webpy_web.database ModuleThere are two ways to use the MySQL management database in the WEBPY framework, one is to use the MySQLdb module in Python:Import MySQLdbThere is also a web.database module with Webpy, the function is basically the same as
The MySQL log file is divided into 4 types: error log, universal query log, slow query log, and binary log.1. Error log: Log The problem that occurs when the MySQL server starts, runs, or stops.(1) Start and set error logThe error log feature is
Transfer from https://www.jianshu.com/p/628bcf8bb557As of MySQL 5.7.18, is my-default.ini no longer included in or installed by distribution packages.MySQL no longer comes with the default configuration fileJust write one manually.Cd/etcsudo vim
1. Text
CHAR (*): A fixed-length string of up to 255 bytes, whose length must be specified at creation time
VARCHAR (*): A variable-length string of up to 255 bytes, whose length must be specified at creation time
Text: variable
1. Optimize flowchartMySQL optimization (mainly increase the database select query, make the query faster)2. optimizing the MySQL aspectMainly from the following four aspects to optimize MySQL① Storage Tiers: How to select a database engine, select
MY.CNF file location is:/ect/mysql/my.cnfWaring: If the file is misconfigured, MySQL will not start.
2Start MySQL:Mode one: Sudo/etc/init.d/mysql startWay two: sudo start MySQLWay three: sudo service MySQL start
3Stop MySQL:Mode one:
First, lamp architecture introduction:linux+ Apache (httpd) + MySQL + PHPOperating system + Extranet service Software + storage Software + scripting language (developed by C)PHP websiteThree characters can be installed on a machine, can also be
PhpMySQL preprocessing Statements
Preprocessing statements are useful for preventing MySQL injection.
preprocessing statements and binding parametersPreprocessing statements are used to execute multiple identical SQL statements and
Understand that MySQL must firmly remember its architecture diagram, MySQL is composed of SQL interface, parser, optimizer, cache, storage engine.1.ConnectorsRefers to the interaction of SQL in different languages2.Management serveices & Utilities:
The classmate Sue me to say that he in order to make the data query become faster, modify the data engine, so query, summed up a bit.After logging in to MySQL, look at the engine supported by the current database and the default database engine,
What is a storage engineThe storage engine is how to store the data, how to index the stored data, and how to update and query the data. Because the storage of data in a relational database is stored as a table, the storage engine can also be called
Mysql5.6.36 script compilation and installation and initialization tutorial, mysql5.6.36 Initialization
Overview
This document describes how to automatically compile and install the script of mysql5.3.6 for centos7.3 and subsequent initialization
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.
A Free Trial That Lets You Build Big!
Start building with 50+ products and up to 12 months usage for Elastic Compute Service