[mythtv-users] mySQL problems

[Chris Manning]

Hi there.  I'm having some problems, and I hope someone can help out.  This
is my first Mythtv install (following Jarod's guide which is very well done.
Thanks Jarod!)  Here is my system setup:

RH9
PVR-350
Asus A7N8X-X Nforce based mobo
Using both onboard sound and ethernet
AMD 2400+
512Mb RAM
X being displayed on the PVR-350

Latest ver of everything available by apt as of 20 mins ago.

So here's what is happening.  When I either schedule a recording, or tape
something that is currently on, it records about 2 or 3 mins (sometimes as
much as 10-15 mins,) and then stops as if it is done recording.  I thought
at first it might have been the 350 crashing the frontend since that seems
to be happening to other people.  The frontend is still running fine.  I
decide to check Mythweb, and it complains that it can't connect to the
backend server.  I decided to restart the backend, however, that doesn't
solve the problem.  Look at the mythbackend.log files, and no errors show
up.  As it turns out, when I restart mysql, things start working again for
another 10 mins.  So upon searching through all the system logs including
the mysql log, I have only found this error in mysqld.log:

Cannot initialize InnoDB as 'innodb_data_file_path' is not set. If you do
not want to use transactional InnoDB tables, add a line skip-innodb to the
[mysqld] section of init parameters in your my.cnf or my.ini. If you want to
use InnoDB tables, add to the [mysqld] section, for example,
innodb_data_file_path = ibdata1:10M:autoextend But to get good performance
you should adjust for your hardware the InnoDB startup options listed in
section 2 at http://www.innodb.com/ibman.html
/usr/libexec/mysqld: ready for connections

Now my sql settings are whatever were setup during the install, and it isn't
used for anything else.  While I'm unix and linux competant, I know little
about mysql.  Does anyone have any ideas what is going on? 
I'd be happy to provide any log files if that will help.

Thanks
Chris Manning