Blog

Everything about Databases with dbsnoop

Category: Artigo

List Tables in Any Database

Oracle To list all tables: SELECT tablespace_name, table_name, owner FROM dba_tables; To list all tables for the current user: SELECT tablespace_name, table_name, owner FROM user_tables; To list all tables the user has access to (whether the user is the owner or not):

Read more >>

What is Replication?

While some database servers, like MySQL, support replication natively, others require third-party software. Data from one MySQL database server (the source) can be replicated to one or

Read more >>

DBA: what is it?

It safeguards data by limiting access to just those who have been given permission, guaranteeing the protection of sensitive data. Additionally, DBA is in charge of the entire system, regularly performing backups, and defending the bank from harmful attacks.

Read more >>

What are literals in MySQL?

Literals: SET var_Name = ‘ALEXANDRE’ In the example above we’ve assigned the literal ALEXANDRE to the var_Name variable. We can say that the content (or meaning) of var_Name is ALEXANDRE.

Read more >>

Installing innotop to monitor innodb

Reading these tables can be a thankless and innocuous task for those who don’t have much experience with MySQL. Even worse would be trying to use the show engine InnoDB status. I confess that in the early years of MySQL the result of this command, to me, looked a lot like the alien signal hidden in

Read more >>

MySQL on Amazon AWS: RDS or EC2?

Alphabet Soup: AWS is Amazon Web Services. By the way, I think the web is no more, as Amazon services have reached much higher levels. RDS is an acronym for Relational Database Services, and EC2 Elastic Compute Cloud.

Read more >>
en_US