Hi, Are you using MyISAM or InnoDB? What are the values of table_open_cache, table_definition_cache and innodb_open_files?
--justin On Tue, Apr 21, 2015 at 6:26 AM, Honza Horak <hho...@redhat.com> 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@lists.launchpad.net > Unsubscribe : https://launchpad.net/~maria-discuss > More help : https://help.launchpad.net/ListHelp >
_______________________________________________ Mailing list: https://launchpad.net/~maria-discuss Post to : maria-discuss@lists.launchpad.net Unsubscribe : https://launchpad.net/~maria-discuss More help : https://help.launchpad.net/ListHelp
