maria-discuss team mailing list archive

[Honza Horak <hhorak@xxxxxxxxxx>]

On 04/21/2015 05:07 PM, Justin Swanhart wrote:
> Hi,
>
> Are you using MyISAM or InnoDB?  What are the values of
> table_open_cache, table_definition_cache and innodb_open_files?

It is a mixture of MyISAM and InnoDB, but we got complaints especially 
about the MyISAM tables.

Options table_open_cache, table_definition_cache have default values, so 
400, innodb_open_files is changed to 128.

Honza

> --justin
>
> On Tue, Apr 21, 2015 at 6:26 AM, Honza Horak <hhorak@xxxxxxxxxx
> <mailto:hhorak@xxxxxxxxxx>> wrote:
>
>     Hey, with limited experiences with mariadb deployments, I'm
>     wondering how many open files by the mysqld daemon is still sane
>     (expected).
>
>     We have a customer that reports hundreds of thousands of open files
>     with 600 connections (thread_pool_max_threads is used). Those
>     processes seem rather stalled, but files in the datadir are often
>     opened 40.000 times.
>
>     Is it even possible that one file is opened several times during
>     processing one query? Or does it mean there are ~40.000 queries running?
>
>     Version of MariaDB: 5.5.40
>
>     Honza
>
>     _______________________________________________
>     Mailing list: https://launchpad.net/~maria-discuss
>     Post to     : maria-discuss@xxxxxxxxxxxxxxxxxxx
>     <mailto:maria-discuss@xxxxxxxxxxxxxxxxxxx>
>     Unsubscribe : https://launchpad.net/~maria-discuss
>     More help   : https://help.launchpad.net/ListHelp