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
Check processor and cpu details Rumi, January 15, 2017 $ cat /proc/cpuinfo | grep vendor | uniq $ cat /proc/cpuinfo | grep ‘model name’ | uniq $ lscpu $ lscpu | grep -i mhz $ cat /proc/cpuinfo | grep -i mhz | uniq $ watch -n 0.1 “cat /proc/cpuinfo | grep -i mhz” $ cat /proc/cpuinfo | grep processor Continue Reading
How To Transfer Contacts From iPhone To Android (5 Ways) Rumi, January 7, 2017 Source: How To Transfer Contacts From iPhone To Android (5 Ways) 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