Panda Database Optimizer (PDBO)

One of my acquaintances approached me and, almost swearing (actually swearing), started cursing out the content managers. He said, thank goodness we sorted out the access rights more or less, thanks to the UPP module. We restricted access for the completely inexperienced to the batch editor, AOP, and Category Management +. We left only the admin panel and Trade Management 6 Personal Editor ++ for editing products directly on the site. We did all possible optimizations, and the site flies until work begins on filling in product cards, attributes, building relationships, and dependencies. The problem is trivial - we see high fragmentation of indexes and tables in the DB. I show him how to go into PHP admin, and then I get more swearing. He asked how I imagine that he would do it himself. He asked for a "magic button" to ensure no one slows down the site, and for it to run automatically at set times. This is a cleaned-up version of what was said, but it was clear, understood, and done.

The result is a minimalist, visually understandable, and, I would say, "ascetic" module for optimizing DB tables and indexes.

Main tasks and advantages of PDBO:
- Simple visual assessment of table fragmentation (as my acquaintance put it: the degree of "messed up")
- Manual optimization of fragmentation of all tables with one button (my acquaintance expressed it as ensuring no "fool" messes up anything extra)
- Logging of recent actions (to understand if those "slackers" are following instructions)
- Cron job support (in case some "donkey" forgets to clean up after themselves)
- Intuitive interface (so the button can't be missed, specifically for the visually impaired)
- No additional features, as the module is intended for non-specialists.

Write a review

Your Name:


Your Review: Note: HTML is not translated!

Rating: Bad           Good

Enter the code in the box below: