Experience and summary of mysqlhotcopy Hot Backup Tool

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

Detailed analysis of mysql hidden space

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

Classic Sharing MySQL limit Query Optimization

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.

MySQL master-slave Configuration

MySQL-VIP: 192.168.1.200 2-MySQL-master1: 192.168.1.201 3 MySQL-master2: 192.168.1.202 4 5 OS: CentOS 5.4 6. MySQL version: 5.0.89 7 Keepalived version: 1.1.20 1. MySQL master-master Configuration 1. Modify the MySQL configuration file To enable the

Analysis on hidden space in MySQL

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

Reexploration of mysql backup and recovery

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

Mysql job creation and troubleshooting

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

Install and uninstall the Mysql5.1 plug-in storage engine

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

Retrieve the mysql root Password

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

Mysql tutorial-truncate and delete

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==============================

Enable Mysql Remote Access

  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

Summary of some usage of insert ignore into and replace into in MySQL

  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

[MySQL optimization] MySQL group by Operation Optimization

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

Minor problems encountered during mysql Installation

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,

Mysql 1064 USING BTREE

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

25 required for MySQL Performance Optimization

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

Mysql database Stored Procedures

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

View the usage of each mysql database and the last modification time of each table in the database

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

How to use the time-based Query functions of Mysql

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

Mysql drop table data recovery

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

Total Pages: 3233 1 .... 2816 2817 2818 2819 2820 .... 3233 Go to: GO

Contact Us

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

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.