[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