[mythtv-users] ramfs for mysql

Simon Hobson linux at thehobsons.co.uk
Thu Jan 5 16:36:49 UTC 2012


Raymond Wagner wrote:

>The fact that a page has appeared several times just shows that people
>who don't know what they're doing are fiddling around with MySQL.

Then the correct response isn't to delete all references and leave 
them in the dark - it's leave the page up and add what you've written 
here as to why is shouldn't be done.

Otherwise, next time someone comes along as has the same idea, the 
same discussion will get repeated - which is not good use of anyone's 
time.


Miroslav Suchy wrote:

>You can do the same with much less effort by tuning up
>/etc/mysql/my.cnf. You can start with:
>tmpdir          = /dev/shm
>Which will use tmpfs for temporary tables.
>
>And bump up some variables of mysql. This is what I have in my my.cnf:
>set-variable    = sort_buffer_size=100M
>read_buffer_size = 100M
>set-variable    = read_rnd_buffer_size=100M
>set-variable    = max_connect_errors=2000
>myisam_sort_buffer_size = 100M
>set-variable    = max_connections=2000
>set-variable    = tmp_table_size=128M
>set-variable    = max_heap_table_size=128M
>innodb_flush_log_at_trx_commit=0
>innodb_buffer_pool_size=500M
>
>But be warned, that I have a *lot* of memory. You can check
>http://dev.mysql.com/doc/refman/5.0/en/memory-use.html

Which could also usefully be on a page of "why not to put MySQL files 
on a ram disk" - or on their own page (DB tuning page ?) with a link.


-- 
Simon Hobson

Visit http://www.magpiesnestpublishing.co.uk/ for books by acclaimed
author Gladys Hobson. Novels - poetry - short stories - ideal as
Christmas stocking fillers. Some available as e-books.


More information about the mythtv-users mailing list