postgresqltuner
minion
Our great sponsors
postgresqltuner | minion | |
---|---|---|
3 | 2 | |
2,551 | 222 | |
- | 0.5% | |
0.0 | 6.4 | |
4 months ago | about 1 month ago | |
Perl | Perl | |
GNU General Public License v3.0 only | Artistic License 2.0 |
Stars - the number of stars that a project has on GitHub. Growth - month over month growth in stars.
Activity is a relative number indicating how actively a project is being developed. Recent commits have higher weight than older ones.
For example, an activity of 9.0 indicates that a project is amongst the top 10% of the most actively developed projects that we are tracking.
postgresqltuner
- Postgresqltuner: Analyse Your PostgreSQL Database
-
In MySQL, never use “utf8”. Use “utf8mb4”
Are the DBA's on this thread committing code to the MySQL [1] and Postgres [2] tuner scripts that give new DBA's all your learned advise and battle hardening experience? Or at least a repo with the same objectives?
[1] - https://github.com/major/MySQLTuner-perl
[2] - https://github.com/jfcoz/postgresqltuner
- Is there any tool I can use to see what improvements can be made to a db?
minion
-
Managing a Test Database
What finally drove me over the edge was writing some code for a client using the Minion job queue. The queue is solid, but it creates new database connections, thus ensuring that it can’t see anything in your database transactions. I figured out a (hackish) solution, but I was tired of hackish solutions.
-
High Priority Fast Lane for the Minion Job Queue
Since Minion relies on PostrgeSQL the actual implementation was very simple. Just a few lines of Perl to spawn spare processes and one small change in the SQL query used to dequeue jobs.
What are some alternatives?
MySQLTuner-perl - MySQLTuner is a script written in Perl that will assist you with your MySQL configuration and make recommendations for increased performance and stability.
pgbadger - A fast PostgreSQL Log Analyzer
kanban-board - Single-click full-stack application (Postgres, Spring Boot & Angular) using Docker Compose
LANraragi - Web application for archival and reading of manga/doujinshi. Lightweight and Docker-ready for NAS/servers.
netdisco - A web-based network management tool.
Yancy - The Best Web Framework Deserves the Best Content Management System
MirrorCache - Download Redirector
apache2buddy - apache2buddy
pgaudit_analyze - PostgreSQL Audit Analyzer
mojo - :sparkles: Mojolicious - Perl real-time web framework