performance mysql

Objective: We all know the nature of transactions, the database in order to maintain these properties, especially consistency and isolation, the general use of lock this way. At the same time, the database is a high concurrency application,

Reference: http://codingstandards.iteye.com/blog/1344833In the above reference article, "High performance MySQL," fourth chapter fourth section in the third edition of my corresponding chapter sixth Chapter fifth sectionRecently analyzed the

Mind Mapping Introduced The most storage engines used in MySQL are InnoDB and MyISAM. As the default storage engine for MySQL, MyISAM is worth us to learn, the following is my "High-performance mysql"

MySQL's website: http://www.mysql.com/downloads/There will be several versions of the selection in this download screen.1. MySQL Community Server Community version, open source is free, but does not provide official technical support.2. MySQL

Btree Index:If there is no particular type, most of it is the btree index, which uses the btree data structure to store it, and most MySQL engines support this index,archive engine is an exception ,before 5.1 this engine does not support any

a MySQL overviewMySQL is a very popular open source database, when I turn from Oracle to do MySQL, the most profound thing is that this guy actually is the server and storage separate! And even more can not endure is, it unexpectedly is plug-in

Objective: We all know the nature of transactions, the database in order to maintain these properties, especially consistency and isolation, the general use of lock this way. At the same time, the database is a high concurrency application,

Article from: http://blog.sina.com.cn/s/blog_62b37bfe0101he5t.html thanks to the author for sharingMySQL's website: http://www.mysql.com/downloads/There will be several versions of the selection in this download screen.1. MySQL Community Server

Objective This time to introduce the iterator pattern, is also a behavior pattern. I now think that blogging a bit to deal with, before the day an article, feel this actually a bit did not understand a thorough written down, and after writing

Due to the complexity of the database, baseless assertion space is very large, fast catching up with TCM regimen. Avoid using NULL for reasons that are mentioned in high-performance MySQL for a while. We suggest that you read more books and watch

This article turns from https://m.imooc.com/article/details?article_id=17290 thanks to the author The previous article recorded my understanding of the MySQL transaction isolation level READ UNCOMMITTED.This article records my understanding of

Different versions of MySQLArticle from: http://blog.sina.com.cn/s/blog_62b37bfe0101he5t.html thanks to the author for sharingMySQL's website: http://www.mysql.com/downloads/There will be several versions of the selection in this download screen.1.

Introduction: Recently looking at high performance MySQL, record writing study notes: High performance MySQL learning notes (ii) schema and data type optimization Note core content: How to choose the correct data type of MySQL, the difference

I am a living example, the University of Instrumentation major, 12 after graduating the first job is a circuit board test. Because the project is exposed to the database of things, purely when the advanced point of the Excel table with.At that time

In the last two days, the requirement is to use a fixed table for the temporary tables used in the refund and return statements.When you build your own table, such as (just for example):CREATE TABLE Tasks (task_id int UNSIGNED not NULL

MySQL's website: http://www.mysql.com/downloads/There will be several versions of the selection in this download screen.1. MySQL Community Server Community version, open source is free, but does not provide official technical support.2. MySQL

When you use the Explain tool to view the SQL statement execution plan, if the Select_type field appears "DEPENDENT subquery", you have to notice that you have fallen into the MySQL sub-query Slow "pit."Related books: high-performance MySQL (3rd

Database is an important application in the Web site, placed in the fourth article is because before too late to summarize the reasons, in the previous article I saw either MySQL or nosql some of the cache and distributed some of the more scalable

When you use the explain tool to view the execution plan of the SQL statement, if the select_type field contains "DEPENDENTSUBQUERY", you should note that, you have fallen into the slow mysql subquery "pit... Here is a specific example of a query

Background: In years of work, we have designed many system or product databases, including single-host databases, lan databases, and Internet databases. For different environments, the design considerations are different. Even in the same