Yesterday, somebody asked me how much traffic a Shotcast server produces. And I though I might as well share the computation: Stream @ 128 kbps (Kilo Bit per second) on in average 30 days of a month n = average number of users that listen 24h per day s = 1.1 = Shoutcast overhead factor […]
MySQL: Drop ALL tables of a database
After looking around for a while, here is a littleĀ recipeĀ to efficiently drop all tables from a MySQL database. Background story: If you have sufficient access rights to the MySQL server, you could easily drop database dbname; and create database dbname; If circumstances don’t allow you to drop and create this way, here are two ways […]