Linux find du Tips
find large file in linux filesystem.
find /mdata -type f -printf '%s %p\n'| sort -nr | head -10
du -a /mdata |sort -n -r |head -n 10
Linux extend filesystem Tips
How to extend filesystem in virtualbox Linux?
MySQL Study 004 - Query table without primary key Tips
MySQL Study 005 - Query unused Index Tips
MySQL Study 003 - PT Tool Install Tips
MasOS SSH UTF8 Error Tips
There is LC_CTYPE error while connect to VM via ssh.
YourMacBook-Pro ~ % ssh root@127.0.0.1 -p2223
root@127.0.0.1's password:
Last login: Wed Mar 2 11:00:35 2022 from gateway
-bash: warning: setlocale: LC_CTYPE: cannot change locale (UTF-8): No such file or directory
[root@centos7 ~]#
Edit /etc/ssh/ssh_config and comment out SendEnv LANG LC_*.
YourMacBook-Pro:~ you$ sudo vi /etc/ssh/ssh_config
## SendEnv LANG LC_*
warning: setlocale: LC_CTYPE: cannot change locale (UTF-8): No such file or directory
Have a good work&life! 2022/03 via LinHong
MySQL Study 002 - ROWNUM Tips
There is NOT row_num function in MySQL.
How to achieve this function in MySQL?
MySQL Study 001 - Install Tips
Linux perl error in bash Tips
perl: warning: Setting locale failed.
Oracle Basic SQL 014 Study Tips
Sub-queries in select can be converted to left join (use_hj/use_nl)
Tips: The execution plan has the OUTER keyword
标量子查询可以转left join外连接（use_hj/use_nl)
Tips:
OUTER关键字Oracle Basic SQL 013 Study Tips
Remove characters from a string
Split strings and numbers
Oracle Basic SQL 012 Study Tips
Generate a continuous number
Query iterate over the string one by one