Maximising Performance - Revision history

JuanR: /* Software Related */

2023-06-04T12:41:18Z

‎Software Related

John: /* MySQL® */

2022-08-25T08:05:44Z

‎MySQL®

John: /* Email Provider */

2022-08-12T09:28:18Z

‎Email Provider

SarahK at 18:13, 26 April 2022

2022-04-26T18:13:50Z

PeterM at 16:55, 17 January 2022

2022-01-17T16:55:58Z

John: /* Server Related */

2021-09-16T12:00:31Z

‎Server Related

Lawrence: /* Server Related */

2020-12-29T16:32:30Z

‎Server Related

SarahK: /* Software Related */

2020-10-05T17:57:29Z

‎Software Related

DanR at 14:30, 10 September 2020

2020-09-10T14:30:26Z

SarahK: /* Software Related */

2020-08-04T13:53:02Z

‎Software Related

@@ Line 14: / Line 14: @@
 $disable_admin_ticket_page_counts = true;
 </div>
 === Logging ===

@@ Line 49: / Line 49: @@
 === MySQL® ===
-WHMCS performance is largely dependent on a correct MySQL® configuration, especially for larger databases. Make any changes to the server's <tt>my.cnf</ttt> file under the <tt>mysqld</tt> section, usually in <tt>/etc/my.cnf</tt> (cPanel servers and most others).
+WHMCS performance is largely dependent on a correct MySQL® configuration, especially for larger databases. Make any changes to the server's <tt>my.cnf</tt> file under the <tt>mysqld</tt> section, usually in <tt>/etc/my.cnf</tt> (cPanel servers and most others).
 * As a starting point, set <tt>max_connections</tt> to a low value like <tt>50</tt> and increase based on the available RAM.

← Older revision		Revision as of 09:28, 12 August 2022
Line 44:		Line 44:

	To diagnose and resolve this, see [https://help.whmcs.com/m/troubleshooting/l/1261469-troubleshooting-email-sending-problems Troubleshooting Email Problems].		To diagnose and resolve this, see [https://help.whmcs.com/m/troubleshooting/l/1261469-troubleshooting-email-sending-problems Troubleshooting Email Problems].
		+
		+	Consider switching to an external mail provider such as MailGun, SendGrid or SparkPost, as these are often more performant than SMTP systems. For further information see [[Mail_Tab#Configuring_a_Mail_Provider_in_WHMCS_8.0_and_later\|Configuring a Mail Provider]].

	=== MySQL® ===		=== MySQL® ===

@@ Line 1: / Line 1: @@
-If you grow to have a large client base, page loads may begin to slow down. This is because the more data you have, the larger the database becomes, and so calculating and looping through the data will naturally take longer. However, there are some things you can do to help keep things fast:
+If you grow to have a large client base, page loads may become slower. This is because the more data you have, the larger the database becomes, and so calculating and looping through the data will naturally take longer.
 ==Software Related==
-*'''Disable Ticket Counts''' — When you have a lot of tickets, calculating the number of tickets per status to display each time you open a ticket can slow things down. To avoid that, disable the ticket counts by adding the following line to your WHMCS <tt>configuration.php</tt> file:<div class="source-cli">$disable_admin_ticket_page_counts = true;</div>
+=== Disable Ticket Counts ===
-*'''Logging''' — In WHMCS, you can enable logging for, for example, SQL errors, hooks loading, or module commands. You can find these under '''Configuration (<i class="fa fa-wrench" aria-hidden="true"></i>) > System Settings > General Settings > Other''' as ''SQL Error Reporting'' or ''Hooks Debug'', or under '''System Settings (<i class="fa fa-wrench" aria-hidden="true"></i>) > System Logs > Module Debug Log''' ('''Utilities > Logs > Module Debug Log''' in WHMCS 7.x and earlier). Make sure to disable these for debugging errors that may occur, since they can and will increase the database size exponentially.
-*'''Hooks/Addons''' — Third party customizations can slow the performance of WHMCS.  Ensure that any customization that you are using is up-to-date and works with the version of WHMCS you are running.
+When you have a lot of tickets, calculating the number of tickets per status to display each time you open a ticket can slow things down.
-*'''Database Backups''' — The database backup process can be CPU, memory and disk intensive - whilst the entire database is exported, compressed and uploaded/emailed. If performance issues are observed at the same time every day during the database backup process, this could be a potential cause. Refer to the [[Backups#Limitations|Backups documentation]] for more information.
 ==Server Related==
-*'''Email Provider''' — Long loading times when performing an action which involves the sending of an email (placing an order, opening or replying to a support ticket, publishing an invoice etc.) are often caused by connection issues to the chosen email provider. To diagnose and resolve please refer to [https://help.whmcs.com/m/troubleshooting/l/1261469-troubleshooting-email-sending-problems Troubleshooting Email Problems].
+=== Email Provider ===
-*'''MySQL Tweaks''' — WHMCS performance is largely dependent on a correct MySQL® configuration, especially for larger databases. Make any changes to the server's <tt>my.cnf</ttt> file under the <tt>mysqld</tt> section, usually in <tt>/etc/my.cnf</tt> (cPanel servers and most others). As a starting point, they may want to set <tt>max_connections</tt> to a low value like <tt>50</tt> and increase based on their available RAM. When you are done configuring this and the following other important settings, restart MySQL and let it run for 48 hours:
 ** <tt>wait_timeout</tt> (at least 300, so MySQL doesn't drop connections too soon)
 ** <tt>sort_buffer_size</tt> (2–4 MB)
@@ Line 17: / Line 56: @@
 ** <tt>max_allowed_packet</tt> (16 MB)
-*'''System Tweaks''' — WHMCS is a PHP MySQL script, and so the more RAM or SWAP memory and raw processing power you have at your disposal, the better the performance from your installation.  For more information, see our [[System Requirements]]. We recommend using the higher set values and modules under the '''Recommended Settings''' for best results.
+=== System Tweaks ===

@@ Line 16: / Line 16: @@
 ** <tt>read_buffer_size</tt> (2–4 MB)
 ** <tt>max_allowed_packet</tt> (16 MB)
-[[File:Videotutorial.png‎|center|link=https://www.youtube.com/watch?v=CxQoRhefC8U|MySQL Tuning]]
 *'''System Tweaks''' — WHMCS is a PHP MySQL script, and so the more RAM or SWAP memory and raw processing power you have at your disposal, the better the performance from your installation.  For more information, see our [[System Requirements]]. We recommend using the higher set values and modules under the '''Recommended Settings''' for best results.

@@ Line 15: / Line 15: @@
 ** <tt>sort_buffer</tt> (2–4 MB)
 ** <tt>read_buffer</tt> (2–4 MB)
-** <tt>max_allowed_packet</tt> (16 MB[[File:Videotutorial.png‎|center|link=https://www.youtube.com/watch?v=CxQoRhefC8U|MySQL Tuning]]
+** <tt>max_allowed_packet</tt> (16 MB)
 *'''System Tweaks''' — WHMCS is a PHP MySQL script, and so the more RAM or SWAP memory and raw processing power you have at your disposal, the better the performance from your installation.  For more information, see our [[System Requirements]]. We recommend using the higher set values and modules under the '''Recommended Settings''' for best results.