Coding Technology

How to view the size of MySQL database(s) via the MySQL CLI

I thought I’d quickly post up this quick MySQL snippet to help others who are trying to quickly view the size of a MySQL database from the MySQL CLI. The following query displays the size of all your current MySQL databases on your server in megabytes:- SELECT table_schema “Data Base Name”, sum( data_length + index_length […]

Apps & OS's Coding Technology

Slow connections on remote MySQL Servers

Now a few of my projects are getting much bigger and the need for having dedicated Database servers are now more appealing than ever. With MySQL when setting it up I noticed that when trying to access a remote database from an application server, it would takes ages to respond/connect to it. After searching around […]