Home
Gists
Bookmarks

Subscribe

MongoDB

MongoDB: Fix WARNING: soft rlimits too low

Onyx

14 ก.ย. 2016 • 1 min read

Fix ** WARNING: soft rlimits too low. Number of files is 256, should be at least 1000

ulimit -n 2048 && mongod

Sign up for more like this.

Enter your email

มายเอสตะคริวแอล ๘.๐๐ นิดๆ กับปัญหา DELETE ตอน safe mode

เมื่อฉันรัน command delete แล้วทาง mysql แจ้งว่า DELETE FROM items WHERE create_at BETWEEN '2021-01-28 00:00:00' AND '2021-01-28 23:59:59';Error Code: 1175. You are using safe update mode and you tried to update a table without a WHERE that uses a

Onyx 4 ก.พ. 2021 • 1 min read

Split export MongoDB to JSON

You could do this with a shell script and via the mongoexport options --skip and --limit so basically limit the number of documents in each file and use skip as an offset. Something like this if your total is let say 5 milion records: limit=10000; skip=0; for i

Onyx 3 ก.พ. 2021 • 1 min read

MySql 8.0 Fix ONLY_FULL_GROUP_BY issue

Solution 1: Remove ONLY_FULL_GROUP_BY from mysql console SET GLOBAL sql_mode=(SELECT REPLACE(@@sql_mode,'ONLY_FULL_GROUP_BY',''));you can read more here Solution 2: Remove ONLY_FULL_GROUP_BY from phpmyadmin Open phpmyadmin & select localhostClick on menu Variables & scroll down for sql

Onyx 21 ม.ค. 2021 • 1 min read

iTORN © 2021

Powered by Ghost