In the previous post I wrote about a way to get a Mysql database size from Mysql shell. Now I’d like to share a way to get size of each Mysql table: SELECT table_name,`engine` ,ROUND(data_length/1024/1024/1024,2) total_size_gb, ROUND(index_length/1024/1024/1024,2) total_index_size_gb, table_rows FROM information_schema.TABLES WHERE table_schema = ‘rt3′; It’s useful if you need to know what you should clean in your huge database. [via Techie-Gyan]
Connect to Oracle DB from Perl script
After successful installation of DBD::Oracle it’s time to use it. The connection string is the same as for he rest DB: my $dbi = DBI->connect(“dbi:Oracle:$db_name:$db_host:$db_port”, $db_user, $db_pass); As result of running code above I got following error: Couldn’t connect to database db_name: ORA-12154: TNS:could not resolve the connect identifier specified (DBD ERROR: OCIServerAttach) After googling I found that the problem was that. I tried to […]
Installing DBD::Oracle under Fedora 11
Recently I got a task which needs to communicate with database Oracle from Perl. Perl has an excellent database abstraction interface DBI. But for specific database it needs a driver – DBD module. To install DBD::Oracle you have to perform following simple steps: Download and install oracle-instantclient11.2-basic and oracle-instantclient11.2-devel RPMs from Instant Client Downloads for Linux x86 page. Export ORACLE_HOME: export ORACLE_HOME=/usr/lib/oracle/11.2/client/ Install DBD::Oracle using […]