Keep it Simple

Showing posts with label databases. Show all posts
Showing posts with label databases. Show all posts
Friday, December 24, 2021

Postgresql locks

›
Locks in postgres Find locks select pid, state, usename, query, query_start from pg_stat_activity where pid in ( select pid from pg_l...
Sunday, March 25, 2012

How to calculate the MySQL database size

›
Connect to mysql and run the command bellow # total db size SELECT table_schema "Data Base Name", SUM( data_length + index_lengt...
Thursday, January 12, 2012

MySQL backup in time

›
Run mysqldump on master database (needs to have innodb) # replication point in time mysqldump --single-transaction --flush-logs \ --mas...
›
Home
View web version
Powered by Blogger.