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