MySQL's database files can be copied directly, but that refers to the "MyISAM" type of table.Instead of using Mysql-front to create a table directly, the default is the "InnoDB" type, a table that corresponds to only one "*.frm" file on disk, unlike
To perform show slave status from the server, you can view a number of synchronization parameters, and we need to pay special attention to the following parameters:Name of the primary server binary log file that the I/O thread in
The MySQL service failed to start on the local computer error 1067 process Unexpected termination this is typically My.ini file configuration error
First find this file: Default installation path
The code is as follows
Copy Code
A unibilling machine suddenly loads heavier a few days ago. The CPU is found to be heavily occupied in top. The AGI program runs slowly, and a zombie process occurs. In fact, there were only about 50 concurrent calls. Far from the normal level. The
Server Configuration
1. After the purchase of a good VPS login server first modify password passwd root2. Modify the SSH timeout time
The code is as follows
Copy Code
Vi/etc/ssh/sshd_configClientaliveinterval
One, MySQL installation
MySQL Downloads
http://dev.mysql.com/downloads/mysql/
MySQL version selection
MySQL feature custom selection installation
Function Customization Selection
Path Customization Selection
Set Root user password
Different points:
1. Truncate and delete Delete only the data do not delete the structure of the table (definition)
The DROP statement deletes the table's structure-dependent constraints (constrain), triggers (trigger), indexes (index); That depends
First, the implementation of local automatic backup database is simple:
1. Log in as Root
2. Scheduled Tasks (3:30 automatic execution/usr/bin/mysqlbackup per day)
Crontab
0 3:30 * * */usr/bin/mysqlbackup
3. Write an automatic backup database script
Gtid Introduction
What is Gtid
The Gtid (Global Transaction ID) is the number for a committed transaction and is a globally unique number.
Gtid is actually made up of Uuid+tid. Where the UUID is the unique identifier of a MySQL instance. TID
The MySQL ALTER TABLE command is used to modify the table structure, such as adding/modifying/deleting fields, indexes, primary keys, and so on, and this article introduces the use of the MySQL ALTER TABLE statement through an example,
The MySQL
Objective
I believe we all know that implicit type conversions have the risk of being indexed, and that in the case of high concurrency and large amounts of data, the result of an index is very serious. Dragging the database down, and then crashing
Today in Docker installed MySQL, is its own Docker pack.
The first new dockerfile content is as follows:
From Mysql:latest
Maintainer Abel.yang
LABEL descripttion= "This" the image is a for MAC to use MySQL "vendor=" Gi Thub "version="
I met a strange question about exists today.
The first statement is as follows:
Select
count (1) from the
APPLY t
WHERE
EXISTS (
select r.apply_id
from record R
WHERE
t.apply_id = r.apply_id
);
The resulting results are: 89584
The
I. Installation of NginxAn order to fix:USE=FASTCGI emerge Nginx
New Users and Groups:Groupadd wwwUseradd www-g www
Nginx installed by default will add Nginx group and Nginx users, but I am still accustomed to create a new www group and WWW users
The example of this article describes the method of PHP implementation to clear MySQL dead connection. Share to everyone for your reference, specific as follows:
Connection, the main performance is that there are too many sleep connections, and
A trigger is a special stored procedure that triggers execution when inserting, deleting, or modifying data in a particular table, and it has a finer and more complex data control capability than the standard functionality of the database itself.the
Mysql query result output to the file method, mysql Query Result
Export/output/Write mysql query results to a file
Method 1:
Run the following command:Mysql> select count (1) from table into outfile '/tmp/test.xls ';
Query OK, 31 rows affected (0
Objective: the master database is down and upgraded from the master database to the master database.Prepare the environment:1 web Server3 MySQL serversEnvironment description:1. The bbs website service is running on the web, and the database service
Access can only use this same life-saving feature in windows, which makes me feel terrible and hard to switch access to mysql. However, I have found many articles on the internet and have not directly converted it. I heard that odbc can be used for
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