Use the mysql_rds_kill_query procedure with the query’s ID to terminate any queries that are currently being processed by the MySQL server. You can query the
Author: SHAFI SHAIK
Hi, this is Shafi Shaik, Microsoft Solutions Specialist in Data platform as well as in Data Management & Analytics. I am a certified associate in Oracle SQL*Plus and extensively trained in MongoDB Administration. My current role is Database administration with hands-on expertise in almost all relational databases namely Microsoft SQL Server, MySQL, Oracle SQL*Plus, PostGreSQL & Teradata. I'm also specialized in database development, warehousing, traditional data analysis and Big Data analysis.
ERROR 1095 (HY000): You are not owner of thread
The following error occurs when using RDS MySQL when you attempt to kill a user session. MySQL> KILL 46552; > ERROR 1095 (HY000): You are
1227 – Access denied; you need SUPER or SYSTEM_VARIABLES_ADMIN
The following error occurs frequently when using RDS MySQL, especially when you attempt to modify global parameter settings. > 1227 – Access denied; you need
CREATE TABLE IF EXISTS in MySQL
In MySQL, it’s always advantageous to use the keyword IF NOT EXISTS when creating database objects like databases, tables, views, functions, and procedures. In this
You have new mail in /var/spool/mail/root
The notification “You have a new mail in /var/spool/mail/root” may occasionally appear in your EC2/Linux system after you execute a command. OR you could be
Is Flush Hosts deprecated?
Yes, as per MySQL documentation, using the command FLUSH HOSTS is deprecated. When FLUSH HOSTS is used, MySQL will clear the host cache, which effectively
Big Data & SQL 