zeldor.biz

Linux, programming and more

Copyright © 2023
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 »