[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