when I first saw this trixk to speed up the db: 1. stop mysql 2. cat dbfile > /dev/null 3. start mysql.... and it wor - devRant

Ranter

Comments

0

spl0

2043

8y

Eh?
0

bowvernon110391

122

8y

That's computer's way of saying "ignorance is bliss".
3

Biscuit85

92

8y

devnul beats nosql by a mile :D
0

spl0

2043

8y

Still don't understand it
0

Biscuit85

92

8y

@spl0 you setup devnul as a nonexisting device so nothing is saved to the db:)
1

wersooth

176

8y

Linux will read the full file and keep it in memory, so after the CAT, mysql won't have to re-read from the disk, it's already in the mem. I was looking at this and laughing, but a DB pro explained to me once :)
0

spl0

2043

8y

@Biscuit85 err that's not what it's doing though
0

spl0

2043

8y

@wersooth Thanks! Does that really work? MySQL's own buffer cache must be rubbish!
1

Biscuit85

92

8y

It's preloading the db file to mem. But there is a running joke/rant on mongo vs dev/null
0

monolithicblob

479

8y

@Biscuit85 eh what? Find me a source for that statement thanks.
0

Biscuit85

92

8y

@monolithicblob try this one: https://youtu.be/b2F-DItXtZs
0

spl0

2043

8y

Why can't mysql cache it's own file?
0

spl0

2043

8y

@Biscuit85 ok that's totally different to what you said before
1

Biscuit85

92

8y

@spl0 sorry had only a glimpse at the code that has been posted. On the second look the > was to the right :)

devRant © 2021 Hexical Labs LLC
Privacy Policy | Terms of Service