Skip to content
Main Menu
  • Home
  • Blog
  • Contact

DevOps Fu

Tips and Tricks for DevOps Engineers

  • Home
  • Blog
  • Contact

Tag: MySQL

  • Home
  • Blog
  • MySQL

How to show the disk space used by MySQL tables?

February 4, 2019March 26, 2019 Fabrice

Connect to your MySQL server and run the following: mysql> select table_name, round(((data_length + index_length) / (1024 * 1024)), 2) as `Size in MB` from information_schema.tables where table_schema = ‘YOUR_DB_NAME’ order by `Size in MB`; I work as a freelancer,… Read More

DatabaseMySQLLeave a comment

How to enable and analyse the slow query log on MySQL?

October 2, 2018March 26, 2019 Fabrice

Set the following variables in your MySQL config file: slow_query_log = 1 (means true) long_query_time = 0 (means 0 seconds) log_queries_not_using_indexes = 1 (means true) log_output = FILE (default is TABLE) Setting long_query_time to 0 will instruct MySQL to log… Read More

DatabaseMySQLLeave a comment

How to install a MySQL NDB Cluster on Ubuntu?

August 13, 2018March 26, 2019 Fabrice

Official documentation here. There are 3 different types of nodes for MySQL Cluster: NDB manager, NDB node and MySQL server. Please note the standard MySQL server does not support NDB tables, so the MySQL server must be the one compiled… Read More

DatabaseMySQLLeave a comment

How to fix login issues with a password-less root MySQL user?

May 22, 2018March 25, 2019 Fabrice

If you installed MySQL without a root password, you will have difficulties to login as root. For example, you need to sudo first, and can’t login as a regular user. The solution to this problem is to create a new… Read More

SysadminMySQLLeave a comment

Recent Posts

  • How to test that a service account has access to a certain resource in Kubernetes?
  • How to persist variables in a loop from a find command in Bash?
  • How to iterate an array in Bash?
  • How to trim leading and trailing characters in Bash?
  • How to install jq on CentOS?

Categories

  • Automation
  • AWS
  • Bash
  • CentOS
  • Containers
  • Cryptography
  • Database
  • Development
  • Docker
  • Git
  • Kubernetes
  • Linux
  • Python
  • Sysadmin
  • Virtualization

Archives

  • March 2021
  • December 2020
  • October 2020
  • August 2020
  • July 2020
  • June 2020
  • April 2020
  • March 2020
  • February 2020
  • November 2019
  • June 2019
  • May 2019
  • April 2019
  • March 2019
  • February 2019
  • December 2018
  • November 2018
  • October 2018
  • September 2018
  • August 2018
  • July 2018
  • June 2018
  • May 2018
Copyright © 2018-2019 Fabrice Triboix
Best Business by Axle Themes