MySQL

Demonstrate concurrency issues at different isolation levels1. When the isolation level of a transaction is set to read UNCOMMITTED, dirty reads, non-repeatable reads, and virtual reads are thrownA windowSet TRANSACTION isolation level READ

Basic use of MySQL databaseService side1. Installation: sudo apt-get install Mysql-service2. Start: sudo service MySQL start3. See if there is a MySQL service in the process: PS ajx|grep MySQL (/usr/sbin/mysqld)4. Stop service: sudo service MySQL

ORM Technology: Object-relational Mapping is responsible for mapping the table structure of a relational database to an object.1. Installing the SQLAlchemy modulePip Install SQLAlchemy2. Initializing the connection1 #!/usr/bin/env python2 #-*-coding:

Show index from TABLE_NAMEThis command helps diagnose poorly performing queries, especially if the query uses an available index.The following describes the meaning of the result column that this command displays:| Table | Non_unique | Key_name |

Today, my client gave me feedback and said an error.# # # Error querying database. Cause:com.mysql.jdbc.PacketTooBigException:Packet for query is too large (> 1024). You can change this value on the server by setting the Max_allowed_packet '

0, this blog part of the content is Deolin's personal views and habits.1, set Del_flag = 1 is called "Remove",The delete from table is called "Erase" (expunge),As for delete, Cancel (cancel), it is more like the concept of a business layer rather

Pessimistic lock and optimistic lock are two common methods of resource concurrent lock design, and also a very basic concept in concurrent programming. Before I wrote an article about the processing ideas and solutions of concurrency, here I will

MySQL 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.Create a TriggerIn

Two ways to license MySQL databaseMethod One: Create a user by using the grant command and authorize The simple syntax for the grant command is as follows:Grant all privileges the dbname.* to [e-mail protected] identified by ' passwd '; The

Database development is a database management system (DBMS) and database application software design and development of the general term, data operation and maintenance, participate in the database production environment problem optimization and

Django currently supports three MySQL drivers for MySQL links MySQLdb is a native driver that have been developed and supported for Overa decade by Andy Dustman. Mysqlclient is a fork of MySQLdb which notably supports Python 3 Andcan

MySQL default data file storage directory is/var/lib/mysql, if you want to move the directory to the/data need to take the following steps:1. Set up data Directorymkdir data2. Stop MySQL ServiceService Mysqld Stop3. Move/var/lib/mysql Entire

MySQL replication is asynchronous or semi-synchronous. When Master fails, some slave may not receive the latest relay log, which means that each slave may be in a different state. It is trivial to handle these consistency issues manually because you

MySQL latency Association performance optimization method and mysql latency performance optimization Background] An error occurred while alerting the load of a business database. The cpu usr reached 30-40, which remained high. Use tools to view the

Summary of several MySQL installation methods and configuration problems, and mysql installation methods 1. Install MySQL rpm package # Download installation source [root @ localhost src] # wget https://dev.mysql.com/get/mysql-community-release-el7-5

MySQL 5.6.27 installation tutorial in Linux, mysql5.6.27 This article provides an example of how to install MySQL 5.6.27 in Linux for your reference. The specific content is as

Briefly describe the differences between MySQL and Oracle, and briefly describe mysqloracle 1. Oracle is a large database, while Mysql is a small and medium-sized database. The market share of Oracle is 40%. Mysql is only about 20%. At the same time,

CentOS6.7 mysql5.6.33 how to modify the data file location, Problem: mysql cannot connect to the data files stored in mysql because the partition capacity is small and full, Solution: 1. Delete unnecessary data in a partition, such as log files.

Install Multiple mysql5.7.19(tar.gz.pdf, mysql5.7.19tar.gz For the first time in Linux to install the MySQL-5.7.19 version tutorial please refer to the previous article, if you have installed, then please see this linux to Install Multiple mysql-5.7.

How to use mysql function concatenation to query concat functions, mysqlconcat As follows: // Query the year and month of the managefee_managefee table. Use the concat function to combine them into year-month. For example, splice 2017 and 1 into 20