https://www.youtube.com/watch?v=LiT84WC9vrQ&t=182s
#proxmox #virtual #vps #virtualisasi #server #backup
#proxmox #virtual #vps #virtualisasi #server #backup
YouTube
How to Backup and Restore on Proxmox Virtual Machine
How to Backup and Restore on Proxmox Virtual Machine
Hi guys, welcome to my channel Fathir Habib, on this time i want to show you how to backup and restore on proxmox virtual machine, on this time i use the mikrotik virtual machine. If you want to backup…
Hi guys, welcome to my channel Fathir Habib, on this time i want to show you how to backup and restore on proxmox virtual machine, on this time i use the mikrotik virtual machine. If you want to backup…
https://musaamin.web.id/cara-install-samba-server-di-debian-9-server/
#samba #linux #ubuntu #network #networking #share #sharing #file #windows #folder
#samba #linux #ubuntu #network #networking #share #sharing #file #windows #folder
Musa Amin
Cara Install Samba Server di Debian 9 Server • Linux & Open Source
Cara Install Samba Server di Debian 9 Server. Artikel ini membahas tentang cara install Samba server di Debian 9 server, share folder untuk anonim dan user.
https://linuxize.com/post/how-to-install-and-configure-samba-on-centos-7/
#samba #linux #centos #network #networking #share #sharing #file #windows #folder
#samba #linux #centos #network #networking #share #sharing #file #windows #folder
Linuxize
How to Install and Configure Samba on CentOS 7
In this tutorial we will show how to install Samba on CentOS 7 and configure it as a standalone server to provide file sharing across different operating systems over a network.
Forwarded from Wiwid LuckyGuy354
Tips n tricks DB:
- Jangan join > 2 table
- Klo join, pastiin type column, collation size sama as is
- wildcard utk like, pakai HANYA dibelakang string
- range ada start dan end... Jangan hanya > atau < aja
- hindari kalkulasi where
- hindari count distinct, pakai count group by
- kalau update lebih dr 1 kondisi, pakai composite index utk tiap field kondisi
- best practice utk soft delete: pakai flag (1/0) dan bukan timestamp+null
- avoid nullable column, pakai default '' or 0 aja
- semua column yg akan dpakai di WHERE, ORDER BY, GROUP BY, JOIN wajib di index
- avoid max size dari column (mis: varchar(255))
- db naming pakai _ klo > 1 syllable
- default db charset: utf8mb4 jgn utf8 aja
- default collation: utf8mb4_general_ci
- low cardinal column ga ush di index, i.e: gender
- query <= 15ms (😭) -> diluar network
- siapin query killer (klo berani) dari awal (😱)
- perhatikan column order utk klo mo bikin composite index dan query2 yg akan pakai composite index itu
- join, put smaller table on the left!
- select columns jangan select *, pakai yg dbutuhkan aja, utk keep memory usage
- kontent teks dgn isi ber-paragraph2, bikin table sendiri, bikin relasi 1 on 1
- jgn sorting data, klo hasilnya besar ( > 1000 rows)
- jangan pakai NOT IN ..., Instead, pakai NOT EXISTS ( SELECT 1 ... WHERE IN )
- explain tiap query sebelum di commit/deploy
Dari om ariedeha di group phpid
- Jangan join > 2 table
- Klo join, pastiin type column, collation size sama as is
- wildcard utk like, pakai HANYA dibelakang string
- range ada start dan end... Jangan hanya > atau < aja
- hindari kalkulasi where
- hindari count distinct, pakai count group by
- kalau update lebih dr 1 kondisi, pakai composite index utk tiap field kondisi
- best practice utk soft delete: pakai flag (1/0) dan bukan timestamp+null
- avoid nullable column, pakai default '' or 0 aja
- semua column yg akan dpakai di WHERE, ORDER BY, GROUP BY, JOIN wajib di index
- avoid max size dari column (mis: varchar(255))
- db naming pakai _ klo > 1 syllable
- default db charset: utf8mb4 jgn utf8 aja
- default collation: utf8mb4_general_ci
- low cardinal column ga ush di index, i.e: gender
- query <= 15ms (😭) -> diluar network
- siapin query killer (klo berani) dari awal (😱)
- perhatikan column order utk klo mo bikin composite index dan query2 yg akan pakai composite index itu
- join, put smaller table on the left!
- select columns jangan select *, pakai yg dbutuhkan aja, utk keep memory usage
- kontent teks dgn isi ber-paragraph2, bikin table sendiri, bikin relasi 1 on 1
- jgn sorting data, klo hasilnya besar ( > 1000 rows)
- jangan pakai NOT IN ..., Instead, pakai NOT EXISTS ( SELECT 1 ... WHERE IN )
- explain tiap query sebelum di commit/deploy
Dari om ariedeha di group phpid