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