Search results

Is anyone familiar with this issue: ... [ 87%] Built target auth_gssapi Scanning dependencies of target auth_pam [ 87%] Building C object plugin/auth_pam/CMakeFiles/auth_pam.dir/auth_pam.c.o cc: warning: -Wl,-z,relro,-z,now: 'linker' input unused [-Wunused-command-line-argument] [ 87%] Linking...

+1 for a plugin, not built-in by default.

All that I can say is simply... AWESOME JOB! Thank you! Now it's a peace of cake to apply custom patches when needed. Regarding "update_full" - we may need some additional info regarding what exactly it does. For example in FreeBSD - is it calling freebsd-update and/or updating all ports?

Reading some forums suggest looking if this file /etc/systemd/system/mariadb.service.d/limits.conf exists...

404 on desktop here.

It was the same with me back in the time when I used SuPHP.

There is nothing to "fix". PHP 7.4 do not have Pecl/Pear by default. You can install them manually.

With Apache this can be done easily with .htaccess file or custom httpd configuration as described here: https://forum.directadmin.com/threads/how-to-change-php-version-only-for-subdomain.53107/#post-272593

CURRENT_TIMESTAMP is synonym of NOW() Since MySQL 5.6.5 DEFAULT NOW() should be accepted. There are however evidences that it is not the case - for example if you look at the bottom of https://bugs.mysql.com/bug.php?id=27645, you'll see that a person complained on 29 Dec 2017 that "It is still...

try this: `creation_date` datetime(0) DEFAULT CURRENT_TIMESTAMP(0), `modif_date` datetime(0) DEFAULT CURRENT_TIMESTAMP(0) ON UPDATE CURRENT_TIMESTAMP(0), This "0" is the microsecond precision (can be from 0 to 6). Alternatively do not use datetime datatype but timestamp. It will work with it.

Just to note here that it is no longer the case on FreeBSD 11.3. If I do not have the ./custom/ap2/configure.apache file with "--enable-http2" \ "--enable-ssl-staticlib-deps" \ "--with-ssl=/usr/local/lib_http2" \, then it does NOT enable HTTP2.

You can test here: https://http2.pro/

Do as da_admin user: - SHOW STATUS LIKE 'Qcache%'; - SHOW VARIABLES LIKE 'query%'; Than calculate: 1. Cache fill (how much RAM you use and how much you reserved for the cache - you want that close to 100%): ((query_cache_size – Qcache_free_memory) / query_cache_size )*100 2. Cache hits (how...

First find the bottleneck. There are many services that run on the system. Yes, SQL is usually the suspect for high load but... not always the case. Let me show you and example of what happens on my setup (with SSD disk). If I look at the processes, MariaDB is always at the highest usage of CPU...

You should definitely mount it. Personally I am doing something else - I copy the data to a new place, then delete the original and replace it's directory with a symlink using ln -s

disable_functions directive is controlled by php.ini

One more thing to note: 1. If you have many reads and less writes, Query Cache is better; 2. If you have many writes, Memcache/Redis is better; 3. DO NOT USE BOTH.

Having more cache means you have more CPU time to maintain it. If you have many cache misses, it means that your server not only: 1. Looks into cache and finds nothing (wastes CPU time); 2. Do a regular SQL query; but also 3. Stores new entries in the cache, drops old, defrags (when out of...

What do you mean by "lock down" and "opening" in regards for PHP configurations? It is possible to have per-user php.ini settings. Check here: https://help.directadmin.com/item.php?id=672

Just a quick note that sometimes overcaching makes things worse than no cache at all (in case the cache misses are too much).