Run ‘top’ to check PID of mysqld causes high CPU load Run the following command to check thread ID: pidstat -t -p <mysqld_pid> 1 Login to mysql as root user and run the following command to get slow query causes high CPU load: select * from performance_schema.threads where THREAD_OS_ID = <TID> From the image above…
The following query can be used to count duplicated records in MySQL: SELECT count(*) AS duplicate_count FROM ( SELECT column_name FROM table GROUP BY column_name HAVING COUNT(column_name) > 1 ) AS t
The following regular expression function can be used to strip HTML tags: SELECT REGEXP_REPLACE(field, ‘<[^>]*>+’, ”) FROM table It is very simple.
I unable to do audio recording in Kdenlive. Audio device does not show in Settings => Configure Kdenlive => Capture => Audio tab. To fix this issue, install libqt5multimedia5-plugins. $ sudo apt install libqt5multimedia5-plugins Restart Kdenlive and go to Settings => Configure Kdenlive => Capture => Audio tab. Audio device list will be shown and…
XAMPP’s Phpmyadmin folder is forbidden as default if accessed from internet. To open access this folder we have to edit /xampp/apache/conf/extra/httpd-xampp.conf file in Windows or /opt/lampp/etc/extra/httpd-xampp.conf file in Linux. Open httpd-xampp.conf file in text editorFind the following line: # Windows Alias /phpmyadmin “C:/xampp/phpMyAdmin/” <Directory “C:/xampp/phpMyAdmin”> AllowOverride AuthConfig Require local ErrorDocument 403 /error/XAMPP_FORBIDDEN.html.var </Directory> # Linux…
First, we install all packages required for the installation of the driver using this command: sudo apt-get install linux-headers-generic build-essential dkms git Now clone the git repository: git clone https://github.com/clnhub/rtl8192eu-linux.git Move to the new folder created: cd rtl8192eu-linux Remove current drivers (check with dkms status or sudo lshw -C network what drivers are available): sudo rmmod rtl8xxxu Blacklist the…
MySQL or MariaDB install has default value of sql mode named STRICT_TRANS_TABLES. The MySQL docs for STRICT_TRANS_TABLES state: Strict mode controls how MySQL handles input values that are invalid or missing. A value can be invalid for several reasons. For example, it might have the wrong data type for the column, or it might be…
To resolve this issue, we have to export GPG key from deprecated keyring. Get list of existing keys $ sudo apt-key list Warning: apt-key is deprecated. Manage keyring files in trusted.gpg.d instead (see apt-key(8)). /etc/apt/trusted.gpg ——————– pub rsa4096 2017-05-08 [SCEA] 1EDD E2CD FC02 5D17 F6DA 9EC0 ADAE 6AD2 8A8F 901A uid [ unknown] Sublime HQ…
Cloning into ‘<repo>’… error: chmod on /mnt/c/<repo>/.git/config.lock failed: Operation not permitted fatal: could not set ‘core.filemode’ to ‘false’ Above error message shown when Git tried to clone repository in mounting file system in Linux. To solve this issue, we have to edit /etc/fstab file and change uid and guid options. My uid and guid is…
For Windows user, it is very easy to create shortcut of file. Right click on the file, and choose Create Shortcut menu. For Ubuntu, we have to do a little bit effort. For example we want to create shortcut of file and put into Desktop. Open two windows of File Manager / Nautilus. One window…
