|
If this number is negative, reduce the innodb_buffer_pool_size until the sort_buffer_size turns positive, but allocate approximately from between 25%-50% of memory to the innodb_buffer_pool_size if the database is hosted on the Cacti server, or upto 80% of the system memory if the database is separate from the Cacti web server. However, try to not go below the default setting of 2,097,152. A sort buffer performs sorts for some queries using ORDER BY or GROUP BY. Configuring sort_buffer_size decides how much memory will be allocated for sort queries. The sort_buffer_size may need to be adjusted from the default if the workload requires a significant number of sort queries. The sort_buffer_size is defined on a per-session variable. Use the same equation as that of the join_buffer_size to determine the per connection possible memory.
|
|
|
InnoDB will hold as much tables and indexes in system memory as is possible. Therefore, you should make the innodb_buffer_pool large enough to hold as much of the tables and index in memory. Checking the size of the /var/lib/mysql/cacti directory will help in determining this value. We are recommending 25%% of your systems total memory, but your requirements will vary depending on your systems size. If you database is very large or remote, you can consider increasing this size. If remote, it can by as high as 80% of the systems memory. However, cautions must be taken to reduce the swapiness of the system, or to remove swap to keep the system from swapping.
|
InnoDB將盡可能多地保存系統內存中的表和索引。因此，你應該使innodb_buffer_pool足夠大，以便在內存中保存盡可能多的表和索引。檢查/ var / lib / mysql / cacti目錄的大小將有助於確定此值。我們建議您的系統總內存佔25 %%，但您的要求會因係統大小而異。
|
|
%s will divide the innodb_buffer_pool into memory regions to improve performance for versions of MariaDB less than 10.5. The max value is 64, but should not exceed more than the number of CPU cores/threads. When your innodb_buffer_pool is less than 1GB, you should use the pool size divided by 128MB. Continue to use this equation up to the max the number of CPU cores or 64.
|
％s會將innodb_buffer_pool劃分為內存區域以提高性能。最大值為64.當你的innodb_buffer_pool小於1GB時，你應該使用池大小除以128MB。繼續使用此公式，最大值為64。
|
|
%s will divide the innodb_buffer_pool into memory regions to improve performance for versions of MySQL upto and including MySQL 8.0. The max value is 64, but should not exceed more than the number of CPU cores/threads. When your innodb_buffer_pool is less than 1GB, you should use the pool size divided by 128MB. Continue to use this equation up to the max of the number of CPU cores or 64.
|
％s會將innodb_buffer_pool劃分為內存區域以提高性能。最大值為64.當你的innodb_buffer_pool小於1GB時，你應該使用池大小除以128MB。繼續使用此公式，最大值為64。
|
|
When using MariaDB 10.2.4 and above, this setting should be off if atomic writes are enabled. Therefore, please enable atomic writes instead of the double write buffer as it will increase performance.
|
使用 MariaDB 10.2.4 及更高版本時，如果啟用了原子寫入，則應關閉此設置。因此，請啟用原子寫入而不是雙寫入緩衝區，因為它會提高性能。
|
|
When using MariaDB 10.2.4 and above, you can use atomic writes over the doublewrite buffer to increase performance.
|
使用 MariaDB 10.2.4 及更高版本時，您可以在雙寫緩衝區上使用原子寫入來提高性能。
|
|
PHP %s is the minimum version
|
PHP％s是最小版本
|
|
Click 'Continue' to Delete the following External Link.
|
單擊“繼續”以刪除以下用戶域。
|
|
Click 'Continue' to Delete following External Links.
|
單擊“繼續”以刪除以下用戶域。
|
|
Delete External Link
|
外部連結
|
|
Delete External Links
|
外部連結
|
|
Click 'Continue' to Disable the following External Link.
|
單擊“繼續”以禁用以下用戶域。
|
|
Click 'Continue' to Disable following External Links.
|
單擊“繼續”以禁用以下用戶域。
|
|
Disable External Link
|
外部連結
|
|
Disable External Links
|
外部連結
|
|
Click 'Continue' to Enable the following External Link.
|
單擊“繼續”以啟用以下用戶域。
|
|
Click 'Continue' to Enable following External Links.
|
單擊“繼續”以啟用以下用戶域。
|
|
Enable External Link
|
外部連結
|
|
Enable External Links
|
外部連結
|
|
a Session Timeout
|
已逾時
|
