[mythtv-users] Performance MySQL on RAM

Josu Lazkano josu.lazkano at gmail.com
Mon Oct 22 20:59:22 UTC 2012


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


More information about the mythtv-users mailing list