Today, a problem suddenly came to mind, originally in order to improve SQL Server performance, the Company rules query statements are generally added with (NOLOCK)Now turn Java, use MySQL why not mention this thing?First in MySQL wrote a query
One months ago, there were a lot of problems when I did the work, and we solved them all. After it is done, it is time to re-do the work on another computer, or to meet some of the same problems, and solve them. Fortunately the time is not long,
About PHP MySQL long connection, connection pool some of the way to explore PHP connection to MySQL, with more is the MySQL extension, mysqli extension, Pdo_mysql Extension, is officially provided. PHP operation mechanism is that the page will
MySQL master-slave replication is believed to have been used a lot, but because of the work of the reason has not been used. While this period of time is relatively idle, it will be realized again. Although there are a lot of similar articles on the
This article mainly introduced the MySQL database lock generation reason and the solution, needs the friend can refer to the nextThe database, like the operating system, is a shared resource used by multiple users. When multiple users access data
The same computer is configured mysql5.5 two instances, respectively, on 3310 and 33,112 ports. Set 3310 for the main library and 3311 for the slave library.The final effect is as follows:3310 Main Library:Grant ReplicationSlave,reload,super on *.*
Pessimistic lock and optimistic lock:Pessimistic lock: As the name implies, is very pessimistic, every time to take the data when they think others will change, so every time when the data are locked, so that others want to take this data will block
Today, I had a friend who asked me to help him back up the MySQL database on the windowserver server, so it took a day to complete a daily scheduled backup of the database, a small part here for everyone to record:First, for the MySQL command line
The main purpose of this paper is to test whether a single column should be indexed, with query time and number of scanned rows as reference. MySQL version 5.5.20A: Build a tableCREATE TABLE' record ' (' ID ' )int( One) not NULLauto_increment, '
I want to add a field to a table in the database online, the table is very small, just a few k, but can not execute, a execution will be stuck, locked out.ALTER TABLE tiv_product_detail_copy add activity_type varchar (+) not NULL COMMENT ' activity
InnoDB Lock,Shared and exclusive locks
InnoDB implements standard row-level locks, including two types: Shared locks (S) and exclusive locks (X)
A shared lock (S) allows a transaction to hold this lock to read a row.
An exclusive lock (X) allows
Mysql lock readLocking Reads
In the same transaction, if you query data first and then insert or modify the relevant data, the standard SLELECT will not provide sufficient protection. During your query, another transaction can update or delete the
Mysql consistent reading and mysql consistencyConsistent Nonlocking Reads
Consistent read means that InnoDB uses multiple versions to provide a snapshot for querying a database at a certain time point. This kind of query shows the changes in
Getting started with database design and getting started with databases
Database is the foundation of network applications. A good table structure design plays a vital role in the entire application.
Database design steps:1. Requirement Analysis:
Mycat global auto-increment, mycat global
Auto-increment type
[Root @ node002 conf] # vi/usr/local/mycat/conf/server. xml
Meaning of each parameter:
0: Local File Auto-increment mode.
1: use mysql auto-increment.
2: Use the local timestamp to
Detailed description of four transaction isolation levels of MySQL
The SQL standard defines four isolation levels, including some specific rules to limit which changes inside and outside the transaction are visible and which are invisible.
Detach a MySQL database in Linux
A) Check whether mysql is installed with an rpm package in the system.
[Plain]View plain copy
[Root @ linux ~] # Rpm-qa | grep-I mysql
MySQL-server-5.1.49-1.glibc23
Mysql trigger usage example
MySQL trigger syntax explanation:
Trigger is a special stored procedure that triggers execution when inserting (inset), deleting (delete), or modifying (update) data in a specific table, it provides more refined and
Mysql replace into instance details
Mysql replace into instance details
Replace into is similar to insert. The difference is that replace into first tries to insert data into the table. Mysql replace into instance details
1. If this row of data
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