<p>Have a look at the wiki. This article specifically<br>
<a href="http://www.mythtv.org/wiki/Optimizing_Performance#MySQL_Database_Tweaks">http://www.mythtv.org/wiki/Optimizing_Performance#MySQL_Database_Tweaks</a></p>
<p>Please excuse brevity and pistakes as this email was composed on a mobile phone.<br>
Best regards,<br>
Richard </p>
<div class="gmail_quote">On Oct 23, 2012 4:34 AM, "Pieter De Wit" <<a href="mailto:pieter@insync.za.net">pieter@insync.za.net</a>> wrote:<br type="attribution"><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<br>
<br>
Sent from my iPad<br>
<br>
On 23/10/2012, at 9:59, Josu Lazkano <<a href="mailto:josu.lazkano@gmail.com">josu.lazkano@gmail.com</a>> wrote:<br>
<br>
> Hello,<br>
><br>
> I have some questions abot MySQL performance, I have a dedicatd server<br>
> for the backend with 2GB of memory. I am thinking on buy 2GB more and<br>
> get 4GB of RAM.<br>
><br>
> Is possible to use RAM memory to optimize MySQL?<br>
><br>
> I add 2 lines on the configuration:<br>
><br>
> tmp_table_size = 256M<br>
> max_heap_table_size = 256M<br>
><br>
> This is my complete MySQL configuration:<br>
><br>
> [client]<br>
> port = 3306<br>
> socket = /var/run/mysqld/mysqld.sock<br>
><br>
> [mysqld_safe]<br>
> socket = /var/run/mysqld/mysqld.sock<br>
> nice = 0<br>
><br>
> [mysqld]<br>
> tmp_table_size = 256M<br>
> max_heap_table_size = 256M<br>
><br>
> user = mysql<br>
> pid-file = /var/run/mysqld/mysqld.pid<br>
> socket = /var/run/mysqld/mysqld.sock<br>
> port = 3306<br>
> basedir = /usr<br>
> datadir = /var/lib/mysql<br>
> tmpdir = /tmp<br>
> lc-messages-dir = /usr/share/mysql<br>
> skip-external-locking<br>
> key_buffer = 16M<br>
> max_allowed_packet = 16M<br>
> thread_stack = 192K<br>
> thread_cache_size = 8<br>
> myisam-recover = BACKUP<br>
> query_cache_limit = 1M<br>
> query_cache_size = 16M<br>
> expire_logs_days = 10<br>
> max_binlog_size = 100M<br>
><br>
> [mysqldump]<br>
> quick<br>
> quote-names<br>
> max_allowed_packet = 16M<br>
><br>
> [mysql]<br>
><br>
> [isamchk]<br>
> key_buffer = 16M<br>
><br>
> !includedir /etc/mysql/conf.d/<br>
><br>
> How could I check the performance of the database?<br>
><br>
> Thanks and best regards.<br>
><br>
> --<br>
> Josu Lazkano<br>
> _______________________________________________<br>
> mythtv-users mailing list<br>
> <a href="mailto:mythtv-users@mythtv.org">mythtv-users@mythtv.org</a><br>
> <a href="http://www.mythtv.org/mailman/listinfo/mythtv-users" target="_blank">http://www.mythtv.org/mailman/listinfo/mythtv-users</a><br>
<br>
Hi,<br>
<br>
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.<br>
<br>
( I do a LOAD of MySQL work so unless you are hammering the db, 1000's of connections, the default will do you well )<br>
<br>
Cheers,<br>
<br>
Pieter<br>
_______________________________________________<br>
mythtv-users mailing list<br>
<a href="mailto:mythtv-users@mythtv.org">mythtv-users@mythtv.org</a><br>
<a href="http://www.mythtv.org/mailman/listinfo/mythtv-users" target="_blank">http://www.mythtv.org/mailman/listinfo/mythtv-users</a><br>
</blockquote></div>