(Sean Hull) Setting up replication in MySQL is something we need to do quite often. Slaves die, replication fails, or tables and data get out of sync. Whenever we build a slave, we must start with a snapshot of all the data from the master database.

(Maciej Dobrzanski) As with any open source software, anyone can download MySQL sources, build binaries for some platforms and distribute their own packages. So we have the official ones from Oracle, MariaDB, and Percona – the makers of MySQL and its forks respectively.

(wubayou) Today’s MySQL database tutorial covers a few basic concepts. Specifically, we are going to discuss how to create a MySQL database in the first place. Next, you will learn how to list and select databases in MySQL. Finally, you will see the steps to remove databases in MySQL.

(Maciej Dobrzanski) MySQL performance is largely defined by keys and how efficiently queries can use them. As you scale, at certain point it isn’t enough anymore to just have any indexes and still get a good performance in return. You have to really figure them out and allow your queries to do less

(Jayant Kumar) Lets see what HA solutions can be designed in mysql and where are they suited.

(Maciej Dobrzanski) How important a primary key design can be for MySQL performance? The answer is: Extremely! If tables use InnoDB storage engine, that is.

(Gleb Shchepa) Probably, most of us tried to read the output of MySQL EXPLAIN command at least once.

(Thomas) For as long as it is only about a few of them, it is as simple as looking at the SHOW PROCESSLIST output for thread identifiers to kill. They can be found in the first column called Id. These values can be passed to KILL thread_id command in MySQL.

(Jørgen Løland) A few customers with rather extreme needs have contacted us about a performance issue with the range optimizer. Our solution to the problem is to introduce a new variable in MySQL 5.6, eq_range_index_dive_limit, which can be used to control whether or not the range optimizer will a)

(Maciej Dobrzanski) In an earlier post titled “How to work with a long process list in MySQL”, we showed a neat way to work with the process list by using various shell tools. But some of that can also be done using pure SQL.