Tool: MTU-Optimizer – automatically find the best MTU

Today I would like to present you again a small tool from “own production”. The tool I’m talking about is called MTU-Optimizer. The name already gives an indication of what the tool can do for you: It determines the MTU (Maximum Transmission Unit) and can set it for any network card.
Like most of my tools, the MTU Optimizer is programmed in C# and designed as portable application. (This means: It does not require any installation and can be started, for example, from a USB flash drive.) The download link to the tool can be found at the end of this article. Beforehand, however, I would like to briefly discuss the capabilities of the tool. Therefore we should first have a look at what the MTU is all about.
What is MTU?
MTU is the abbreviation for Maximum Transmission Unit and is the maximum packet size within a protocol. If the data packetsize exceeds […]

Hot to show MySQL database size via SQL statement

Calculate MySQL database size via SQL statementToday, there is only a very short article with an SQL statement which allows you to display the size of a MySQL database, as well as the description of how to read out the database size via phpMyAdmin. Let’s start with the SQL statement. To display the size of a particular MySQL database in MegaByte (MB), use the following SQL command:

SELECT table_schema,
sum( data_length + index_length ) / 1024 / 1024 "Database Size in MB"
FROM information_schema.TABLES WHERE table_schema="{my_database_name}" GROUP BY table_schema

However, within the statement, before the execution, the placeholder {my_database_name} must be replaced by the name of the database whose size is to be determined. If the size of all database should be displayed on the MySQL server, the where clause can be omitted. […]

Fastest padLeft-function in Java

Fastest padLeft function in JavaSince Java does not have a function to pad strings on the left or right side, you either have to program such function yourself or use an existing library, such as Apache Commons. Because I recently needed a function that would pad a numeric string on the left side (= padLeft) with zeros up to a length of 8 characters, but did not want to include a whole library for such a simple task, the only option was to write a padLeft function myself.
However, when researching and implementing, I found various solution approaches and so I ended up with six different padLeft implementations. In order to find the best padLeft function for my use case, I tested all six implementations during a small performance test and found the fastest padLeft function. Before I get […]

Digistore24 – Product catalog as Excel

Digistore Product Catalog as ExcelMost readers of this blog who are on the road to online marketing should have heard about Digistore24. With over 50,000 members and more than 3,500 products, it is probably the largest German marketplace for digital products.
Unfortunately with so many products their product catalog lost the clearness in some way. Although Digistore24 offers detailed information on each product, such as reward, churn rate, average reward per cart, etc., these criteria can not be filtered in the product list. As an affiliate, who is looking for a product which fits the own needs, one is left stranded.
Digistore product catalog as Excel table
That’s why I wrote a small tool, which makes a complete deduction of the listed products and writes them into a sortable and filterable Excel table. Thus, […]

How to install Netis WF2190 driver under Kubuntu

How to install Netis WF2190 in KubuntuThe following article is about how to find and install the appropriate (K)ubuntu driver for the Netis WF2190 WLAN stick. For a few weeks I work mainly under Linux (again) and as with almost every of my attempts trying to switch from Windows to Linux, there were again difficulties with the WiFi this time.
So, to spare you the hassle, I wrote the following short tutorial for you about how to install the Netis WF2190 drivers under Kubuntu.
Finding a Linux driver for a Netis WiFi stick
Before we begin, let’s make a small test by lsusb command. If you enter this command in the terminal, all connected USB devices are listed with fuirther information.

lsusb

As shown in the screenshot below, our WiFi stick is also included in […]