624
edits
Changes
Jump to navigation
Jump to search
Line 158:
Line 158: + + + + + + + + + + + + + + + + + + + + + + + + +
added Optimizing section
{{Tip box|mysql_setpermission is a command line menu driven utility that can assist in MySQL administration.}}
{{Tip box|mysql_setpermission is a command line menu driven utility that can assist in MySQL administration.}}
=== Optimizing MYSQL default settings ===
SME Server uses MYSQL for the webmail package, and the default configuration is optimized for that.
If you are using the SME server to provide MYSQL databases for functions running on workstations, you may need to adjust some of the default MySQL parameters. Keep in mind it is difficult to optimize MYSQL for a number of different applications, as default values that are suitable for one application may not be suitable for another. In determining appropriate settings for MYSQL, you will also need to consider the system resources & general specification of the server that MYSQL is running on.
Pointers for tuning and optimizing the databases can be found at http://www.mysqlperformanceblog.com/2006/09/29/what-to-tune-in-mysql-server-after-installation/ and http://lists.mysql.com/mysql/214398 and specifically re key_buffer_size at http://lists.mysql.com/mysql/214398
The following example comes from this forum thread http://forums.contribs.org/index.php/topic,46694.0.html and refers to this bug report http://bugs.contribs.org/show_bug.cgi?id=6287
To change the following parameters
key_buffer_size=18M
myisam_sort_buffer_size=8M
Create a custom template fragment & edit it to include your required parameters
mkdir -p /etc/e-smith/templates-custom/etc/my.cnf/
pico -w 011mysetup
Save & Exit
Ctrl o
Ctrl x
Expand the changes & restart mysql
expand-template /etc/my.cnf
sv t /service/mysqld
Check /etc/my.cnf to see that the changes are reflected.
<noinclude>
<noinclude>