Category Archives: Linux

Linux stuff

How to get size of Mysql tables

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… Continue reading →

Tags: , , ,

Configure Juniper VPN connection on Fedora 15

Recently I spent a few hours to configure VPN connection using Juniper on my Fedora 15 laptop. Actually there is nothing difficult. But I’d like to mention to one nuance. Looks like Juniper doesn’t work with openJDK Firefox plugin. It needs Sun/Oracle only! Otherwise VPN connection will be terminated immediately after start without any errors… Continue reading →

Tags: , , ,

Installation of Oracle client to Ubuntu 10.04 Lucid

Recently I moved from Fedora 13 to Ubuntu 10.04 on my work laptop. So, I faced again with problem to setup Oracle PHP interface. Oracle provides RPMs only and not DEBs. So, to install the client RPMs should be converted to the DEBs. It can be done easily using utility alien: sudo alien oracle-instantclient11.1-basic-11.1.0.7.0-1.i386.rpm sudo… Continue reading →

Tags: , , ,

How to rebuild Ubuntu package from the sources

There are two ways (at least) to rebuild Ubuntu package from the source. Using Ubuntu diff file and dpkg-buildpackage Download source from Ubuntu repository. Download Ubuntu diff file and apply it: patch -p1 < ubuntu.diff Build package: dpkg-buildpackage -rfakeroot Using .dsc file and debuild Download .dsc file Run following command: dpkg-source -x file.dsc Note, sometimes… Continue reading →

Tags: , , ,

1 2 3 4 5 8 9
Get Adobe Flash player