[mythtv-users] Performance MySQL on RAM

[Richard Morton]

Have a look at the wiki. This article specifically
http://www.mythtv.org/wiki/Optimizing_Performance#MySQL_Database_Tweaks

Please excuse brevity and pistakes as this email was composed on a mobile
phone.
Best regards,
Richard
On Oct 23, 2012 4:34 AM, "Pieter De Wit" <pieter at insync.za.net> wrote:

>
>
> Sent from my iPad
>
> On 23/10/2012, at 9:59, Josu Lazkano <josu.lazkano at gmail.com> wrote:
>
> > Hello,
> >
> > I have some questions abot MySQL performance, I have a dedicatd server
> > for the backend with 2GB of memory. I am thinking on buy 2GB more and
> > get 4GB of RAM.
> >
> > Is possible to use RAM memory to optimize MySQL?
> >
> > I add 2 lines on the configuration:
> >
> > tmp_table_size          = 256M
> > max_heap_table_size     = 256M
> >
> > This is my complete MySQL configuration:
> >
> > [client]
> > port        = 3306
> > socket        = /var/run/mysqld/mysqld.sock
> >
> > [mysqld_safe]
> > socket        = /var/run/mysqld/mysqld.sock
> > nice        = 0
> >
> > [mysqld]
> > tmp_table_size          = 256M
> > max_heap_table_size     = 256M
> >
> > 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
> > lc-messages-dir    = /usr/share/mysql
> > 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/
> >
> > How could I check the performance of the database?
> >
> > Thanks and best regards.
> >
> > --
> > Josu Lazkano
> > _______________________________________________
> > mythtv-users mailing list
> > mythtv-users at mythtv.org
> > http://www.mythtv.org/mailman/listinfo/mythtv-users
>
> Hi,
>
> I have 2gig on my combined BE/FE and it swaps. Very little of it would be
> MySQL IMHO. I am going to go 4gig and just leave the MySQL settings as is.
>
> ( I do a LOAD of MySQL work so unless you are hammering the db, 1000's of
> connections, the default will do you well )
>
> Cheers,
>
> Pieter
> _______________________________________________
> mythtv-users mailing list
> mythtv-users at mythtv.org
> http://www.mythtv.org/mailman/listinfo/mythtv-users
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.mythtv.org/pipermail/mythtv-users/attachments/20121023/45eade69/attachment.html>