Recent content by AdrianC

The slow "ip to hostname" command was probably it, I set a shorter timeout to that and I didn't have problems afterwards, e.g not reaching "max children" anymore. But yes, adding these ip commands to a database and run it in background seems like a better practice. For now I need the results...

Agh ... so I DO have a problem :confused: Uptime 345860 SHOW STATUS LIKE 'created_%'; Created_tmp_disk_tables 0 Created_tmp_files 5 Created_tmp_tables 8 SHOW GLOBAL STATUS LIKE 'created_%'; Created_tmp_disk_tables 849552 <<<<<<<<<<<<<<< :/ Created_tmp_files 5 Created_tmp_tables 1378882

Also, where is the log file that should say something like php-fpm reached pm.max_children ? That should be important. Edit: found it. cat /var/log/plesk-php82-fpm/error.log [28-Jul-2024 05:56:18] WARNING: [pool example3.com] child 3159868 said into stderr: "Timeout." [28-Jul-2024 06:03:00]...

Hello. I need help debugging this... Using: Plesk 18.0.62, PHP 8.2.21 Running as FPM My site has some millions of pages and gets hit by many bots, the database is over 100 GB and some queries are slow, so I think that is enough for some pages to respond slow and use all apache slots. But the...

I did restart the server multiple times while testing variables, the many "Created tmp disk tables" always started from zero when restarting and increased from there. But at this point I think it is a PhpMyAdmin bug. I tried mysqltuner some years ago, I will give it another try becuase I know a...

I tried all the above variables... - It made no difference in the amount of "Created tmp disk tables". - I counted them over time, it increases around 110 to 200 per minute, - The "Created tmp files" remains 5. - This happens while I stopped all my scripts that write to database. - I also tried...

Thanks Bitpalast. I currently have these below values (some are close). I will need to test the recommended values in a few days and I will post a reply. innodb_buffer_pool_size = 90G innodb_flush_method=fsync table_open_cache = 2000 innodb_log_file_size = 50M query_cache_size = 1M

I am trying to optimize my ~large dbs (around 150 GB MySQL) to write less to SSD and more to memory, and I am comparing the variables on a Alma Linux 8.10 with Plesk 18.0.38 with MariaDB 10.3.28 vs a Rocky Linux machine with MySQL 8.x without any panel. On Plesk the MySQL status variables...

I had this error today, it was because in /etc/my.cnf I was adding the config variables before "[mysqld]" area of that config file. My variables should be after [mysqld]

Hello. Can someone clarify this or has more info about this ? ... I was wondering if Plesk uses MPM ITK in order to run each vhost as a different user (user : psacln) And does it have additional customization in order to properly make mod_pagespeed cache files under /var/cache/mod_pagespeed ...

To simplify, I created a hello world file in /adr/alias/index.php and set this in a conf.d include file: Alias /adr /adr/alias <Directory "/adr/alias"> <RequireAny> Require all granted </RequireAny> </Directory> I also tried setting folder and file owner same as my...

I tried to install Zabbix statistics on my Plesk (17.8.11), it creates an alias just like phpmyadmin does, but whenever I access the path (/zabbix) it opens a download prompt instead of processing the php code, I am not sure where to edit in order to make it process the php code. My PHP info...

Even if it uses the correct HELO when sending, doesn't it mean it is a flaw if it cannot do that for incoming connections ? If I have 2 dedicated IPss, I cannot seem to make it reply properly with different hosts in HELO message.

I didn’t think any other details are needed, using latest plesk on CentOS if it matters. I still think it should work ... The two are on separate pppoe (different public ip) but on same router and they can “see” each other on local IP 192.168.1.X Edit: At this point I think is a...

I used to have a public static ip that was received when server directly made a PPPoE connection to my ISP... Now I switched to router being the one doing the pppoe connection and server now has a LOCAL ip, In Plesk under this local ip (e.g 192.168.1.88), I filled the public ip field too. I...