Supposed you have a table that being updated by MySQL triggers and the DB is a master of replication, how do the triggers act in the environment? Here we might have a list of questions: Q1, Will the definition sql…

MySQL 5.5.15 GA has been released in 28 July 2011. Functionality Added or Changed The undocumented –all option for perror is deprecated and will be removed in MySQL 5.6. Bugs Fixed InnoDB Storage Engine: A failed CREATE INDEX operation for…

If you have binary logging enabled on your MySQL server (i.e. the log-bin parameter is set in the config file), then you may notice a bulk of large files in the MySQL data directory over time. Generally you only need…

How can I change user password under MySQL server when I lost my password? Here’s I’ll show two examples. The first example is about how to change password for normal user using Linux command line option, and the second example…

Let’s keep this post smart. It’s intended to help you rebuild a crashed MySQL replication. We assume that bin-log has been enabled at the master side. Basically what you need to do is to retrival a snapshot of your master…

If you set up MySQL replication, you probably have ever faced this problem. there are invalid MySQL queries which cause the replication not to work anymore. Here I’ll explain how you can repair the replication on MySQL slave without rebuilding…

MySQLPerformanceBlog has issue “Several days ago MySQL AB made new storage engine Falcon available for wide auditory. We cannot miss this event and executed several benchmarks to see how Falcon performs in comparison to InnoDB and MyISAM.

Now as new MySQL Storage engine – Falcon is public I can write down my thought about its design, which I previously should have kept private as I partially got them while working for MySQL.