The site to move the use of direct packaging MySQL database and Web files in the form of migration, upload good MySQL data directory inside the site database to the VPS MySQL storage database directory inside, decompression on the line. My VPS Store
MySQL SQL character join function 1, Concat () function 1.1 MySQL's Concat function can connect one or more strings, such as & nbsp; mysql> Select concat (' 10 '); +--------------+ | Concat (' 10 ') | +--------
This article shares the MySQL stored procedure that modifies the table name to uppercase, as follows
1. Conditions:1.1 MySQL settings are case sensitive2. Execute the following stored procedures:
#call uppercase (' Library name ') DROP
1, from MySQL official download mysql version of the source code "must be the source version"
2, the following code type Linux command line
Copy Code code as follows:
[note] Add MySQL group and user
#groupadd MySQL
#useradd-G MySQL
First check that the MySQL service does not start if it does not start, start the service.
Yesterday, after restarting the server, the MySQL ' localhost ' (10061) error, began to think because the database links open too much, the database resource
The following article mainly introduces the basic types of MySQL character set, the actual operation of the unified character set, and other related content of the introduction, the following is the MySQL character set related content description, I
A stored procedure is a program stored in a database library (like a subroutine in a regular language), and, to be exact, there are two types of MySQL-supported "routine": one is the stored procedure we say, The second is a function that can return
Mysqlworkbench is a recently released Visual Database design tool for MySQL AB. This tool is a dedicated tool for designing MySQL databases.
Download Address: http://www.jb51.net/database/29494.html
Mysqlworkbench has many functions and features;
From the official documentation that Linux compiled installed on the MySQL default connection of 100, so the site is not enough for the needs.
MySQL official told us that we need to modify the value of max_connections, so how do we modify it? There
In MySQL, databases and tables are actually directories and texts in the data directory.
Thus, the sensitivity of the operating system determines the case sensitivity of database and table naming. This means that the database and table names are
First, the principle of reproduction
MySQL replication tracks all changes to the database (update, delete, and so on) based on the primary server in the binary log. Each receive from the server from the primary server has been logged to the saved
Referential integrity (referential integrity) is an important concept in database design. In a different list of systems, referential integrity is involved when all references to the database are legitimate or not legitimate. When referential
The following article is mainly about the performance of MySQL closely related to the five configuration parameters of the introduction, I saw a few days ago in the relevant web site on the performance of MySQL closely related to the five parameters
By default, MySQL itself breaks links through various timeout parameters.
Various interpretations of the timeout:
Connect_timeout is useful when establishing a connection, and is recommended for use with connection pooling or for poor network
I. Overview
The event Scheduler is another feature added in MySQL 5.1 that can be used as a timer Task Scheduler to replace some of the timed work > energy that can only be done with the operating system Task Scheduler. For example, the Crontabe in
Same
Show
The timestamp column displays the same format as the datetime column. In other words, the display width is fixed to 19 characters and the format is Yyyy-mm-dd HH:MM:SS.
Different
Range
datetime retrieves and displays datetime values
When you install MySQL in Windows, there are 3 MySQL 5.1 installation packages to choose from:
· Basic installation: The installation package has a file name similar to Mysql-essential-5.1.2-alpha-win32.msi and contains the minimum files required
Original link: http://blog.chinaunix.net/u/29134/showart_1087632.html
Today to briefly summarize the locking mechanism of MySQL, improper welcome to PAT Bricks!
1, for MySQL, there are three kinds of lock level: page level, table level, row level.
Mysql slave database Last_IO_Error: Got fatal error 1236 from master when reading data from binary log: 'Could not find first log file name in binary log index file' error handling, gotfatalerror1236
You will be back later to view the mysql running
The cause of this problem is:The number of connections exceeds the value set by MySQL. It is related to max_connections and wait_timeout. The larger the value of wait_timeout, the longer the idle waiting time for the connection, which leads to the
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