(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.
Tag: Open Source
Choosing a MySQL package
(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.
MySQL: Creating, Listing, and Removing Databases
(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.
Optimizing MySQL performance with accurate keys
(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
Mysql HA solutions
(Jayant Kumar) Lets see what HA solutions can be designed in mysql and where are they suited.
How important a primary key can be for MySQL performance?
(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.
Optimizer: new EXPLAIN FORMAT=JSON
(Gleb Shchepa) Probably, most of us tried to read the output of MySQL EXPLAIN command at least once.
How to selectively kill queries in MySQL?
(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.
On queries with many values in the IN clause
(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)
Another way to work with MySQL process list
(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.
