zeldor.biz

Linux, programming and more

Copyright © 2025
Log in

MySQL – Database size

June 6, 2010 by Igor Drobot Leave a Comment

As I know, there are two ways to calculate the MySQL database size:

First one:

1
du -shc /var/lib/mysql/*

du -shc /var/lib/mysql/*

Second one:

1
SELECT table_schema ,SUM( data_length + index_length) / 1024 / 1024 "Data Base Size in MB" FROM information_schema.TABLES GROUP BY table_schema;

SELECT table_schema ,sum( data_length + index_length) / 1024 / 1024 "Data Base Size in MB" FROM information_schema.TABLES GROUP BY table_schema;

Filed Under: Bash, Linux, MySQL Tagged With: MySQL

Xen cheat sheet

June 6, 2010 by Igor Drobot Leave a Comment

Show uptime: xm uptime
Realtime monitoring: xm top
List domains: xm list
Host info: xm info
Show processor info: xm vcpu-list
Show network interfaces: xm network-list
Show node information: virsh nodeinfo
Show domain V-processor info: virsh vcpuinfo
Show xend log: xm log
domain information: virsh dominfo
Create node: xm create /etc/xen/node.cfg

Filed Under: Linux Tagged With: cheat sheet, Xen

Funny HOST names

June 6, 2010 by Igor Drobot Leave a Comment

asterisk
nibbler
barney
crusty
hades
helios
hera
kronos
maggie
rhea
urania

Filed Under: Fun, Linux Tagged With: Fun

Random Futurama Quote From Shell

June 6, 2010 by Igor Drobot Leave a Comment

Random Futurama from the shell :)

Random Futurama Quotes to fill the day. I just found this awesome site: http://commandlinefu.com. There are a lot of great ideas on this site, I recommend you take a few minutes and check it out. Major props to icco of commandlinefu.com:

Just issue the following command:

1
curl -Is slashdot.org | egrep '^X-(F|B|L)' | cut -d \- -f 2

curl -Is slashdot.org | egrep '^X-(F|B|L)' | cut -d \- -f 2

Here’s the example outputs:
Fry: Can I pull up my pants now?
Leela: My old life wasn’t as glamorous as my webpage made it look.
Bender: Ah crap, I’m some sort of robot!
Bender: Why would God think in binary?

Filed Under: Bash, Fun, Linux Tagged With: bash, Futurama

Rsync with progress bar

June 6, 2010 by Igor Drobot Leave a Comment

1
rsync -azv --progress /opt/Samba/* root@server:

rsync -azv --progress /opt/Samba/* root@server:

9142272 2% 2.86MB/s 0:01:48

Filed Under: Linux Tagged With: Linux, rsync

  • « Previous Page
  • 1
  • …
  • 71
  • 72
  • 73
  • 74
  • Next Page »
Yeaaah Cookie! We use cookies to ensure that we give you the best experience on our website. If you continue to use this site we will assume that you are happy with it.Ok