Indexes are used to quickly locate records with particular column values. Without an index, MySQL has to read through the entire table starting with 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.
MySQL Rollback Changes
All user activity in InnoDB takes place within a transaction. Each SQL query produces its own transaction when the auto-commit mode is enabled. Every time
Unknown system variable ‘query_cache_size’
You should be aware that the message while using MySQL RDS instance “Unknown system variable ‘query_cache_size‘” is not a result of an error but rather
AWS RDS – Tablespaces
The actual data that underlies database objects can be stored in a tablespace. It serves to allot storage for all DBMS-managed segments and offers a
AWS RDS – innodb_file_per_table
You might think about switching the tablespaces from individual to shared if you receive a notification in your AWS RDS stating that “DB Instance instance-name
ProxySQL – MySQL_User Values
ProxySQL is a powerful software load balancer and an open-source database protocol-aware proxy for MySQL that provides high performance, high availability, and high availability. Typically,
Big Data & SQL 