Keep track of database table size changes in MySQL

(Posted originally in kinja ops blog)

I don’t know how common is this problem, but it is good to know from time to time about which tables how many storage space needed in certain time. For example, you can catch an amok running software part which writes your database full. Or, – as you will see soo – you can catch up some code what doesn’t work as excepted.

Continue reading “Keep track of database table size changes in MySQL”

Share This:

MySQL connections listing

(Posted originally in kinja ops blog)

Currently at Kinja we are in a middle of big architectural change on database servers, so I have run into a problem regarding this. Sometimes I have to check current connections on database servers, to see what schemas are in use, what servers using a given db server, or even which users are connected to database server.

Continue reading “MySQL connections listing”

Share This:

Free up space on mysql servers

(Post was originally posted on kinja ops blog)

First, I have to tell you, that the “fragmentation” is not the best word what I should use, but that was the closest to that what I wanted to say. The base of the fragmentation checker script is Peter Zaitchev’s 2008 article about Information_schema, I used that query to get that results what I needed.

Continue reading “Free up space on mysql servers”

Share This: