The test table I set up is like this:
The code is as follows
Copy Code
CREATE TABLE ' foo ' (' Key ' VARCHAR not NULL,' Time ' INT (one) is not NULL,PRIMARY key (' key ')) Engine=myisam DEFAULT Charset=utf8;
In the case of MySQL InnoDB, the preset tansaction isolation level is repeatable read, and there are two main ways to read locks in a select:
SELECT ... LOCK in SHARE MODE SELECT ... For UPDATE
Both of these methods must wait for the other
About MySQL TuningThere are 3 ways to speed up the running of the MySQL server, from low to high efficiency:Replace the problematic hardware.Tuning the MySQL process settings.Optimize the query.
Replacing the problematic hardware is usually our
Character-set-server/default-character-set: Server character set, by default.Character-set-database: Database character set.Character-set-table: Database table character Set.Priority increases in order. Therefore, in general, you only need to set
Basically, every programmer working with the database (and probably your colleagues) will have a problem, how to quickly rollback after MySQL misoperation? For example, delete a table, forget to limit the condition, the whole table is gone. If this
Reprint AddressHttp://www.linuxidc.com/Linux/2015-08/121676.htmIn the MySQL database, when the inserted data cannot support Chinese, the encoding set of the database can be set to UTF8, so the database encoding set and other character encodings are
A view is a table that is exported from one or more tables. is a virtual existence of a table. A view is like a window through which you can see the data that is specifically provided by the system. This allows the user to not see the data in the
Using MySQL will of course have access to the MySQL storage engine, which you will see when creating a new database and creating a new data table.MySQL default storage engine is MyISAM, other commonly used is innodb.What kind of storage engine is
MySQL master-slave Replication Principle IntroductionFirst, the principle of replicationMySQL replication tracks all changes to the database (updates, deletions, and so on) based on the primary server in the binary log. Each slave server receives a
MySQL's defaultCodingis Latin, I use the INSERT statement every time the JSP production page insertsDatabasewhen the Chinese characters are displayed as question marks, after installing MySQL, start the service and log in, use the show variables
Background-6 server (Layer Two) architectureFirst introduce the basic situation of 29,30,31 this San Guan:Server side has two parts: the first part of the Tomcat for the engine of the JSP server, the second part of the Apache as the engine PHP
1 Install php,mysql before installingphp5.5.29 installation: http://blog.csdn.net/clevercode/article/details/52198698.mysql-5.5.27:http://blog.csdn.net/clevercode/article/details/45499231.2 Downloads2.1 This installation of the resource bundle,
Original: Http://www.111cn.net/database/mysql/48888.htm This article summarizes a variety of solutions that cause the MySQL prompt to fail to start the MySQL service "1067 process unexpected termination", You can try to refer to a classmate who has
I. MySQL INTRODUCTION 1, logoThe name of the MySQL dolphin logo is called "Sakila", and it is selected by the founder of MySQL AB from a list of many names suggested by the user in the "Dolphin Naming" contest. The winning name is provided by
1 , IntroductionFlask-sqlalchemy is a Flask extension that simplifies the operation of using SQLAlchemy in Flask programs . SQLAlchemy is a powerful relational database framework that supports a variety of database backgrounds. SQLAlchemy provides
Mysql master-slave replication principle, mysql master-slave PrincipleMaster-slave mode
Flexible mysql master-slave Replication
One master, one slave
Master-master Replication
One master multi-slave --- extended system read performance, because
The applicable scenario of the MySQL master-slave architecture is read/write splitting, which reads data from the master database. In most scenarios, there are many read cases, the single master multi-slave architecture can solve the problem of high
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