Hi all,
I have installed Joomla v1.6 on my FreeBSD server. It seems really slow, even though the server hardware should be adequate: AMD Athlon II X2 250 with 2GB RAM.
Googling this, I discover a few hits in which people mention that some MySQL tuning improves Joomla 1.6 performance, such as this one on a Joomla forum.
Further searches reveal that the FreeBSD port does not automatically include a default my.cnf for MySQL. So I copied one of the sample config files in /usr/local/share/mysql to /usr/local/etc/my.cnf and restarted mysql.
However, mysql wouldn't restart. Looking in the error log /var/db/mysql/venus.err, I found this:
I commented this out of my.cnf and then mysql started properly.
I am curious whether anyone knows why this apparently invalid parameter would be included in the sample configuration files.
I am running MySQL version 5.5.4, which I installed via a package.
I have installed Joomla v1.6 on my FreeBSD server. It seems really slow, even though the server hardware should be adequate: AMD Athlon II X2 250 with 2GB RAM.
Googling this, I discover a few hits in which people mention that some MySQL tuning improves Joomla 1.6 performance, such as this one on a Joomla forum.
Further searches reveal that the FreeBSD port does not automatically include a default my.cnf for MySQL. So I copied one of the sample config files in /usr/local/share/mysql to /usr/local/etc/my.cnf and restarted mysql.
However, mysql wouldn't restart. Looking in the error log /var/db/mysql/venus.err, I found this:
Code:
110425 10:42:50 [ERROR] /usr/local/libexec/mysqld: unknown variable 'thread_concurrency=8'
110425 10:42:50 [ERROR] Aborting
I commented this out of my.cnf and then mysql started properly.
I am curious whether anyone knows why this apparently invalid parameter would be included in the sample configuration files.
I am running MySQL version 5.5.4, which I installed via a package.