I didn't really succeed with firebird 2.1. Changing the version to firebird 2.5 SuperClassic got the expected results and much more. Now my server is Ubuntu 16.06. Everything working perfectly. Thank you all.
Em qua, 15 de abr de 2020 12:14, marius adrian popa <map...@gmail.com> escreveu: > Yes it is possible to increase > > LockSemCount > > > https://pmakowski.ibphoenix.fr/from-the-firebird-support-list-semaphores-exhausted.html > > > http://paulbeachsblog.blogspot.com/2009/06/some-positive-feedback-for-firebird.html > > > I recommend Firebird 2.5/3.0 with SuperClassic > https://firebirdsql.org/en/firebird-2-5/ > https://firebirdsql.org/en/firebird-3-0/ > > > Also you might check optimized configurations file options > https://firebirdsql.org/en/news/optimized-firebird-configuration-files-2nd-edition/ > > > > On Tue, Apr 14, 2020 at 7:57 PM Willian do Amor <willsa...@gmail.com> > wrote: > >> OK thank you. @Alex >> >> Em ter., 14 de abr. de 2020 às 11:46, Alex Peshkoff via Firebird-devel < >> firebird-devel@lists.sourceforge.net> escreveu: >> >>> On 2020-04-14 16:45, Willian do Amor wrote: >>> > I have the dedicated database server running inside Hyper-V. This VM >>> > is running Ubuntu 18.04, with 32 GB of RAM, 8 virtual processor cores >>> > and 1 TB HD. >>> > >>> > The Firebird that runs on that server is Classic Server 2.1. I have >>> > only 4 databases on that machine. The number of users reaches a >>> > maximum of 100 at its peak. >>> > >>> >>> Willian, version 2.1 (and moreover - 2.5 too) is not supported by >>> community any more. >>> >>> > It so happened that over the course of a few days, the systems started >>> > to slow down and connections dropped. The firebird log stated that >>> > there were no more Semaphores available. >>> > >>> > Searching on google I found that I should increase the number of >>> > Semaphores for firebird according to what is available in the Linux >>> > kernel. >>> > >>> > I performed several tests and research, on a certain page that I don't >>> > remember now, a user said he had set 1024 Semaphores for firebird and >>> > that he also increased the maximum number in the kernel. >>> > >>> > I tried to use 1024 in my firebird settings and it showed an error in >>> > the logs stating that the number was not available on my system and >>> > that it was to set the value 64. >>> > >>> > I found through oracle database documentation that oracle uses the >>> > following configuration for its database in the Rad Hat Linux kernel >>> > (it's an example configuration) >>> > >>> > sysctl -w kernel.sem = "5010 641280 5010 128" >>> > I made this configuration on my server and set the Semaphores from >>> > firebird to 128. I realized that I got a much better performance >>> already. >>> >>> You should upgrade to at least 2.5 and forget about SystemV semaphores. >>> But if you really need for some reason keep using 2.1 please search for >>> paid support. Some companies provide it >>> >>> >>> >>> >>> Firebird-Devel mailing list, web interface at >>> https://lists.sourceforge.net/lists/listinfo/firebird-devel >>> >> Firebird-Devel mailing list, web interface at >> https://lists.sourceforge.net/lists/listinfo/firebird-devel >> > Firebird-Devel mailing list, web interface at > https://lists.sourceforge.net/lists/listinfo/firebird-devel >
Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
