Test Tag Extra3
Extra Info zu Mysql: ist ein DB System
Extra Info zu Mysql: ist ein DB System
Problem (Drupal Status Report) "/admin/reports/status":
Transaction isolation level
REPEATABLE-READ
The recommended level for Drupal is "READ COMMITTED".
See the setting MySQL transaction isolation level page for more information.
Solution (in sites/default/settings.php):
Give DB User File permission:
mysqldump --user=MyDBUser --password --tab=/tmp/my_export_dir MyDBName
In /etc/mysql/mariadb.conf.d/50-server.cnf
[mysqld]
#my custom changes
innodb_buffer_pool_size = 8G
query_cache_size=256M
drush sql-cli
drush sql:cli
select * from table1;
truncate table2;
Mysql Group Concat & Order By Rand()
while : ; do mysql -u MY_USERNAME --password='MY_PASSWORD' -e "show full processlist"; sleep 0.5; done
MYSQL neu starten:
service mysql restart || service mariadb restart || service mysqld restart
Mysql export kann sehr lange dauert, wenn man viele und große Datenbanken hat. Damit man schnell ein Backup von allen DBs erstellen kann:
mysqldump --opt --quick --all-databases > /root/backup/mysql/alldbs.sql
Wenn User login notwendig ist :
mysqldump -u root -p --opt --quick --all-databases > /root/backup/mysql/alldbs.sql
Neueste Kommentare
Remove files and show the number of deleted files
Remove all files starting with 2024 in mydir123 and show the number of deleted files:
find mydir123 -name '2024*' -exec rm -vf {} \; | wc -l
find . -name '*' | xargs rm …
find . -name '*' | xargs rm -v
Maybe Patch
https://www.drupal.org/project/tablefield/issues/3397688
/etc/my.cnf
Edit "/etc/my.cnf" ( under [mysqld] ):
transaction_isolation="READ-COMMITTED"
Restart MariaDB / MySQL:
Create Sub-Directories with WGET
wget -U 'Mozilla/MyUserAgent' -P MyTempDir123 --wait=0.2 --random-wait -nd -r -x -l 4 -e robots=off --reject
Ignore Binaries, JS, CSS etc
wget -U 'Mozilla/MyUserAgent2024' -P MyOutPutDirectory --wait=1 --random-wait -nd -r -l 2 -e robots=off --reject
Intel(R) Xeon(R) E-2288G CPU @ 3.70GHz
# sysbench --threads="$(nproc)" cpu run
AMD Ryzen 7 PRO 3700 8-Core Processor
# sysbench --threads="$(nproc)" cpu run
Reload .bashrc without logging out
Diese Lösung wird empfohlen aber hat bei mir nicht funktioniert.
Welche Alternative gibt es?
Composer + PHP 8.3
ln -snf /opt/plesk/php/8.3/bin/php /etc/alternatives/php