How to Reduce mysql bin files on-the-fly

It is not unusual for bin file to fill up the partition for mysql when one is doing master-slave replication.
Ideally one should have a reasonable setting in the my.cnf file. Setting the expire_logs_days to something reasonable or the max_binlog_size to a size you one can leave with.
In the case where one missed the opportunity to do so at the setup time and one cannot afford to change this and do a restart. two commands come in handy. One will reduce to the file desired and the other will reduce the bin files to the desired date.
Continue reading “How to Reduce mysql bin files on-the-fly”

How to run multiple instances of Skype

If you are like me, you have multiple Skype accounts, one for work related stuff and another for personal stuff, or perhaps even more. You may also just have the desire to have that but have not found an efficient way to have these working on the same system. The main thing necessary is to start Skype with a /secondary option/argument So in a typical 64-bit windows system with default installation path, you will start it as follows
Continue reading “How to run multiple instances of Skype”