Managing MySQL resource usage on shared hosting servers can be a challenge, especially on Enhance with Ubuntu. Owl AutoMySQL is a fully automated solution in cPFence that helps prevent overloads by automatically managing and limiting abusive MySQL activity.
cPFence now includes a browser-based WebUI that is fully mobile-friendly, allowing you to enable, disable, or configure Owl AutoMySQL from any device. You can manage this per server or across your entire cluster by selecting the target server in the sidebar dropdown.
Enable or Disable Owl AutoMySQL via WebUI (Recommended)
- Open the cPFence WebUI on your Main Control Panel server.
- Use the Switch Server dropdown to select a specific server or all servers, as needed.
- Go to Tools & Utilities and scroll to the cPFence Owl™ Monitoring Module section.
- Click Enable Owl AutoMySQL to activate automatic MySQL resource controls, or Disable Owl AutoMySQL to turn it off at any time.
Changes apply immediately to the selected server(s).
How to Exclude Specific Users from Owl AutoMySQL
- In the WebUI, navigate to System Settings > Adjust Settings (One Server).
- Click Load Current Settings and find the EXCLUDED_USERS_AUTO_MySQL field.
- Enter usernames to exclude, separated by
|(for example:user1|user2). - Click Save & Restart to apply changes.
Note: You need to use the MySQL username for this, not the site or owner user.
To view the MySQL usernames currently on your server, you can run the following command as root:
mysql -e "SELECT user, COUNT(*) AS login_count FROM mysql.user GROUP BY user ORDER BY login_count DESC;"
Command Line (CLI) Method
cpfence --owl-automysql-on
cpfence --owl-automysql-off
Use these commands to enable or disable Owl AutoMySQL from the terminal on any server.
To exclude users via CLI, edit the configuration file:
nano /opt/cpfence/config.conf
# Example:
EXCLUDED_USERS_AUTO_MySQL="user1|user2"
Why Use Owl AutoMySQL?
- One-Click Activation: Instantly protect your MySQL servers from abusive queries and scripts.
- Automatic Abuse Prevention: Ensures stable performance by blocking overloads while allowing normal usage.
- Customizable: Exclude any user from AutoMySQL with a simple list.
- Designed for Enhance: Perfect for hosting providers using Enhance and Ubuntu—no need for third-party solutions.
Need Further Assistance?
Visit our Knowledgebase or contact our support team for help.
