Load time achievement

Re: Load time achievement

Reply #15 – August 03, 2026, 10:19:48 am

Yes the 2.0 error log, that tail -f /var/www/clients/clientXX/webYY/log/error.log you posted needed a few more lines above where it started, maybe tail -n 20 so we can see just what PHP complained about.

Re: Load time achievement

Reply #16 – August 03, 2026, 10:37:08 am

Code: [Copy]

[code]2026/08/03 22:32:18 [error] 1944#1944: *18202 FastCGI sent in stderr: "PHP message: PHP Warning:  mysqli::real_connect(): (HY000/2002): No such file or directory in /web/sources/ElkArte/Database/Mysqli/Connection.php on line 43; PHP message: PHP Fatal error:  Uncaught Error: mysqli object is not fully initialized in /web/sources/ElkArte/Database/Mysqli/Query.php:165
Stack trace:
#0 /web/sources/ElkArte/Database/Mysqli/Query.php(165): mysqli_query()
#1 /web/sources/ElkArte/Database/AbstractQuery.php(539): ElkArte\Database\Mysqli\Query->executeQuery()
#2 /web/sources/ElkArte/Database/Mysqli/Connection.php(54): ElkArte\Database\AbstractQuery->query()
#3 /web/sources/database/Database.subs.php(73): ElkArte\Database\Mysqli\Connection::initiate()
#4 /web/sources/Load.php(1261): database()
#5 /web/bootstrap.php(358): loadDatabase()
#6 /web/bootstrap.php(90): Bootstrap->bringUp()
#7 /web/bootstrap.php(66): Bootstrap->bringUpBasics()
#8 /web/index.php(41): Bootstrap->__construct()
#9 {main}
  thrown in /web/sources/ElkArte/Database/Mysqli/Query.php on line 165" while reading response header from upstream, client: xxx.xxx.xxx.xxx, server: elkarte2.sch.my, request: "GET /index.php HTTP/2.0", upstream: "fastcgi://unix:/var/lib/php8.4-fpm/webYY.sock:", host: "elkarte2.sch.my", referrer: "https://elkarte2.sch.my/index.php?action=admin;area=logs;sa=errorlog;desc"
2026/08/03 22:32:21 [error] 1944#1944: *18202 FastCGI sent in stderr: "PHP message: PHP Warning:  mysqli::real_connect(): (HY000/2002): No such file or directory in /web/sources/ElkArte/Database/Mysqli/Connection.php on line 43; PHP message: PHP Fatal error:  Uncaught Error: mysqli object is not fully initialized in /web/sources/ElkArte/Database/Mysqli/Query.php:165
Stack trace:
#0 /web/sources/ElkArte/Database/Mysqli/Query.php(165): mysqli_query()
#1 /web/sources/ElkArte/Database/AbstractQuery.php(539): ElkArte\Database\Mysqli\Query->executeQuery()
#2 /web/sources/ElkArte/Database/Mysqli/Connection.php(54): ElkArte\Database\AbstractQuery->query()
#3 /web/sources/database/Database.subs.php(73): ElkArte\Database\Mysqli\Connection::initiate()
#4 /web/sources/Load.php(1261): database()
#5 /web/bootstrap.php(358): loadDatabase()
#6 /web/bootstrap.php(90): Bootstrap->bringUp()
#7 /web/bootstrap.php(66): Bootstrap->bringUpBasics()
#8 /web/index.php(41): Bootstrap->__construct()
#9 {main}
  thrown in /web/sources/ElkArte/Database/Mysqli/Query.php on line 165" while reading response header from upstream, client: xxx.xxx.xxx.xxx, server: elkarte2.sch.my, request: "GET /index.php?action=profile;area=forumprofile;u=1 HTTP/2.0", upstream: "fastcgi://unix:/var/lib/php8.4-fpm/webYY.sock:", host: "elkarte2.sch.my", referrer: "https://elkarte2.sch.my/index.php?action=profile;area=account;u=1"
2026/08/03 22:32:23 [error] 1944#1944: *18202 FastCGI sent in stderr: "PHP message: PHP Warning:  mysqli::real_connect(): (HY000/2002): No such file or directory in /web/sources/ElkArte/Database/Mysqli/Connection.php on line 43; PHP message: PHP Fatal error:  Uncaught Error: mysqli object is not fully initialized in /web/sources/ElkArte/Database/Mysqli/Query.php:165
Stack trace:
#0 /web/sources/ElkArte/Database/Mysqli/Query.php(165): mysqli_query()
#1 /web/sources/ElkArte/Database/AbstractQuery.php(539): ElkArte\Database\Mysqli\Query->executeQuery()
#2 /web/sources/ElkArte/Database/Mysqli/Connection.php(54): ElkArte\Database\AbstractQuery->query()
#3 /web/sources/database/Database.subs.php(73): ElkArte\Database\Mysqli\Connection::initiate()
#4 /web/sources/Load.php(1261): database()
#5 /web/bootstrap.php(358): loadDatabase()
#6 /web/bootstrap.php(90): Bootstrap->bringUp()
#7 /web/bootstrap.php(66): Bootstrap->bringUpBasics()
#8 /web/index.php(41): Bootstrap->__construct()
#9 {main}
  thrown in /web/sources/ElkArte/Database/Mysqli/Query.php on line 165" while reading response header from upstream, client: xxx.xxx.xxx.xxx, server: elkarte2.sch.my, request: "GET /index.php?action=mentions;sa=fetch;api=json;lastsentmention=0;lastsentpm=0 HTTP/2.0", upstream: "fastcgi://unix:/var/lib/php8.4-fpm/webYY.sock:", host: "elkarte2.sch.my", referrer: "https://elkarte2.sch.my/index.php?action=admin;area=permissions;sa=modify;group=0"
