Categories

Optimization related articles (7)

Articles describing how to optimize a mysql database

Articles

 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...

 Database with latin1 content but over a utf8 connection

It is often the case where you want to migrate to a new server.The new server may be configured...

 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...

 Incorrect table definition; there can be only one TIMESTAMP column with CURRENT_TIMESTAMP in DEFAULT or ON UPDATE clause

If you receive this error below when you try to import an sql into your database: Incorrect...

 InnoDB: Unable to lock ibdata1 error

If you are receiving below error it is due to an error with the restart command "service mysql...

 MySQL Indexing for Performance optimization

 Mysql Import databases script

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

 Mysql export databases script

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

 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...

 ibdata reduce size

Step 01) MySQLDump all databases into a SQL text file (call it SQLData.sql) Step 02) Drop all...