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
[EMAIL PROTECTED]
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/
pgpnqGWbTmRY2.pgp
Description: PGP signature
_______________________________________________ mythtv-users mailing list [email protected] http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
