How to enable the slow query log – Mysql in Linux
Introduction: MySQL’s slow query log makes it easy to track SQL queries that take more than a specific time for execution. This allows you to find inefficient SQL […]
Cloud & AWS
2 min read
mysql
Web & Architecture
3 min read
How to install osTicket on ubuntu 20.04
Introduction: osTicket is a free and open source ticketing system for Linux. It is written in PHP and uses MySQL/MariaDB as a database backend. It also supports MySQL
Web & Architecture
2 min read
How to reset the WordPress password in Mysql
Sometimes, a WordPress user, with one of the following capabilities, such as administrator, editor, author, contributor, or subscriber, forgets its login credentials, especially the password. WordPress passwords can
Web & Architecture
1 min read
MySQL – How to temporarily disable a foreign key constraint
To disable foreign key constraints when you want to truncate a table: Use FOREIGN_KEY_CHECKS and remember to enable it when you’re done:
Cloud & AWS
2 min read
MySQL replication status alerts with bash script
MySQL replication should work without problems even if the servers are restarted, databases created and removed, data flowing in and out. Sometimes, however, there are errors that are
Web & Architecture
1 min read
Host host_name is blocked
If the mysqld server receives too many connection requests from the host that is interrupted in the middle, the following error occurs: The max_connect_errors system variable determines the