Home

Database

Compute size of Mysql database with it's tables

Posted February 5th, 2008 by administrator
in
Basically a database is a collection of tables.
So the size of the database is sum total of size of its individual tables.
Size of the table = Size of its Data + Size of its Indexes.
Size of database = Sum of {Individual Table Size}
The following snippet uses that above logic to compute the overall size of the database by computing the size of its individual tables.

How to list all the sequence in schema with size?

Posted February 1st, 2008 by administrator
in

All the oracle sequences are stored in a table called "dba_sequences".

The following query selects the min, max ,current value along with the length current value and orders it by the length in desc.

select SEQUENCE_NAME,MIN_VALUE,MAX_value,LAST_NUMBER,length(LAST_NUMBER)

from dba_sequences

How to do view all the triggers in a schema?

Posted January 31st, 2008 by administrator
in

Yes, you can view triggers using the INFORMATION_SCHEMA.TRIGGERS table. The following sql list all the triggers in a given schema.

select

SEQUENCE_NAME,MIN_VALUE,MAX_value,LAST_NUMBER,length(LAST_NUMBER)

from dba_sequences

where SEQUENCE_OWNER='schema owner'

order by length(LAST_NUMBER) desc

How to view all Stored Procedures in a schema?

Posted January 31st, 2008 by administrator
in

The following sql list the name of all the routines in a given database.

SELECT ROUTINE_NAME

FROM INFORMATION_SCHEMA.ROUTINES

WHERE ROUTINE_TYPE="PROCEDURE" AND ROUTINE_SCHEMA="dbname";

How to convert ISAM table to MYISAM?

Posted January 31st, 2008 by administrator
in

The table types have changed from ISAM to MYISAM from Mysql version 4.x to 5.x.

In order to convert a table from ISAM to MyISAM, simply issue a statement like

ALTER TABLE tblname ENGINE=MYISAM.

How do I import a MySQL dumpfile into my database?

Posted January 1st, 2008 by administrator
in

Data can be dumped into the database using the following command. mysql -p -h DBSERVER dbname < dbname.sql

 

Syndicate content

Back to top