[mythtv-users] Performance MySQL on RAM

[Pieter De Wit]

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