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?

We value your feedback!

Why was this article not helpful? (Check all that apply)
The article is too difficult or too technical to follow.
There is a step or detail missing from the instructions.
The information is incorrect or out-of-date.
It does not resolve the question/problem I have.
How did you find this article?
Please tell us how we can improve this article:
Email Address

new! - Enter your name and email address above and we will post your feedback in the comments on this page!

Did you find this article helpful?

Post a Comment

Email Address:
Phone Number:

Please note: Your name and comment will be displayed, but we will not show your email address.

Related Questions

Here are a few questions related to this article that our customers have asked:
Ooops! It looks like there are no questions about this page.
Would you like to ask a question about this page? If so, click the button below!
Need More Help?

Help Center Search

Current Customers

Email: 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.