Since the Oracle bought Sun (including MySQL), I wanted to improve my knowledge about other databases and to check the alternatives (in case “something” happens to MySQL). Luckily, MySQL is …
Category: Tips & Tricks
Why PostgreSQL is not so popular? (howto part 2)
So… After the first part (Link) where we talk about the installation, the next step would be to create root user and to change postgres and root password. [root@XTdata init.d]# …
Logrotate settings
As you probably know, the default logrotate period on RH based distros is 7 days. From my point of view, this number is to big for production servers (files can …
How to set Access/Restrictions on users logins
I wanted to enable time limit for some users so they are able to use FTP server only during working time. For RH based systems with Vsftpd Open /etc/security/time.conf and …
MySQL Performance – Howto – part 2 (write cache dependance)
I already wrote about Sysbench and MySQL tunning scripts. Those articles can be found HERE and HERE. Now lets do some tests and lets see the dependance from write cache …
List the last created file
If you want to find the newest file inside directory, you can use the ls & tail combination. ls -t | head -1ls -t | head -1 Output bash$ ls …
Dafizilla Table2Clipboard Firefox addon
If you need to copy HTML tables into Excel, Libreoffice Calc or other datasheet applications, you can think about Firefox and Dafizilla Table2Clipboard firefox addon. This addon will allow you …
scp, ssh and rsync without prompting for password – howto
Using scp, rsync and ssh requires the password unless you add the public key from src host to authorised_keys on destination host. scp and rsync commands are used to transfer …
Disk usage analysis
Taking care about disk usage is a very good habit. There are several options for this and now I will only describe df and du commands. The df utility displays …
MySQL Performance – Howto – part 1 (high performance tuning scripts)
Often the server admin has little control over the applications which uses MySQL and it is hard to find the bottlenecks. This blog post can’t bring the peace in the …