[mythtv-users] Sloooow database

Curtis Stanford curtis at stanfordcomputing.com
Wed Jun 11 22:37:53 UTC 2008


>
> Actually, I'm just using the default settings for all of those from
> the Gentoo ebuild, which I'd think is probably the same defaults you'd
> get from the mysql source.  Some of those aren't even in my cnf file,
> so they're using built-in defaults, but here are all of those settings
> from the running database:
>
> show variables where variable_name in ('key_buffer_size',
> 'table_cache', 'sort_buffer_size', 'myisam_sort_buffer_size',
> 'query_cache_size', 'query_cache_limit', 'query_cache_type')
> --------------
>
> +-------------------------+----------+
> | Variable_name           | Value    |
> +-------------------------+----------+
> | key_buffer_size         | 16777216 |
> | myisam_sort_buffer_size | 8388608  |
> | query_cache_limit       | 1048576  |
> | query_cache_size        | 0        |
> | query_cache_type        | ON       |
> | sort_buffer_size        | 524288   |
> | table_cache             | 64       |
> +-------------------------+----------+
> 7 rows in set (0.00 sec)


Thanks. I'm using Gentoo as well but I've changed all the settings.  
Maybe I'll re-emerge it again.

Curtis

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://mythtv.org/pipermail/mythtv-users/attachments/20080611/d243a627/attachment-0001.htm 


More information about the mythtv-users mailing list