Today, I am free to try MYSQLHOTCOPY, a tool for Fast hot backup of the MYISAM engine.(This article is for a single server and will be added to multiple server operations in the future)Comparison between him and MYSQLDUMP:1. The former is a COPY in
The following articles mainly introduce the analysis of MySQL hidden space problems, we all know that the main function of the TMPDIR value of the environment variable used by the MySQL database is to save the actual path name of the Directory
The following articles mainly introduce the specific content of MySQL limit query optimization. We all know that MySQL database optimization is very important. Limit is the most commonly used and optimized. MySQL limit greatly facilitates paging.
The hidden space of MySQL is implemented by setting the environmental variable TMPDIR. If TMPDIR is not set, MySQL uses the default value of the system, usually/tmp,/var/tmp, or/usr/tmp. MySQL uses the value of the environmental variable TMPDIR as
1. My current backup solution is:A (master) -----> B (slave) for real-time synchronization, complete backup at every Sunday on B (slave), do from Monday to SaturdayIncremental backup, Incremental backup time selection, flexible modification
1. Create a stored procedure.2. Create an event (scheduled execution of the stored procedure ).For example, if the STUDENT field of a table contains id, name, age, and login_time (logon time );The logon time is updated to the current time every 30
Mysql Databases use a plug-in storage engine. If the storage engine has been installed on the Mysql server, you can also add or uninstall the storage engine. In Mysql5.1, if the -- with-plugins = innodb parameter is not used during source code
I set the root password for mysql I just installed yesterday. Today I cannot get in.I used a common solution. As follows:1. Send the kill command to the mysqld server to disable the mysqld server (not kill-9). The files that store the process ID are
In short, the table id cleared with truncate will be from the new record, while the table cleared with delete will not continue with the original data record from the new record. Of course, the id here is self-increasing==============================
By default, Mysql cannot be accessed through a remote machine. You can enable remote access through the following configuration.
My Mysql environment is ubuntu + mysql5
1. Modify/etc/mysql/my. conf, bind-address, and specify as the actual IP
The following statements may be used for conditional data insertion in MySQL. Create a simple table for testing:
Create table 'books '(
'Id' INT (11) not null AUTO_INCREMENT,
'Name' VARCHAR (200) not null,
Primary key ('id '),
Unique key 'newindex1
Optimization of MySQL group by operationsBY default, MySQL performs the group by col1, col2.... operation according to the order of the group by field. If an order by clause containing the same columns is explicitly included, the actual execution
I encountered a small problem when installing mysql today, as shown in the figure below.
After reading it, it should be during compilation that an error is reported because the library file ncurses and termcap is missing.If you know the problem,
Export files from the server using the mysqldump command
When importing data to another database, the following message is displayed:
MySQL returns:
#1064-You have an error in your SQL syntax; check the manual that corresponds to your MySQL
Today, database operations are increasingly becoming the performance bottleneck of the entire application, especially for Web applications. Concerning the database performance, this is not just something that DBAs need to worry about, but it is
1. Create a stored procedure
1. Basic Syntax:
Create procedure sp_name ()
Begin
.........
End
Ii. Call the Stored Procedure
1. Basic Syntax:
Call sp_name ()
Note: The stored procedure must be enclosed in parentheses, even if the stored procedure is
These two statements are usually used to maintain the mysql database. 1. view the size of each database in mysql SELECT sum (DATA_LENGTH) + sum (INDEX_LENGTH) FROM information_schema.tables where TABLE_SCHEMA = 'database _ name ';The result is in
Query yesterday's data select * from faq where answer_time = date_sub (curdate (), interval 1 day );
Query the data for this month: select name, submittime from enterprise where date_format (submittime, '% Y-% m') = date_format (now (),' % Y-% m
CUSTOMER NAMECustomers in Ningbo, Zhejiang Province. Data TypeMYSQL databaseSmall Data size1.1 GBFault symptomAll tables in the Gamedb2 database are dropped.Customer demandRestore all data.Fault Detection TestHacker attack!ResultAs the data of a
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