2026/08/03 22:32:25 [error] 1944#1944: *18202 FastCGI sent in stderr: "PHP message: PHP Warning:  mysqli::real_connect(): (HY000/2002): No such file or directory in /web/sources/ElkArte/Database/Mysqli/Connection.php on line 43; PHP message: PHP Fatal error:  Uncaught Error: mysqli object is not fully initialized in /web/sources/ElkArte/Database/Mysqli/Query.php:165
Stack trace:
#0 /web/sources/ElkArte/Database/Mysqli/Query.php(165): mysqli_query()
#1 /web/sources/ElkArte/Database/AbstractQuery.php(539): ElkArte\Database\Mysqli\Query->executeQuery()
#2 /web/sources/ElkArte/Database/Mysqli/Connection.php(54): ElkArte\Database\AbstractQuery->query()
#3 /web/sources/database/Database.subs.php(73): ElkArte\Database\Mysqli\Connection::initiate()
#4 /web/sources/Load.php(1261): database()
#5 /web/bootstrap.php(358): loadDatabase()
#6 /web/bootstrap.php(90): Bootstrap->bringUp()
#7 /web/bootstrap.php(66): Bootstrap->bringUpBasics()
#8 /web/index.php(41): Bootstrap->__construct()
#9 {main}
  thrown in /web/sources/ElkArte/Database/Mysqli/Query.php on line 165" while reading response header from upstream, client: xxx.xxx.xxx.xxx, server: elkarte2.sch.my, request: "GET /index.php HTTP/2.0", upstream: "fastcgi://unix:/var/lib/php8.4-fpm/webYY.sock:", host: "elkarte2.sch.my", referrer: "https://elkarte2.sch.my/index.php?action=admin;area=permissions;sa=modify;group=0"
2026/08/03 22:32:29 [error] 1944#1944: *18202 FastCGI sent in stderr: "PHP message: PHP Warning:  mysqli::real_connect(): (HY000/2002): No such file or directory in /web/sources/ElkArte/Database/Mysqli/Connection.php on line 43; PHP message: PHP Fatal error:  Uncaught Error: mysqli object is not fully initialized in /web/sources/ElkArte/Database/Mysqli/Query.php:165
Stack trace:
#0 /web/sources/ElkArte/Database/Mysqli/Query.php(165): mysqli_query()
#1 /web/sources/ElkArte/Database/AbstractQuery.php(539): ElkArte\Database\Mysqli\Query->executeQuery()
#2 /web/sources/ElkArte/Database/Mysqli/Connection.php(54): ElkArte\Database\AbstractQuery->query()
#3 /web/sources/database/Database.subs.php(73): ElkArte\Database\Mysqli\Connection::initiate()
#4 /web/sources/Load.php(1261): database()
#5 /web/bootstrap.php(358): loadDatabase()
#6 /web/bootstrap.php(90): Bootstrap->bringUp()
#7 /web/bootstrap.php(66): Bootstrap->bringUpBasics()
#8 /web/index.php(41): Bootstrap->__construct()
#9 {main}
  thrown in /web/sources/ElkArte/Database/Mysqli/Query.php on line 165" while reading response header from upstream, client: xxx.xxx.xxx.xxx, server: elkarte2.sch.my, request: "GET /index.php?action=admin;area=logs;sa=errorlog;desc HTTP/2.0", upstream: "fastcgi://unix:/var/lib/php8.4-fpm/webYY.sock:", host: "elkarte2.sch.my", referrer: "https://elkarte2.sch.my/index.php?action=admin;area=logs;sa=errorlog;desc"

The same just repeating if I changed to "localhost", nothing much other than that.
[/code]
The same just repeating if I changed to "localhost", nothing much other than that.

Re: Load time achievement

Reply #17 – August 03, 2026, 11:54:34 am

I have figure out what's forbidding me from using localhost, so that part is resolved now, I can use it just fine now. Old caches are all cleared. new have been built.

The queries delays are still the same though. It is still around 3 seconds ++ while 1.1 is around 0.02-0.03.

2.0 less queries but longer time.

1.1 more queries but lesser time.

Re: Load time achievement

Reply #18 – August 03, 2026, 12:18:54 pm

Did you check the hostname lookup setting (just want to be sure its a DB issue and not something else) is off?

The error message appears to be it was not finding the mysqld.sock socket, what setting did you have to change to fix the issue?

Re: Load time achievement

Reply #19 – August 03, 2026, 04:19:44 pm

It was a jail / chroot issue. Not jailing / chrooting it allows direct connection to localhost, so that issue alone was fixed.

However, there is no improvement whatsoever, so my guess about it was totally wrong. I got nothing to do with either 127.0.0.1 or localhost connection. Learning on how Elkarte 2.0 Beta 1 php is processing database may be is what I need to find out more.

By the way, converting either from or to 127.0.0.1 to or from localhost, need to be done in database as well as settings file, as the leftovers might render an Elkarte forum inaccessible do to the change of path whether just /web for chrooted site using 127.0.0.1 or /full/path/to/web in localhost setup.

It might be easier to setup a new site for testing, unless you want to have some fun too, which I did.

Re: Load time achievement

Reply #20 – August 05, 2026, 12:00:41 pm

I noticed you fix this in this in this forum since its queries are now improved than when it was launched before. Do share the adjustments you made @Spuds.