Pt-Online-schema-change of MySQL online DDL Tool
MySQL DDL:DDL is a feature that makes all MySQL ddbas criticized, because in MySQL, when dDDL is performed on a table, it locks the table. When the table is small, such as less than 1 W rows, it has little impact on the front-
Today, mysqldump is used online to import data tables from one database to another. The export speed is very slow. So I searched the internet and found this stuff. After the test, I found it was good. I will share it with you.
Brief IntroductionMydumper is a multi-threaded export and import tool written in C language, and can ensure consistency between multiple tables. of course, the more threads, the better (this is related to the server configuratio
MYSQL official tool WorkBench Design Database essentials AnalysisThe beautiful Life of the Sun Vulcan (http://blog.csdn.net/opengl_es)This article follows "Attribution-non-commercial use-consistent" authoring public agreementReprint Please keep this sentence: Sun Vulcan's Beautiful Life-this blog focuses on Agile development and mobile and IoT device research: IOS, Android, HTML5, Arduino, Pcduino , Other
Author: skateTime: 2013/02/25
MySQL monitoring management tool-innotop
Innotop is a monitoring tool that displays MySQL and InnoDB in text mode. Innotop is written in Perl, which enables it to be used more flexibly on various operating platforms. It can monitor the running status of
Use the AWK tool in Cygwin to view mysql binlog logs
Linux tools are really powerful. However, as a person who does not have the right to use Linux machines or who does not use Linux for development, it is really inconvenient to use some commands, a unix-like simulation environment running on windows platform is a free software developed by cygnus solutions, which brings a lot of convenience to the use of s
*********************************** * ***** OracleMYSQLDB2sql paging Linux OS resource monitoring tools key recommendations collectlLinux OS resource monitoring tools key recommendations collectlOracle, MySQL and PostgreSQL features comparison (ZT) oracle announced MySQL, GlassFish, and NetBe
*********************************** * ***** Oracle MYSQL DB2 SQL pagin
Microsoft introduced a new tool to help MySQL users migrate their data to Microsoft's SQL Server database. This tool is called the SQL Server migration assistant (SSMA ). The future of MySQL was unknown due to the Oracle-SUN purchase case. Microsoft launched a database migration to
MySQL slow query log analysis tool mysqldumpslow
Mysqldumpslow is a log analysis tool that comes with mysql. As the name suggests, mysqldumpslow is used to query SQL statements that are slow in query. This analyzes the causes of slow SQL query efficiency.
Generally, the results of the mysqldumpslow grouping query are s
Mysqlhotcopy hot backup tool experience and summary bitsCN.com
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 sense of a quick file, and the latter is a collection of SQL statements at the Database end.2.
MySQL migration tool is one of Microsoft SQL Server migration assistant. This release supports the pre-viewed version of ctp1.0 and SQL Server 2008, and the corresponding MySQL database supports 4.1, 5.0, and 5.1, previously, a migration tool for SQL Server 2005 was released. As follows:
Download:Microsoft SQL Serve
it more efficient. Another advantage of Schemaspy is that he is a command-line tool that generates HTML pages after each execution, so it is particularly suitable for crontab, making it possible to adjust the page automatically when the model changes. It's good, isn't it?
This tool is simple to use and can help you do a lot of things. Basically, if your database has a foreign key, you steal music, if not,
Label:Mysql-schema-sync is a cross-platform , green, non- dependent MySQL table structure Automatic synchronization tool that is developed using go.Used to synchronize changes in the database structure of a line (other environment) to a test (local) environment!Can solve the multi-person development, each person uses the independent database causes the structure to be different the question!Support Features
1. innotop Installation Reference Official Website: # cdinnotop-1.9.0 install INNOTOP tool is very simple, it is written by PERL, of course
1. innotop Installation Reference Official Website: http://innotop.googlecode.com/svn/html/installing.html # wget http://innotop.googlecode.com/files/innotop-1.9.0.tar.gz# tar-zxvf innotop-1.9.0.tar.gz # cd innotop-1.9.0 installation INNOTOP tool is very simple, it is w
PhpMyAdmin is a MySQL management tool. It can manage MySQL directly from the web without going to the system for execution. Installation steps: 1. obtain the file ftp: ohaha.ks.edu.twpubsourcephpmyadmin_2.0.5.tar.gz or ftp: ohaha.ks.edu. twpubsourcephpc_phpMyAdmin_2 phpmyadminmysql management tool
Preface:
PhpMyAdmi
shell> MySQL--user=user_name--password=your_password db_nameshell> MySQL--helpshell> mysql-?Options--protocol={tcp | sockets | PIPE | MEMORY}MySQL commandSome commands MySQL can explain themselves. To view these commands, enter Help or \h at the
Similar to the linux top tool, mytop can monitor the performance information of mysql servers in real time.Installation Method1. Install DependenciesCopy codeThe Code is as follows:# Cpan# Cpan> install DBI# Cpan> install Term: ReadKey# Cpan> install DBD: mysql# Cpan> exit 2. Download and install mytopCopy codeThe Code is as follows:Cd/tmpWget http://jeremy.zawod
Similar to the linux top tool, mytop can monitor the performance information of mysql servers in real time.
Installation Method
1. Install DependenciesCopy codeThe Code is as follows: # cpan# Cpan> install DBI# Cpan> install Term: ReadKey# Cpan> install DBD: mysql# Cpan> exit
2. Download and install mytopCopy codeThe Code is as follows: cd/tmpWget http://jeremy.
Mysqlsla is hackmysql.com launched a MySQL log analysis tool, the function is very powerful. Data reports are very useful for analyzing the causes of slow queries, including execution frequency, data volume, query consumption, etc.
First, use
Mysqlsla-lt Slow Mysql-slow.log
Or
Mysqlsla-lt Slow MYSQL-SLOW.LOG-SF "+s
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.