Xtrabackup is a physical backup tool that supports the INNODB and XTRADB storage engines, and it has the following features:(1) The backup process is fast and reliable;(2) The backup process does not interrupt the transaction being performed;(3) can
My article has compiled 2 common forms of MySQL multi-row variable columns: http://blog.csdn.net/rainyspring4540/article/details/50231435Here is not to mention, the following is the more complex derivative form:Table structure:CREATE TABLE student (
First, table Design
Library names, table names, field names must be split with lowercase letters and "_".
The library name, table name, and field name must be no more than 12 characters.
The name of the library, table name, field
Start MySQL Error:ERROR 2002 (HY000): Can ' t connect to local MySQL server through socket '/var/lib/mysql/mysql.sock ' (111)1. Check the/ETC/RC.D/INIT.D/MYSQLD status first to see if M y S Q L has been started.Also see if it is a permission issue.2.
Discusses the MySQL select index when single-column and multicolumn indexes are used, as well as the leftmost prefix principle for multi-column indexes.1. Single-Column indexingIn the performance optimization process, choosing which columns to
In the previous article we described the approximate flow of transaction submissions in the case of closing binlog. The reason for shutting down Binlog is because the transaction commit process turns into a two-phase commit after the Binlog is
For two development, a large part of the search for files and the change of databasefor database changes. has not found the more useful monitoring database change monitoring software.Today, I'll show you how to monitor database changes using MySQL's
Linux, when we use the MySQL C API to operate the MYSQLDB, by default, the program will be Latin1 this character set to do SQL operations, this situation, it is likely to appear garbled,For example, the character set of the database is UTF8, and
Create a tableData type int (shaping, Integer) not Null,char (character) tinyint (smallest shaping) varchar (variable-length character type)CREATE TABLE Xiaohu (ID Int (4) is not NULL,Name Char (a) is not NULL,Age tinyint (2) is not null default ' 0
1) Start:Sudo/etc/init.d/mysql start2) Stop:Sudo/etc/init.d/mysql stop3) Reboot:Sudo/etc/init.d/mysql restart4) View log:Cat/var/log/mysql.errCat/var/log/mysql/error.log5) not supported in ChineseChange/ETC/MYSQL/MY.CNFAdd the following in
1. Optimize your query for queriesMost MySQL servers have query caching turned on. This is one of the most effective ways to improve sex, and this is handled by the MySQL database engine. When many of the same queries are executed multiple times,
MySQL INNODB Transaction ISOLATION level dirty read, repeatable read, Phantom readThe level of isolation for MySQL InnoDB transactions is level four, which is "repeatable read" by default (Repeatable Read).· READ UNCOMMITTED (readuncommitted).
One, MySQL command line argumentsUsage:mysql [OPTIONS] [Database]//Command mode-?,--help//Display assistance information and exit-I,--HELP//Display Help information and exit--auto-rehash//Auto-complete function, like Linux inside, press the TAB key
I have long heard that the two commands, lock tables and unlock tables, literally know that the function of the former is to lock the table and the latter is to unlock it. But how to use, how to use, not very clear. Today, in a detailed study, we
MySQL is a powerful open-source database. With more and more database-driven applications, people have been pushing MySQL to its limits. Here are 101 tips for adjusting and optimizing MySQL installation. Some of the techniques are specific to the
after installing Mysql-serveryou will be prompted to run mysql_secure_installation. Running Mysql_secure_installation will perform several settings:a) Set a password for the root userb) Delete Anonymous accountc) Remove the root user from remote
One, Apache download: http://www.apache.org/Installation: Direct decompression to Apache for the file name on the disk.
Locate the drive letter: \apache\conf\httpd.conf file, open with Notepad, find: Define srvroot This entry, its value is
How to Use mysqldump to back up MySQL Data,
MySQL's mysqldump tool supports single-threaded operations. Multiple tables are exported one by one without a parallel machine, which makes it unable to quickly back up data.
Mydumper is a utility that
Quick Mysql Statement Review (full) and mysql Statement Review
Basic operations
View Database
show databases;
Character Set
create database day15 default character set utf8
View Character Set
show create database day15;
Delete
drop database
MySQL improves Insert performance and mysqlinsert Performance
The time required to insert a record is composed of the following factors, and the number indicates the approximate proportion:
Connection: (3)
Send query to server: (2)
Analysis
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