How to get size of whole mysql-db?

SELECT Round(Sum(data_length + index_length) / 1024 / 1024, 1) „size“ FROM information_schema.tables GROUP BY „size“;

If you want to search words that are not spelled correctly you can use mysql’s buildin SOUNDEX function:



Veröffentlicht unter mysql.

Both of them, centralized and decentralized systems, have their unique strengths, advantages, and peculiarities. In this examination, I’ll dive into both concepts. It was an IT related issue that encouraged me to get in touch with this issue, but the concepts and thoughts can be applied to almost every area.
None of both is a better nor superior concept. It depends on the specific situation if centralization or decentralization is a better match. In reality, you will often find a combination of both of them. And sometimes an advantage can be a disadvantage as well, depending on the point of view.

Centralization can appear as decentralization. Imagine a system containing several redundant nodes (client-systems). If they are completely synchronized they seem like a centralized system. You can always wrap an imaginary container around a system, and handle it from outside as an atomic entity. No need to look into the system, as long as you can communicate from outside to it. Think about an enterprise. From a customer perspective, you’ll see one entity – like one centralized system. If you working inside that company, you possibly see yourself as one department, equal to other departments, supplementing the whole system.

Advantages of centralization:

  • easily maintainable
  • changes need’s to be done only in one place, the central-hub
  • no redundancy
  • client-systems dealing with the central-hub can easily be established
  • less complex than decentralized systems
  • Communication needs to be standardized

Advantages of decentralization:

  • Single client-system are dispensable
  • client-systems are more autonomous – can live for themselves
  • Direct communication between client-systems
  • No need for a standardized communication
  • more tolerant against attacks



A quite handy tool for monitoring tcp traffic is tcptrack. Get it with:

and start it with

the interface parameter -i eth0 must be according to your needs, you can check your interfaces with ifconfig.

There is also tcpdump, tcpflow and other nice tools


Sometimes one like to figure out what programs listen at a port. Here we can get an overview with:

Where t=tcp, u=udp, p=show program name, l=show listening ports, n= numeric (not resolve machine names)
The Output could look something like this:



With lsof you can determine easily which program listens on a port and under which user that program runs:


MTA stands for „mail transfer agent“. Popular ones are sendmail, exim and postfix.

If you want to know what MTA is running locally you can check which program listens on port 25:

You might also telnet on port 25 and let the MTA himself respond who he is:


For configuring exim4 the preferred way is to use the graphical interface, call it with:



Some usefull commands:

change your nick

List channels on current server

Join a channel named „channelname“

Leave a channel


Veröffentlicht unter bitchx.

Easiest way to check a connection for a MSSQL database:

Create a file called : myfile.udl

Paste the following content (make sure to use your settings):


Veröffentlicht unter mssql.

Do you want to know how often words occur in a pdf file? And sort them by the most occurring word:

Let’s break it down step by step:

displays the pdf content on the command-line


replaces all control characters (cntrl), all numbers (digits) and all punctuation characters (punct) with an empty string.
See here for character classes.

replaces all spaces with a newline


The last part sorts the output, groups unique lines and prefix them with the amount and finally sort them again
with ignored leading blanks (-b), sort numeric (-n), in reverse order (-r)

Veröffentlicht unter pdf.

Let’s have a look which packages are already installed and show only those with „php“ in the name. A fresh system usually shouldn’t give any results.

Next you can check what kind of modules are available. Do it like this:

Now install the php7 base packages with the command:

Now install some other packages for php: