Category: MySQL

I encountered an issue in MySQL where a subquery on a field with an index was taking an extensive amount of time because the index was not being utilized. It turned out that the collation of the fields being compared was different.

Here is a summary of the blog article in English: "When issuing raw SQL in Django, an error '2027 Malformed packet' may occur with certain SQL statements. A helpful solution is to avoid using double quotations."

When querying MySQL (5.7) with Django, the process started to stop due to the error (2013, 'Lost connection to MySQL server during query'). First, check the innodb_strict_mode setting in the current connection. Use the command SHOW VARIABLES LIKE '%innodb_strict_mode%'; It needs to be set to ON.

When trying to connect MySQL Client 8.0 to MySQL 5.6, DataGrip displays an error message: "[08S01] Communications link failure java.io.EOFException: SSL peer shut down incorrectly," and the connection fails.

If you encounter the django.db.utils.InterfaceError: "(0, '')" error When this error occurs intermittently during get operations depending on the table or record, it might be due to a mismatch in the connection character encoding.

If a Django project that has been working until now fails to start after a long time with the following error: ``` version_info, _mysql.version_info, _mysql.__file__ NameError: name '_mysql' is not defined ```

While managing the root user with the mysql_user module in Ansible, I found that I was no longer able to grant privileges to other users.

Something is wrong with AWS RDS MySQL replication

This isn't a completely quantitative discussion, but...

Background I'm creating a full-text index with bigrams in InnoDB on MySQL 5.6. However, when I tried to search for the term "TWIN,"