How to Optimize your Database in MODX Revolution

Written by Arnel Custodio
Views: 222
Published: Feb 16, 2013

MODX provides a tool that can help improve database performance and therefore the overall website performance.  This tool is available in the System Info section of MODX and is called OPTIMIZE DATABASE.  The following article shows how to find and use the OPTIMIZE DATABASE option.


Optimizing Your MODX Database

  1. Login to the Modx Administrator Dashboard.
  2. Hover over the menu bar at the top of the screen where you see REPORTS.  Click on SYSTEM INFO when the drop-down menu appears.
  3. Three tabs in System InfoYou will see three tabs in the interface.  Click on DATABASE TABLES to continue.
  4. The screen that you will see shows all of the tables (and sizes of each table) within MODX.  This information can help you to determine how large the database is getting.  Click on the OPTIMIZE DATABASE button to proceed. Optimize database button
  5. There will be no indicator of completion.  If you have a lot of data in your database, then the optimization make take a few minutes.  Otherwise, it will only be a few seconds.


Use the optimization option if you have a large database and performance appears to have declined.  Use this option on a regular basis and it will help keep your MODX installation running smoothly.

 

 

 

 

 

 

Did you find this article helpful?

Login to comment.

Managing Modx
1. Managing Users in Modx
2. Part I: Managing Users Groups in Modx
3. Replacing the Modx Editor with TinyMCE
4. How to manually reset MODx Administrator user password using API
5. Resetting the Password for Modx Users through the Database
6. How to view an error log in Modx
7. How to Add Content Types to Modx
8. Loading MODX Components in Package Management
9. Installing Packages in Modx Package Management
10. Changing System Settings in Modx
11. Creating Systems Settings in Modx
12. Part I: Setting Up Friendly URLs for MODX- HTACCESS file changes
13. Part II: Making Template and System Setting Changes to Enable Friendly URLs for Modx
14. How to Optimize your Database in MODX Revolution
15. How to find MODX System Information
16. Flush Permissions and Sessions in MODX
17. How to Configure SMTP Email for MODX
18. Adding the Google Analytic Widget to the MODX Dashboard

Support Center Login

Your Opinion Matters

... but we need to know what you're thinking!

I'm Arnel Custodio, your friendly Community Support technician, and I wrote the article you're looking at now. I like to think it's perfect, but I'm sure you have some suggestions. Please, let me know what they are!

Feedback
Your Email Address
Because we'd like to talk with you!

Have a Question?

If you need some help, submit your question to our Community! We guarantee a response within 60 minutes (8am - 9pm EST, Monday - Friday)

Recent Questions

  1. Accessing FTP: wait for account setup?
  2. is there a way to link a picture from an image gallery page to the specific item in eshop?
  3. Wordpress 404 error

Support Center Search

Current Customers

Email: support@WebHostingHub.com Ticket: Submit a Support Ticket
Call: 877-595-4HUB (4482)
757-416-6627 (Intl.) 		Chat: Click To Chat Now

Ask the Community

Get help with your questions from our community of like-minded hosting users and Web Hosting Hub Staff.

Not a Customer?

Get web hosting from a company that is here to help.