| # Backup | |
| docker exec CONTAINER /usr/bin/mysqldump -u root --password=root DATABASE > backup.sql | |
| # Restore | |
| cat backup.sql | docker exec -i CONTAINER /usr/bin/mysql -u root --password=root DATABASE | |
Notes to install Ubuntu 22.04.4LTS (Upgraded to 24.04LTS) up and running on my 2017 MacBook Pro 15 inch (MacBookPro14,3).
Now everything except the TouchID (Fingerprint), Suspend and Hibernation seems to work for me.
About Ubuntu 24.04LTS: I tried to install Ubuntu 24.04 and didn't have success. There was a crash issue during installation. https://bugs.launchpad.net/subiquity/+bug/2065310 But I installed 22.04 and upgraded it to the 24.04LTS later and it working same as 22.04.4.
| -- https://www.geekytidbits.com/performance-tuning-postgres/ | |
| -- http://www.craigkerstiens.com/2012/10/01/understanding-postgres-performance/ | |
| -- http://okigiveup.net/what-postgresql-tells-you-about-its-performance/ | |
| -- https://wiki.postgresql.org/wiki/Introduction_to_VACUUM,_ANALYZE,_EXPLAIN,_and_COUNT | |
| -- https://devcenter.heroku.com/articles/postgresql-indexes#b-trees-and-sorting | |
| -- http://www.databasesoup.com/2014/05/new-finding-unused-indexes-query.html | |
| -- performance tools | |
| -- https://www.vividcortex.com/resources/network-analyzer-for-postgresql | |
| -- show running queries (pre 9.2) |