[mythtv-users] MySQL Error in Jarod's Guide?
jarod at wilsonet.com
Wed Mar 16 06:47:51 UTC 2005
On Tuesday 15 March 2005 14:26, Rei Toi wrote:
> First, I'm newbie. You have been warned. :)
> Second, thanks again for your guide, Jarod. It was a tremendous help to
> I *think* that I may have found an error in section 12 for MySQL. I'm
> hoping that those with more experience can check this before I open a
> ticket for it on Jarod's site. So, please, correct me if I'm wrong.
> I believe there is an error in the optimizations for MySQL v3.x.
> Specifically, this line should be excluded from the guide:
> set-variable = query_cache_size = 16M
> This apparently is not a valid setting for versions of MySQL prior to
> 4.0.1. From the MySQL Reference Manual :: 5.11 The MySQL Query Cache:
> "From version 4.0.1 on, MySQL Server features a query cache. When in
> use, the query cache stores the text of a SELECT query together with the
> corresponding result that was sent to the client. If the identical query
> is received later, the server retrieves the results from the query cache
> rather than parsing and executing the query again."
> I followed the guide to do an install of FC3, which installed MySQL ver
> 3.23.58. After adding the above mentioned entry into /etc/my.cnf,
> mysqld failed to start with the following error in /var/log/mysqld.log:
> 050314 20:59:48 mysqld started
> No variable match for: -O 'query_cache_size=16M'
> /usr/libexec/mysqld Ver 3.23.58 for redhat-linux-gnu on i386
> Use '--help' or '--no-defaults --help' for a list of available options
> 050314 20:59:49 mysqld ended
> mysqld --help for this version shows no option for query_cache_size.
> Should I open a ticket for this, or am I wrong?
Hm, you're probably correct. Someone sent me the MySQL 3.x info, which I'd
assumed to be accurate. I'm running 4.x on all my own systems now, so I
hadn't actually tried those settings myself. No need to open a ticket, I'll
just fix it now.
jarod at wilsonet.com
Got a question? Read this first...
MythTV, Fedora Core & ATrpms documentation:
MythTV Searchable Mailing List Archive
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Size: 189 bytes
Desc: not available
Url : http://mythtv.org/pipermail/mythtv-users/attachments/20050315/9c6e4aeb/attachment.pgp
More information about the mythtv-users