MySQL: Table Size

Sometimes it is required to find out the size of a table in MySQL database. For example, if it is needed to perform an optimization and you analyze if some tables have become too large and it is time to tweak them somehow. In this short note i will show the SQL query that gets […]

MySQL: Checksum Table

Sometimes it is required to compare two tables to check if they are the same or not. For this you can calculate and compare the checksums of each table, using the CHECKSUM TABLE command in MySQL. This command is especially useful if you’re using MySQL replication and want to ensure that master and slave are […]

MySQL Server Installation and Initial Configuration on CentOS/RHEL

MySQL is the world’s most popular open source relational database management system that runs as a server providing multi-user access to a number of databases. This guide explains how to install and perform the initial secure configuration of MySQL Server on CentOS/RHEL based systems. MySQL Server Installation Install MySQL Server and MySQL Client using ‘yum’ […]