This post covers the basic information of files that MySQL Server uses / creates for various tasks. Update: Various files in MySQL 8.0 Refer following updated article for latest information…
The post MySQL related file types and basic information first appeared on Change Is Inevitable.
Have you ever come across a situation called NO MORE SPOOL SPACE? My friend does and hence I studied a bit about Teradata. The query: SELECT DISTINCT fieldname FROM tablename; The error: “NO MORE SPOOL SPACE”. Correct, the problem wasn’t related to MySQL, that was for something called Teradata. Initially, I could see that query should be […]
QA-Testing Definitions-Interview Questions: II (F – S): Data Dictionary: A database that contains definitions of all data items defined during analysis. Data Flow Diagram: A modeling notation that represents a functional decomposition of a system. Data Driven Testing: Testing in which the action of a test case is parameterized by externally defined data values, maintained […]
Are you tired of manually renaming MySQL tables, one by one, especially when dealing with a large number of them? In this guide, we’ll introduce you to a MySQL stored…
The post How to bulk rename table MySQL first appeared on Change Is Inevitable.
Yesterday a friend came across an oracle query problem: Consider below table: cid cname.... cdata 1 x xxxx 1 x xxxx .. 2 xzzz fjnd 3 a evddd Now the…
The post Oracle query-eliminate duplicate but one using rowid first appeared on Change Is Inevitable.
And I looked back and thought of updating this post… Recently Monty has posted again and I completely convinced with whatever Monty has conveyed now or earlier. The explainations he has provided under self-interview,…
The post Petition – Help saving MySQL – II first appeared on Change Is Inevitable.
I’m having RHEL 5 (32-bit) and MySQL-5. I was trying to check how much is the Memory Utilization limits for MySQL 5 on 32bit OS. We can easily calculate the…
The post MySQL Memory Usage Limits on 32 bit Linux first appeared on Change Is Inevitable.
Recently MySQL has offered MySQL Certification Free Retake on both DBA or Developer Certifications for a limited time. For MySQL Certifications: 1. MySQL 5.0 Data Base Administrator Certification (SCMDBA) –…
The post MySQL Certification Free Retake: Get TWO chances to get MySQL Certified first appeared on Change Is Inevitable.
And I looked back and thought of updating this post… We all are aware about the acquisition happened to MySQL; Sun and now Oracle. A common understanding tells me that…
The post Monty: Help Saving MySQL – The Oracle & EC first appeared on Change Is Inevitable.
This procedure lists available database objects under passed database name. It lists present Tables, Views, Stored Procedures, Functions and Triggers under particular database. It also lists storage engine of tables.…
The post Stored procedure to Find database objects first appeared on Change Is Inevitable.