Viewing articles tagged 'mysql'

 B-TREE and B+TREE Index (Part 2)

When you hear in the industry the word index, they often mean a B-tree index. Most of the MySQL...

 Client does not support authentication protocol requested by server

If you have a mysql authentication issues related to the error below you can take the following...

 Connect to mysql server under docker

You can use below command to connect to a mysql dockerized version: mysql -u root -h 127.0.0.1...

 Enable mysql general log and slow query log and enable log rotation and archiving of logs

In this short tutorial we will learn how to configure the following: Enable general log in...

 Host is not allowed to connect to this MariaDB server

The error "Host is not allowed to connect to this MariaDB server" usually points to a remote...

 How to optimize the mysql database using mysqltuner script

Most modern applications these days including popular CMS use databases. As databases grow in...

 InnoDB versus MyISAM (Part 1)

Below we want to outline differences between InnoDB and MyIsam engine in mysql.   InnoDB...

 Mysql export databases script

We can use this command to export the databases as single files: mysql -uroot -p -e 'show...

 Mysql Import databases script

#!/bin/bash usage() {echo "$0 [mysql_parameters] <SQL files...>" >&2echo " Restores...

 MySQL Indexing for Performance optimization

 Percona binary log check - cluster control activate

This is a short tutorial on how to check if mysql binary log is enabled and activate it, if it is...