[mythtv-users] mySQL problems

Chris Manning kenric at lozengy.net
Mon Mar 22 12:34:02 EST 2004

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:

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.

Chris Manning

More information about the mythtv-users mailing list