Login | Register For Free | Help
Search for: (Advanced)

Mailing List Archive: MythTV: Users
Optimize MySQL
 

Index | Next | Previous | View Flat


josu.lazkano at gmail

Apr 29, 2012, 2:15 PM


Views: 674
Permalink
Optimize MySQL

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
_______________________________________________
mythtv-users mailing list
mythtv-users [at] mythtv
http://www.mythtv.org/mailman/listinfo/mythtv-users

Subject User Time
Optimize MySQL josu.lazkano at gmail Apr 29, 2012, 2:15 PM
    Re: Optimize MySQL mtdean at thirdcontact Apr 29, 2012, 2:46 PM
        Re: Optimize MySQL josu.lazkano at gmail Apr 30, 2012, 1:27 AM

  Index | Next | Previous | View Flat
 
 


Interested in having your list archived? Contact Gossamer Threads
 
  Web Applications & Managed Hosting Powered by Gossamer Threads Inc.