how to connect to shared web hosting MySQL / MariaDB
First connect to your hosting server with SFTP / SSH account user name and password, then run the command: mysql -u databasename -h databaseHosting -p databasename...
My Work Diary
First connect to your hosting server with SFTP / SSH account user name and password, then run the command: mysql -u databasename -h databaseHosting -p databasename...
Open a CMD as Administrator. started off in c:\Windows\system32. cd config\systemprofile\AppData\Local mkdir TileDataLayer cd TileDataLayer mkdir Database
in my case, the mariadb / mysql is 32bit, as you knew 32bit only support about 3GB RAM, so instead of allocated 4GB,I changed it to...
The best bet: Turn off query cache: find my.ini in windows, or my.conf in linux add line in mysqld [mysqld] … query_cache_type=0 query_cache_size=0 0 is off...
https://officecdn.microsoft.com/db/492350f6-3a01-4f97-b9c0-c7c6ddf67d60/media/en-us/ProPlus2021Retail.img
innodb_flush_log_at_trx_commit to 2 can improve the performance of MySQL and solve the problem of excessive handle usage.