[Maria-developers] MariaDB 10.0.6 using more file descriptors than 5.5 ?
Hi, I've just migrated MariaDB (+tokudb) from 5.5.33a to 10.0.6, and I've encountered a '[ERROR] Error in accept: Too many open files' error during a backup. As this was not occuring with MariaDB 5.5, is this expected to have 10.0.6 using much more file descriptors ? (open_files_limit was set to about 8100 with 5.5, I raised it to 65535 now to fix this issue). Thanks, Jocelyn Fournier
TokuDB uses many file descriptors, it should work the same on 5.5 and 10.x but if you came from an InnoDB DB it could be an issue if you didnt raise the open_files_limit. Here is an explaination on how TokuDB uses filedescriptors : https://github.com/Tokutek/ft-engine/wiki/TokuDB-Files-and-File-Descriptors Regards. On 20/11/2013 15:19, Jocelyn Fournier wrote:
Hi,
I've just migrated MariaDB (+tokudb) from 5.5.33a to 10.0.6, and I've encountered a '[ERROR] Error in accept: Too many open files' error during a backup. As this was not occuring with MariaDB 5.5, is this expected to have 10.0.6 using much more file descriptors ? (open_files_limit was set to about 8100 with 5.5, I raised it to 65535 now to fix this issue).
Thanks, Jocelyn Fournier
_______________________________________________ Mailing list: https://launchpad.net/~maria-developers Post to : maria-developers@lists.launchpad.net Unsubscribe : https://launchpad.net/~maria-developers More help : https://help.launchpad.net/ListHelp
Hi, Actually on 5.5 I was also using TokuDB, I didn't convert my DB. And AFAIK 5.5 and 10.0.6 are using the same TokuDB version (7.0.4). Thanks, Jocelyn Le 20/11/2013 15:28, Jean Weisbuch a écrit :
TokuDB uses many file descriptors, it should work the same on 5.5 and 10.x but if you came from an InnoDB DB it could be an issue if you didnt raise the open_files_limit.
Here is an explaination on how TokuDB uses filedescriptors : https://github.com/Tokutek/ft-engine/wiki/TokuDB-Files-and-File-Descriptors
Regards.
On 20/11/2013 15:19, Jocelyn Fournier wrote:
Hi,
I've just migrated MariaDB (+tokudb) from 5.5.33a to 10.0.6, and I've encountered a '[ERROR] Error in accept: Too many open files' error during a backup. As this was not occuring with MariaDB 5.5, is this expected to have 10.0.6 using much more file descriptors ? (open_files_limit was set to about 8100 with 5.5, I raised it to 65535 now to fix this issue).
Thanks, Jocelyn Fournier
_______________________________________________ Mailing list: https://launchpad.net/~maria-developers Post to : maria-developers@lists.launchpad.net Unsubscribe : https://launchpad.net/~maria-developers More help : https://help.launchpad.net/ListHelp
_______________________________________________ Mailing list: https://launchpad.net/~maria-developers Post to : maria-developers@lists.launchpad.net Unsubscribe : https://launchpad.net/~maria-developers More help : https://help.launchpad.net/ListHelp
Hi, Jocelyn! On Nov 20, Jocelyn Fournier wrote:
I've just migrated MariaDB (+tokudb) from 5.5.33a to 10.0.6, and I've encountered a '[ERROR] Error in accept: Too many open files' error during a backup. As this was not occuring with MariaDB 5.5, is this expected to have 10.0.6 using much more file descriptors ? (open_files_limit was set to about 8100 with 5.5, I raised it to 65535 now to fix this issue).
I'm vaguely remember (but failed to find a corresponding Jira issue), that InnoDB's async i/o used quite a lot of file descriptors. Perhaps that, together with TokuDB, used up all your 8100 descriptors. Regards, Sergei
participants (3)
-
Jean Weisbuch
-
Jocelyn Fournier
-
Sergei Golubchik