Hello Ludovic, Any update on this please? Thanks, - Arun
On Tue, Nov 23, 2021 at 7:19 PM Arun Kangle <akan...@gmail.com> wrote: > >>>select count(1) from node; > > MariaDB [(none)]> use pf > Reading table information for completion of table and column names > You can turn off this feature to get a quicker startup with -A > > Database changed > MariaDB [pf]> select count(1) from node; > +----------+ > | count(1) | > +----------+ > | 69 | > +----------+ > 1 row in set (0.000 sec) > > MariaDB [pf]> > > I am running it as a VM with 4 vCPU 16Gig RAM and 110GB Disk > > Thanks, > - Arun > > On Tue, Nov 23, 2021 at 6:55 PM Zammit, Ludovic <luza...@akamai.com> > wrote: > >> Hello Arun, >> >> You can connect to the database and run that command: >> >> select count(1) from node; >> >> What are the specs on your servers? CPU, RAM and disk. >> >> Thanks, >> >> *Ludovic Zammit* >> *Product Support Engineer Principal* >> *Cell:* +1.613.670.8432 >> Akamai Technologies - Inverse >> 145 Broadway >> Cambridge, MA 02142 >> Connect with Us: <https://community.akamai.com> <http://blogs.akamai.com> >> <https://twitter.com/akamai> <http://www.facebook.com/AkamaiTechnologies> >> <http://www.linkedin.com/company/akamai-technologies> >> <http://www.youtube.com/user/akamaitechnologies?feature=results_main> >> >> On Nov 23, 2021, at 4:55 AM, Arun Kangle <akan...@gmail.com> wrote: >> >> Hi Ludovic, >> PFA screenshot. It took around 32 Seconds to search that user. >> >> For total count, I am getting below error: >> >> root@aolicnac:~# /usr/local/pf/bin/pfcmd node count all >> Use of uninitialized value in join or string at >> /usr/local/pf/lib_perl/lib/perl5/SQL/Abstract/Classic.pm line 1386. >> nb >> >> On Mon, Nov 22, 2021 at 11:53 PM Zammit, Ludovic <luza...@akamai.com> >> wrote: >> >>> Hello Arun, >>> >>> How many device you have in the database ? >>> >>> Can you take a screenshot of your node search ? >>> >>> Thanks, >>> >>> *Ludovic Zammit* >>> *Product Support Engineer Principal* >>> *Cell:* +1.613.670.8432 >>> Akamai Technologies - Inverse >>> 145 Broadway >>> Cambridge, MA 02142 >>> Connect with Us: <https://community.akamai.com/> >>> <http://blogs.akamai.com/> >>> <https://urldefense.com/v3/__https://twitter.com/akamai__;!!GjvTz_vk!Ezf_4HdrM807WGVSjF3YNUUn3uX7CTB9fkXPhJ5qiY1cNr0A0Hmv3UfK2klThA$> >>> <https://urldefense.com/v3/__http://www.facebook.com/AkamaiTechnologies__;!!GjvTz_vk!Ezf_4HdrM807WGVSjF3YNUUn3uX7CTB9fkXPhJ5qiY1cNr0A0Hmv3Uf1yplVhg$> >>> <https://urldefense.com/v3/__http://www.linkedin.com/company/akamai-technologies__;!!GjvTz_vk!Ezf_4HdrM807WGVSjF3YNUUn3uX7CTB9fkXPhJ5qiY1cNr0A0Hmv3UfyTDbOew$> >>> <https://urldefense.com/v3/__http://www.youtube.com/user/akamaitechnologies?feature=results_main__;!!GjvTz_vk!Ezf_4HdrM807WGVSjF3YNUUn3uX7CTB9fkXPhJ5qiY1cNr0A0Hmv3Uf4YbWArw$> >>> >>> On Nov 19, 2021, at 1:23 AM, Arun Kangle via PacketFence-users < >>> packetfence-users@lists.sourceforge.net> wrote: >>> >>> Hello All, >>> I recently upgraded to 11.0.0 (now to 11.1.0) from 10.3.0. Upgrade went >>> fine and everything else works fine but Node search has become very slow. >>> The first page (row length set to 10) itself takes very long and then >>> equal long time to make any other search. >>> >>> Search is faster from CLI using the pfcmd command. >>> >>> Has anyone else faced this problem? If yes, any pointers on how to make >>> it fast? >>> >>> root@aolicnac:/usr/local/pf/bin# cat /etc/debian_version >>> 11.1 >>> root@aolicnac:/usr/local/pf/bin# ./pfcmd version >>> PacketFence 11.1.0 >>> >>> Thanks in advance, >>> - Arun >>> _______________________________________________ >>> PacketFence-users mailing list >>> PacketFence-users@lists.sourceforge.net >>> >>> https://urldefense.com/v3/__https://lists.sourceforge.net/lists/listinfo/packetfence-users__;!!GjvTz_vk!CwoHzpvXlN9fV0uLrnxNT2yE9mFbVtRkEY47w_s_Jy7S2d8MsvI9Rd3HVEmQPA4Z$ >>> >>> >>> <Screenshot 2021-11-23 at 3.20.39 PM.png> >> >> >>
_______________________________________________ PacketFence-users mailing list PacketFence-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/packetfence-users