[lug] mysqldump versus snapshot versus..

dio2002 at indra.com dio2002 at indra.com
Thu Aug 2 17:11:18 MDT 2007


> We set our "key_buffer" setting to 1/2 of available mem, which seems to do

I'll take a look at these my.cnf settings in the manual and see what i can
dig up.  Basically anything with an M (memory related) is prime candidate
for tuning.

thanks

> Our basic my.cnf looks like:
>
> [mysqld]
> datadir=/var/lib/mysql
> socket=/var/lib/mysql/mysql.sock
> old_passwords=1
> log-bin=mysql-bin
> server-id=1
> key_buffer = 1999M
>
> A really tricked-out one looks like:
>
> [mysqld]
> [...]
> skip-locking
> key_buffer = 1999M
> max_allowed_packet = 1M
> table_cache = 512
> sort_buffer_size = 2M
> read_buffer_size = 2M
> myisam_sort_buffer_size = 64M
> thread_cache = 8
> query_cache_size = 32M
> # Try number of CPU's*2 for thread_concurrency
> # dual-quad-core = 8 CPUs
> thread_concurrency = 16
> ft_min_word_len = 3
> server-id       = 3
> log-bin=mysql-bin
>
> - Steve
>
> --
> EMAIL: (h) steve at badcheese.com  WEB: http://badcheese.com/~steve
>
> _______________________________________________
> Web Page:  http://lug.boulder.co.us
> Mailing List: http://lists.lug.boulder.co.us/mailman/listinfo/lug
> Join us on IRC: lug.boulder.co.us port=6667 channel=#colug
>




More information about the LUG mailing list