[mythtv-users] Optimize MySQL

[Josu Lazkano]

Hello all, I am trying to speed up my MySQL service.

I have a FE/BE system with a EXT4 disk for the all system and DB
datadir, an other disk with XFS for recordings.

I try to run the optimize_mythdb.pl script, but this is the output:

# perl /usr/share/doc/mythtv-backend/contrib/maintenance/optimize_mythdb.pl
Can't locate MythTV.pm in @INC (@INC contains: /etc/perl
/usr/local/lib/perl/5.14.2 /usr/local/share/perl/5.14.2 /usr/lib/perl5
/usr/share/perl5 /usr/lib/perl/5.14 /usr/share/perl/5.14
/usr/local/lib/site_perl .) at
/usr/share/doc/mythtv-backend/contrib/maintenance/optimize_mythdb.pl
line 15.
BEGIN failed--compilation aborted at
/usr/share/doc/mythtv-backend/contrib/maintenance/optimize_mythdb.pl
line 15.

Is there any problem with my perl?

This is my MySQL configuration:

socket		= /var/run/mysqld/mysqld.sock

[mysqld_safe]
socket		= /var/run/mysqld/mysqld.sock
nice		= 0

[mysqld]
user		= mysql
pid-file	= /var/run/mysqld/mysqld.pid
socket		= /var/run/mysqld/mysqld.sock
port		= 3306
basedir		= /usr
datadir		= /var/lib/mysql
tmpdir		= /tmp
language	= /usr/share/mysql/english
skip-external-locking

key_buffer		= 16M
max_allowed_packet	= 16M
thread_stack		= 192K
thread_cache_size       = 8

myisam-recover         = BACKUP

query_cache_limit	= 1M
query_cache_size        = 16M

expire_logs_days	= 10
max_binlog_size         = 100M

[mysqldump]
quick
quote-names
max_allowed_packet	= 16M

[mysql]

[isamchk]
key_buffer		= 16M

!includedir /etc/mysql/conf.d/

Must I change any configuration?

Thanks for your help and best regards.

-- 
Josu Lazkano