Increase MySQL connections max_connections Rumi, January 19, 2017 If you need to increase MySQL Connections without MySQL restart do like below mysql> show variables like ‘max_connections’; +—————–+——-+ | Variable_name | Value | +—————–+——-+ | max_connections | 100 | +—————–+——-+ 1 row in set (0.00 sec) mysql> SET GLOBAL max_connections = 150; Query OK, 0 rows affected (0.00 sec)… Continue Reading
Learning watch command with examples! Rumi, January 18, 2017 watch date watch -d date watch -n 10 df -h watch -t date watch echo “‘”‘$$'”‘” watch echo $$ watch -n 0.5 echo $$ watch -n 1 ‘ps -e -o pid,uname,cmd,pmem,pcpu –sort=-pmem,-pcpu | head -15’ watch -d -n 1 ifconfig watch -n 1 tail /var/log/messages watch -d=cumulative date watch “du… Continue Reading
Fixing error: ‘Access denied for user ‘debian-sys-maint’@’localhost’ (using password: YES)’ Rumi, January 17, 2017 For all you Ubuntu/MySQL developers out there, have you ever seen the following? neo@thematrix:~$ sudo /etc/init.d/mysql restart * Stopping MySQL database server mysqld [fail] * Starting MySQL database server mysqld [ OK ] /usr/bin/mysqladmin: connect to server at ‘localhost’ failed error: ‘Access denied for user ‘debian-sys-maint’@’localhost’ (using password: YES)’ So,… Continue Reading
Tightvnc setup on Linux Mint Rumi, January 16, 2017 sudo apt-get install tightvncserver cd ~/.vnc ls nano (or your favorite text editor.) xstartup. edit anything you need to. Then run: tightvncserver Go to your other computer. Run a vnc viewer. And enter in your IP like- <vncserverIP>:1 Continue Reading
UDP Load Balancing using PEN Rumi, January 5, 2017 First setup PEN load balancer using this document. After that, keep digging below 🙂 And that’s it, so now if we run pen we see it now has UDP support. root@penudp:~/pen-0.18.0# pen usage: pen [-C addr:port] [-X] [-b sec] [-S N] [-c N] [-e host[:port]] [-t sec] [-x N] [-w… Continue Reading
Linux Remove All Partitions or Data And Create Empty Disk Rumi, December 13, 2016 Use the following dd command to remove data from /dev/hdX: dd if=/dev/zero of=/dev/hdX bs=512 count=1 OR for sata disk, use the following syntax: dd if=/dev/zero of=/dev/sdX bs=512 count=1 In this example, empty sata disk /dev/sdb, enter (you must be login as the root user): fdisk /dev/sdb dd if=/dev/zero of=/dev/sdb bs=512… Continue Reading
The safest way to clean up /boot partition in Debian or Ubuntu Rumi, December 7, 2016 First check your kernel version, so you won’t delete the in-use kernel image, running: uname -r Now run this command for a list of installed kernels: dpkg –list ‘linux-image*’ and delete the kernels you don’t want/need anymore by running this: sudo apt-get remove linux-image-VERSION Replace VERSION with the version of… Continue Reading
LEMP on Debian 7 Rumi, December 3, 2016December 3, 2016 Installing MySQL 5 In order to install MySQL, we run apt-get install mysql-server mysql-client You will be asked to provide a password for the MySQL root user – this password is valid for the user root@localhost as well as root@server1.example.com, so we don’t have to specify a MySQL root password… Continue Reading
Identify WWN in linux Rumi, December 3, 2016 Here are some useful commands for the most popular Linux/Unix operating systems to find your HBA WWN. There are several methods to identify HBA WWN for the fiber storage units in your server network. Method 1: (The hard way) Verified on Suse Linux Enterprise Server and CentOS/Redhat The info is… Continue Reading
How to update Debian 6 Squeeze Rumi, November 6, 2016 After a Debian version has reached EOL (end of life), its repositories go to the Debian archive. Therefore we can use this archive to get packags for our distribution. The syntax for our /etc/apt/sources.list is as follows: deb http://archive.debian.org/debian/ <version> main non-free contrib deb-src http://archive.debian.org/debian/ <version> main non-free contrib deb… Continue Reading