Kubernates Pods failing: Waiting for changelog lock....
Waiting for changelog lock…. This issue might happen when the some sql statements took a very long time for execution
Read More
TECHIES WORLD
For Techs.... Techniques.... Technologies....
Mysql
How to grant access to binlog for user in MySQL
Sometime it may require to to grant access to binlog for a user other that superuser in MySQL. We can
Read More
How to change the MySQL password policy level
MySQL used a plugin called validate_password which setup the password policy level. There are three password policy levels in MySQL
Read More
How to get the data count for all tables in a MySQL database
We can use the following query to get the data count for all tables in MySQL database. Where dbname need
Read More
How to get the full query from MySQL process list
MySQL process list can be viewed by the following query. But this will give the only the first 100 characters
Read More
MySQL restore Error: ERROR 2006 (HY000) at line 2968: MySQL server has gone away
ERROR 2006 (HY000) at line 2968: MySQL server has gone away This error usually happens while restoring large database dumps
Read More
How to terminate MySQL query
Sometimes it may required to kill long running queries from MySQL. In-order to do the same, login to the MySQL
Read More
How to delete procedure from MySQL
We can remove the stored procedure from MySQL using a simple query. Here name should replaced with the name of
Read More
PhpMyAdmin Error: Warning in ./libraries/sql.lib.php#601 count(): Parameter must be an array or an object that implements Countable
Warning in ./libraries/sql.lib.php#601count(): Parameter must be an array or an object that implements Countable This error occurs on using PhpMyAdmin
Read More
MySQL Dump Error: The user specified as a definerdoes not exist when using LOCK TABLES
The user specified as a definerdoes not exist when using LOCK TABLES This error happens on exporting the MySQL database
Read More
PHP: Warning: mysqli_connect(): (HY000/2002): No such file or directory
Warning: mysqli_connect(): (HY000/2002): No such file or directory This usually happens on customized LAMP installations. Here the php cannot find
Read More