MySQL: Copy data từ 1 database ở server này sang 1 database ở server khác

Hôm nay tôi có 1 task về MySQL là copy data từ 1 database từ server này sang 1 database ở server khác. SQLYog đã có sẵn 1 feature cho phép...

Deploying MySQL on Amazon EC2 – 8 Best Practices

http://www.iheavy.com/2011/02/21/deploying-mysql-on-amazon-ec2-best-practices/

MySQL: Liệt kê các open transactions (InnoDB Plugin)

Trước tiên phải cài đặt common_schema trước, rồi dùng lệnh sau: SELECT * FROM common_schema.innodb_transactions; Kill các transaction đã...

MySQL: List locked transactions using common_schema framework

Show info on locked transactions: mysql> SELECT * FROM common_schema.innodb_locked_transactions; +---------------+---------------------...

MySQL: use foreach() for common_schema framework

foreach(): Invoke a script on each element of given collection.  $()  is a synonym of this routine. Select multiple columns; execute mu...

MySQL: use repeat_exec() of common_schema framework

Use  repeat_exec()  to delete huge amount of rows in smaller chunks, with sleeping interval: mysql> call repeat_exec(2, 'DEL...

Nolock on MySQL

SET SESSION TRANSACTION ISOLATION LEVEL READ UNCOMMITTED ; SELECT * FROM YOURTABLE SET SESSION TRANSACTION ISOLATION LEVEL REPEATABLE REA...

Visual Data Compare MySQL Webyod

Visual Data Comparison is an interactive implementation of Data Synchronization. Internally the two use the same code, but Visual Data Compa...

InnoDB and MaraDB and Percona MySQL

http://www.mysql.com/products/

ps_helper: useful for everyday DBA/Developer

ps_helper is a collection of views and procedures against the performance_schema database within MySQL, that can be used to generate extra...

common_schema: DBA’s framework for MySQL

http://code.openark.org/forge/common_schema

Check all tables that have a reference to a table

SELECT TABLE_NAME FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_SCHEMA='isporttl' AND COLUMN_NAME='userID' AND TABLE_NAME ...

Solving INFORMATION_SCHEMA slowness

http://www.mysqlperformanceblog.com/2011/12/23/solving-information_schema-slowness/ http://www.mysqlperformanceblog.com/2013/12/03/innodb_st...

Show Log Configuration on MySQL

SHOW VARIABLES LIKE '%log%'; MySQL prior to 5.1.0 requires a change to the MySQL my.cnf file and a restart in order to log slow...

Check MySQL version

Today I need to check MySQL version. I found a way as the screenshot below. First, in SQLYod, choose you MySQL Server and click 'Test ...

Copy structure and schema on SQL Server and MySQL

Today I have a task that copy structure and schema from one database to another database on MySQL. First, in the original database, rig...

MySQL Performance background

Showing running queries in MySQL show processlist; http://www.electrictoolbox.com/show-running-queries-mysql/ List all indexes for MyS...

MySQL Administrator background

MySQL show tables - How do I list the tables in a MySQL database? show tables; http://alvinalexander.com/blog/post/mysql/list-tables-in-...