[mythtv-users] MySQL Error in Jarod's Guide?

[Jarod Wilson]

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
> me.
>
> 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:
>
> http://dev.mysql.com/doc/mysql/en/query-cache.html
>
> "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 Wilson
jarod at wilsonet.com

Got a question? Read this first...
     http://catb.org/~esr/faqs/smart-questions.html
MythTV, Fedora Core & ATrpms documentation:
     http://wilsonet.com/mythtv/
MythTV Searchable Mailing List Archive
     http://www.gossamer-threads.com/lists/mythtv/
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 189 bytes
Desc: not available
Url : http://mythtv.org/pipermail/mythtv-users/attachments/20050315/9c6e4aeb/attachment.pgp