0

Query to Determine Disk Space Usage for AWS MySQL RDS

The following query will show you the disk space usage for an AWS MySQL RDS in MB: SELECT table_schema, SUM(data_length + index_length)/1024/1024 AS Total_GB, SUM(data_length)/1024/1024 AS Data_GB, SUM(index_length)/1024/1024 AS Index_GB, COUNT(*) AS tables, CURDATE() AS today FROM information_schema.tables GROUP BY… Continue Reading

0

Incrementing a column of type Int directly in MySQL

I had a problem where I wanted to increase the value of the votes column each time a nominee received a vote. As I’m not entirely proficient in SQL I figured I would have to first perform a select, save… Continue Reading