introduction to mysql

Different from row-level or page-level locking options:· Version (for example, the technology used to insert data in MySQL in parallel), which can be a write operation with many read operations at the same time. This indicates that the database or

MyISAM:The default MySQL plug-in storage engine is one of the most commonly used storage engines in Web, data warehousing, and other application environments. Note: by changing the STORAGE_ENGINE configuration variables, you can easily change the

There are four database isolation levels, as described in the high-performance mysql book: Then let's talk about how to modify the transaction isolation level: 1. Modify the global settings, modify the mysql. ini configuration file, and add Copy

The following articles mainly describe MySQL database commands in detail. We first begin by displaying the basic information of the MySQL database to parse the MySQL database commands in detail, the following describes the specific content of the

Different storage engines also have different backup support. MyISAM storage engine can use the LVM snapshot function to implement hot backup. If there is no LVM, only warm backup can be implemented. Different storage engines also have different

The following articles mainly describe the actual usage of the MySQL statistical function GROUP_CONCAT, if you are interested in the actual usage of the MySQL statistical function GROUP_CONCAT, you can click the following article to view

The log file type MySQL has several different log files, which can help you find out what happened inside mysqld: errors in logging information types in log files when logging starts, runs, or stops mysqld. Query the Client Connection established by

Foreword The Global shared memory is mainly used by MySQLInstance (mysqld process) and the underlying storage engine to store various global operations and shared temporary storage information, such as QueryCache, cache ThreadCache for connection

This article mainly introduces the triggers in MySQL, including using triggers to add, update, and delete users. If you need them, you can refer to the following: in many cases, it is better to understand what you do. The solution should be designed

The following articles mainly describe how to correctly use the MySQL (the best combination with PHP) service, and the related content of MySQL maintenance and actual application design notes, this article focuses on the following several practical

If you are new to the MySQL database, you will certainly have some difficulties in learning it. The following articles are mainly for new users, that is, the prelude to using MySQL, if you are interested in the content related to the prelude used by

The following articles mainly describe MySQL database commands in detail. We first begin by displaying the basic information of the MySQL database to parse the MySQL database commands in detail, the following describes the specific content of the

Next we will introduce you to the mysql trigger new old for your reference. If you have encountered similar problems in mysql trigger, you may wish to take a look and I believe it will help you. Mysql trigger new old: "NEW. column_name" or "OLD.

Introduction to the MySQL database environment (3) [figure] 4. start and stop the MySQL service The above uses bat batch processing to open a MySQL service, and the service runs in the command window. We can also start MySQL as a service. Use the

MySQL5.5 the default storage engine is InnoDB. The simplest answer is that if you don't know which storage engine to choose, you can use InnoDB because it supports transactions and has good performance. MySQL5.5 the default storage engine is InnoDB.

From: http://database.ctocio.com.cn/422/8919922.shtml MySQL GUI tools is a set of graphical desktop application tools that can be used to manage MySQL servers. The tool package includes three tools: MySQL query browser, MySQL administrator, and

Suppose we created a testIndex table: CREATETABLEtestIndex (I _testIDINTNOTNULL, vc_NameVARCHAR (16) NOTNULL). We randomly inserted 1000 records into the table, one of which is I _testIDvc_Name555erquan looking for vc_Name = Suppose we created a

I. Backup Type and other description: 1.1 whether the server will continue to provide service points during Backup: Hot Backup: read/write during Backup is not affected Warm backup: only read operations can be performed during Backup Cold backup:

This blog post aims to read and understand your own books and use this picture to explain. If there are any mistakes, I hope you can correct them and share them with us for the purpose of mutual discussion.First, let's introduce the source of the

Speaking of databases, most small and medium-sized enterprises use SQL server and MYSQL. SQL SERVER is developed by Microsoft. It works very well with IIS and ASP. However, SQL SERVER is charged, while MYSQL is completely free. On the one hand, it